Search Results gmf_outgoing_material_layers

Overview

GMF.GMF_OUTGOING_MATERIAL_LAYERS is a Process Manufacturing Financials (GMF) base table that stores consumption material layers. It records the individual cost layers created when material is issued out of inventory in an Oracle EBS Process Manufacturing environment, working in conjunction with Oracle Cost Management's quantity layer architecture. The table captures document quantities, units of measure, and remaining inbound document quantities for each outgoing material transaction.

In terms of Data Vault modeling, the ETRM metadata classifies this object heuristically as standalone, meaning it presents no outgoing foreign keys other than the relationship to CST_QUANTITY_LAYERS through LAYER_ID. From a modeling suggestion perspective, this table behaves primarily as a satellite attached to the cost layer hub (CST_QUANTITY_LAYERS), since it holds descriptive and quantitative attributes (document quantity, UOM, remaining quantity) that qualify the parent layer. It also carries link-like characteristics through MMT_TRANSACTION_ID, which ties each layer record to an inventory transaction. The table is only valid in schemas where Process Manufacturing Financials is installed and is documented in ETRM 12.2.2 with 14 columns.

Key Information Stored

The table is keyed first by the surrogate identifier LAYER_ID, which is the sole column in unique index GMF_OUTGOING_MATERIAL_LAYR_U1 and serves as the FK to CST_QUANTITY_LAYERS. This is the principal business-key candidate for the layer parent.

• LAYER_ID — Surrogate/business key linking to the cost quantity layer.
• MMT_TRANSACTION_ID — Inventory transaction identifier; with LOT_NUMBER it forms the second unique index (GMF_OUTGOING_MATERIAL_LAYR_U2), providing an alternate business-key candidate.
• LOT_NUMBER — Lot consumed, part of the alternate unique key.
• TRANS_ID — Transaction reference for the outgoing document.
• LAYER_DOC_QTY — Document quantity held in the layer.
• LAYER_DOC_UM — Unit of measure for the layer document quantity.
• REMAINING_IB_DOC_QTY — Remaining inbound document quantity, used in cost roll-forward and depletion logic.
• MMT_ORGANIZATION_ID — Inventory organization context.
• Audit columns: CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN, and DELETE_MARK for logical deletion.

Common Use Cases and Queries

Typical usage centers on cost layer reconciliation, inventory depletion analysis, and lot-level cost traceability. A common pattern joins the table to CST_QUANTITY_LAYERS on LAYER_ID to retrieve full layer detail, and filters by organization and lot to trace consumption for a given item.

SELECT g.LAYER_ID, g.MMT_TRANSACTION_ID, g.LOT_NUMBER,
       g.LAYER_DOC_QTY, g.LAYER_DOC_UM, g.REMAINING_IB_DOC_QTY
FROM   GMF.GMF_OUTGOING_MATERIAL_LAYERS g
WHERE  g.MMT_ORGANIZATION_ID = :org_id
AND    g.DELETE_MARK = 0;

Reporting uses include period-end cost variance reports, lot consumption summaries for regulatory traceability, and reconciliation of remaining layer quantities against inventory balances. Because REMAINING_IB_DOC_QTY tracks depletion, it is useful in aging reports for layer consumption. Queries should always include DELETE_MARK = 0 to exclude logically deleted rows, and filters on MMT_ORGANIZATION_ID for organization-level performance.

Related Objects

• CST_QUANTITY_LAYERS — Parent cost layer table; joined on LAYER_ID = CST_QUANTITY_LAYERS.LAYER_ID via the documented FK.
• MTL_MATERIAL_TRANSACTIONS (MMT) — Joined on MMT_TRANSACTION_ID = MTL_MATERIAL_TRANSACTIONS.TRANSACTION_ID; supplies item, subinventory, and transaction type context.
• GMF_OUTGOING_MATERIAL_TMP / related GMF cost tables — Companion staging and cost distribution tables in the Process Manufacturing Financials cost flow.
• CST_LAYER_COST_DETAILS — Provides per-layer valuation amounts when combined with layer IDs.
• MTL_TRANSACTION_LOT_NUMBERS — Supplies lot validation and quantity detail matched on lot and transaction.
• MTL_SYSTEM_ITEMS / MTL_PARAMETERS — Item and organization definitions referenced through the MMT organization and item identifiers.

These relationships position GMF_OUTGOING_MATERIAL_LAYERS as a bridging satellite between inventory transaction activity and cost layer valuation within Process Manufacturing Financials.