When Using EIM_PROD_INT2 Interface Table, S_PROD_LN_PROD Is Not Getting Deleted

(Doc ID 2151625.1)

Last updated on MAY 30, 2017

Applies to:

Siebel Life Sciences CRM - Version [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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms