Search Results csi_i_extended_attribs

Overview

The CSI_I_EXTENDED_ATTRIBS table is a core data definition table within the Oracle E-Business Suite Install Base (CSI) module. It serves as the master repository for defining extended attribute templates. These templates provide a flexible framework for capturing and storing custom, non-standard data points associated with item instances, inventory items, or item categories. The table's primary role is to define the metadata for these attributes—such as their data type, format, and validation rules—before specific values are assigned to individual item instances. This structure enables organizations to extend the standard Install Base data model to meet unique business requirements without customizing the core application.

Key Information Stored

The table's central column is the ATTRIBUTE_ID, which serves as the primary key and uniquely identifies each extended attribute definition. The table stores the context for where the attribute is applicable through foreign key columns linking to other master data entities. The INSTANCE_ID column links an attribute definition directly to a specific item instance in the CSI_ITEM_INSTANCES table. The INVENTORY_ITEM_ID and MASTER_ORGANIZATION_ID columns together link a definition to a specific item in the MTL_SYSTEM_ITEMS_B table. The ITEM_CATEGORY_ID column links a definition to an item category in the MTL_CATEGORIES_B table. Additional columns, implied by its template purpose, would typically store the attribute name, data type (e.g., VARCHAR2, NUMBER, DATE), value set information, display prompts, and whether it is mandatory.

Common Use Cases and Queries

A primary use case is generating a list of all defined extended attributes for a specific inventory item, which is essential for configuring user interfaces and validating data entry. For example, a query to find all attribute templates defined for a particular item in the master organization would join to MTL_SYSTEM_ITEMS_B. Another critical scenario is data migration or reporting, where one must extract the attribute definitions alongside the actual values stored in the related CSI_IEA_VALUES table. A common reporting pattern involves joining CSI_I_EXTENDED_ATTRIBS to CSI_IEA_VALUES on ATTRIBUTE_ID and to CSI_ITEM_INSTANCES to present a complete view of item instances and their custom characteristics. Administrators may also query this table to audit attribute usage before modifying or purging definitions.

Related Objects

The table maintains integral relationships with several key EBS objects, as documented by its foreign keys. It references master data tables: CSI_ITEM_INSTANCES (via INSTANCE_ID), MTL_SYSTEM_ITEMS_B (via INVENTORY_ITEM_ID and MASTER_ORGANIZATION_ID), and MTL_CATEGORIES_B (via ITEM_CATEGORY_ID). More significantly, it is referenced as a parent table by objects that store or utilize the defined attribute metadata. The CSI_IEA_VALUES table holds the actual values for item instances and references CSI_I_EXTENDED_ATTRIBS via ATTRIBUTE_ID. The CSI_T_EXTEND_ATTRIBS and XDP_WORKLIST_DETAILS tables reference it via ATTRIB_SOURCE_ID, indicating its metadata is used in transactional and service fulfillment (XDP) contexts, respectively.