Denormailzed Column Used in Query and Denormalized Column Not Always Populated With Data (S_ACT_EMP)
Last updated on MARCH 02, 2017
Applies to:Siebel CRM - Version 22.214.171.124  and later
z*OBSOLETE: Microsoft Windows Server 2003
Product Release: V7 (Enterprise)
Version: 126.96.36.199 
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.
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.
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