Unable To Transact Splitted Move Order Lines Using INV_PICK_WAVE_PICK_CONFIRM_PUB.Pick_Confirm API
(Doc ID 2499128.1)
Last updated on FEBRUARY 03, 2019
Applies to:
Oracle Inventory Management - Version 11.5.10.0 and laterInformation in this document applies to any platform.
Symptoms
Unable To Transact Splitted Move Order Lines Using INV_PICK_WAVE_PICK_CONFIRM_PUB.Pick_Confirm API
STEPS
-----------------------
Example:Original move order data with 1 line:
Primary quantity: 2
Primary UOM code: kg
Secondary quantity: 1.88679
Secondary UOM code: l
The allocate detail qty and allocate secondary qty were modified using the APIs in the following sequence:
Split one from line 1:
Primary Quantity: 1
Secondary quantity: .9434
Sequence of steps:
1.- INV_MOVE_ORDER_PUB.PROCESS_MOVE_ORDER_LINE (Success (To allocate only Qty 1)
2.- INV_REPLENISH_DETAIL_PUB.LINE_DETAILS_PUB (Success (MTL_MATERIAL_TRANSACTIONS_TEMP) )
3.- INV_MOVE_ORDER_PUB.PROCESS_MOVE_ORDER_LINE (Success (MTL_TXN_REQUEST_LINES))
4.- INV_TRX_UTIL_PUB.DELETE_LOT_SER_TRX (Success, (To choose another lot))
5.- INV_TRX_UTIL_PUB.INSERT_LOT_TRX (Success Qty 1, Sec Qty: .9434, new first Lot 'SES181018')
6.- INV_PICK_WAVE_PICK_CONFIRM_PUB.PICK_CONFIRM (Success, transaction was made)
Split two from line 1:
Primary quantity: 1
Secondary quantity: .9434
Sequence of steps:
1.- INV_MOVE_ORDER_PUB.PROCESS_MOVE_ORDER_LINE (Success Qty: 1)
2.- INV_REPLENISH_DETAIL_PUB.LINE_DETAILS_PUB (Success Qty: 1)
3.- INV_MOVE_ORDER_PUB.PROCESS_MOVE_ORDER_LINE (Success Qty: 1)
4.- INV_TRX_UTIL_PUB.DELETE_LOT_SER_TRX (Success)
5.- INV_TRX_UTIL_PUB.INSERT_LOT_TRX (Success Qty 1, Sec Qty: .9434, new second Lot 'SES18101801')
6.- INV_PICK_WAVE_PICK_CONFIRM_PUB.PICK_CONFIRM (API Return S. Success, but the transaction WAS NOT MADE and appears on transact move order form).
Now See the Delivered quantity and detailed quantity are the same on MTL_MATERIAL_TRANSACTIONS_TEMP and MTL_TXN_REQUEST_LINES.
EXPECTED BEHAVIOR
-----------------------
Second move order line should get transacted successfully
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 |