Upgrade Historical Subleger Transaction Accounting Error ORA-00001 and XLA_AE_LINES_U1 (Doc ID 1446261.1)

Last updated on APRIL 02, 2012

Applies to:

Oracle Receivables - Version: 12.1.3 and later   [Release: 12.1 and later ]
Information in this document applies to any platform.

Symptoms

After the upgrade from 11.5.10 to 12.1.3, all the accounting periods have been updated in compliance with SLA accounting entries.

Attempting to run the Program 'Upgrade Historical Subleger Transaction Accounting' and failed with the following error found in the log:

Cause: FDPSTP failed due to ORA-01086: savepoint 'UPGRADE_BY_REQUEST' never
established in this session or is invalid
ORA-06512: at "APPS.AR_UPGHARNESS_PKG", line 956
ORA-00001: unique constraint (XLA.XLA_AE_LINES_U1) violated


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