CSI Asset Tracking listing of pending transactions with specific transaction ID parameter
Description
Categories: Draft
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 ... more
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 ... more
Run
CSI Asset Tracking listing of pending transactions with specific transaction ID parameter and other Oracle EBS reports with Blitz Report™ on our demo environment
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 |
Parameter Name | SQL text | Validation | |
---|---|---|---|
Pending Transaction |
|
LOV |