My Oracle Support Banner

R12: AP/XLA: Sweeping Transactions Spawned The Unaccounted Transactions Report (APXUATR_XMLP) Which Completes With Error: ORA-20001: APP-XLA-95103: An internal error occurred (Doc ID 1247735.1)

Last updated on JUNE 21, 2023

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.


Sweep transactions spawned the Unaccounted Transactions Report (XML) which errors out as reported in the output log:

Error Message
Calling XDO Data Engine...
oracle.apps.xdo.XDOException: !!Error : trigger 'beforeReportTrigger' returns status as 'false'
EXCEPTION: update_xla_events: ORA-20001: 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. No event exists for the document represented by the given source information..
Failure in update_xla_events while updating XLA unaccounted events
end before_report_apxuatr:
before_report_apxuatr: flag=EE; message=AP_SWEEP_FAILED

Steps to Reproduce
Responsibility : Payables
Navigate: Accounting > Control Payables Periods
1 - Attempt to close period, get message:
     APP-SQLAP-10304: You cannot close this period because exceptions exist.
2 - Attempt to sweep transactions to next period
3 - Confirm operation, request spawned for Unaccounted Transactions Report (XML) program
4 - In requests window, note the program completes in error.




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.