EIM - Unable To Update The Denormalized Column S_ACT_EMP.ACT_EVT_STAT_CD With S_EVT_ACT.EVT_STAT_CD in Siebel Version 8.1.1.10 (Doc ID 1614374.1)

Last updated on JULY 20, 2016

Applies to:

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

Symptoms

On : 8.1.1.10 SIA [21229] version, EIM

ACTUAL BEHAVIOR
----------------------
When the value of field S_EVT_ACT.EVT_STAT_CD is updated using EIM, the value of S_ACT_EMP.ACT_EVT_STAT_CD remains unchanged. S_ACT_EMP.ACT_EVT_STAT_CD is a denormalized column and EIM is unable to update this column in 8.1.1.10.

EXPECTED BEHAVIOR
-----------------------
S_ACT_EMP.ACT_EVT_STAT_CD is a denormalized column and should be updated with the value of EVT_STAT_CD column of S_EVT_ACT, when running EIM.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Load data into EIM_ACTIVITY
2. Run EIM.

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot update denormalized columns using EIM.

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