Perform Pick Load and Pick Drop Tasks Using Public APIs

Automate warehouse operations by utilizing public APIs to perform Pick Load and Pick Drop tasks with this enhancement in Release 12.2.13. Before this release, such tasks often required manual intervention or custom integrations, limiting automation capabilities and increasing operational overhead in high-volume environments.

This feature provides significant value by enabling seamless integration with external systems or custom applications, reducing manual effort, and enhancing picking efficiency. It addresses the need for scalable automation in Logistics and Distribution industries, supporting use cases like integrating third-party warehouse automation systems with Oracle Warehouse Management. High-level implementation considerations include ensuring API compatibility with existing systems and defining specific business rules for task execution through these APIs.

New Public API details are as follows:

API Name: Pick Load

Technical Name: WMS_TASK_MGMT_PUB.LOAD_TASK

Description: Use this API to load outbound or warehousing tasks. It can be called in the PL/SQL context to load one task at a time. You can load the following types of tasks:

  • Move Order Transfer
  • Sales Order Pick
  • Internal Sales Order Pick
  • Backflush Transfer
  • WIP Component Issue

The output PL/SQL tables will provide the details of the loaded task with its lot numbers or serial numbers, as applicable.

API Name: Pick Drop

Technical Name: WMS_TASK_MGMT_PUB.PICK_DROP

Description: Use this API to drop the loaded LPNs one at a time.

Limitation: This API does not support LPN de-consolidation, which requires dynamic user input.

Steps to enable and configure

You don't need to do anything to enable this feature.

Tips and considerations

- Ensure that your IT team is familiar with Oracle Integration Repository to effectively implement these APIs.

- Define clear business rules for picking tasks to avoid conflicts or inefficiencies when automating via APIs.

- Test API integrations in a sandbox environment before deploying to production to mitigate risks of disruption.

Key resources

  • Oracle Integration Repository
  • For more information, refer to the feature Picking APIs in the Oracle Warehouse Management Release Notes for Release 12.2.13, MOS Document ID 2983910.1.