After Applying Patch 16060007, ORA-00923 when running Custom Account Analysis Report (Doc ID 1915637.1)

Last updated on FEBRUARY 26, 2019

Applies to:

Symptoms

On : 12.1.3 version, Subledger Accounting Account Analysis Report,

After Applying Patch 16060007, Error when attempting to run a copy of the seeded Account Analysis Report for Subledger Accounting using a modified BI template.
Issue is not reproduced using the seeded Account Analysis Report.

ERROR ( Custom Account Analysis Report log file)
-----------------------------------------------------------------------------------
java.sql.SQLException: ORA-00923: FROM keyword not found where expected

at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288)
at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:745)
at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:216)
at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:810)
at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1039)
at oracle.jdbc.driver.T4CPreparedStatement.executeMaybeDescribe(T4CPreparedStatement.java:850)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1134)
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3339)
at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3384)
at oracle.apps.xdo.dataengine.XMLPGEN.processQuery(XMLPGEN.java:1947)
at oracle.apps.xdo.dataengine.XMLPGEN.processSQLDataSource(XMLPGEN.java:501)
at oracle.apps.xdo.dataengine.XMLPGEN.writeData(XMLPGEN.java:445)
at oracle.apps.xdo.dataengine.XMLPGEN.writeGroupStructure(XMLPGEN.java:308)
at oracle.apps.xdo.dataengine.XMLPGEN.processData(XMLPGEN.java:273)
at oracle.apps.xdo.dataengine.XMLPGEN.processXML(XMLPGEN.java:215)
at oracle.apps.xdo.dataengine.XMLPGEN.writeXML(XMLPGEN.java:254)
at oracle.apps.xdo.dataengine.DataProcessor.processDataStructre(DataProcessor.java:390)
at oracle.apps.xdo.dataengine.DataProcessor.processData(DataProcessor.java:355)
at oracle.apps.xdo.oa.util.DataTemplate.processData(DataTemplate.java:334)
at oracle.apps.xdo.oa.cp.JCP4XDODataEngine.runProgram(JCP4XDODataEngine.java:294)
at oracle.apps.fnd.cp.request.Run.main(Run.java:157)

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Copy concurrent program definition XLAAARPT to XLAAARPT2
2. Create a custom template to use with the report
3. Submit XLAAARPT2, specifying the new template XLAAARPT2, as the Layout
4. No errors.
5. Apply Patch 16060007.
6. Run Report.
7. Error raised in report log.

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot run the custom report after applying patch.

Changes

 Applying <Patch 16060007:R12.XLA.B>.  This Patch is  replaced by  <Patch 21340722:R12.XLA.B>

Cause

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