Results for “attrib_source_id”

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

Overview

CSI_T_EXTEND_ATTRIBS is a transaction-detail table in the CSI (Install Base) product of Oracle E-Business Suite, holding the extended attribute values captured against inventory and install-base transactions. The table resides in the CSI schema and is documented as a VALID object in both Oracle EBS 12.1.1 and 12.2.2. Its stated purpose is to store the extended attributes associated with transaction details, complementing the core transaction line detail records with flexible, source-driven attribute values.

Each row represents a single extended-attribute assignment for a transaction line detail. The record is qualified by an attribute source and a source table reference, allowing a transaction line to carry multiple extended attributes drawn from configurable attribute definitions and value sets. In the Install Base context, these attributes carry customer-defined descriptive and operational data that the standard transaction model does not accommodate.

Under a heuristic Data Vault classification mined from the foreign-key structure, this table is satellite-leaning. It captures descriptive, time-bounded attributes (evidenced by ACTIVE_START_DATE and ACTIVE_END_DATE) attached to a parent transaction line detail, which aligns with satellite behavior rather than hub or link semantics.

Key Information Stored

The table contains 33 columns. The most significant are summarized below.

• TXN_ATTRIB_DETAIL_ID — The surrogate primary key, defined by CSI_T_EXTEND_ATTRIBS_PK. It also serves as the sole column of the unique index CSI_T_EXTEND_ATTRIBS_U01.
• TXN_LINE_DETAIL_ID — Foreign key to CSI_T_TXN_LINE_DETAILS, anchoring each extended attribute to its parent transaction line detail.
• ATTRIB_SOURCE_ID — Foreign key referencing both CSI_I_EXTENDED_ATTRIBS and CSI_IEA_VALUES; identifies the extended attribute definition or the value-set entry from which the attribute derives.
• ATTRIB_SOURCE_TABLE — Identifies the source table supplying the attribute definition or value.
• ATTRIBUTE_VALUE — Holds the captured value of the extended attribute for the transaction line detail.
• ACTIVE_START_DATE / ACTIVE_END_DATE — Define the effective interval of the attribute record, enabling dated attribute history.
• PRESERVE_DETAIL_FLAG — Indicates whether the attribute detail must be retained through processing or migration.
• PROCESS_FLAG / MIGRATED_FLAG — Control and status indicators used by processing and data-migration programs.
• SECURITY_GROUP_ID — Foreign key to FND_SECURITY_GROUPS; enforces Application Object Library security-group partitioning.
• OBJECT_VERSION_NUMBER — Optimistic locking column supporting concurrent updates.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — Standard EBS audit columns.
• CONTEXT — The descriptive flexfield context column, with ATTRIBUTE1 through ATTRIBUTE15 providing the corresponding flexfield segment values.

The surrogate key (TXN_ATTRIB_DETAIL_ID) is distinct from the documented business-key candidate, which is the same column exposed through the CSI_T_EXTEND_ATTRIBS_U01 unique index.

Common Use Cases and Queries

Reporting on extended transaction attributes is a frequent requirement for install-base data quality analysis, attribute completeness reporting, and downstream integration extracts.

• Retrieving all extended attributes for a transaction line detail:
  SELECT e.TXN_ATTRIB_DETAIL_ID, e.ATTRIB_SOURCE_ID, e.ATTRIBUTE_VALUE, e.ACTIVE_START_DATE, e.ACTIVE_END_DATE FROM CSI.CSI_T_EXTEND_ATTRIBS e WHERE e.TXN_LINE_DETAIL_ID = :line_detail_id;
• Joining to the parent transaction line detail:
  SELECT d.TXN_LINE_DETAIL_ID, e.ATTRIBUTE_VALUE FROM CSI.CSI_T_TXN_LINE_DETAILS d, CSI.CSI_T_EXTEND_ATTRIBS e WHERE d.TXN_LINE_DETAIL_ID = e.TXN_LINE_DETAIL_ID;
• Resolving the attribute definition via the source:
  SELECT e.ATTRIBUTE_VALUE, a.ATTRIB_SOURCE_ID FROM CSI.CSI_T_EXTEND_ATTRIBS e, CSI.CSI_I_EXTENDED_ATTRIBS a WHERE e.ATTRIB_SOURCE_ID = a.ATTRIB_SOURCE_ID;
• Filtering only currently active attributes using ACTIVE_START_DATE and ACTIVE_END_DATE.
• Isolating records still awaiting processing via PROCESS_FLAG, or already migrated via MIGRATED_FLAG.

Related Objects

The following objects are most significant to CSI_T_EXTEND_ATTRIBS, based on the documented foreign-key relationships.

• CSI_T_TXN_LINE_DETAILS — Parent table; joined on TXN_LINE_DETAIL_ID.
• CSI_I_EXTENDED_ATTRIBS — Attribute definition table; joined on ATTRIB_SOURCE_ID.
• CSI_IEA_VALUES — Attribute value-set table; joined on ATTRIB_SOURCE_ID.
• FND_SECURITY_GROUPS — AOL security group table; joined on SECURITY_GROUP_ID.
• XDP_WORKLIST_DETAILS — References this table through TXN_ATTRIB_DETAIL_ID; links worklist processing to the extended attribute detail record.