The Archive Distributions History concurrent process archives and purges data from the distributions history and distribution adjustment tables for use at a later date. The Retrieve Distributions History concurrent process retrieves the archived data.
This section describes the Archive and Retrieve Distributions History processes.
The Archive and Retrieve Distributions History processes include the following:
In order to maintain performance on current and prior year data, distributions history lines and distribution adjustment lines can be archived and retrieved at a later time.
The archive distributions history process identifies all history and summary lines for the specified payroll, for those payroll periods falling within the given begin and end time periods, and archives and purges the respective tables. If there is a payroll period within the specified begin and end periods for which there are no lines in the history or summary tables, the process completes successfully and ignores those periods for which no payroll information exists in Oracle Labor Distribution.
The Archive History Report provides users with an account of archived distribution and encumbrance lines.
To archive the actual cost distributions for a period, perform the following steps.
In Labor Distribution, navigate to the Submit Request window as follows:
Processes & Reports - Run
The Submit a New Request pop-up window appears.
Select the Single Request radio button.
Click OK.
The Submit Request window appears.
In the Name field, select one of the following from the list of values:
PSP: Archive Distributions History
PSP: Retrieve Distributions History
The Parameters pop-up window appears.
In the Payroll Name field, select a payroll name from the list of values.
In the Begin Time Period field, select a beginning period from the list of values.
In the End Time Period field, select an ending period from the list of values.
Click OK.
In the Submit Request window, click Submit.
The Requests window appears.
To view the report file, select the appropriate Request ID and click View Output.
Close the window.
To generate the Archive History Report for a period, perform the following steps.
In Labor Distribution, navigate to the Submit Request window as follows:
Processes & Reports - Run
The Submit a New Request pop-up window appears.
Select the Single Request radio button.
Click OK.
The Submit Request window appears.
In the Name field, select PSP: Archive History Report from the list of values.
The Parameters pop-up window appears.
In the Payroll Name field, select a payroll name from the list of values.
In the Begin Time Period field, select a beginning period from the list of values.
In the End Time Period field, select an ending period from the list of values.
Click OK.
In the Submit Request window, click Submit.
The Requests window appears.
To view the report file, select the appropriate Request ID and click View Output.
Close the window.