Search Results wms_device_integration_wcs




Overview
Explore in AI Chat

Overview

The APPS.WMS_DEVICE_INTEGRATION_WCS package is a stub API within Oracle Warehouse Management (WMS) that provides the integration framework between Oracle E-Business Suite and third-party Warehouse Control System (WCS) devices. Its principal role is to initiate and synchronize requests directed at material handling equipment such as conveyors, sorters, put-to-light systems, and automated storage and retrieval systems. In Oracle EBS 12.1.1 and 12.2.2, this package is delivered as part of the WMS device integration layer and is intended to be extended by device vendors or implementation partners, who supply the device-specific logic required to communicate with the physical hardware. The package relies on a temporary staging table, WMS_DEVICE_REQUEST, as the primary source of input, and joins that data with core inventory and warehouse tables to enrich each request before dispatch.

Key Procedures and Functions

The package exposes four documented procedures, with SYNC_DEVICE_REQUEST serving as the central entry point. The API is classified as OTHER in the ETRM metadata.

  • SYNC_DEVICE_REQUEST — Initiates a request to a WMS device. It accepts a request identifier, the target device identifier, and a resubmit flag indicating whether the call accompanies transaction processing or represents a resubmission to the device. It returns a status code (Success or Error), an optional request-level status message, and an optional device-level status message. Vendors extend this procedure to implement the actual device interface logic.
  • UPDATE_REQUEST — Updates the status or state of an existing device request, reflecting the outcome of processing or device acknowledgment.
  • SYNC_DEVICE — Synchronizes the state of a specific device, ensuring the application's view of the device aligns with the physical equipment.
  • SIGNOFF_MSG_TO_OUT_PIPE — Writes a completion or sign-off message to a database pipe, enabling downstream processes to detect request completion.

Tables Accessed

The package reads and writes device request data through documented tables accessed via APPS synonyms. The staging table WMS_DEVICE_REQUEST supplies the base request records. To enrich each request, it joins with MTL_SYSTEM_ITEMS (item details), MTL_ITEM_LOCATIONS (location), MTL_PARAMETERS (organization), and WMS_LICENSE_PLATE_NUMBERS (LPN). The documented historical table WMS_DEVICE_REQUESTS_HIST retains a record of processed requests for auditing and troubleshooting. The package also leverages DBMS_PIPE, using database pipes as the transport mechanism to pass serialized request payloads to an external receiving program.

Usage Notes

WMS_DEVICE_INTEGRATION_WCS is typically invoked from WMS transaction flows, concurrent programs, or custom device-integration code rather than directly from standard forms. When a warehouse transaction requires device interaction, the request is staged in WMS_DEVICE_REQUEST and processed by SYNC_DEVICE_REQUEST. The reference implementation shows a cursor over the request table joining enrichment tables, packing each record, and sending it across a database pipe; a receiving program waits on that pipe and forwards the data to the physical device. Because the package is a stub, production deployments must extend it with vendor- or site-specific logic. The documented metadata indicates the package is referenced by two other packages, confirming its role as a shared integration utility. For 12.2.2, the same interfaces remain relevant as part of the WMS device integration framework.