how to fetch current schedule process start time of any Oracle Fusion scheduled report
Summary:
I have a requirement to fetch incremental data. I am using below query. but due to frequent transaction. Few transactions are getting picked by 2 consecutive schedules. Currently, using this code we comparing last schedule process start time and sysdate. Assumption was sysdate and current schedule time will be same but there is difference of few seconds. and transaction completed during that duration are duplicated in next run as well.
To avoid this , I am planning to compare last schedule process start time and current process start time to avoid compilation time overlap.
Please let me know if you have any idea how it can be resolved.
Tagged:
0