My Oracle Support Banner

iStore Duplicate Shopping Lists Are Leading To Party Merge Failure - ORA-00001: unique constraint (IBE.IBE_SH_SHP_LISTS_ALL_U2) violated (Doc ID 1531473.1)

Last updated on SEPTEMBER 10, 2021

Applies to:

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


When attempting to run the Party Merge process the following error relating to iStore occurs :-


Getting the below error when merging party xxx1 to xxx2

****** Error executing merge procedure : IBE_MERGE_PVT.merge_ship_lists for table : IBE_SH_SHP_LISTS_ALL
Data exists in table for the merge-to party. Aborting merge
**** Error ****
Error: Merge failed in procedure IBE_MERGE_PVT.merge_ship_lists for entity IBE_SH_SHP_LISTS_ALL
This unexpected SQL error occurred during the merge process :
ORA-00001: unique constraint (IBE.IBE_SH_SHP_LISTS_ALL_U2) violated


1. Run Party Merge process
2. Error Occurs


 User had been de-activated and then re-actived



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.