R12 XLABAOPE Open Period Balances Program Fails with Error ORA-00001 xla_control_balances_u1 Violated (Doc ID 2104562.1)

Last updated on JULY 20, 2017

Applies to:

Oracle General Ledger - Version 12.0.0 to 12.2 [Release 12.0 to 12.2]
Oracle Subledger Accounting - Version 12.0.0 to 12.2 [Release 12.0 to 12.2Cloud]
Information in this document applies to any platform.
Open Period Balances Program (XLABAOPE)

Symptoms

Run the Open Period Balances Program (XLABAOPE), the following error occurs:

ERROR
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.  

ORA-20001: -: XLA-95103: An internal error occurred. Please inform your system administrator or support representative that:

Changes

Upgrade from 11i; MRC was setup in 11i.

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