My Oracle Support Banner

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

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
Symptoms
Cause
Solution
References


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