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

CSI Asset Tracking listing of pending transactions with specific transaction ID parameter and other Oracle EBS reports with Blitz Report™ on our demo environment

Copy

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