During Upgrade to 12.2 ar120trxpsa.sql Has Performance Issues, and Gives Error ORA-00001 When Running Multiple Workers (Doc ID 1959717.1)

Last updated on MARCH 08, 2017

Applies to:

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

Symptoms

If upgrade script ar120trxpsa.sql is submitted with multiple workers, the following error occurs:

ORA-00001: unique constraint (XLA.XLA_AE_LINES_U1) violated

Also, a single worker takes days to complete

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