Do I need to consider Request_date as Last Run of the concurrent program from the table fnd_concurrent_requests?
I can see other date fields as well: Please share your thoughts for considering Last Run date of the concurrent program.
|ACTUAL_START_DATE||DATE||The actual time and date when the request started running|
|ACTUAL_COMPLETION_DATE||DATE||The time and date when the request was completed|
|REQUEST_DATE||DATE||Yes||Concurrent request submission date|
Thank you in advance. Have a nice day :-)
Request date = the date the request was scheduled to run.
Actual start date = the date the request actually started running - will be different to the above, due to the manager wait times, work schedules etc.
Actual completion date = the date the request completed.
so if you want to know "when did the request last run?" - use actual start date.