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.

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!


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


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