Organization Specific LOV with BU_ID Gets Created With Different Org WS_SRC_ID (Doc ID 2737857.1)

Last updated on APRIL 18, 2023

Applies to:

Symptoms

When LOVs with BU_ID are loaded into S_LST_OF_VAL table, the identical LOVs belonging to different organizations get stamped with same WS_SRC_ID

Steps to reproduce:
---------------------
1. Create an LOV “EIM TEST” of type “AAG_ACCOUNT_TYPE” associated to Org “XYZ” [XYZ=0-R9NH through S_BU]
2. Load another LOV “EIM TEST” of type “AAG_ACCOUNT_TYPE” associated to Org “PQR” through EIM [PQR=1-1OIUI through S_BU]
3. EIM has no logic to distinguish these LOVs based on the BU_ID as the WS_SRC_ID does not have BU_ID as a foreign key mapping attribute.

Result of above:

The imported LOV with a different BU_ID must create a new record with ROW_ID = WS_SRC_ID = 1-36S-1, this does not happen

Changes

Cause

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