R12: AP/XLA: APXPCER_XMLP Period Close Exceptions Report (XML) Completes in Error: trigger 'beforeReportTrigger' returns status as 'false'
(Doc ID 1567395.1)
Last updated on JULY 07, 2022
Applies to:
Oracle Payables - Version 12.0.0 and laterOracle Subledger Accounting - Version 12.0.0 and later
Information in this document applies to any platform.
Symptoms
The APXPCER_XMLP module: Period Close Exceptions Report (XML), completes in Error with the following in the log file.
Calling XDO Data Engine...
oracle.apps.xdo.XDOException: !!Error : trigger 'beforeReportTrigger' returns status as 'false'
at oracle.apps.xdo.dataengine.XMLPGEN.executeTriggers(XMLPGEN.java:654)
at oracle.apps.xdo.dataengine.XMLPGEN.processData(XMLPGEN.java:263)
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)
and farther down....
validate_parameters: flag=EE; message=AP_ALL_NOT_OPEN_PERIOD
End process_period: current timestampL
before_report_apxpcer: flag=EE; message=AP_ALL_NOT_OPEN_PERIOD
The "AP_ALL_NOT_OPEN_PERIOD" is the clue to the solution.
STEPS TO REPRODUCE:
-------------------------------------------------------------
-
Navigate to submit request window in Payables Responsibility
- Select request "Period Close Exceptions Report (XML)"
- Do not enter any value for parameter - or - select a closed period
- Submit the request
- Request fails status Error
Changes
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 |
Changes |
Cause |
Solution |
References |