Search Results gmd_material_header_gtmp




Overview
Explore in AI Chat

Overview

GMD_MATERIAL_HEADER_GTMP is a temporary staging table owned by the GMD schema (Process Manufacturing Product Development) in Oracle E-Business Suite 12.1.1 and 12.2.2. The "_GTMP" suffix identifies it as a global temporary table used to stage material header records during batch processing operations, most commonly when material movements are validated, expanded, or transferred from formula and batch definitions into permanent inventory transactions.

The table is documented as standalone under the heuristic Data Vault classification, meaning no downstream foreign keys were mined from its column set. In Data Vault modeling terms, this suggests treating it as an unintegrated staging area rather than a true hub, link, or satellite. Its transient nature and single-row batch identity reinforce that classification.

Key Information Stored

The table contains 25 documented columns. The surrogate primary key is ENTITY_ID, enforced by the unique index GMD_MATERIAL_HDR_GTMP_PK. No separate business-key unique index is documented.

Common Use Cases and Queries

This table is typically referenced when troubleshooting batch material processing, move order generation, or formula-to-inventory transfers. Analysts query it to inspect what was staged during a specific concurrent request run.

SELECT batch_id, batch_no, formula_no, orgn_code, maintain_type
FROM   gmd_material_header_gtmp
WHERE  batch_id = :batch_id;

A second pattern verifies move order linkage:

SELECT entity_id, formula_id, spr_id, move_order_header_id
FROM   gmd_material_header_gtmp
WHERE  update_inventory_ind = 'Y';

Reporting often joins staged rows back to permanent material headers once the batch completes.

Related Objects