Oracle EBS 查询RCV_TRANSACTIONS_INTERFACE and PO_INTERFACE_ERRORS Records

查询接收输入数据错误原因

The join is the column interface_line_id in the po_interface_errors table and the interface_transaction_id in the rcv_transactions_interface table

So to find the corresponding po interface errors you would run the following sql query if knowing the specific interface_transaction_id  value:

select * from po_interface_errors

where interface_line_id in

(select interface_transaction_id from rcv_transactions_interface

where interface_transaction_id = &INTFC_TRANS_ID);

Also if you wish to find for example a PO receiving error you could run the following sql:

select * from po_interface_errors

where interface_line_id in

(select interface_transaction_id from rcv_transactions_interface

where po_header_id in

(select po_header_id from po_headers_all

where segment1 = '&PO_NUMBER'));

 

The following is a blanket query that would cover all records for both rcv_headers_interface and rcv_transactions_interface tables:

select * from rcv_headers_interface a,

po_interface_errors b

where a.header_interface_id = b.interface_header_id

and a.group_id = b.batch_id

;

select * from rcv_transactions_interface a,

po_interface_errors b

where a.interface_transaction_id = b.interface_line_id

and a.group_id = b.batch_id

;

-- 刘轶鹤