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 DECEMBER 03, 2019

Applies to:

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

Symptoms

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

--Error

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



--Steps

1. Run Party Merge process
2. Error Occurs



Changes

 User had been de-activated and then re-actived

 

Cause

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
Symptoms
Changes
Cause
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.