HOW THE CFG_STATE_CD FIELD IN THE S_ASSET_ITEM AND S_ASSET_ITEM_XA TABLE GETS POPULATED? (Doc ID 545725.1)

Last updated on MARCH 02, 2017

Applies to:

Siebel eConfigurator - Version 7.7.2.2 SIA [18356] and later
Oracle Solaris on SPARC (64-bit)
Product Release: V7 (Enterprise)
Version: 7.7.2.2 [18356] Fin Svcs
Database: Oracle 9.0.1.2
Application Server OS: Sun Solaris 9
Database Server OS: HP-UX 10.0

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


Goal


Customer would like to get some documentation on how the cfg_state_cd field in the s_asset_item and the s_asset_item_xa table gets populated.

They understand the list of values (e.g Saved Item, Engine Picked Item, User Requested Item etc), but they would like to understand the rules that dictate what value tie out to what conditions. Meaning when is it set to Saved Item, Engine Picked Item, User Requested Item etc.

They use eConfigurator with Group Policies. Currently customer is experiencing an inconsistent behavior that appears to be tied to the values in this field. For e.g. they can see data in the group policies list view (products and attributes), but when they render that through eConfigurator, they all appear as blanks.

Solution

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