Solved

User Error - IEE startup - PLS-00201: identifier 'IFSAPP.PROXY_LOGIN_SYS' must be declared

  • 15 June 2022
  • 2 replies
  • 741 views

Userlevel 3
Badge +8

Trying to start IEE for a specific user and getting this error below. Other users work fine, on the same machine.  Same user works fine in Aurena. Could it be profile/permissions related? How would one attempt to fix this?

Server error messages:
7a92cecb-c6b0-4fcc-92b3-5a6fb6618dcd

Ifs.Fnd.FndSystemException: Explorer: A fatal error occurred. Application will terminate. Sorry for any inconvenience. ---> Ifs.Fnd.FndSystemException: Unexpected error while calling server method AccessPlsql/Invoke ---> Ifs.Fnd.FndServerFaultException: Failed executing statement (ORA-06550: line 9, column 11:
PLS-00201: identifier 'IFSAPP.PROXY_LOGIN_SYS' must be declared
ORA-06550: line 9, column 4:
PL/SQL: Statement ignored
ORA-06550: line 10, column 4:
PLS-00201: identifier 'IFSAPP.FND_CONTEXT_SYS' must be declared
ORA-06550: line 10, column 4:
PL/SQL: Statement ignored)

ORA-06550: line 9, column 11:
PLS-00201: identifier 'IFSAPP.PROXY_LOGIN_SYS' must be declared
ORA-06550: line 9, column 4:
PL/SQL: Statement ignored
ORA-06550: line 10, column 4:
PLS-00201: identifier 'IFSAPP.FND_CONTEXT_SYS' must be declared
ORA-06550: line 10, column 4:
PL/SQL: Statement ignored

   at Ifs.Fnd.AccessProvider.FndConnection.ParseErrorHeader(FndBuffer buffer, FndManualDecisionCollection decisions)
   at Ifs.Fnd.AccessProvider.FndConnection.UnMarshalResponseHeader(Stream responseStream, FndManualDecisionCollection decisions)
   at Ifs.Fnd.AccessProvider.FndConnection.HandleHttpSuccessResult(HttpWebResponse result, FndManualDecisionCollection decisions, String operation, FndBodyType responseBodyType, Object responseBody)
   at Ifs.Fnd.AccessProvider.FndConnection.InvokeInternal(Object requestBody, Object responseBody, String intface, String operation, FndRequestContext requestContext, FndManualDecisionCollection decisions, Boolean forcedSync, Boolean integrationGateway)
   --- End of inner exception stack trace ---
   at Ifs.Fnd.AccessProvider.FndConnection.InvokeInternal(Object requestBody, Object responseBody, String intface, String operation, FndRequestContext requestContext, FndManualDecisionCollection decisions, Boolean forcedSync, Boolean integrationGateway)
   at Ifs.Fnd.AccessProvider.FndConnection.InvokeInternal(String intface, String operation, Object requestBody, Object responseBody, FndRequestContext requestContext, Boolean forcedSync, Boolean integrationGateway)
   at Ifs.Fnd.AccessProvider.PLSQL.FndPLSQLCommandCollection.Invoke()
   at Ifs.Fnd.AccessProvider.PLSQL.FndPLSQLCommand.ExecuteNonQuery()
   at Ifs.Fnd.ApplicationRuntime.Core.FndApplication.InitializeSystemSettingsFromServer()
   at Ifs.Fnd.ApplicationRuntime.Core.FndApplication.StartupApplication()
   --- End of inner exception stack trace ---

 

 

icon

Best answer by Ruchira 15 June 2022, 04:25

View original

2 replies

Userlevel 5
Badge +12

Hi,

Have you tried solution described here?

 

Userlevel 3
Badge +8

Thank you Ruchira. It’s solved. 

  1. A missing CONNECT grant for particular user through the proxy user.
  2. The CONNECT privilege has been revoked due to some reason. During the creation of users, a user entry to proxy_users table is added automatically. However, if that gets removed, you will get the mentioned error message.

Reply