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
Last updated on OCTOBER 12, 2017
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***
Sweep transactions spawned the Unaccounted Transactions Report (XML) which errors out as reported in the output log:
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
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.
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