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 :-
****** 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