WORKFLOW in oracle

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.