Search Results wms_opm_integration_grp




Overview
Explore in AI Chat

Overview

The APPS.WMS_OPM_INTEGRATION_GRP package is a PL/SQL group (GRP) type package in Oracle E-Business Suite that provides the integration bridge between Oracle Warehouse Management (WMS) and Oracle Process Manufacturing (OPM). It is declared with AUTHID CURRENT_USER, meaning its SQL statements execute under the privileges of the invoking schema rather than the package owner, and it references the standard APPS synonym layer. The package belongs to the WMS family of integration packages that coordinate communication between the Warehouse Control System (WCS) device layer and OPM transactional logic.

Its primary role is to interpret inbound messages or responses originating from warehouse devices and translate them into the appropriate OPM-side processing logic. The package header identified in the ETRM metadata is dated 2005 ($Header: WMSOPMS.pls 120.3), placing it in the mature, stabilized layer of the WMS codebase that remains supported across EBS 12.1.1 and 12.2.2.

Key Procedures and Functions

The documented metadata lists a single public procedure, PROCESS_RESPONSE.

  • PROCESS_RESPONSE — Handles an inbound response tied to a specific warehouse device and request. Its parameters include a device identifier (p_device_id), a request identifier (p_request_id), and a parameter values record of type WMS_WCS_DEVICE_GRP.MSG_COMPONENT_LOOKUP_TYPE, which carries the message component payload. It returns standard EBS API status values via x_return_status, x_msg_count, and x_msg_data. The procedure is the single documented entry point by which WMS/WCS device feedback is routed into OPM integration processing.

The procedure follows the conventional EBS API error-handling contract using the FND message stack, allowing callers to inspect x_return_status and retrieve diagnostic detail through FND_MSG_PUB when x_msg_count exceeds zero.

Tables Accessed

The ETRM metadata for this package does not enumerate underlying tables directly (tables are referenced via APPS synonyms). By design, the integration logic reads and writes OPM transactional and WMS device/message tables through the APPS synonym layer, including the WCS device and message component structures referenced in its signature (WMS_WCS_DEVICE_GRP). Actual table access is encapsulated behind the synonym indirection, so consumers should rely on the documented API surface rather than assuming direct DML on specific base tables.

Usage Notes

WMS_OPM_INTEGRATION_GRP is typically invoked from WMS/WCS integration flows rather than end-user forms, and the metadata notes it is referenced by one other package, indicating it is consumed internally within the WMS integration stack. PROCESS_RESPONSE is called when a device response or message must be reconciled against an outstanding request, passing the device, request, and message payload so that OPM-side consequences can be applied and status returned to the caller.

Customizations should treat the package as a GRP API: call PROCESS_RESPONSE within the standard EBS exception-handling construct, initialize the MSG_COMPONENT_LOOKUP_TYPE record correctly, and always inspect x_return_status and the message stack. Because the package uses AUTHID CURRENT_USER, invoking schemas must hold the necessary privileges on the underlying WMS and OPM objects. Direct modification of package source is not supported; extend behavior through wrapper packages that honour the documented signature.