This appendix covers the following topics:
Oracle Incentive Compensation processes large volumes of data, which may give rise to storage and performance issues. OIC provides users the ability to run archive and purge in audit only mode for an information report on the scope of the archive/purge for analysis before actually executing the archive and purge program. This report gives an estimate on how many periods to purge at a time based on the provided volumes. Users can then run the OIC Archive and Purge concurrent program to increase space in the system and improve its performance.
For details of the archive and purge flow see: Archive and Purge System Flow, Oracle Incentive Compensation Implementation Guide.
The Archive and Purge OIC Periods concurrent program archives and purges permanently closed periods data from OIC tables. The start period is determined by the procedure as the earliest non-archived permanently closed period. Users should be aware that the records purged from the production instance cannot be rolled back easily. Note that:
The data will be available in the archive tables.
Two audit tables (header/detail document the details of data purged including number of rows deleted, corresponding table names, periods selected and who columns.
In case of a failed execution, user can leverage the restart capability.
Should an error occur during processing, users can correct the condition that caused the failure, and resubmit the concurrent request that failed with the same parameters. The procedure will recognize the previous failed execution and resume processing from where it left off.
Note: It will not be possible to select a different end period until the one that failed has been completed. The same processing is involved if the previous concurrent request is resubmitted or a new one is submitted.
For detailed information on tables associated with the archive and purge process, see: Archive and Purge Tables, Oracle Incentive Compensation Implementation Guide.
Navigate to: Incentive Compensation Administrator > Requests > Schedule.
Search for and select Archive and Purge OIC Periods concurrent program.
Use End period to enter an end date.
From the Run Mode list of values:
Select Audit Only to run an audit report of which tables can be archived and purged.
Select Archive and Purge to archive and purge the tables identified in the audit report.
Select Submit. Note the Request ID.
Navigate to Requests. Click the Details icon for the Archive and Purge OIC Periods Request ID
Click View Log to view the concurrent program logs. The archive_status=Y and purge_status=Y determines the successful completion of the program.
If you have run the concurrent program as Audit Only, review the tables that have been identified for archive and purge,
If you have run the concurrent program to Archive and Purge, view the log to:
Verify that the audit tables contain the expected data and that the counts agree with the data in the archive tables.
Verify the archive tables contain the data that was to be purged.
Verify that the archived data has been deleted from the main OIC tables.
In case a submitted request fails, review the log of the request and note the last table that was processed.
Verify that the table cn_arc_audit_all has one record with either archive_status=N or purge_status=N (there should never be more than one).
Correct the issue from the first step that caused the failure.
Resubmit the request.
Navigate to Requests and ensure that the process shows as successfully completed
Review the log. Note that the processing skips the tables that had been processed previously and processes the rest.
Additional Information: Before you archive or purge any data, See: Functional Prerequisites in the topic Planning for Archive and Purge, Oracle Incentive Compensation Implementation Guide.
See Archive and Purge, Oracle Incentive Compensation Implementation Guide.