My Oracle Support Banner

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

Last updated on JULY 10, 2020

Applies to:

Oracle Receivables - Version 12.1.3 and later
Information in this document applies to any platform.


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


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
 1. Bug Summary
 2. Fixed File(s)
 3. Recommended Patch(es)
 4. Solution Steps

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