My Oracle Support Banner

Ar120lcjgr.sql Fails With Error ORA-00001: Unique Constraint (AR.AR_CHARGE_SCHEDULES_U2) Violated when upgrading from 12.1 to 12.2 (Doc ID 2357468.1)

Last updated on JULY 10, 2020

Applies to:

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


Customer is upgrading from 12.1.3 to 12.2
Applied patch 10124646 ORACLE E-BUSINESS SUITE RELEASE 12.2.0 [R12.2] UPGRADE DRIVER
When patch tried to run script ar120lcjgr.sql it encountered an error.

Skipped the error message and proceeded to apply the patch;

After patching completed, tried to rerun script ar120lcjgr.sql manually, but getting error message


ERROR at line 1:
ORA-00001: unique constraint (AR.AR_CHARGE_SCHEDULES_U2) violated
ORA-06512: at line 27

The issue can be reproduced at will with the following steps:
1. Run script manually
  $ cd /usr/lic/oracle/home/product/fs1/EBSapps/appl/ar/12.0.0/patch/115/sql/

  $ sqlplus apps/password

  SQL> @ar120lcjgr.sql AR 1000

Enter value for 3: 2 (worker id)
Enter value for 4: 4 (number of workers)

2. Get the error message


 Upgrade from 12.1 to 12.2


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

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