Concurrent program “Purge Debug Log and System Alerts” in Release 11i and “Purge Logs and Closed System Alerts” in Release 12 is recommended way to purge messages.
This program purges all messages up to the specified date,except messages for active transactions (new or open alerts, active ICX sessions, concurrent requests, and so on). This program is by default scheduled to run daily and purge messages older than 7 days. Internally this concurrent program invokes FND_LOG_ADMIN APIs.
Data from the following tables will be deleted when you run “Purge Logs and Closed System Alerts'” or “Purge Debug Log and System Alerts” program :
select * from FND_EXCEPTION_NOTES;
select * from FND_OAM_BIZEX_SENT_NOTIF;
select * from FND_LOG_METRICS;
select * from FND_LOG_UNIQUE_EXCEPTIONS;
select * from FND_LOG_EXCEPTIONS;
select * from FND_LOG_MESSAGES;
select * from FND_LOG_TRANSACTION_CONTEXT;
select * from FND_LOG_ATTACHMENTS
These tables contain debug & error messages.
Purge Concurrent Request and/or Manager Data Program
This concurrent program is used to purge concurrent requests log/out file, and/or CM log files.