Reports Error: Applied Receipts Journal (ARXAPPJR) Fails With Exhausted Resultset Error Message and No Output Is Generated (Doc ID 564564.1)

Last updated on APRIL 06, 2017

Applies to:

Oracle Receivables - Version 11.5.10.2 and later
Information in this document applies to any platform.
Oracle XML Publisher - Version: 9.2.0.7


Symptoms

Applied Receipts Journal (ARXAPPJR) using XML Publisher fails with Exhausted ResultSet error message and does not produce any output. Errors shown are:

4/3/08 2:29:12 PM] [main] Starting GSF service with concurrent process id = 31078.
[4/3/08 2:29:12 PM] [main] Initialization Parameters: oracle.apps.fnd.cp.opp.OPPServiceThread:2:0:max_threads=5
[4/3/08 2:29:13 PM] [Thread-12] Service thread starting up.
[4/3/08 2:29:13 PM] [Thread-13] Service thread starting up.
[4/3/08 3:06:33 PM] [OPPServiceThread0] Post-processing request 8028522.
[4/3/08 3:06:33 PM] [31078:RT8028522] Executing post-processing actions for request 8028522.
[4/3/08 3:06:33 PM] [31078:RT8028522] Starting XML Publisher post-processing action.
[4/3/08 3:06:33 PM] [31078:RT8028522]
Template code: BAR0TRXP
Template app: BAR
Language: en
Territory: 00
Output type: PDF
[4/3/08 3:06:33 PM] [UNEXPECTED] [31078:RT8028522] java.sql.SQLException: Exhausted Resultset
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:179)
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:269)
at oracle.jdbc.driver.OracleStatement.prepare_for_new_get(OracleStatement.java:3465)
at oracle.jdbc.driver.OracleStatement.getStringValue(OracleStatement.java:3715)
at oracle.jdbc.driver.OracleResultSetImpl.getString(OracleResultSetImpl.java:460)
at oracle.apps.fnd.cp.util.CpUtil.getCanonicalLocalNode(CpUtil.java:127)
at oracle.apps.fnd.cp.opp.XMLPublisherProcessor.process(XMLPublisherProcessor.java:210)
at oracle.apps.fnd.cp.opp.OPPRequestThread.run(OPPRequestThread.java:153)

and

[4/22/08 10:06:33 AM] [main] Starting GSF service with concurrent process id = 32017.
[4/22/08 10:06:33 AM] [main] Initialization Parameters: oracle.apps.fnd.cp.opp.OPPServiceThread:2:0:max_threads=5
[4/22/08 10:06:33 AM] [Thread-12] Service thread starting up.
[4/22/08 10:06:33 AM] [Thread-13] Service thread starting up.
[4/22/08 10:18:28 AM] [OPPServiceThread1] Post-processing request 8035242.
[4/22/08 10:18:28 AM] [32017:RT8035242] Executing post-processing actions for request 8035242.
[4/22/08 10:18:28 AM] [32017:RT8035242] Starting XML Publisher post-processing action.
[4/22/08 10:18:28 AM] [32017:RT8035242]
Template code: ARXAPPJR
Template app: AR
Language: en
Territory: US
Output type: PDF
sparcv8plus+vis sparcv8plus sparcv8 sparcv8-fsmuld sparcv7 sparc]
[4/22/08 10:18:44 AM] [UNEXPECTED] [32017:RT8035242] java.lang.reflect.InvocationTargetException: java.lang.ClassCastException: oracle.xdo.parser.v2.XSLNode
at oracle.xdo.parser.v2.XSLForEachGroup.appendChild(XSLForEachGroup.java:122)
at oracle.xdo.parser.v2.XSLBuilder.pushXSLNode(XSLBuilder.java:1055)
at oracle.xdo.parser.v2.XSLBuilder.startElement(XSLBuilder.java:412)
at oracle.xdo.parser.v2.NonValidatingParser.parseElement(NonValidatingParser.java:1227)
at oracle.xdo.parser.v2.NonValidatingParser.parseRootElement(NonValidatingParser.java:314)
at oracle.xdo.parser.v2.NonValidatingParser.parseDocument(NonValidatingParser.java:281)
at oracle.xdo.parser.v2.XMLParser.parse(XMLParser.java:266)
at oracle.xdo.parser.v2.XSLProcessor.newXSLStylesheet(XSLProcessor.java:560)
at java.lang.reflect.Method.invoke(Native Method)
at oracle.apps.xdo.common.xml.XSLT10gR1.invokeNewXSLStylesheet(XSLT10gR1.java:558)
at oracle.apps.xdo.common.xml.XSLT10gR1.transform(XSLT10gR1.java:228)
at oracle.apps.xdo.common.xml.XSLTWrapper.transform(XSLTWrapper.java:177)
at oracle.apps.xdo.template.fo.util.FOUtility.generateFO(FOUtility.java:1044)
at oracle.apps.xdo.template.fo.util.FOUtility.generateFO(FOUtility.java:997)
at oracle.apps.xdo.template.fo.util.FOUtility.generateFO(FOUtility.java:212)
at oracle.apps.xdo.template.FOProcessor.createFO(FOProcessor.java:1657)
at oracle.apps.xdo.template.FOProcessor.generate(FOProcessor.java:967)
at oracle.apps.xdo.oa.schema.server.TemplateHelper.runProcessTemplate(TemplateHelper.java:5888)
at oracle.apps.xdo.oa.schema.server.TemplateHelper.processTemplate(TemplateHelper.java:3438)
at oracle.apps.xdo.oa.schema.server.TemplateHelper.processTemplate(TemplateHelper.java:3527)
at oracle.apps.fnd.cp.opp.XMLPublisherProcessor.process(XMLPublisherProcessor.java:245)
at oracle.apps.fnd.cp.opp.OPPRequestThread.run(OPPRequestThread.java:153)

[4/22/08 10:18:44 AM] [32017:RT8035242] Completed post-processing actions for request 8035242.

Changes

 

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