Search Results edw_sec_itemset_info_t

Overview

EDW_SEC_ITEMSET_INFO_T is a metadata-bearing table owned by the BIS (Business Intelligence System / Applications BIS) schema within Oracle E-Business Suite. It forms part of the Enterprise Data Warehouse (EDW) security and item set infrastructure, and its presence is documented across both EBS 12.1.1 and 12.2.2 physical schemas. The table stores descriptive information about item sets and their association to fact definitions, enabling the EDW reporting layer to resolve how fact data is organized and exposed to downstream analytical consumers.

The ETRM documentation explicitly notes that this object is "Not implemented in this database," indicating that its presence is version- and installation-dependent. Administrators should verify existence before referencing the object in customizations or extracts. From a Data Vault modeling perspective, the heuristic classification mined from the foreign key structure is standalone. This suggests the table functions as a self-contained reference or descriptor entity rather than participating in a classic hub, link, or satellite pattern. As a modeling suggestion, it is best treated as a static reference dimension keyed on fact identity.

Key Information Stored

The documented physical schema exposes five columns. The most significant are described below:

• FACT_ID — The principal identifier column, documented as a foreign key referencing ASO_ER_DATA_BIN_FACT. It links each item set record to its parent fact definition and is the primary business join key.
• FACT_NAME — The short internal name of the associated fact, used in reporting filters and metadata displays.
• FACT_LONG_NAME — The descriptive label of the fact, suitable for user-facing reports and dashboards.
• ITEMSET_NAME — The name of the item set to which the fact is bound. This is the primary business-key candidate for identifying which analytical item set a fact belongs to.
• FK_COL_NAME — The name of the foreign key column used by the item set linkage, supporting dynamic or generic join resolution within the EDW security framework.

No surrogate primary key is documented in the ETRM excerpt; FACT_ID serves as the operative identifier through its foreign key relationship. Because the table is classified as standalone, no unique index is formally documented, and the combination of FACT_ID and ITEMSET_NAME can reasonably be treated as a candidate business key for de-duplication in custom queries.

Common Use Cases and Queries

Typical use cases center on metadata reconciliation and reporting-layer auditing. Analysts use this table to confirm which item sets a given fact participates in, to translate fact identifiers into readable names, and to document the security schema during migration or cloning projects.

A representative query pattern joining the fact table is:

• SELECT i.FACT_ID, i.FACT_NAME, i.FACT_LONG_NAME, i.ITEMSET_NAME FROM EDW_SEC_ITEMSET_INFO_T i WHERE i.ITEMSET_NAME = :itemset;
• SELECT f.FACT_ID, i.ITEMSET_NAME FROM ASO_ER_DATA_BIN_FACT f JOIN EDW_SEC_ITEMSET_INFO_T i ON f.FACT_ID = i.FACT_ID;

These patterns support impact analysis before fact changes, item set usage inventories for security reviews, and diagnostic validation when a report returns unexpected item set membership. Because the table may not exist in every environment, defensive coding with existence checks is recommended.

Related Objects

The following objects are most significant in relation to EDW_SEC_ITEMSET_INFO_T:

• ASO_ER_DATA_BIN_FACT — Referenced via FACT_ID; the parent fact definition table providing the authoritative fact registry.
• ASO_ER_DATA_BIN — The broader data bin structure underpinning EDW fact storage and often joined through the fact table.
• EDW_SEC_* security tables — Sibling metadata objects in the BIS schema governing item set and role-based access definitions.
• BIS responsibility and menu objects — Which depend on EDW metadata to render analytical content correctly.

Collectively, these relationships position EDW_SEC_ITEMSET_INFO_T as a lightweight but essential descriptor bridging fact definitions and item set security in the Oracle EBS data warehouse layer.