RCV Transaction Processor Error -- INV_MATERIAL_STATUS_GRP.get_lot_serial_status_control

RCV Error for Returns

ORA-01403: no data found in Package INV_MATERIAL_STATUS_GRP Procedure get_lot_serial_status_control

INV_MATERIAL_STATUS_GRP.get_lot_serial_status_control

Few reasons for getting this error could be receiving quantity in txn interface does not match with the lot quantity or serial quantity in lots interface or serials interface.  

To solve the issue, make sure the receiving quantity matches with lot/serial quantity.

To check the error details:

SELECT * FROM rcv_headers_interface;  -- get the header_interface_id                                                                      

SELECT *

  FROM po_interface_errors

 WHERE interface_header_id = &header_interface_id;

SELECT * FROM rcv_transactions_interface; -- Use INTERFACE_TRANSACTION_ID in below queries

To check the Lot/Serial interface:

SELECT *

  FROM mtl_serial_numbers_interface

 WHERE product_transaction_id = &intf_transaction_id        --from above query

 AND product_code = 'RCV';

SELECT *

  FROM apps.mtl_transaction_lots_interface

 WHERE product_transaction_id = &intf_transaction_id        --from above query

 AND product_code = 'RCV';