Merged SO Not Always Kept With Active SO For A Chain Of System Merges (Doc ID 2663501.1)

Last updated on JULY 13, 2023

Applies to:

Symptoms

On : 4.0.2.2 version, Master Index Main Component

ISSUE
---------------
When a chain of system merges takes place, the merged SO is not always kept with the active SO.

For example:

If for source system A, local id 111 is merged into local id 222, and then local id 222 is merged into local id 333, then under some circumstances local id 111 ends up on a different EUID to 222 and 333.
This occurs when local id 222 is on an EUID that also has an active local id from a different source system (say, source system B).

If local id 222 was the only active local id on its EUID, the system merge works as expected and all three local ids would end up on the same EUID (with 111 and 222 having a merged status).

STEPS
-----------------------
The issue can be reproduced at will with the following steps:

1. Create three EUIDs, A, B and C, using a single source system and three local ids, 1, 2 and 3 respectively.
2. Add a second source system to EUID B for a different source. This means EUID B will have two SOs, with two different system codes.
3. Use the web service to merge local id 1 into local id 2. This will merge EUID A into B and change local id 1 to a status of merged.
4. Use the web service to merge local id 2 into local id 3. This will move local id 2 to EUID C and change its status to merged, but it leaves local id 1 on EUID B.

Cause

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