Purging Strategy for eBusiness Suite 11i
In this Document
Abstract
History
Details
Concurrent Jobs to purge data
Additional Notes
Summary
References
APPLIES TO:
Oracle Application Object Library - Version 11.5.10.0 to 12.1.3 [Release 11.5 to 12.1]
Information in this document applies to any platform.
Checked for relevance on 30-NOV-2013
ABSTRACT
There is no single Archive/Purge routine that is called by all modules within eBusiness 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.
Update : November 2008 - since this note was written, a much more comprehensive article has been published in Note 752322.1 "Reducing Your Oracle E-Business Suite Data Footprint using Archiving, Purging, and Information Lifecycle Management"
HISTORY
Author : Mike Shaw
Create Date 18-Aug-2008
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 1016344.102 What Tables Does the Purge Signon Audit Data Concurrent Program Affect?
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:
ecx_error_msgs
ecx_msg_logs
ecx_outbound_logs
ecx_external_retry
ecx_inbound_logs
ecx_outbound_logs
ecx_external_logs
ecx_oxta_logmsg
ecx_doclogs
Purge Rule Executions (FNDDWPURG)
The table being purged by "Purge Rule Executions (FNDDWPURG) is:
fnd_debug_rule_executions
Additional Notes
You can monitor and run purging programs through OAM by navigating to the Site Map--> Maintenence --> Purge section.
SUMMARY
Purging of un-needed data is an activity that needs to be performed on all systems to ensure best performance and minimize disk space requirements. This note outlines some of the processes that may be required from the FND perspective
REFERENCES
NOTE:104282.1 - Concurrent Processing - Purge Concurrent Request and/or Manager Data Program (FNDCPPUR)
NOTE:132254.1 - Speeding Up And Purging Workflow
NOTE:277124.1 - FAQ on Purging Oracle Workflow Data
NOTE:298698.1 - Avoiding abnormal growth of FND_LOBS table in Applications 11i
NOTE:332103.1 - Purge Debug Log And System Alerts Performance Issues
NOTE:337923.1 - A Closer Examination Of The Concurrent Program Purge Obsolete Workflow Runtime Data
NOTE:338523.1 - Cannot Find The Purge Obsolete ECX Data Concurrent Request
NOTE:387459.1 - ATG Supplied Data Purge Requests
NOTE:402116.1 - Page Access Tracking in Oracle Applications Release 12
NOTE:388088.1 - How to Purge Data from the FND_UNSUCCESSFUL_LOGINS Table?
NOTE:397118.1 - Where Is 'Delete Data From Temporary Table' Concurrent Program - ICXDLTMP.SQL
NOTE:413795.1 - Page Access Tracking Data Purge Concurrent Request Fails With Ora-942
NOTE:423177.1 - Date Parameters For "Purge Fnd_stats History Records" Do Not Auto-Increment
NOTE:444524.1 - About Oracle Applications Technology ATG_PF.H Rollup 6
NOTE:461897.1 - Which Tables Store the Page Access Tracking Data?
NOTE:466593.1 - How To Delete Diagnostic Logs and Statistics?
NOTE:553711.1 - Purge Obsolete Ecx Data Error ORA-06533: Subscript Beyond Count
NOTE:555463.1 - How to Purge Generic or Purchasing Attachments from the FND_LOBS Table
NOTE:565942.1 - Which Table Column And Timing Period Does The FNDCPPUR Purge Program Use
NOTE:1016344.102 - Concurrent Processing - List of Tables Accessed by the Purge Signon Audit Data Concurrent Program
NOTE:752322.1 - Reducing Your Oracle E-Business Suite Data Footprint using Archiving, Purging, and Information Lifecycle Management
NOTE:92333.1 - Concurrent Processing - How to Optimize the Process of Running Purge Concurrent Request and/or Manager Data (FNDCPPUR)
In this Document
Abstract
History
Details
Concurrent Jobs to purge data
Additional Notes
Summary
References
APPLIES TO:
Oracle Application Object Library - Version 11.5.10.0 to 12.1.3 [Release 11.5 to 12.1]
Information in this document applies to any platform.
Checked for relevance on 30-NOV-2013
ABSTRACT
There is no single Archive/Purge routine that is called by all modules within eBusiness 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.
Update : November 2008 - since this note was written, a much more comprehensive article has been published in Note 752322.1 "Reducing Your Oracle E-Business Suite Data Footprint using Archiving, Purging, and Information Lifecycle Management"
HISTORY
Author : Mike Shaw
Create Date 18-Aug-2008
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 1016344.102 What Tables Does the Purge Signon Audit Data Concurrent Program Affect?
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:
ecx_error_msgs
ecx_msg_logs
ecx_outbound_logs
ecx_external_retry
ecx_inbound_logs
ecx_outbound_logs
ecx_external_logs
ecx_oxta_logmsg
ecx_doclogs
Purge Rule Executions (FNDDWPURG)
The table being purged by "Purge Rule Executions (FNDDWPURG) is:
fnd_debug_rule_executions
Additional Notes
You can monitor and run purging programs through OAM by navigating to the Site Map--> Maintenence --> Purge section.
SUMMARY
Purging of un-needed data is an activity that needs to be performed on all systems to ensure best performance and minimize disk space requirements. This note outlines some of the processes that may be required from the FND perspective
REFERENCES
NOTE:104282.1 - Concurrent Processing - Purge Concurrent Request and/or Manager Data Program (FNDCPPUR)
NOTE:132254.1 - Speeding Up And Purging Workflow
NOTE:277124.1 - FAQ on Purging Oracle Workflow Data
NOTE:298698.1 - Avoiding abnormal growth of FND_LOBS table in Applications 11i
NOTE:332103.1 - Purge Debug Log And System Alerts Performance Issues
NOTE:337923.1 - A Closer Examination Of The Concurrent Program Purge Obsolete Workflow Runtime Data
NOTE:338523.1 - Cannot Find The Purge Obsolete ECX Data Concurrent Request
NOTE:387459.1 - ATG Supplied Data Purge Requests
NOTE:402116.1 - Page Access Tracking in Oracle Applications Release 12
NOTE:388088.1 - How to Purge Data from the FND_UNSUCCESSFUL_LOGINS Table?
NOTE:397118.1 - Where Is 'Delete Data From Temporary Table' Concurrent Program - ICXDLTMP.SQL
NOTE:413795.1 - Page Access Tracking Data Purge Concurrent Request Fails With Ora-942
NOTE:423177.1 - Date Parameters For "Purge Fnd_stats History Records" Do Not Auto-Increment
NOTE:444524.1 - About Oracle Applications Technology ATG_PF.H Rollup 6
NOTE:461897.1 - Which Tables Store the Page Access Tracking Data?
NOTE:466593.1 - How To Delete Diagnostic Logs and Statistics?
NOTE:553711.1 - Purge Obsolete Ecx Data Error ORA-06533: Subscript Beyond Count
NOTE:555463.1 - How to Purge Generic or Purchasing Attachments from the FND_LOBS Table
NOTE:565942.1 - Which Table Column And Timing Period Does The FNDCPPUR Purge Program Use
NOTE:1016344.102 - Concurrent Processing - List of Tables Accessed by the Purge Signon Audit Data Concurrent Program
NOTE:752322.1 - Reducing Your Oracle E-Business Suite Data Footprint using Archiving, Purging, and Information Lifecycle Management
NOTE:92333.1 - Concurrent Processing - How to Optimize the Process of Running Purge Concurrent Request and/or Manager Data (FNDCPPUR)
