Results for “csi_iea_values”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

CSI_IEA_VALUES is the Install Base (CSI) transaction table that stores instance extended attribute values in Oracle E-Business Suite 12.1.1 and 12.2.2. Where CSI_ITEM_INSTANCES captures the core definition of an installed item instance, CSI_IEA_VALUES holds the user-defined and seeded extended attribute data attached to that instance. The table carries the description "Instance Extended Attribute Values" and resides in the CSI schema under the Install Base product, with a status of VALID in the ETRM repository.

Functionally, the object acts as the value side of an attribute framework: each row links a specific instance (INSTANCE_ID) to a specific extended attribute definition (ATTRIBUTE_ID) and stores the resulting value in ATTRIBUTE_VALUE. Because it resolves a many-to-many relationship between instances and attribute definitions, the metadata classifies this object heuristically as hub-leaning in a Data Vault model. This classification should be treated as a modeling suggestion rather than a documented fact; the physical table itself functions as a detail/value store keyed by the surrogate ATTRIBUTE_VALUE_ID.

The table is non-key-flex and is maintained through standard concurrent and form processing. It includes WHO audit columns, a SECURITY_GROUP_ID for multi-org reference filtering, an OBJECT_VERSION_NUMBER for optimistic locking, and a MIGRATED_FLAG used to signal rows that arrived through migration rather than direct entry.

Key Information Stored

CSI_IEA_VALUES contains 30 documented columns. The most significant are:

• ATTRIBUTE_VALUE_ID — the surrogate primary key (CSI_IEA_VALUES_PK) and also the unique business-key candidate via CSI_IEA_VALUES_U01.
• INSTANCE_ID — foreign key to CSI_ITEM_INSTANCES; identifies the installed instance to which the value belongs.
• ATTRIBUTE_ID — foreign key to CSI_I_EXTENDED_ATTRIBS; identifies the extended attribute definition being populated.
• ATTRIBUTE_VALUE — the actual stored value of the extended attribute for that instance.
• ACTIVE_START_DATE / ACTIVE_END_DATE — date-effectivity window for the value, enabling historical tracking.
• CONTEXT — the descriptive flexfield context under which the attribute is defined.
• ATTRIBUTE1 through ATTRIBUTE15 — the DFF segment columns available for structured capture.
• SECURITY_GROUP_ID — reference to FND_SECURITY_GROUPS controlling visibility.
• MIGRATED_FLAG — indicates legacy-migrated records.
• OBJECT_VERSION_NUMBER — optimistic locking support.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — standard WHO audit columns.

Common Use Cases and Queries

Typical reporting joins CSI_IEA_VALUES back to CSI_ITEM_INSTANCES to present instance attribute data alongside the installed asset, or to CSI_I_EXTENDED_ATTRIBS to resolve attribute names. For example, an attribute listing by instance can be written as a join across INSTANCE_ID and ATTRIBUTE_ID:

SELECT iea.ATTRIBUTE_VALUE, def.ATTRIBUTE_NAME FROM CSI.CSI_IEA_VALUES iea, CSI.CSI_I_EXTENDED_ATTRIBS def, CSI.CSI_ITEM_INSTANCES inst WHERE iea.ATTRIBUTE_ID = def.ATTRIBUTE_ID AND iea.INSTANCE_ID = inst.INSTANCE_ID AND iea.SECURITY_GROUP_ID = :sg.

Common scenarios include: auditing which instances carry a particular extended attribute value, extracting current values by filtering on ACTIVE_START_DATE and ACTIVE_END_DATE, reviewing historical value changes, identifying migrated rows through MIGRATED_FLAG, and supporting worklist-driven attribute maintenance where XDP_WORKLIST_DETAILS references ATTRIB_SOURCE_ID.

Related Objects

• CSI_ITEM_INSTANCES — joined via CSI_IEA_VALUES.INSTANCE_ID; parent of the installed instance.
• CSI_I_EXTENDED_ATTRIBS — joined via CSI_IEA_VALUES.ATTRIBUTE_ID; attribute definition table.
• CSI_IEA_VALUES_H — history table; references CSI_IEA_VALUES.ATTRIBUTE_VALUE_ID.
• CSI_T_EXTEND_ATTRIBS — references CSI_IEA_VALUES via ATTRIB_SOURCE_ID.
• XDP_WORKLIST_DETAILS — references CSI_IEA_VALUES via ATTRIB_SOURCE_ID.
• FND_SECURITY_GROUPS — joined via SECURITY_GROUP_ID.