When Using EIM_PROD_INT2 Interface Table, S_PROD_LN_PROD Is Not Getting Deleted
Last updated on MAY 30, 2017
Applies to:Siebel Life Sciences CRM - Version 220.127.116.11 [IP2014] and later
Information in this document applies to any platform.
Set up a job do delete associations between Products and Product Lines. In EIM_PROD_INT2, populate PROD_NAME, PROD_BU and PRODLN_PROD_LN_NAME.
EIM will successfully populate T_PRODLNPRO_PRODID and T_PRODLNPRO_PRODLN columns but will fail subsequently to identify the ROW_ID of S_PROD_LN_PROD records.
In order to fill T_PRODLNPRO__RID, EIM generates the following statement:
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms