My Oracle Support Banner

Subledger Accounting: Update Subledger Accounting Balances ORA-1: In (XLA.XLA_CONTROL_BALANCES_U1) After Applying 13840855 And 14255667 (Doc ID 1579443.1)

Last updated on DECEMBER 13, 2017

Applies to:

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


Attempting to run the 'Update Subledger Accounting Balances' and the following error occurs:

Balances are not initialized for the latest open period.
Before proceeding with balance calculation, run Open Period Balances Program for Ledger ID: 235 for the latest open period in General Ledger.

After that, you open the period and run 'Open Period Balances' (request # 73774718), and it failed with the following error:

ORA-20001: -: XLA-95103: 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.move_balances_forward. ORA-00001: unique constraint (XLA.XLA_CONTROL_BALANCES_U1) violated."


Applied patches 13840855:R12.XLA.B and 14255667:R12.XLA.B


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.