Store Hierarchy Import Fails Due to 'ORA-00001: unique constraint violated' When PA_CT_SEQ and PA_PRTY_SEQ Overlap (Doc ID 1542979.1)

Last updated on AUGUST 07, 2017

Applies to:

Oracle Retail Central Office - Version 13.3 to 13.4.5 [Release 13.3 to 13.4]
Information in this document applies to any platform.

Symptoms

In Oracle Retail Central Office (ORCO), store hierarchy import fails due to 'unique constraint' on table PA_ARTY caused by overlapping sequences PA_CT_SEQ and PA_PRTY_SEQ.

Steps To Reproduce:

1. Create customers from Oracle Retail Point of Service (ORPOS) so that the number of customers created is greater in number than the PA_PRTY_SEQ.
2. Confirm that all new customers are replicated from the store to central office.
    Note: PA_CT_SEQ is used to store ID_PRTY in PA_PRTY table. In the database PA_CT_SEQ should be greater than PA_PRTY_SEQ
3. Import store hierarchy file into ORCO

Observe that the import fails due to error below:

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