[PO] Advance Shipment Notice (ASN) - Completed Error

Supplier created ASN at I-Supplier portal, Processing Status for that ASN shows Error. Where can i troubleshoot?

I tried from front end: Transaction Open Interface, Transaction Status Summary and even Pending Transactions. No way i can find the error record.

Back end:

SELECT * FROM apps.rcv_shipment_headers WHERE shipment_num='ASN_Number'
AND asn_type='ASN';

Result: No record

SELECT * FROM apps.rcv_headers_interface WHERE shipment_num='ASN_Number';

Result: 1 record returned

Double check apps.rcv_transactions_interface & appss.po_interface_errors tables. Found relevant records was there. To allow user to recreate the ASN, delete the record from apps.rcv_headers_interface & apps.rcv_transactions_interface tables. You cannot reuse the ASN number unless you delete the record from apps.rcv_headers_interface.