Search Results ego_obj_ag_assocs_b




Overview
Explore in AI Chat

Overview

EGO_OBJ_AG_ASSOCS_B is a base table in the EGO schema, owned by the Advanced Product Catalog module in Oracle E-Business Suite (documented for 12.1.1 and 12.2.2). It stores the associations between catalog objects and attribute groups, effectively defining which attribute groups are attached to which object definitions and under which classification and data level. This mapping is foundational to the extensible attribute framework used throughout Oracle Product Information Management, enabling attribute groups to be reused across multiple object definitions rather than being duplicated.

From a Data Vault modeling perspective, the metadata classifies this object heuristically as standalone. In practice, this suggests treating EGO_OBJ_AG_ASSOCS_B as a link-style structure that resolves the relationship between an object and an attribute group, with the association identifier serving as the durable key and edition/audit attributes acting as satellites to track attribute-level change over time.

Key Information Stored

The surrogate primary key is ASSOCIATION_ID, enforced by EGO_OBJ_AG_ASSOCS_B_PK. Two unique indexes document the business-key candidates:

The most significant columns include OBJECT_ID, which identifies the catalog object being extended; ATTR_GROUP_ID, which references the attribute group being attached; CLASSIFICATION_CODE, which scopes the association to a specific classification; and DATA_LEVEL_ID (with the companion DATA_LEVEL value), which distinguishes level-specific versus level-independent behavior. ENABLED_FLAG controls whether the association is currently active. VIEW_PRIVILEGE_ID and EDIT_PRIVILEGE_ID capture the security privileges governing who may view or modify the association. Finally, ZD_EDITION_NAME supports edition-based redefinition in 12.2.2, while CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, and LAST_UPDATE_LOGIN provide the standard audit trail.

Common Use Cases and Queries

The table is typically queried to determine which attribute groups appear on a given object or classification, to audit privilege assignments, and to validate configuration completeness after a setup migration.

  • Listing attribute groups attached to an object: 
    SELECT OBJECT_ID, ATTR_GROUP_ID, CLASSIFICATION_CODE, DATA_LEVEL_ID
FROM   EGO_OBJ_AG_ASSOCS_B
WHERE  OBJECT_ID = :object_id
AND    ENABLED_FLAG = 'Y'
AND    (ZD_EDITION_NAME IS NULL OR ZD_EDITION_NAME = :edition);
  • Checking for duplicate or conflicting business keys before insert, using the U2 column set.
  • Reporting on edit versus view privilege coverage for an object definition.
  • Reconciling associations against attribute group definitions in EGO_ATTR_GROUPS_V during upgrade validation from 12.1.1 to 12.2.2, where ZD_EDITION_NAME becomes relevant.

Related Objects

Because the object is a standalone, no additional foreign-key-to-hub relationships are enforced at the database level, so joins to the related tables above are performed on the documented business columns rather than declared constraints.