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 AUGUST 21, 2015

Applies to:

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


<p >*Symptoms
<span >Briefly describe the symptoms of the problem. Remember to delete any customer specific information


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



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