OraFAQ Forum: Weblogic & Application Server » FRM-40007 :- Invalid user identifier or password during middle of forms operation.

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))

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

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

Code: [Select all] [Show/ hide]

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

Code: [Select all] [Show/ hide]

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

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat May 03 00:38:50 CDT 2025