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 SEPTEMBER 20, 2024
Applies to:
Oracle General Ledger - Version 12.1.3 and later Oracle Receivables - Version 12.1.3 and later Oracle Payables - Version 12.1.3 and later Oracle Assets - Version 12.1.3 and later Information in this document applies to any platform.
Symptoms
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."
Changes
Applied patches 13840855:R12.XLA.B and 14255667:R12.XLA.B
Cause
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
