Putaway Part Of Xdock Receiving Getting Error (Doc ID 2795718.1)

Last updated on JUNE 08, 2023

Applies to:

Symptoms

Putaway part of xdock receiving getting error

While receiving putaway getting error for xdock. The receiving part done, but putaway getting error by standard program Receiving Transaction Processor.

ERROR
-----------------------

Ex.. in processTrxBatch ..:java.sql.SQLException: Closed Resultset: NEXT


STEPS
-----------------------
The issue can be reproduced at will with the following steps:

1. Go to receiving form, Query PO
2. Provide required detail and save
3. Observe that program ended in error
4. Check the pending transactions and see the error

Log file
---------------------------------------
sid:820806915: [20-JUL-21 07:34:32] WMS_ATF_RUNTIME_PUB_APIS.Complete_Operation_Instance: x_msg_data => WMSFND_API.G_MISS_CHARWMS_TXN_SUCCESSFND_API.G_MISS_CHAR
sid:820806915: [20-JUL-21 07:34:32] WMS_ATF_RUNTIME_PUB_APIS.Complete_Operation_Instance: x_msg_count => 1
sid:820806915: [20-JUL-21 07:34:32] WMS_ATF_RUNTIME_PUB_APIS.Complete_Operation_Instance: x_source_task_id =>
sid:820806915: [20-JUL-21 07:34:32] WMS_ATF_RUNTIME_PUB_APIS.Complete_Operation_Instance: x_error_code =>
sid:820806915: [20-JUL-21 07:34:32] WMS_ATF_RUNTIME_PUB_APIS.Complete_Operation_Instance: x_return_status ==> S
sid:820806915: [20-JUL-21 07:34:32] WMS_ATF_RUNTIME_PUB_APIS.Complete_Operation_Instance: x_msg_data ==>
sid:820806915: [20-JUL-21 07:34:32] WMS_ATF_RUNTIME_PUB_APIS.Complete_Operation_Instance: x_msg_count ==>
sid:820806915: [20-JUL-21 07:34:32] WMS_ATF_RUNTIME_PUB_APIS.Complete_Operation_Instance: x_error_code ==>
sid:820806915: [20-JUL-21 07:34:32] WMS_ATF_RUNTIME_PUB_APIS.Complete_Operation_Instance: Before Exiting .
sid:820806915: [20-JUL-21 07:34:32] WMS_ATF_Util_APIs: complete_tm_processing - After calling wms_atf_runtime_pub_apis.complete_operation_instance
sid:820806915: [20-JUL-21 07:34:32] WMS_ATF_Util_APIs: x_return_status = S
sid:820806915: [20-JUL-21 07:34:32] WMS_ATF_Util_APIs: x_msg_count =
sid:820806915: [20-JUL-21 07:34:32] WMS_ATF_Util_APIs: x_msg_data =
sid:820806915: [20-JUL-21 07:34:32] WMS_ATF_Util_APIs: x_return_status = S
sid:820806915: [20-JUL-21 07:34:32] WMS_ATF_Util_APIs: x_msg_count =
sid:820806915: [20-JUL-21 07:34:32] WMS_ATF_Util_APIs: x_msg_data =
sid:820806915: [20-JUL-21 07:34:32] WMS_ATF_Util_APIs: Exiting complete_tm_processing
sid:820806915: [20-JUL-21 07:34:32] INV_TXNSTUB_PUB: Entered INV_TXNSTUB_PUB.postTransaction
sid:820806915: [20-JUL-21 07:34:32] INV_TXNSTUB_PUB: InstallBase Trackable: N
sid:820806915: [20-JUL-21 07:34:32] INV_TXNSTUB_PUB: g_fnd_install_status is not I or item is not installbase trackable
sid:820806915: [20-JUL-21 07:34:32] INV_TRX_MGR: Before Calling DCP API
*** Entering Dropshipreceive() in OE_DS_PVT ***
Proces Online Mode:0
Transaction ID :19340881
Application Short Name :INV
Unable to find the sales order identifier for this transaction ORA-0000: normal, successful completion
Dropshipreceive(), This may not be a dropship transaction
sid:820806915: [20-JUL-21 07:34:32] INV_TRX_MGR: Ex.. in processTrxBatch ..:java.sql.SQLException: Closed Resultset: next
sid:820806915: [20-JUL-21 07:34:32] INV_LPN_TRX_PUB: retval=1, regmsg=Ex.. in processTrxBatch ..:java.sql.SQLException: Closed Resultset: next
sid:820806915: [20-JUL-21 07:34:32] INV_LPN_TRX_PUB: calling API to clear the picked quantity
sid:820806915: [20-JUL-21 07:34:32] INV_LPN_TRX_PUB: API call to clear picked quantity successful
sid:820806915: [20-JUL-21 07:34:32] INV_TXN_MANAGER_PUB: Error from PROCESS_LPN_TRX.. Ex.. in processTrxBatch ..:java.sql.SQLException: Closed Resultset: next
"sid:820806915: [20-JUL-21 07:34:32] po.src.rvtp.rvtii.RVTII.C.1939: RVTII:060 INV TRX Manager Error Msg: Ex.. in processTrxBatch ..:java.sql.SQLException: Closed Resultset: next
"
"sid:820806915: [20-JUL-21 07:34:32] po.src.rvtp.rvtii.RVTII.C.1939: ORA-01405: fetched column value is NULL
"
sid:820806915: [20-JUL-21 07:34:32] po.plsql.anonymous block.ANONYMOUS BLOCK.begin: v--------Procedure Started-----------v
sid:820806915: [20-JUL-21 07:34:32] po.plsql.anonymous block.ANONYMOUS BLOCK.1: 'Ex.. in processTrxBatch ..:java.sql.SQLException: Closed Resultset: next'
sid:820806915: [20-JUL-21 07:34:32] po.plsql.RCV_ERROR_PKG.RCV_ERROR_PKG.begin: v--------Procedure Started-----------v
sid:820806915: [20-JUL-21 07:34:32] po.plsql.RCV_ERROR_PKG.RCV_ERROR_PKG.123: logging error on column INTERFACE_TRANSACTION_ID
sid:820806915: [20-JUL-21 07:34:32] po.plsql.RCV_ERROR_PKG.RCV_ERROR_PKG.124: error stack from call to po_interface_call
sid:820806915: [20-JUL-21 07:34:32] po.plsql.RCV_ERROR_PKG.RCV_ERROR_PKG.-1: Current Calling Stack = ? RVTBM.C RVTPT.C RVTPA.C RVTII.C ANONYMOUS BLOCK RCV_ERROR_PKG
"sid:820806915: [20-JUL-21 07:34:32] po.plsql.RCV_ERROR_PKG.RCV_ERROR_PKG.-1: ----- PL/SQL Call Stack -----

Cause

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