Results for “gmo_material_undispenses_u1”

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

Overview

GMO.GMO_MATERIAL_UNDISPENSES is a transactional table in the Oracle E-Business Suite Process Manufacturing (OPM) schema GMO. It stores records of material reverse dispenses — the reversal or partial reversal of material that was previously dispensed to a batch or production order. In EBS 12.1.1 and 12.2.2, this object supports shop-floor and weigh-and-dispense workflows, the reconciliation of physical container weights, and the accurate reversal of inventory transactions such as reservations and issue orders. Records here typically trace back to a dispense event recorded in GMO_MATERIAL_DISPENSES and provide the transactional counterpart that returns quantities to inventory.

From a heuristic Data Vault classification mined from its foreign-key structure, the table is modeled as standalone. It does not function as a conventional hub, link, or satellite grouping of other master entities; instead, it is a self-contained transaction fact with its own surrogate key. The physical schema documents 40 columns and a single unique index, indicating a fairly denormalized operational record.

Key Information Stored

The surrogate primary key is UNDISPENSE_ID, enforced through GMO_MATERIAL_UNDISPENSES_PK. The business-key candidate surfaced by the unique index GMO_MATERIAL_UNDISPENSES_U1 is the composite (UNDISPENSE_ID, DISPENSE_ID), meaning the documented uniqueness assertion is bound to both the surrogate identifier and the originating dispense. A non-unique index, GMO_MATERIAL_UNDISPENSES_N1, supports access by (DISPENSE_ID, INVENTORY_ITEM_ID).

• UNDISPENSE_ID — surrogate primary key for the reverse dispense event.
• DISPENSE_ID — the original dispense being reversed; the principal link back to GMO_MATERIAL_DISPENSES.
• UNDISPENSE_NUMBER — user-visible reverse dispense document number.
• UNDISPENSE_TYPE — classifies the reversal as Production or Ad hoc.
• SOURCE_TRANSACTION_ID — ID of the driving source transaction, such as the batch ID.
• BATCH_ID, BATCH_STEP_ID, MATERIAL_DETAIL_ID — production context identifying the batch, step, and material detail line.
• INVENTORY_ITEM_ID, ORGANIZATION_ID, SUBINVENTORY_CODE — the item, inventory organization, and subinventory or booth affected.
• UNDISPENSED_DATE, UNDISPENSING_MODE — when and how the reversal was performed.
• DISPENSED_QTY, UNDISPENSED_QTY — pending reverse quantity versus actual reverse-dispensed quantity.
• GROSS_REQUIRED_WEIGHT, SOURCE_CONTAINER_TARE, SOURCE_CONTAINER_WEIGHT, SOURCE_CONTAINER_REWEIGHT, ACTUAL_GROSS_WEIGHT, TARGET_CONTAINER_TARE — the weight measurements used to validate the reversal.
• SOURCE_CONTAINER_ITEM_ID, TARGET_CONTAINER_ITEM_ID, SOURCE_CONTAINER_DEVICE_ID, TARGET_CONTAINER_DEVICE_ID — the container items and devices involved.
• RESERVATION_ID, DISPENSE_AREA_ID, DISPENSE_BOOTH_ID — the inventory reservation and physical dispense area/booth.
• Audit columns CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN.

Common Use Cases and Queries

Typical operational scenarios include reconciling reverse dispenses against their originating dispense, auditing weight variance on the shop floor, and reporting returned quantities by item or subinventory. A common join pattern links a reverse dispense to its source dispense and inventory item:

SELECT u.UNDISPENSE_NUMBER, u.UNDISPENSED_QTY, u.UNDISPENSED_DATE,
  d.DISPENSE_NUMBER, u.INVENTORY_ITEM_ID, u.SUBINVENTORY_CODE
FROM GMO.GMO_MATERIAL_UNDISPENSES u, GMO.GMO_MATERIAL_DISPENSES d
WHERE u.DISPENSE_ID = d.DISPENSE_ID
AND u.UNDISPENSED_DATE >= :start_date;

Weight-variance analysis compares ACTUAL_GROSS_WEIGHT against GROSS_REQUIRED_WEIGHT less the container tare columns. Aggregate reporting by UNDISPENSE_TYPE, ORGANIZATION_ID, or UNDISPENSING_MODE supports reverse-dispense trend analysis. Reservation-driven queries join on RESERVATION_ID to trace inventory impact back to MTL_RESERVATIONS.

Related Objects

• GMO.GMO_MATERIAL_DISPENSES — joined via DISPENSE_ID; the source dispense being reversed.
• MTL_RESERVATIONS — joined via RESERVATION_ID; the inventory reservation affected by the reversal.
• GMO.GMO_DISPENSE_AREA_B — joined via DISPENSE_AREA_ID; the physical dispense area definition.
• MTL_SYSTEM_ITEMS_B — item master referenced through INVENTORY_ITEM_ID.
• MTL_ITEM_LOCATIONS / subinventory definitions — referenced through SUBINVENTORY_CODE and ORGANIZATION_ID.
• GME_BATCH_HEADER — batch context referenced through BATCH_ID.