Unaccounted Transactions Report (Xml) Errors Out When Closing The Periods (Doc ID 1088973.1)

Last updated on OCTOBER 07, 2024

Applies to:

Symptoms

The Unaccounted Transaction Sweep (APXUATR_XMLP) ends with the following error:

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.ja
va: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)

The FND Debug for the Unaccounted Transaction Sweep shows:

before_report_apxuatr: flag=EE; message=AP_SWEEP_FAILED
Failure in update_xla_events while updating XLA unaccounted events
"APP-XLA-95103: An internal error occurred. Please inform your system
administrator or support representative that:

An internal error has occurred in the program xla_events_pkg.update_event.
Unable to perform UPDATE on the event. The event (XXYYBB) is either invalid
or has been final accounted.."
"-: XLA-95103: An internal error occurred. Please inform your system
administrator or support representative that:

An internal error has occurred in the program xla_events_pkg.update_event.
Unable to perform UPDATE on the event. The event (XXYYBB) is either"

Cause

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