My Oracle Support Banner

Update Subledger Accounting Balances (XLABAPUB) Fail with Error ORA-00001 (Doc ID 1503747.1)

Last updated on MAY 04, 2018

Applies to:

Oracle Receivables - Version 12.1.3 and later
Information in this document applies to any platform.


Attempting to run the Update Subledger Account Balances program and it completes with the following error:

XLABAPUB module: Update Subledger Accounting Balances
**Starts**30-OCT-2012 13:27:45
An internal error occurred.  Please inform your system administrator or support representative that:

An internal error has occurred in the program xla_balances_calc_pkg.calculate_control_balances. 
ORA-00001: unique constraint (XLA.XLA_CONTROL_BALANCES_U

The Program is either run as part of Create Accounting or as a standalone concurrent request.


To view full details, 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 a vibrant support community of peers and Oracle experts.