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

Last updated on JULY 25, 2016

Applies to:

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

Symptoms

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.

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