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 8.1.1.14 [IP2014] and later
Information in this document applies to any platform.

Symptoms

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:

Cause

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