Search Results gmo_dispense_config




Overview
Explore in AI Chat

Overview

GMO_DISPENSE_CONFIG is a configuration table in the Oracle Manufacturing Execution System (MES) for Process Manufacturing (GMO) product family. It stores the dispensing rules that govern how a specific inventory item, within a specific organization, is dispensed when produced against a specific recipe. In Oracle EBS 12.1.1 and 12.2.2, this table sits between the recipe master data (GMD_RECIPES_B) and the shop-floor dispensing transactions executed through the MES operator workbench, providing the tolerance, unit-of-measure, expiration, and lead-time controls that determine whether a dispense step is required and whether an operator can proceed.

From a Data Vault modeling perspective, the heuristic classification mined from the foreign-key structure is standalone. This suggests the table should be treated as an independent reference or configuration entity rather than a link or satellite dependent on an upstream hub. In practice, it behaves as an operational setup table whose rows are maintained by process engineers and referenced during dispensing execution.

Key Information Stored

  • CONFIG_ID — Surrogate primary key, enforced by the index GMO_DISPENSE_CONFIG_PK. Uniquely identifies each dispensing configuration record.
  • INVENTORY_ITEM_ID, ORGANIZATION_ID, RECIPE_ID — The core business-key triplet, together forming the first three columns of the unique index GMO_DISPENSE_CONFIG_U1. Together they scope a configuration to a specific item, a specific inventory organization, and a specific recipe.
  • START_DATE, END_DATE — Effective-dating columns that complete the business key GMO_DISPENSE_CONFIG_U1. They allow multiple configuration versions to coexist over time and control which rule is in force at dispensing time.
  • DISPENSE_UOM — The unit of measure in which the item is dispensed, which may differ from the recipe's base UOM.
  • TOLERANCE_TYPE, HIGH_TOLERANCE, LOW_TOLERANCE — The tolerance rule applied to dispensed quantities, specifying the type of tolerance and its upper and lower bounds.
  • DISPENSE_REQUIRED_FLAG — Indicates whether dispensing is mandatory for the item/recipe combination.
  • SECURECODE_REQUIRED_FLAG — Controls whether a secure operator code must be entered before dispensing is permitted.
  • DISPENSE_EXPIRATION_FENCE — Defines the expiration window after which a dispensed quantity may no longer be used.
  • LEAD_TIME — The lead time associated with dispensing the material, used for scheduling and staging.
  • ERECORD_ID — Identifier linking the configuration to the electronic records (e-records) framework for regulatory traceability.
  • Audit columns — CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN capture standard Oracle EBS who-column auditing.

Common Use Cases and Queries

Typical usage includes validating dispensing setup before production release, reporting on tolerance configuration across plants, and auditing which items are flagged as requiring secure-code dispensing. A common query retrieves the currently effective configuration for an item and recipe:

  • Join GMO_DISPENSE_CONFIG to GMD_RECIPES_B on RECIPE_ID to resolve recipe names and versions.
  • Join to MTL_SYSTEM_ITEMS_B on INVENTORY_ITEM_ID and ORGANIZATION_ID for item and organization descriptions.
  • Filter on START_DATE <= SYSDATE AND (END_DATE IS NULL OR END_DATE >= SYSDATE) to obtain active rows.
  • Report on DISPENSE_REQUIRED_FLAG = 'Y' or SECURECODE_REQUIRED_FLAG = 'Y' for compliance and shop-floor readiness reviews.
  • Aggregate HIGH_TOLERANCE and LOW_TOLERANCE by organization to detect overly loose or tight dispensing tolerances.

Because the table is effective-dated, point-in-time queries must include the date predicates to avoid returning multiple overlapping rows.

Related Objects

  • GMD_RECIPES_B — Referenced through GMO_DISPENSE_CONFIG.RECIPE_ID; supplies recipe header data for the configuration.
  • MTL_SYSTEM_ITEMS_B — Provides item master information for INVENTORY_ITEM_ID.
  • MTL_PARAMETERS / HR_OPERATING_UNITS — Resolve ORGANIZATION_ID to an inventory organization or operating unit.
  • GMO_DISPENSE_CONFIG_PK / GMO_DISPENSE_CONFIG_U1 — The primary and unique indexes that enforce identity and business uniqueness.
  • MES dispensing execution tables and the Dispense workbench — Consume the tolerance, UOM, expiration, and secure-code settings defined here during shop-floor dispensing.
  • E-records framework tables — Linked via ERECORD_ID for regulatory audit trails.