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