Search Results gmo_sworkbench_pvt




Overview
Explore in AI Chat

Overview

GMO_SWORKBENCH_PVT is a private PL/SQL package in the APPS schema that implements the core processing logic behind the Oracle EBS Process Manufacturing (OPM) Shop Floor Workbench. It belongs to the GMO (Oracle Manufacturing/Process Execution) module family, alongside the group package GMO_SWORKBENCH_GRP, which serves as the public entry point that delegates to this private implementation. In Oracle EBS 12.1.1 and 12.2.2, this package supports dispense and material reservation activities performed on the shop floor: validating that a material is eligible for reservation, creating and updating inventory reservations, querying existing reservations, and calculating task-related metrics and time/quantity figures used by the workbench user interface.

The package carries an API classification of PVT, indicating that it is intended for internal use by the module rather than as a published integration API. Its dependency on FND_API confirms it participates in the standard Oracle Application Object Library error-handling and API conventions.

Key Procedures and Functions

The ETRM metadata documents thirteen procedures and functions within the package. The principal ones relevant to reservation and shop floor processing include:

  • UPDATE_PLANNING_STATUS — Updates the status of a dispensing planning record to reflect progress through the shop floor workflow.
  • GET_TASK_PERCENTAGE — Returns the completion percentage for a given task, used to display progress on the workbench.
  • GET_WEEKLY_TASK_PERCENTAGE — Returns task completion percentage on a weekly basis, supporting period-based reporting and planning views.
  • GET_HOURS / GET_MINUTES / GET_DAYS — Utility functions that extract time components, used to format durations for display and calculation.
  • CREATE_MATERIAL_RESERVATION — Creates an inventory reservation for a material against a dispensing or batch requirement.
  • VALIDATE_MTL_FOR_RESERVATION — Validates that a material and its attributes are eligible for reservation before creation occurs.
  • UPDATE_RESERVATION — Modifies an existing material reservation.
  • QUERY_RESERVATION — Retrieves reservation details for display or downstream processing.

Together these procedures form the reservation lifecycle for shop floor dispensing: validation, creation, modification, and inquiry.

Tables Accessed

The package accesses the following tables via APPS synonyms:

  • MTL_RESERVATIONS — the core Oracle Inventory reservation table, read and written by the reservation creation, update, and query procedures.
  • GME_MATERIAL_DETAILS — holds material requirement details for process batches, used to determine what must be reserved and dispensed.
  • GME_BATCH_HEADER — the process batch header, providing batch context for shop floor tasks.
  • GMO_DISPENSE_AREA_B — defines dispense areas used in the shop floor layout.
  • GMO_DISPENSING_PLANNING and GMO_DISPENSING_PLANNING_S — base and translation tables holding dispensing planning records whose status is updated by UPDATE_PLANNING_STATUS.

The dependency listing also confirms a reference to INV_RESERVATION_GLOBAL, the Oracle Inventory public reservation API package, which GMO_SWORKBENCH_PVT calls to perform the actual low-level reservation operations.

Usage Notes

GMO_SWORKBENCH_PVT is invoked indirectly through GMO_SWORKBENCH_GRP, and is referenced by only one other package, reflecting its private implementation role. It is typically executed from the OPM Shop Floor Workbench forms when operators dispense materials, adjust reservations, or view task progress. Because it depends on INV_RESERVATION_GLOBAL and FND_API, it should be treated as an internal component rather than a supported custom integration point; customizations should target the group package or the underlying Inventory APIs instead. The presence of INV_RESERVATION_GLOBAL in the dependency chain explains the association with the "inv_reservation_global" search term.