My Oracle Support Banner

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 MAY 03, 2021

Applies to:

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

Symptoms

On running EIM process the value of S_ACT_EMP.ACT_EVT_STAT_CD remains unchanged when value of field S_EVT_ACT.EVT_STAT_CD is updated.

S_ACT_EMP.ACT_EVT_STAT_CD is a denormalized column and EIM is unable to update this column in 8.1.1.10.

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

 

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.