ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN AFCF54931F878ACDE053B46B6358666E SELECT citd.instance_id, citd.transaction_id, citd.transaction_date, citd.inv_material_transaction_id, citd.txn_sub_type_id, citd.source_txn_type_name, cia.fa_asset_id, cia.asset_quantity, cia.active_end_date , cia.fa_location_id IB_fa_location, cia.fa_sync_flag, cia.active_end_date FROM csi_inst_txn_details_v citd, csi_i_assets cia, csi_inst_txn_details_v citd2 WHERE 1=1 AND citd2.instance_id = citd.instance_id AND cia.instance_id (+) = citd.instance_id ORDER BY 1, 2 US CSI Asset Tracking listing of pending transactions with specific transaction ID parameter When a transaction is successfully interfaced to Oracle Assets, the transaction's status will be updated from 'PENDING' to 'COMPLETE'. The majority reasons are: 1) OAT related set ups are not completed/correct, e.g asset category, asset location, asset name. 2) Previous transaction for the same asset is still in pending, e.g. asset is not created by create asset program so move transaction will not be processed. 3) Asset is updated from Oracle Asset which caused asset status, location out of sync with OAT record. Erro message - 'Prior transactions are in pending status for this item instance. Please process them first before processing this one.' you will need find out which is the 'Prior transactions' You can always go to the transaction's related instances and find out which is the earlier pending transaction using following query Draft 1=1 1 10 1=1 citd.transaction_id=:txn_id LOV custom Y SELECT citd.transaction_id value, cte.error_text description FROM csi_transactions ct, csi_item_instances_h ciih, csi_inst_txn_details_v citd, csi_i_assets cia, mtl_system_items_b msi, csi_txn_errors cte WHERE ct.transaction_status_code = 'PENDING' AND ct.transaction_id = ciih.transaction_id AND ciih.instance_id = citd.instance_id AND ciih.transaction_id = citd.transaction_id AND cia.instance_id (+) = citd.instance_id AND msi.inventory_item_id = citd.inventory_item_id AND msi.organization_id = citd.inv_master_organization_id AND NOT EXISTS (SELECT 'x' FROM csi_inst_txn_details_v citd2 WHERE citd2.instance_id = citd.instance_id AND citd2.transaction_id < citd.transaction_id AND citd2.transaction_status_code = 'PENDING' ) AND cte.transaction_id (+) = ct.transaction_id US Pending Transaction