Search Results gme_material_details

Overview

The GME_MATERIAL_DETAILS table is a core data object within the Oracle E-Business Suite Process Manufacturing (GME) module, specifically for Process Execution. Its primary role is to store detailed quantity information for materials (ingredients, products, by-products) associated with a Work in Process (WIP) batch or a Formulated Process Order (FPO). A critical function of this table, as indicated by the official description, is to track actual quantities when a batch is scaled. When scaling occurs, the actual quantity is not updated on the Process Manufacturing (PM) side of the system. Therefore, GME_MATERIAL_DETAILS serves as the necessary repository to maintain accurate quantity data, ensuring consistency between the PM and Process Operations Control (POC) components.

Key Information Stored

The table stores material transaction details linked to a specific batch. Its structure is defined by a primary key on MATERIAL_DETAIL_ID and a unique key constraint that enforces uniqueness per batch line. Essential columns include:

• MATERIAL_DETAIL_ID: The unique system-generated identifier (Primary Key).
• BATCH_ID: Foreign key to GME_BATCH_HEADER, linking the detail to its parent batch or FPO.
• LINE_NO: Identifies the specific material line within the batch formula.
• LINE_TYPE: Denotes the type of material line (e.g., ingredient, product, co-product).
• Quantity columns (as per the description) that hold the planned, actual, and scaled quantities for the material. These are crucial for tracking discrepancies post-scaling and for accurate cost and inventory reconciliation.

Common Use Cases and Queries

This table is central to batch execution reporting and reconciliation. Common use cases include generating batch material yield reports, analyzing variance between planned and actual material consumption, and supporting inventory interface transactions. For technical consultants, frequent queries involve joining to batch header and master recipe tables. A typical pattern to retrieve material details for a specific batch would be:

SELECT gmd.line_no, gmd.line_type, gmd.actual_qty, gmd.planned_qty
FROM gme_material_details gmd
WHERE gmd.batch_id = :batch_id
ORDER BY gmd.line_no;

Another critical query scenario involves identifying materials where scaling has caused a divergence between system quantities, which is essential for post-scale adjustment programs or custom reports.

Related Objects

GME_MATERIAL_DETAILS is intrinsically linked to several key Process Manufacturing tables. Its primary relationship is with GME_BATCH_HEADER (via BATCH_ID), which stores the batch master record. It is also closely related to GME_MATERIAL_DETAILS_HIST, which may archive historical transactions. The table is referenced by various Process Execution APIs and forms that manage batch material transactions. For complete material definition, queries often join to GMT_MATERIALS or item master tables (MTL_SYSTEM_ITEMS_B) using the material identifier stored within the detail record.