Home » Fusion Middleware & Colab Suite » Weblogic & Application Server » FRM-40007 :- Invalid user identifier or password during middle of forms operation. (Oracle Fusion Middleware 12c(12.2.1.2.0))
FRM-40007 :- Invalid user identifier or password during middle of forms operation. [message #684602] Mon, 05 July 2021 06:37
deepakmannazhi
Messages: 137
Registered: February 2010
Location: Dubai, UAE
Senior Member

Dear Experts,

we have two divisions in our application. Both are created as different schemas

DIVISION1 AND DIVISION2 in addition to this, we have a main schema, through which the first connection is happening.

From the main screen, users can navigate to each division using DIVISION1 AND DIVISION2 Buttons


WHEN BUTTON PRESSED IN DIVISION1


declare
	the_connect varchar2(20);
begin
  the_connect  := Get_Application_Property(CONNECT_STRING); 
  logout;
  logon('DIVISION1','DIVISION1@' || the_connect);
   :Global.DbUser := Get_Application_Property(USERNAME);
 
call_form('FORM');

end;



WHEN BUTTON PRESSED IN DIVISION2


declare
	the_connect varchar2(20);
begin
  the_connect  := Get_Application_Property(CONNECT_STRING); 
  logout;
  logon('DIVISION2','DIVISION2@' || the_connect);
   :Global.DbUser := Get_Application_Property(USERNAME);
 
call_form('FORM');

end;


This is working. But sometimes we are getting Quote:
FRM-40007 :- Invalid user identifier or password
error.

This is not happening all the time, but occasionally we are getting this error. After monitoring few days, we found that this error is happening when the user do switching between divisions(schemas) continuously.

Hope I explained the issue properly.

Could you please help me to solve this issue

Thanks and best Regards
Deepak








Previous Topic: Webutil to Excel
Next Topic: Weblogic 10.3.6 disable TLSv1.1
Goto Forum:
  


Current Time: Thu Mar 28 16:37:24 CDT 2024