Results for “target_container_tare”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

GMO_MATERIAL_DISPENSES is a core transactional table within the Oracle Manufacturing Execution System for Process Manufacturing (GMO) product family. It records the physical dispensing of raw materials and ingredients from source containers into target containers during the execution of a batch or work order. Each row represents a discrete dispensing event, capturing the material being issued, the quantities required versus dispensed, container and weight information, and the batch context in which the dispense occurred.

The table resides in the GMO schema and is documented as VALID in both Oracle EBS 12.1.1 and 12.2.2 environments. Its primary key is GMO_MATERIAL_DISPENSES_PK, defined on the DISPENSE_ID column. The ETRM heuristic Data Vault classification for this object is standalone, indicating that the table is modeled primarily as an independent transaction entity rather than being tightly bound into a single hub-and-satellite chain. From a modeling perspective, this suggests the table can be treated as a self-contained fact or hub candidate, with its relationships expressed through foreign keys to reference tables rather than through shared business keys.

Key Information Stored

The table contains 39 documented columns. The most operationally significant are listed below.

• DISPENSE_ID — Surrogate primary key, unique identifier for each dispensing event.
• ORGANIZATION_ID, BATCH_ID, DISPENSE_ID — Collectively form the unique index GMO_MATERIAL_DISPENSES_U1, a business-key candidate scoping a dispense to an organization and batch.
• BATCH_STEP_ID — Identifies the specific batch step against which the dispense is performed.
• INVENTORY_ITEM_ID — The material item being dispensed.
• DISPENSE_NUMBER — Human-readable dispense identifier used in operational reporting.
• DISPENSE_TYPE, DISPENSE_SOURCE — Classify the nature and origin of the dispense.
• REQUIRED_QTY and DISPENSED_QTY — Planned versus actual quantities, expressed in DISPENSE_UOM.
• SOURCE_CONTAINER_DEVICE_ID and TARGET_CONTAINER_DEVICE_ID — The physical source and destination containers involved.
• ACTUAL_GROSS_WEIGHT, GROSS_REQUIRED_WEIGHT, SOURCE_CONTAINER_TARE, SOURCE_CONTAINER_WEIGHT, SOURCE_CONTAINER_REWEIGHT, TARGET_CONTAINER_TARE — Weight capture columns supporting gravimetric reconciliation.
• DISPENSED_DATE, DISPENSING_MODE — Timing and mode of the dispensing action.
• RESERVATION_ID — Foreign key to MTL_RESERVATIONS, tying the dispense to inventory reservation.
• DISPENSE_AREA_ID — Foreign key to GMO_DISPENSE_AREA_B.
• LOT_NUMBER, MATERIAL_STATUS, SUBINVENTORY_CODE — Lot, status, and inventory location detail.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — Standard EBS audit columns.

Common Use Cases and Queries

Typical reporting scenarios include batch reconciliation (comparing REQUIRED_QTY to DISPENSED_QTY), yield variance analysis using the weight columns, and audit trails of who dispensed what and when. A representative query joins dispenses to their batch and material context:

SELECT d.DISPENSE_NUMBER, d.BATCH_ID, d.INVENTORY_ITEM_ID, d.REQUIRED_QTY, d.DISPENSED_QTY, d.DISPENSED_DATE FROM GMO.GMO_MATERIAL_DISPENSES d WHERE d.ORGANIZATION_ID = :org_id AND d.BATCH_ID = :batch_id;

Variance reporting can filter on DISPENSED_QTY <> REQUIRED_QTY to surface over- or under-dispenses. Container reconciliation queries typically reference ACTUAL_GROSS_WEIGHT against the tare and required weight columns. Locating undispensed or reversed activity requires joining to GMO_MATERIAL_UNDISPENSES on DISPENSE_ID.

Related Objects

• MTL_RESERVATIONS — Referenced via GMO_MATERIAL_DISPENSES.RESERVATION_ID; links the dispense to its inventory reservation.
• GMO_DISPENSE_AREA_B — Referenced via DISPENSE_AREA_ID; the physical dispensing area definition.
• GMO_MATERIAL_UNDISPENSES — References GMO_MATERIAL_DISPENSES.DISPENSE_ID; records reversal or undispense transactions.
• GMO_DISPENSING_PLANNING — References DISPENSE_ID; planning records associated with the dispense.
• GMO_BATCH_PROGRESSION — References DISPENSE_ID; positions the dispense within the batch execution flow.
• GME_MATERIAL_DISPENSING_GTMP — References DISPENSE_ID; the global temporary staging structure used by the material dispensing process.

Together these objects form the dispensing and batch execution backbone of process manufacturing in Oracle EBS.