My Oracle Support Banner

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

Last updated on FEBRUARY 26, 2019

Applies to:

Oracle Payables - Version 12.1.3 and later
Information in this document applies to any platform.


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(
at oracle.jdbc.driver.T4CTTIoer.processError(
at oracle.jdbc.driver.T4CTTIoer.processError(
at oracle.jdbc.driver.T4C8Oall.receive(
at oracle.jdbc.driver.T4CPreparedStatement.doOall8(
at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(
at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(
at oracle.jdbc.driver.T4CPreparedStatement.executeMaybeDescribe(
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(
at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(
at oracle.apps.xdo.dataengine.XMLPGEN.processQuery(
at oracle.apps.xdo.dataengine.XMLPGEN.processSQLDataSource(
at oracle.apps.xdo.dataengine.XMLPGEN.writeData(
at oracle.apps.xdo.dataengine.XMLPGEN.writeGroupStructure(
at oracle.apps.xdo.dataengine.XMLPGEN.processData(
at oracle.apps.xdo.dataengine.XMLPGEN.processXML(
at oracle.apps.xdo.dataengine.XMLPGEN.writeXML(
at oracle.apps.xdo.dataengine.DataProcessor.processDataStructre(
at oracle.apps.xdo.dataengine.DataProcessor.processData(
at oracle.apps.xdo.oa.util.DataTemplate.processData(
at oracle.apps.xdo.oa.cp.JCP4XDODataEngine.runProgram(
at oracle.apps.fnd.cp.request.Run.main(

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.

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


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


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

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