What is the recommended schedule for running these purge programs in the system?
|DELDIAGLOG||Delete Diagnostic Logs|
|DELDIAGSTAT||Delete Diagnostic Statistics|
|FNDCPCRS||Summarize and Purge Concurrent Request Stats|
|FNDDWPURG||Purge Rule Executions|
|FNDECXPR||Purge Obsolete ECX Data|
|FNDGFMPR||Purge Obsolete Generic File Manager Data|
|FNDOAMLOGPURGE||Purge Diagnostic and Log Messages|
|FNDPGHST||Purge FND_STATS History Records|
|FNDWFPR||Purge Obsolete Workflow Runtime Data|
|FNDWF_NTF_RESEND||Resend Failed/Error Workflow Notifications|
|ICXDLTMP||Purge Inactive Sessions|
|MSCATPPURG||Purge ATP Temp Tables|
There is no general rule for purging as this depends on your business, size of your instance, hardware and data retention policies:
For most of the list, keeping one month of logs/diagnostics can be a good option.
The requests can be run daily at the period of least activity.