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

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.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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