My Oracle Support Banner

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

Last updated on JUNE 25, 2021

Applies to:

Siebel CRM - Version 17.0 [IP2017] and later
Information in this document applies to any platform.


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




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

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