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 SEPTEMBER 09, 2016

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.
***Checked for relevance on 10th Aug 2013***

Symptoms

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 occurr
ed. 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.

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