Store Hierarchy Import Fails Due to 'ORA-00001: unique constraint violated' When PA_CT_SEQ and PA_PRTY_SEQ Overlap
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.
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:
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