Mismatch in Transaction Status Between Transaction Console and BI Report – Expense Approval

Hi Experts,

We are facing a status mismatch issue for an Expense Approval transaction in Oracle Fusion.

Issue Description

For Expense Report: EXPRPT0007****4948

• Transaction Console Status → Completed
• BI Report Status → Pending

This discrepancy is impacting our business reporting and analysis

Query Used in BI Report :

SELECT htd.*
FROM hrc_txn_header hth,
hrc_txn_data htd
WHERE 1=1
AND hth.TRANSACTION_ID = htd.TRANSACTION_ID
AND hth.MODULE_IDENTIFIER = 'Expense Approval'
AND hth.SUBJECT = 'EXPRPT0007****4948'

Observations

• Expense report was initially Submitted → Rejected → Resubmitted → Approved (Completed).
• Transaction Console correctly shows Completed.
• BI report appears to fetch earlier “Submitted” transaction rows, showing them as