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