Denormailzed Column Used in Query and Denormalized Column Not Always Populated With Data (S_ACT_EMP)

(Doc ID 497248.1)

Last updated on MARCH 02, 2017

Applies to:

Siebel CRM - Version 7.8.2.3 [19221] and later
z*OBSOLETE: Microsoft Windows Server 2003
Product Release: V7 (Enterprise)
Version: 7.8.2.3 [19221]
Database: Microsoft SQL Server 2000 SP4
Checked For Relevance 13th August 2016

Application Server OS: Microsoft Windows 2003 Server SP1
Database Server OS: Microsoft Windows 2003 Server SP1

This document was previously published as Siebel SR 38-3399742731.


Symptoms

It was reported that when querying on the Activity List View (which uses the Action BC) , on the Status field, all of the expected records are not being retrieved. 

Analysis and investigation revealed that the column S_ACT_EMP.ACT_EVT_STAT_CD, which is a denormalized column, is being used in the where clause for the Siebel generated query rather than the expected S_EVT_ACT.EVT_STAT_CD column. 

Further analysis revealed that this column is not always being populated, with some records having nulls and this was affecting query results.

This can be reproduced using standard SRF and doing the following:
1. Create a new account call
2. Add an attendee call.
3. The resulting attendee call's S_ACT_EMP.ACT_EVT_STAT_CD is null.

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