What is the actual criteria that Oracle uses to purge concurrent requests?
Hello,
I would like some help with the inner workings of the FNDCPPUR, Purge Concurrent Request and/or Manager Data program.
Using Doc ID 565942.1, Which Table Column And Timing Period Does The FNDCPPUR Purge Program Use, I learnt that
The "Purge Concurrent Request and/or Manager Data" purges / removes "Completed" requests based on the greatest of two columns, ACTUAL_COMPLETION_DATE or LAST_UPDATE_DATE, in comparison to the present SYSDATE minus the Age value.
I then wrote a little concurrent request that archived the concurrent requests immediately before we purged them. I used the following logic.
WHERE GREATEST(actual_completion_date, last_update_date) < g_this_date - p_delete_age;