My Oracle Support Banner

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.

Symptoms

ACTUAL BEHAVIOR
---------------

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.

STEPS
-----------------------
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).


Cause

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
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.