Search Results gmd_material_details_gtmp




Overview
Explore in AI Chat

Overview

GMD_MATERIAL_DETAILS_GTMP is a global temporary table owned by the GMD schema in Oracle E-Business Suite, belonging to the Process Manufacturing Product Development module. The "_GTMP" suffix indicates that this is a session-scoped staging object rather than a permanent transactional table. It is used to temporarily hold material, quantity, lot, and grade detail records while a formula, recipe, or material transaction is being processed, exploded, rolled up, or displayed, before those records are committed to permanent storage or returned to a calling interface. The table is therefore a working buffer that supports material rollup and formula detail computation, and it typically holds rows only for the lifetime of the database session that populated it.

The mined relationship data classifies this object heuristically as standalone under a Data Vault modelling view, meaning it behaves as an isolated staging construct with no dependent child tables of its own. The only documented foreign key is a reference from RESERVATION_ID to MTL_RESERVATIONS, indicating that reservation context may be carried alongside staged material lines. Because the name carries the _GTMP marker, it should not be treated as an audited source of truth; it is populated on demand by Process Manufacturing programs and reports.

Key Information Stored

The physical definition documents 72 columns. The most significant include:

Common Use Cases and Queries

This table is normally accessed only within the session that populated it, so queries are session-local and often used for troubleshooting or confirming what a Process Manufacturing program staged before committing. A typical pattern joins the staged rows to inventory items and lot master data, for example selecting ENTITY_ID, LINE_ID, ITEM_NO, LOT_NO, and QTY where ITEM_ID matches an inventory item, or filtering by ENTITY_ID to isolate a single formula, recipe, or transaction. Reporting use cases include verifying material rollup output, reconciling staged quantities against actual material requirements, and validating lot and grade assignments. Because rows are transient, a query should be run immediately after the originating transaction or concurrent program has executed; otherwise the table will typically appear empty.

Related Objects

The documented relationship ties GMD_MATERIAL_DETAILS_GTMP.RESERVATION_ID to MTL_RESERVATIONS.RESERVATION_ID, making MTL_RESERVATIONS the principal referenced object. Practical dependencies drawn from the column set include MTL_SYSTEM_ITEMS_B and MTL_SYSTEM_ITEMS_KFV for item identity, MTL_LOT_NUMBERS for lot validation, MTL_ITEM_LOCATIONS and subinventory definitions for locator context, and GMD_FORMULA / GMD_RECIPE structures where formula and recipe lines are being expanded. The staged material lines are closely related in purpose to permanent Process Manufacturing material detail structures, and MTL_MATERIAL_TRANSACTIONS provides the authoritative posting record against which staged details are ultimately realized. Because it is a temporary table, no dependent objects should be built directly against it.