When The Lots Are Clubbed And Received In A Particular Order for Return Material Authorization (RMA) Orders, Receiving Transaction Processor Errors - RVTPT:040 (Doc ID 2823656.1)

Last updated on APRIL 16, 2023

Applies to:

Symptoms

In Mobile Transactions

When attempting to club the lots and receive in a particular order, the following error occurs in the Receiving Transaction Processor (RTP).

ERROR

[05-JUL-21 08:56:38] INV_ROI_INTEGRATION_GRP: l_count_rma_lots:1
[05-JUL-21 08:56:38] INV_ROI_INTEGRATION_GRP: p_lot_number: XXX
[05-JUL-21 08:56:38] INV_ROI_INTEGRATION_GRP: Matching user entered lot with RMA lot :062
[05-JUL-21 08:56:38] INV_ROI_INTEGRATION_GRP: RMA quantity is :0
[05-JUL-21 08:56:38] INV_ROI_INTEGRATION_GRP: RMA lot does not match with user lot so error out062
[05-JUL-21 08:56:38] INV_ROI_INTEGRATION_GRP: Exitting INV_VALIDATE_LOT - g_exc_error error:2021-07-05 08:05:38:062
[05-JUL-21 08:56:38] INV_RCV_INTEGRATION_PVT($Revision: 120.173.12020000.80 $): INVCONV, After calling INV_ROI_INTEGRATION_GRP.INV_VALIDATE_LOT :WMSINB-22231
[05-JUL-21 08:56:38] INV_RCV_INTEGRATION_PVT($Revision: 120.173.12020000.80 $): Exitting VALIDATE_LOT_SERIAL_INFO - execution error:2021-07-05 08:05:38:WMSINB-22256
[05-JUL-21 08:56:38] INV_RCV_INTEGRATION_PVT($Revision: 120.173.12020000.80 $): STACKED ERROR MESSAGES : |This Lot &P_LOT_NUMBER does not exist in the RMA. (PGM_NAME=INV_ROI_INTEGRATION_GRP.Inv_Validate_lot)|ORA-01403: no data found in Package INV_MATERIAL_STATUS_GRP Procedure get_lot_serial_status_control|ORA-01403: no data found in Package INV_MATERIAL_STATUS_GRP Procedure get_lot_serial_status_control|ORA-01403: no data found in Package INV_MATERIAL_STATUS_GRP Procedure get_lot_serial_status_control|ORA-01403: no data found
ORA-01403: no data found in Package INV_MATERIAL_STATUS_GRP Procedure get_lot_serial_status_control
[05-JUL-21 08:56:38] INV_RCV_INTEGRATION_APIS($Revision: 120.17.12020000.16 $): validate_lot_serial_info: private API new debug
[05-JUL-21 08:56:38] po.src.rvtp.rvtpt.RVTPT.C.4097: RVTPT:040 Error in lot/serial or rvtptdoactions or lpn_validation or iot. Rollback to savepoint


STEPS

The issue can be reproduced at will with the following steps:
1. Trying to receive a Return Material Authorization (RMA) where LPN A - has "Lot 1" (say, 40 quantity) and LPN B has "Lot 1" (say, 38 quantity) and "Lot 2" (say, 2 quantity).
2. Receive "Lot 2" first and then "Lot 1"
3. MSCA Receipt works - "Txn Success"
4. But Receiving Transaction Processor (RTP) fails.
5. However, if Lot 1 is received first and then Lot 2.--> MSCA Receipt and RTP processing both are successful.

Cause

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