WMS Drop LPN Failed With Error ORA-20014
(Doc ID 1583602.1)
Last updated on AUGUST 06, 2024
Applies to:
Oracle Warehouse Management - Version 12.1.3 and laterInformation in this document applies to any platform.
Symptoms
Drop LPN into inventory using receiving form failed with error.
ERROR
ORA-20014: Cancellation Cannot be performed on a Drop Operation in package WMS_ATF_RUNTIME_PUB_APIS Procedure Cancel_Operation_Plan.
Debug log file shows the following:
----------------------------------------------
.....
[17-AUG-13 00:02:51] INV_COST_GROUP_PVT: l_organization_id: 105
[17-AUG-13 00:02:51] INV_COST_GROUP_PVT: Failed Txn Temp Id : 501070344
[17-AUG-13 00:02:51] INV_LPN_TRX_PUB: Error from CostGrpAPI:
[17-AUG-13 00:02:51] INV_LPN_TRX_PUB: ***Error g_exec in c_mmtt loop trxtmpid=501070344,Sqlerrm:User-Defined Exception
[17-AUG-13 00:02:51] INV_LPN_TRX_PUB: failedrowcnt=1 msg=ORA-01403: no data found in Package INV_COST_GROUP_PVT Procedure INV_COST_GROUP_PVT
[17-AUG-13 00:02:51] INV_LPN_TRX_PUB: before calling java TM transaction quantity=60
[17-AUG-13 00:02:51] INV_LPN_TRX_PUB: before calling java TM secondary transaction quantity=
[17-AUG-13 00:02:51] INV_LPN_TRX_PUB: before calling java TM primary quantity=60
[17-AUG-13 00:02:51] INV_LPN_TRX_PUB: Done with MMTT cursor insrowcnt=1 failedrowcnt=1
[17-AUG-13 00:02:51] INV_LPN_TRX_PUB: l_process: 0
[17-AUG-13 00:02:51] WMS_PUTAWAY_UTILS.complete_putaway_wrapper: complete_putaway_wrapper: After Calling Inventory TM
[17-AUG-13 00:02:51] WMS_PUTAWAY_UTILS.complete_putaway_wrapper: complete_putaway_wrapper: l_txn_ret: -1
[17-AUG-13 00:02:51] WMS_PUTAWAY_UTILS.complete_putaway_wrapper: complete_putaway_wrapper: Txn Message Falied to assign cost group to item
[17-AUG-13 00:02:51] WMS_PUTAWAY_UTILS.complete_putaway_wrapper: complete_putaway_wrapper: G_EXC_UNEXPECTED_ERROR ocurred after l_progress = 240
Changes
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 |
Changes |
Cause |
Solution |
References |