My Oracle Support Banner

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

Last updated on NOVEMBER 07, 2022

Applies to:

Oracle Receivables - Version 12.1.3 and later
Oracle Payables - Version 12.1.3 and later
Oracle Assets - Version 12.1.3 and later
Oracle General Ledger - 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!

In this Document
 1. Bug Summary
 2. Fixed Files
 3. Recommended Patches
 4. Solution Steps

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.