OTBI report does not display data for a day because TC timezone — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

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.

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!