WMS Drop LPN Failed With Error ORA-20014 (Doc ID 1583602.1)

Last updated on AUGUST 06, 2024

Applies to:

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

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