Search Results ego_item_gtn_attrs_b_u1

Overview

EGO.EGO_ITEM_GTN_ATTRS_B is a transaction-data table in the Oracle E-Business Suite (EBS) 12.1.1 / 12.2.2 EGO schema that stores the single-row, untranslated Global Data Synchronization Network (GDSN) attribute values for a given item and organization. In the ETRM (E-Business Suite Technical Reference Manual) the object is documented as VALID with FND Design Data reference EGO.EGO_ITEM_GTN_ATTRS_B, and it resides in the APPS_TS_TX_DATA tablespace with a PCT Free of 10.

Functionally, the table supports item data synchronization and trade-item (GDSN / GS1) attribute publication within Oracle Product Information Management (PIM) and the Item Master. Because the "_B" suffix denotes the base, untranslated table, user-facing or language-dependent descriptions are held in a corresponding "_TL" table, while the physical, code-level GDSN values persist here.

The metadata heuristic mined from the foreign-key structure classifies this object as standalone — that is, it is modeled as a standalone entity rather than a classic Data Vault hub, link, or satellite. In Data Vault terms it most closely resembles a satellite attached to the item/organization business key, since it carries descriptive, attribute-rich content (weights, packaging, temperatures, regulatory flags) keyed against INVENTORY_ITEM_ID and ORGANIZATION_ID rather than introducing new business keys of its own. This classification should be treated as a modeling suggestion only; the authoritative structure is defined by the two unique indexes EGO_ITEM_GTN_ATTRS_B_U1 and EGO_ITEM_GTN_ATTRS_B_U2.

Key Information Stored

The table is wide (111 documented columns in the 12.2.2 physical schema) but the following columns carry the primary structural and business meaning:

• EXTENSION_ID (NUMBER(15), mandatory) — unique identifier for the attribute row; enforced by the unique index EGO_ITEM_GTN_ATTRS_B_U2.
• INVENTORY_ITEM_ID (NUMBER(15), mandatory) — inventory item identifier; foreign key to MTL_SYSTEM_ITEMS_B.
• ORGANIZATION_ID (NUMBER(15), mandatory) — organization identifier; foreign key to MTL_SYSTEM_ITEMS_B.

Together, INVENTORY_ITEM_ID and ORGANIZATION_ID form the composite business key enforced by the unique index EGO_ITEM_GTN_ATTRS_B_U1. The surrogate primary key is EXTENSION_ID. This distinction is important: EXTENSION_ID uniquely identifies a physical row, whereas the item/organization pair uniquely identifies the business entity.

Additional significant attribute columns include:

• ITEM_CATALOG_GROUP_ID and REVISION_ID — catalog grouping and item revision references (foreign keys to MTL_ITEM_CATALOG_GROUPS_B and MTL_ITEM_REVISIONS_B respectively).
• GROSS_WEIGHT / UOM_GROSS_WEIGHT and other measurement pairs such as NET_CONTENT, DIAMETER, DRAINED_WEIGHT and STACKING_FACTOR with their associated UOM columns.
• Regulatory and packaging flags such as IS_TRADE_ITEM_A_CONSUMER_UNIT, IS_PACK_MARKED_WITH_GREEN_DOT, IS_TRADE_ITEM_GENETICALLY_MOD and IS_TRADE_ITEM_RECALLED.
• Commercial/availability attributes including BRAND_NAME, CATALOG_PRICE, SUGGESTED_RETAIL_PRICE, EFFECTIVE_DATE, CANCELED_DATE, DISCONTINUED_DATE and the START/END_AVAILABILITY_DATE_TIME pair.
• Standard EBS audit columns: CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN and REQUEST_ID.

Common Use Cases and Queries

Typical usage clusters around item synchronization reporting, GDSN export validation, and data quality checks on trade-item attributes.

• Retrieve GDSN attributes for a specific item and organization:

  SELECT extension_id, inventory_item_id, organization_id,
         gross_weight, uom_gross_weight, brand_name,
         effective_date, canceled_date
    FROM ego.ego_item_gtn_attrs_b
   WHERE inventory_item_id = :item_id
     AND organization_id   = :org_id;

• Validate uniqueness / detect duplicates against the business key (should return rows only if integrity is compromised):

  SELECT inventory_item_id, organization_id, COUNT(*)
    FROM ego.ego_item_gtn_attrs_b
   GROUP BY inventory_item_id, organization_id
  HAVING COUNT(*) > 1;

• Report items flagged as trade items with discontinued dates for catalog maintenance.
• Join to MTL_SYSTEM_ITEMS_B to surface item descriptions alongside GDSN measurements for synchronization extracts.

For lookup by surrogate key, filtering on EXTENSION_ID is the most efficient access path.

Related Objects

The following objects are the most significant dependencies and join targets:

• MTL_SYSTEM_ITEMS_B — joined on INVENTORY_ITEM_ID and ORGANIZATION_ID; supplies the base item/organization definition.
• MTL_ITEM_CATALOG_GROUPS_B — referenced via ITEM_CATALOG_GROUP_ID for search and catalog grouping.
• MTL_ITEM_REVISIONS_B — referenced via REVISION_ID for item revision context.
• EGO_ITEM_GTN_ATTRS_TL — the translated counterpart holding language-dependent attribute text keyed to the base row.
• EGO_ITEM_GTN_ATTRS_B_U1 and EGO_ITEM_GTN_ATTRS_B_U2 — the unique indexes enforcing the business key and surrogate key respectively.

Where GDSN publication or synchronization is required, public APIs and concurrent programs in the EGO/PIM product family operate against this table as the persistence layer for the untranslated attribute payload.