Core Concurrent Processing - EBS (MOSC)

MOSC Banner

What is the actual criteria that Oracle uses to purge concurrent requests?

edited Feb 11, 2015 10:13AM in Core Concurrent Processing - EBS (MOSC) 7 commentsAnswered ✓

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;

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center