Some Tables ,API Commonly required SQL for IB

Base Table for all IB :

csi.csi_item_instances

Table that hold CSI Transaction error :

csi.csi_txn_errors.

How OM is linked to CSI :

last_oe_order_line_id from csi_item_instances is line_id from oe_order_lines_all

If Transactions are created for the Order but still there is no Install base created then check if there is any error for the Transaction in the Error Table.

You can use the following Query to get Error Information.

select * from csi.csi_txn_errors where TRANSACTION_ID IN (SELECT transaction_id--, trx_source_line_id
FROM mtl_material_transactions
WHERE trx_source_line_id IN (select line_id from oe_order_lines_all
where header_id IN (select header_id from oe_order_headers_all
where order_number = 'Your Order Number'))
AND transaction_type_id = 33);
-----API FOR IB Creation/Update ----------------

csi_item_instance_pub.create_instance
csi_item_instance_pub.update_instance