Oracle Reports are Failing with ORA-00600: internal error code

Description:

Customers run the Oracle Report are Failing with APPS.FND_CP_OPP_IPC ORA-00600: internal error code. This issue made low level business impact

 

Solution:

  • Check the Concurrent Log file to detail of that error.
  • Shutdown the concurrent managers (sh adcmctl.sh stop)
  • Kill the FNDLIBR in OS level.
  • And shutdown the application services (sh adstpall.sh)
  • Run the following SQL file for the Correct users.
  • Connect system/<password>

SQL> @$FND_TOP/patch/115/sql/afopp001.sql

  • Connect applsys/<password>

SQL> @$FND_TOP/patch/115/sql/afopp002.sql

  • Start the application and check with customer
  • After that issue has been resolved.

Reference:

Oracle knowledge base Document.

Recent Posts