Results for “csi_i_extended_attribs”

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

Overview

CSI_I_EXTENDED_ATTRIBS is a core table within the Oracle E-Business Suite Install Base (CSI) module. It stores the Extended Attribute Template definition — the flexible, user-defined descriptors that extend the standard Install Base item instance record with attribute sets defined at the item, category, or instance level. In Oracle EBS 12.1.1 and 12.2.2, this table serves as the anchor for the Install Base extended attribute framework, allowing installations to capture additional characteristics about customer products and configurations without modifying the base schema.

Within a Data Vault-style reading, the table is best characterized as satellite-leaning. It is keyed by a single surrogate column and carries descriptive, time-bounded attributes around business keys rather than acting as a pure hub or link. Under this modeling suggestion, the surrogate key serves as the technical identifier while the remaining business keys reference the parent dimensions.

Key Information Stored

The table consists of 36 documented columns. The most important include:

• ATTRIBUTE_ID — the surrogate primary key, defined by CSI_I_EXTENDED_ATTRIBS_PK and reinforced by the unique index CSI_I_EXTENDED_ATTRIBS_U01. This is the value referenced by child tables as a foreign key.
• ATTRIBUTE_CODE and ATTRIBUTE_NAME — the business-facing identifier and descriptive label of the extended attribute.
• ATTRIBUTE_LEVEL — indicates whether the attribute template applies at the instance level, item level, or category level.
• ATTRIBUTE_CATEGORY — the descriptor flexfield context under which the attribute is grouped.
• INSTANCE_ID — a foreign key to CSI_ITEM_INSTANCES, tying the template to a specific installed instance.
• INVENTORY_ITEM_ID and MASTER_ORGANIZATION_ID — the foreign keys to MTL_SYSTEM_ITEMS_B that bind the template to a defined item and its master organization.
• ITEM_CATEGORY_ID — a foreign key to MTL_CATEGORIES_B when the attribute level is category-based.
• ACTIVE_START_DATE and ACTIVE_END_DATE — the effective dating window for the template.
• ATTRIBUTE1 through ATTRIBUTE15 — the DFF/descriptive flexfield segments used to store configuration values.
• SECURITY_GROUP_ID — the foreign key to FND_SECURITY_GROUPS scoping multi-org and data security.
• MIGRATED_FLAG and standard audit columns (CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE) — control and auditability fields.

The unique index CSI_I_EXTENDED_ATTRIBS_U02 (ATTRIBUTE_CODE, ATTRIBUTE_LEVEL, INVENTORY_ITEM_ID, MASTER_ORGANIZATION_ID, ITEM_CATEGORY_ID, INSTANCE_ID) is the composite business-key candidate, distinguishing the surrogate ATTRIBUTE_ID from the logical uniqueness of the template definition.

Common Use Cases and Queries

Typical usage centers on defining, retrieving, and reporting extended attribute values for installed items. A common query joins the table to its associated values:

• Locate all templates for a given item: SELECT ATTRIBUTE_ID, ATTRIBUTE_CODE, ATTRIBUTE_NAME FROM CSI.CSI_I_EXTENDED_ATTRIBS WHERE INVENTORY_ITEM_ID = :p_item AND ACTIVE_END_DATE IS NULL.
• Retrieve deployed values by joining to CSI_IEA_VALUES on ATTRIBUTE_ID.
• Report templates at the category level using ITEM_CATEGORY_ID joined to MTL_CATEGORIES_B.
• Audit effective-dating using ACTIVE_START_DATE and ACTIVE_END_DATE filters.

Reporting scenarios include Install Base configuration inventories, service contract coverage analysis, and customer asset audits where extended attributes drive classification.

Related Objects

The most significant relationships are:

• CSI_ITEM_INSTANCES — parent instance records via INSTANCE_ID.
• MTL_SYSTEM_ITEMS_B — item definition via INVENTORY_ITEM_ID and MASTER_ORGANIZATION_ID.
• MTL_CATEGORIES_B — category definitions via ITEM_CATEGORY_ID.
• FND_SECURITY_GROUPS — security scoping via SECURITY_GROUP_ID.
• CSI_IEA_VALUES — child table holding actual attribute values, referenced through ATTRIBUTE_ID.
• CSI_T_EXTEND_ATTRIBS — template metadata referenced via ATTRIB_SOURCE_ID.
• XDP_WORKLIST_DETAILS — worklist integration via ATTRIB_SOURCE_ID.

Together these objects form the backbone of the Install Base extended attribute framework across EBS 12.1.1 and 12.2.2.