Search Results original_uom

Overview

GMD_ITEM_SUBSTITUTION_HDR_B is the master header table for Item Substitution within the Oracle E-Business Suite Process Manufacturing Product Development module (GMD). In Oracle EBS 12.1.1 and 12.2.2, this table stores the substitution rules that define when one inventory item may be replaced by another during formulation, manufacturing, or order fulfillment. It functions as the controlling record for each substitution definition, holding the original item, the substitution preference, validity dates, and ownership context. The detail lines that specify which replacement items apply are stored in a companion table, while this header preserves the rule-level identity and status.

From a Data Vault modeling perspective, the metadata classifies this object heuristically as a standalone structure. This suggests modeling it as a hub or a self-contained entity rather than a link, since no inbound foreign keys to an upstream parent are documented — only outbound references from dependent tables. The primary key is GMD_ITEM_SUBSTITUTION_HDR_B_PK on SUBSTITUTION_ID, and a unique index, GMD_ITEM_SUBSTITUTION_HDR_B_U1, also exists on SUBSTITUTION_ID.

Key Information Stored

The table comprises 51 documented columns. The most significant include:

SUBSTITUTION_ID — the surrogate primary key and unique business-key candidate, uniquely identifying each substitution header record.
SUBSTITUTION_NAME — the user-facing name of the substitution rule.
SUBSTITUTION_STATUS — controls whether the rule is active, inactive, or otherwise enabled.
SUBSTITUTION_VERSION — supports versioning of substitution definitions.
ORIGINAL_ITEM_ID and ORIGINAL_INVENTORY_ITEM_ID — identify the item being substituted.
ORIGINAL_QTY, ORIGINAL_UOM, and ORIGINAL_ITEM_UOM — capture the quantity and unit of measure of the original item.
PREFERENCE — ranks substitution priority.
START_DATE and END_DATE — define the effective period of the rule.
OWNER_ORGN_CODE and OWNER_ORGANIZATION_ID — specify the owning organization.
REPLACEMENT_UOM_TYPE — indicates the unit-of-measure conversion type for replacements.
ATTRIBUTE_CATEGORY and ATTRIBUTE1 through ATTRIBUTE30 — the standard EBS descriptive flexfield columns.
CREATED_BY, CREATION_DATE, LAST_UPDATE_DATE, LAST_UPDATED_BY, and LAST_UPDATE_LOGIN — the standard audit columns.

Common Use Cases and Queries

Typical usage centers on retrieving active substitutions for a given item or organization. A common query filters on status and date range:

SELECT substitution_id, substitution_name, original_item_id, preference
FROM gmd_item_substitution_hdr_b
WHERE substitution_status = 'ACTIVE'
AND SYSDATE BETWEEN start_date AND NVL(end_date, SYSDATE + 1);

Reporting scenarios include analyzing substitution rules by owning organization, tracking expiring substitutions, and joining headers to detail lines for a complete rule definition. Integration with formula substitution logic is another frequent use case, where the header supplies rule-level context.

Related Objects

Several dependent tables reference this header through SUBSTITUTION_ID:

GMD_ITEM_SUBSTITUTION_DTL — the detail table holding individual replacement items for each rule.
GMD_FORMULA_SUBSTITUTION — links substitution definitions to formula substitution logic.
CE_UK_VAL_SUBS_CODES — a validation table referencing substitution headers.

These relationships confirm the header as the parent entity within the item substitution model, with all dependent records keyed by SUBSTITUTION_ID.

Table: GMD_ITEM_SUBSTITUTION_HDR_B 12.2.2
owner:GMD, object_type:TABLE, fnd_design_data:GMD.GMD_ITEM_SUBSTITUTION_HDR_B, object_name:GMD_ITEM_SUBSTITUTION_HDR_B, status:VALID, product: GMD - Process Manufacturing Product Development , description: This is master table for the Item Substitution, which holds the item substitution details , implementation_dba_data: GMD.GMD_ITEM_SUBSTITUTION_HDR_B ,
Table: GMD_ITEM_SUBSTITUTION_HDR_B 12.1.1
owner:GMD, object_type:TABLE, fnd_design_data:GMD.GMD_ITEM_SUBSTITUTION_HDR_B, object_name:GMD_ITEM_SUBSTITUTION_HDR_B, status:VALID, product: GMD - Process Manufacturing Product Development , description: This is master table for the Item Substitution, which holds the item substitution details , implementation_dba_data: GMD.GMD_ITEM_SUBSTITUTION_HDR_B ,
View: GMD_ITEM_SUBSTITUTION_HDR_VL 12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:GMD.GMD_ITEM_SUBSTITUTION_HDR_VL, object_name:GMD_ITEM_SUBSTITUTION_HDR_VL, status:VALID, product: GMD - Process Manufacturing Product Development , implementation_dba_data: APPS.GMD_ITEM_SUBSTITUTION_HDR_VL ,
View: GMD_ITEM_SUBSTITUTION_HDR_VL 12.2.2
owner:APPS, object_type:VIEW, fnd_design_data:GMD.GMD_ITEM_SUBSTITUTION_HDR_VL, object_name:GMD_ITEM_SUBSTITUTION_HDR_VL, status:VALID, product: GMD - Process Manufacturing Product Development , implementation_dba_data: APPS.GMD_ITEM_SUBSTITUTION_HDR_VL ,