Seconds Difference Between BI Report Job History End Processing Time Stamp And Data Base Timestamp
(Doc ID 2736256.1)
Last updated on MARCH 24, 2021
Applies to:Oracle Fusion Order Management Cloud Service - Version 11.13.20.04.0 and later
Information in this document applies to any platform.
SELECT TO_CHAR(NVL(MAX(history.COMPLETEDTIME),SYSDATE),'yyyy-MM-dd HH24:MI:SS') FROM fusion_ora_ess.request_history history
There is a few seconds difference between the BI Report Job History End Processing Time Stamp and the Completion time stamp in the database.
The issue can be reproduced at will with the following steps:
1. Schedule BI Publisher Report from BI
2. Check the time taken in "Report Job History" and database (using the SQL Query).
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document