Oracle EBS 查询RCV_TRANSACTIONS_INTERFACE and PO_INTERFACE_ERRORS Records

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
;

-- 刘轶鹤