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

(Doc ID 1083510.1)

Last updated on JUNE 06, 2017

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

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms