Skip to main content
Question

IFS10 UPD3 not working after oracle upgrade to 19C


Forum|alt.badge.img+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

Forum|alt.badge.img+5
  • Do Gooder (Employee)
  • 30 replies
  • March 7, 2024

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 


Forum|alt.badge.img+1
  • Author
  • Do Gooder (Partner)
  • 1 reply
  • March 10, 2024

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


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings