Purging Strategy for E-Business Suite

Purging Strategy for E-Business Suite

Introduction:

There is no single Archive/Purge routine that is called by all modules within E-Business Suite, instead each module has module specific archive/purge procedures.

This note lists the Purging routines available for the “System Administrator” (FND module)   Not all of these purging processes will be appropriate for all customers, so review the documentation to confirm which are necessary for your own environment and how often they should be run.

Details:

Concurrent Jobs to purge data

• Purge Obsolete Workflow Runtime Data (FNDWFPR)

Oracle Applications System Administrators Guide – Maintenance Release 11i (Part No. B13924-04)
Note 132254.1  Speeding up and Purging Workflow
Note 277124.1  FAQ on Purging Oracle Workflow Data
Note 337923.1  A closer examination of the Concurrent Program Purge Obsolete Workflow Runtime Data

• Purge Debug Log and System Alerts (FNDLGPRG)

Note 332103.1  Purge Debug Log And System Alerts Performance Issues

• Purge Signon Audit data (FNDSCPRG)

Note 388088.1   How To Clear The Unsuccessful Logins

• Purge Concurrent Request and/or Manager Data (FNDCPPUR)

Oracle Applications System Administrator Guide – Maintenance Release 11i (Part No. B13924-04)
Note 565942.1   Which Table Column And Timing Period Does The FNDCPPUR Purge Program Use
Note 104282.1  Concurrent Processing Tables and Purge Concurrent Request and/or Manager Data Program (FNDCPPUR)
Note 92333.1   How to Optimize the Process of Running Purge Concurrent Request and/or Manager Data (FNDCPPUR)

• Delete Diagnostic Logs (DELDIAGLOG)

Note 466593.1   How To Delete Diagnostic Logs and Statistics?

• Delete Diagnostic Statistics (DELDIAGSTAT)

Note 466593.1   How To Delete Diagnostic Logs and Statistics?

• Purge FND_STATS History Records (FNDPGHST)

Oracle Applications System Administrators Guide – Configuration Release 11i (Part No. B13925-06)
Note 423177.1  Date Parameters For “Purge Fnd_stats History Records” Do Not Auto-Increment

• Page Access Tracking Purge Data (PATPURGE)

Note 413795.1   Page Access Tracking Data Purge Concurrent Request Fails With Ora-942
Note 461897.1   Which Tables store the Page Access Tracking Data?
Note 402116.1   Page Access Tracking in Oracle Applications Release 12

• Purge Obsolete Generic File Manager Data (FNDGFMPR)

Oracle Applications System Administrators Guide – Configuration Release 11i (Part No. B13925-06)
Note 298698.1   Avoiding abnormal growth of FND_LOBS table in Application
Note 555463.1   How to Purge Generic or Purchasing Attachments from the FND_LOBS Table

• Summarize and Purge Concurrent Request Statistics (FNDCPCRS)

(no references found)

• Purge Inactive Sessions (ICXDLTMP)

Note 397118.1  Where Is ‘Delete Data From Temporary Table’  Concurrent Program – ICXDLTMP.SQL

• Purge Obsolete ECX Data (FNDECXPR)

Note 553711.1   Purge Obsolete Ecx Data Error ORA-06533: Subscript Beyond Count
Note 338523.1   Cannot Find ”Purge Obsolete Ecx Data” Concurrent Request
Note 444524.1   About Oracle Applications Technology ATG_PF.H Rollup 6

The tables being purged by “Purge Obsolete ECX Data (FNDECXPR)” are:

1. ecx_error_msgs
2. ecx_msg_logs
3. ecx_outbound_logs
4. ecx_external_retry
5. ecx_inbound_logs
6. ecx_outbound_logs
7. ecx_external_logs
8. ecx_oxta_logmsg
9. ecx_doclogs

• Purge Rule Executions (FNDDWPURG)

The table being purged by “Purge Rule Executions (FNDDWPURG) is:

1. fnd_debug_rule_executions

Additional Notes

You can monitor and run purging programs through OAM by navigating to the Site Map–> Maintenance –> Purge section.