OTBI report does not display data for a day because TC timezone
Summary:
As per the Oracle white paper on Transaction Console, you can get up to 500 transactions in the downloaded csv file. It is a technical limitation that download action can only support up to a maximum of 500 transactions.
Only other option is to Streamline your download or use OTBI for reporting purpose. Streamline the download means filter based status or one process in transaction console and then download those transactions.
So, I created a OTBI report
When I ran the report for 19/05/25 I received a report with 159 entries but when I downloaded from the transaction console there were 493.
Further, when I did some more investigation, I found that some of the transactions that were executed on 19th May as per Australian Time zone, have been submitted date as 18th May in database so they did not show up on the report. This is because the DB uses UTC time zone to save the data.