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

Last updated on AUGUST 21, 2016

Applies to:

Oracle Warehouse Management - Version 12.1.3 and later
Information 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

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms