Search Results activate_operation_instance

Overview

WMS_OP_INBOUND_PVT is a private PL/SQL package owned by APPS within the Oracle Warehouse Management (WMS) module of Oracle E-Business Suite. It functions as the inbound document handler within the Warehouse Management operation plan framework, supporting the material flow of received goods from dock to storage. The package is declared with AUTHID CURRENT_USER, meaning it executes with the privileges of the calling schema rather than the definer. It is part of the same family of operation-instance APIs invoked by the WMS operation plan engine (Init_op_plan_instance and Activate_operation_instance).

In short, the package manages the inbound side of the WMS operation plan lifecycle: it prepares the temporary transaction records, activates them with the suggested subinventory and locator, completes or cancels them, and handles special flows such as crossdocking and cleanup.

Key Procedures and Functions

The package exposes seven documented procedures and functions:

• INIT — The document handler for inbound document records, called from Init_op_plan_instance. It duplicates the child MMTT/MTLT records, nulls out the relevant fields on the parent MMTT record, and returns the source task id of the child document record created. It accepts the document record (an MTL_MATERIAL_TRANSACTIONS_TEMP row type) and the operation type id of the first operation.
• ACTIVATE — The document handler called from Activate_operation_instance. It updates the MMTT records with the suggested subinventory and locator for the inbound operation.
• COMPLETE — Finalizes the inbound operation instance, releasing or confirming the transaction records for the operation plan.
• CLEANUP — Removes or resets temporary records created during the operation plan flow, preventing orphaned MMTT/MTLT data.
• CANCEL — Cancels an in-progress inbound operation instance, reversing staged changes.
• ABORT — Aborts an inbound operation when the plan cannot continue, typically due to error or exception conditions.
• REVERT_CROSSDOCK — Reverses a crossdock operation, returning material to a non-crossdocked state.

Tables Accessed

The package reads and writes the following tables through APPS synonyms:

• MTL_MATERIAL_TRANSACTIONS_TEMP (MMTT) — the primary staging table for material transactions. INIT duplicates child MMTT/MTLT records, and ACTIVATE updates the suggested subinventory and locator.
• MTL_SECONDARY_INVENTORIES — validates and resolves the suggested subinventory.
• MTL_SYSTEM_ITEMS_B — item validation and attribute lookup.
• MTL_SERIAL_NUMBERS_TEMP and MTL_TRANSACTION_LOTS_TEMP — temporary serial and lot records for the transaction.
• MTL_TRANSACTION_REASONS — populates transaction reasons on inbound moves.
• MTL_TXN_REQUEST_LINES — movement request line details, relevant to the operation plan.
• WMS_DISPATCHED_TASKS and WMS_LICENSE_PLATE_NUMBERS — WMS task and LPN context for the inbound operation.
• WSH_DELIVERY_DETAILS — delivery line context used for crossdock handling.
• FND_NEW_MESSAGES and DUAL — error message resolution and utility queries.

Usage Notes

WMS_OP_INBOUND_PVT is a private (PVT) package and is not part of the public PL/SQL API surface. It is invoked internally by the WMS operation plan framework, specifically from the Init and Activate operation instance handlers of the operation plan engine. The package is referenced by two other packages, confirming it is a subordinate component in the inbound operation flow rather than a standalone entry point. Because it is AUTHID CURRENT_USER, custom code that calls it must run under an APPS-enabled schema. Oracle EBS 12.1.1 and 12.2.2 deployments typically invoke this package indirectly through receiving, putaway, and crossdock transactions executed in the WMS mobile forms and the Warehouse Management concurrent programs. It should not be called directly from customer extensions.