OPP Manager Error 'ORA-600 [kqludp2]' Unable To Publish XML Reports

OPP Manager Error 'ORA-600 [kqludp2]' Unable To Publish XML Reports

Applies to:

Oracle Concurrent Processing - Version 12.1.3 to 12.1.3 [Release 12.1]
Oracle Application Object Library - Version 11.5.10.2 to 11.5.10.2 [Release 11.5]
Information in this document applies to any platform.

Symptoms:

In 11.5.10.2 / BI Publisher 5.6.3

After recently upgrading the database to10g, when attempting to run any BI Publisher report the request completes with warning and no output is produced.  The request log show there to be no Output Post Processor available or running, however, the concurrent administration form shows the OPP manager to be running.

ICM log has references to 'get_cart_appl failed due to ORA-01000: maximum open cursors exceeded'
Review of the OPP log shows the following error occurring:
 
[EXCEPTION] [OPPServiceThread0] java.sql.SQLException: ORA-00600: internal error code, arguments: [kqludp2], [0x9EAFC1B0], [0], [], [], [], [], []
ORA-06512: at "APPS.FND_CP_OPP_IPC", line 85
ORA-06512: at line 1

at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:289)
at oracle.jdbc.ttc7.Oall7.receive(Oall7.java:589)
at oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1972)
at oracle.jdbc.ttc7.TTC7Protocol.parseExecuteFetch(TTC7Protocol.java:1119)
at oracle.jdbc.driver.OracleStatement.executeNonQuery(OracleStatement.java:2185)
at oracle.jdbc.driver.OracleStatement.doExecuteOther(OracleStatement.java:2059)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:2976)
at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:656)
at oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:734)
at oracle.apps.fnd.cp.opp.OPPAQMonitor.initAQ(OPPAQMonitor.java:557)
at oracle.apps.fnd.cp.opp.OPPAQMonitor.init(OPPAQMonitor.java:533)
at oracle.apps.fnd.cp.opp.OPPAQMonitor.initialize(OPPAQMonitor.java:88)
at oracle.apps.fnd.cp.opp.OPPServiceThread.init(OPPServiceThread.java:91)
at oracle.apps.fnd.cp.gsf.BaseServiceThread.run(BaseServiceThread.java:134)

NOTE: This issue also occurs after applying the Patch:20395533:R12.AD.B.DELTA.6 (This is a pre-req for HR RUP8 20000288).

The issue can be reproduced at will with the following steps:

1. Run any BI Publisher report

Due to this issue, users are unable to run XML reports
Cause

This is Unpublished Bug 5895677 ATG11510RUP5D5:FUNC:STARTING OPP GIVES ORA-600[KQLUDP2] CAN'T RUN XDO WITH CP.

Seeing the following in the OPP log:
 
[EXCEPTION] [OPPServiceThread0] java.sql.SQLException: ORA-00600: internal error code, arguments: [kqludp2], [0x9EAFC1B0], [0], [], [], [], [], []
ORA-06512: at "APPS.FND_CP_OPP_IPC", line 85
ORA-06512: at line 1
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:289)
at oracle.jdbc.ttc7.Oall7.receive(Oall7.java:589)

 
Solution:

1. Shut down all services
IMPORTANT: BE SURE TO RUN THESE SCRIPTS AS THE CORRECT USERS SYSTEM and APPLSYS ONLY.
Also, verify NO CP processes are running on OS. This includes FNDLIBR, FNDSM, etc.

 2. Run $FND_TOP/patch/115/sql/afopp001.sql as SYSTEM.

3. Run $FND_TOP/patch/115/sql/afopp002.sql as APPLSYS.  Commit.

4. Restart managers and test again.

Reference metalink Doc ID 1083510.1