Subledger Accounting: Update Subledger Accounting Balances ORA-1: In (XLA.XLA_CONTROL_BALANCES_U1) After Applying 13840855 And 14255667
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
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