My Oracle Support Banner

OPP Manager Error 'ORA-600 [kqludp2]' Unable To Publish XML Reports (Doc ID 1083510.1)

Last updated on NOVEMBER 22, 2023

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

To view full details, sign in with your My Oracle Support account.

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

In this Document
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.