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 AUGUST 24, 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 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

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