When ONLY BASE COLUMNS parameter for S_PROD_INT_BU table is set, these columns are not updated. (Doc ID 1992851.1)

Last updated on JULY 13, 2015

Applies to:

Siebel CRM - Version 8.1.1.11.9 [IP2013] and later
Information in this document applies to any platform.

Symptoms

There is a requirement to update PROD_EFF_START_DT and PROD_EFF_END_DT columns on S_PROD_INT_BU table, using EIM_PROD_INT table. The following columns are specified for ONLY BASE COLUMNS parameter.

 

ONLY BASE COLUMNS = S_PROD_INT.NAME, \

S_PROD_INT.BU_ID, \

S_PROD_INT.VENDR_OU_ID, \

S_PROD_INT_BU.BU_ID, \

S_PROD_INT_BU.PROD_INT_ID, \

S_PROD_INT_BU.PROD_CD, \

S_PROD_INT_BU.PROD_EFF_START_DT, \

S_PROD_INT_BU.PROD_EFF_END_DT

 

Although the user keys and the target columns are specified, PROD_EFF_START_DT and PROD_EFF_END_DT columns are not updated.

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