Purging Related to SYS ADMIN & WORKFLOW

This document describes archiving across applications, how to submit the purge processes, purging criteria for records, what information does and does not get purged, the tables information is purged from and how to restore archived information.

System Administration

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.

Archiving it.

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.

Workflow

To purge the workflow runtime tables use the standard concurrent program FNDWFPR ”Purge Obsolete Workflow Runtime Data”.

Instructions

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
Srinivas Ramineni
Oracle Apps DBA