Most of the Oracle Installed base error transactions reside in
csi_txn_errors table. source_header_ref_id is nothing but the order header ID. In case it is required to get the IB failed transactions based on the order number, one can utilize the following query.
select * from csi_txn_errors csie, oe_order_headers_all_b oedh where
csie.source_header_ref_id = oedh.header_id and oedh.order_number= &order_number