Question

IFS10 UPD3 not working after oracle upgrade to 19C

  • 7 March 2024
  • 2 replies
  • 23 views

Badge +1

What to do if :

 

  1. Oracle 12c is upgraded to 19c
  2. Still IFS is on Apps10 Upd3 (As we know 19c is not compatible with UPD3) 
  3. All IFS services are running (Admin / Monitoring / Weblogic consoles are working fine)
  4. Application is not accessible (Login not possible)

Looking for a solution to fix it.

 

Error : Error appears after entering Id/password

Server error messages:
4d6169f7-41f1-493d-b432-f94d454dcaf3

Ifs.Fnd.FndSystemException: Unexpected error while calling server method AccessPlsql/Invoke

   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.AccessProvider.PLSQL.FndPLSQLSelectCommand.ExecuteReader(String recordType, Int32 fetchsize)
   at Ifs.Fnd.AccessProvider.PLSQL.FndPLSQLSelectCommand.ExecuteReader()
   at Ifs.Fnd.AccessProvider.Interactive.FndLoginDialog.checkLanguage(FndLoginCredentials loginCreds)
   at Ifs.Fnd.AccessProvider.Interactive.FndLoginDialog.AuthenticateCredentials(FndLoginCredentials loginCreds) ---> Ifs.Fnd.FndServerFaultException: Failed executing statement (ORA-04063: package body "IFSAPP.MESSAGE_SYS" has errors
ORA-06508: PL/SQL: could not find program unit being called: "IFSAPP.MESSAGE_SYS"
ORA-06512: at "IFSAPP.FND_CONTEXT_SYS", line 387
ORA-06512: at "IFSAPP.FND_CONTEXT_SYS", line 192
ORA-06512: at line 3)

ORA-04063: package body "IFSAPP.MESSAGE_SYS" has errors
ORA-06508: PL/SQL: could not find program unit being called: "IFSAPP.MESSAGE_SYS"
ORA-06512: at "IFSAPP.FND_CONTEXT_SYS", line 387
ORA-06512: at "IFSAPP.FND_CONTEXT_SYS", line 192
ORA-06512: at line 3

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


2 replies

Userlevel 2
Badge +4

Hi,

 

Oracle 19C becomes supported on IFS Application 10 from UPD6 onwards. 

Please update to a later UPD and you should be fine.

 

Kind Regards,

Andreas 

Badge +1

Hi,

We won't update the IFS because it's in read-only mode. The client now uses S4 Hana. We'll keep it for data reference and reporting for a few years. We're just looking for a solution to start up the application; everything else will be taken care of.

Thanks,

Puru

Reply