Query to find out the Receiving Transaction Interface error details in EBS R12

Objective

The intent of this document is to find out the error’s details when standard Program not able to process the records in interface table (RCV_TRANSACTIONS_INTERFACE).

Why we need to do

If the interface line is unable to process the lines then need to find out why it’s failed. So, In that case need to identify those such error’s from Interface error table.

How to resolve

To get the Receiving Interface error’s details are from below Query.

Query:

SELECT *
FROM   po_interface_errors
WHERE  interface_line_id IN (SELECT interface_transaction_id
FROM   rcv_transactions_interface
WHERE  interface_transaction_id = XXX);

Alam