My Oracle Support Banner

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 later
Oracle 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:
-------------------------------------------------------------

  1. Navigate to submit request window in Payables Responsibility
  2. Select request "Period Close Exceptions Report (XML)"
  3. Do not enter any value for parameter -  or - select a closed period
  4. Submit the request
  5. 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


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