Archiving Audit Data:
Auditing is the main feature that produces high impact on Applications But it is a very useful tool use it with proper planning.
Disable auditing using the “Disable – Prepare for Archive” and running the Audit Trail Update Tables report.
Set the Archive group to Disable Purge Table and running the Audit Trail Update tables report.
Purge Concurrent Request and/or Manager Data:
Use this program to delete:
1. Request log files, concurrent manager log files, ad report output files from your product directories maintained by the operating system
2. Records (rows) from Application Object Library database tables that contain history information about concurrent requests and concurrent manager processes.
Use this program to compute performance statistics for each of the concurrent programs, if the Concurrent: Collect Request Statistics profile option is set to “Yes”.
Purge Signon Audit Data:
Use this program to purge Sign-On Audit information created before a specified date.
The following data is deleted:
1. Data for who signs on and for how long
2. Data for who is selecting what responsibility and when they do it
3. Data for who uses which forms in an application and when
Purge Obsolete Generic File Manager Data:
To purge uploaded files form the Generic File Manager, run the concurrent program, Purge Obsolete Generic File Manager Data.
This concurrent program should also be used to periodically delete obsolete data. It is recommended that you schedule this program to run every day or so, using the default parameter values.
To purge the workflow runtime tables use the standard concurrent program FNDWFPR ”Purge Obsolete Workflow Runtime Data”.
Navigate to the Submit Requests form in Oracle Applications to submit the Purge Obsolete Workflow Runtime Data concurrent program.
You can supply the following parameters for the Purge Obsolete Workflow Runtime Data concurrent program:
Item Type----The item type to purge. Leaving this field blank defaults to purging the runtime data for all item types.
Item Key----The item key to purge. Leaving this field blank defaults to purging the runtime data for all item keys.
Age----Minimum age of data to purge, in days.
Persistence Type----The persistence type to be purged, either ’TEMP’ for Temporary or ’PERM’ for Permanent. The default is ’TEMP’.
Note: If you have implemented Oracle Applications Manager, you can use Oracle Workflow Manager to submit and manage the Purge Obsolete Workflow Runtime Data concurrent program.By
Oracle Apps DBA