Blog dedicated to Oracle Applications (E-Business Suite) Technology; covers Apps Architecture, Administration and third party bolt-ons to Apps

Friday, December 5, 2008

In-built Data purge concurrent programs

As per metalink note 387459.1:

The ATG / FND supplied data purge requests are the following:
- Purge Concurrent Request and/or Manager Data        [FNDCPPUR]
- Purge Obsolete Workflow Runtime Data                    [FNDWFPR]
- Purge Signon Audit data                                             [FNDSCPRG.sql]
- Purge Obsolete Generic File Manager Data                [FNDGFMPR]
- Purge Debug Log and System Alerts                          [FNDLGPRG]
- Purge Rule Executions                                               [FNDDWPUR]
- Purge Concurrent Processing Setup Data for Cloning  [FNDCPCLN]


Metalink Note 732713.1 describes purging strategy for E-Business Suite 11i:

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.

Concurrent Jobs to purge data

  • Purge Obsolete Workflow Runtime Data (FNDWFPR)

 Oracle Applications System Administrator’s 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’s 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 Administrator’s 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 Administrator’s 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

  • Purge Rule Executions (FNDDWPURG)

(no references found)

Additional Notes

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


This note also gives reference of a white paper in Note 752322.1 "Reducing Your Oracle E-Business Suite Data Footprint using Archiving, Purging, and Information Lifecycle Management"

4 comments:

Anonymous said...

Copyright © 2008 Oracle.

Vikram Das said...

Oracle RDBMS is Copyright E.F. Codd and IBM :)

zzmaher said...

Thanks Vikram....realy a good note..hope to submit another one for 12.0.6

Abuzeid maher

tokyodba said...

do you know how to run FNDLGPRG using concsub?