My Oracle Support Banner

Enhancement - Require Pick Independent And Bulk Tasks On The Same LPN, Currently See Error Bulk Pick Requires Unused LPN (Doc ID 3074124.1)

Last updated on MARCH 24, 2025

Applies to:

Oracle Warehouse Management - Version 12.2.9 and later
Information in this document applies to any platform.

Symptoms

Requirement to pick Independent and Bulk tasks on the same pallet. Assume for example 120 warehouses and due to the above issue, and currently assigning independent and bulk tasks to different pickers.
Some times bulk tasks have very small quantities and requires to be added to the same pallet where independent tasks exists. When trying load bulk task on the LPN where independent tasks exists, the following error occurs:

Error

 "Bulk pick requires unused LPN. Press any key to continue" 

Usage :

The feature of loading Bulk and Independent task into the same Transfer LPN is given through a public API - Mix_Bulk_Ind_Tasks() under the public package - WMS_BP_CUSTOM_USER_PUB.

Please find below the list of parameters of the API :

P_Organization_ID - Organization ID in which the bulk and independent tasks exists.
P_Transaction_Temp_ID - The transaction temp ID of the bulk or independent pick task .
P_Transfer_LPN_ID - The loaded transfer LPN ID into which the current task also should to be loaded.
x_load_bulk_ind_mixing - Indicates whether the bulk pick tasks and independent tasks should be mixed. The default value is N to prevent mixing of the tasks.
x_load_multi_bulk_ind_mixing - Indicates whether to load independent and bulk tasks (multiple or single). The default value is N to prevent loading of multiple bulk tasks.
X_Return_Status Status of API call after the API completes processing.
If the API performs successfully, the value is FND_API.G_RET_STS_SUCCESS.
If there is an expected error, the value is FND_API.G_RET_STS_ERROR.
If there is an unexpected error, the value is FND_API.G_RET_STS_UNEXP_ERROR.
X_Msg_Count Number of error messages that the API encounters.
X_Msg_Data Displays error message text. If the parameter X_Msg_Count is 1, then this variable contains the actual message.

Assumptions:

1) Organization should be WMS enabled.
2) This feature is not supported for lot or lot/serial controls and works only for plain items.
3) The transfer LPN should not be a nested LPN.
4) This feature supports only Sales Order Picks and does not support Manufacturing Picks.

Note: This API ignores the Outbound Operation Plan value that is set in the Warehouse Task Management tab of the Organization Parameters window

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.