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);
Recent Posts

Start typing and press Enter to search