How To Transact Move Order Using INV_PICK_WAVE_PICK_CONFIRM_PUB.Pick_Confirm API

In this Document

APPLIES TO:

Oracle Inventory Management - Version 11.5.10.2 to 12.1.3 [Release 11.5.10 to 12.1]
Information in this document applies to any platform.

This document includes 11.5.10, 12.0.1 and later

GOAL

The purpose of this document is to provide a demonstration showing how Move Orders can be transacted using APIs. The demonstration uses the API INV_PICK_WAVE_PICK_CONFIRM_PUB.Pick_Confirm to transact Move Orders.

There is a document which has sample code for test purposes.

SOLUTION

Sample Code:

Please review the below instructions and sample code document. The API call looks something like this using INV_PICK_WAVE_PICK_CONFIRM_PUB from INVPCPWB.pls. See the sample code for a complete example but here is a snippet of the call:

...

INV_PICK_WAVE_PICK_CONFIRM_PUB.Pick_Confirm

(

p_api_version_number => l_api_version

, p_init_msg_list => l_init_msg_list

, p_commit => l_commit

, x_return_status => x_return_status

, x_msg_count => x_msg_count

, x_msg_data => x_msg_data

, p_move_order_type => l_move_order_type

, p_transaction_mode => l_transaction_mode

, p_trolin_tbl => l_trolin_tbl

, p_mold_tbl => l_mold_tbl

, x_mmtt_tbl => x_mmtt_tbl

, x_trolin_tbl => x_trolin_tbl

, p_transaction_date => l_transaction_date

);

...

Note: In 11.5.9, the last parameter (transaction date) was added with Patch 3438094 in version INVPCPWB.pls 115.47.11590.6.

Steps:

1) Create a Move Order and approve it.
2) Query for the move order and allocate quantity for the Move Order lines
3) Run the API to transact material from the allocated subinventory with move order line id as the parameter.

Move Order Type:

Value	Move Order Type
1	Requisition
2	Replenishment
3	Pick Wave
4	Receipt
5	Manufacturing Component Pick
6	Put Away

FAQ

#1) How to transact partial qty on a move order line ?

Steps:
1) Create , book and release the sales order with Auto Allocate = Yes, Auto Pick Confirm = No.
2) Go to Transact Move Orders, Query for the move order, Click on View/ Update Allocations.
3) Reduce the allocation qty, and click save. (Note that API INV_REPLPENISH_DETAIL_PUB.Line_Details_Pub does have a limitation where it cannot allocate quantity lesser than requested quantity, so, this can be done only from forms)
4) Now transact the move order using the same API code as before.
5) See that the reduced qty on the move order line is transacted, and rest on the order line is back ordered.

This needs to be released again, as the current move order would be closed after its transacted.
This is same as front-end functionality, when clicking on 'Transact' button it will try to transact all the lines that are allocated on that form.

Note: If requested_qty = detailed_qty on the Move Order Line, the API would transact all the detailed_qty. If the detailed_qty < requested_qty, only detailed_qty will be transacted, and the rest would be back-ordered.

#2) Is under-picking supported using API ?

Under picking is not supported through the api. It can only be done manually via the Transact move orders form.

#3) Can you split allocations using API ?

The public API INV_PICK_WAVE_PICK_CONFIRM_PUB.PICK_CONFIRM() is only meant
for transacting allocation against the move order. 'Splitting Allocation' kind of functionality through
public API is not supported.

#4) After allocating user-defined serials for a lot-serial controlled item following Note 1332302.1 seeing error "Lot-serial quantity does not match transaction quantity" error while transacting using API ?

Please review if the lot and serial information is correct on the allocation from Transact Move Orders form -> Query for the move order -> Click on View/ Update Allocations. It is more likeky that the lot - serial - subinventory - locator information may be incorrect on the allocation. Please correct the same and then, run the transact API again.

REFERENCES

NOTE:729261.1 - How To Create A Move Order Header Using INV_MOVE_ORDER_PUB.Create_Move_Order_Header API [Video] ?
NOTE:729265.1 - How To Process Move Orders (Create Header and Lines) Using INV_MOVE_ORDER_PUB.Process_Move_Order API [Video] ?
NOTE:729513.1 - How to use APIs for Inventory / Product Information Management [Video] ?
NOTE:729998.1 - Oracle Inventory Management Application Program Interface ( APIs)
NOTE:783521.1 - How to Allocate Move Orders using INV_REPLENISH_DETAIL_PUB.line_details_pub API ?
NOTE:729263.1 - How To Create Move Order Lines Using INV_MOVE_ORDER_PUB.Create_Move_Order_Lines API [Video] ?
NOTE:1900798.1 - INV_Pick_Wave_Pick_Confirm_PUB.Pick_Confirm Return Status Code U