Purging Strategy in Oracle E-Business Suite -1- (FNDLGPRG)

Concurrent Program shortname is FNDLGPRG

Program name is;
"Purge Logs and Closed System Alerts" in R12
"Purge Debug Log and System Alerts" in 11i

This concurrent program purge tables listed below.

FND_EXCEPTION_NOTES

FND_OAM_BIZEX_SENT_NOTIF

FND_LOG_METRICS

FND_LOG_UNIQUE_EXCEPTIONS

FND_LOG_EXCEPTIONS

FND_LOG_MESSAGES

FND_LOG_TRANSACTION_CONTEXT

FND_LOG_ATTACHMENTS

Recommendation is scheduling this program every day with purging 10 days older data.

If these tables are very big as workaround truncate will be possible for these table

truncate table applsys.FND_EXCEPTION_NOTES;
truncate table applsys.FND_OAM_BIZEX_SENT_NOTIF;
truncate table applsys.FND_LOG_METRICS;
truncate table applsys.FND_LOG_UNIQUE_EXCEPTIONS;
truncate table applsys.FND_LOG_EXCEPTIONS;
truncate table applsys.FND_LOG_MESSAGES;
truncate table applsys.FND_LOG_TRANSACTION_CONTEXT;
truncate table applsys.FND_LOG_ATTACHMENTS;

Purging Strategy in Oracle E-Business Suite -2-(FNDCPPUR)