Restoring Archived Ledgers and Journals

PeopleSoft allows you to restore archived ledgers and journals using the Data Archive Manager component (PSARCHRUNCNTL).

Page Name

Definition Name

Usage

Archive Data to History Page

PSARCHRUNCNTL

Select an archive ID (template) and the batch number for the process run of the data that you want to restore.

Use the Archive Data to History page (PSARCHRUNCNTL) to restore archived ledgers and journals. Select an archive ID (template) and the batch number of the process run of the data that you want to restore.

Navigation:

PeopleTools > Data Archive Manager > Archive Data to History

The Selection option on the Archive Data to History page places a copy of the data located in the active source ledger and journal records and tables into the history tables and the Delete option removes the archived data from the active source database tables. If you delete data from the source tables in error, you can restore the data from the history tables by using the Rollback option on the Archive Data to History page.

You cannot restore selected parts of the data from the history tables because the process restores all data for a specific archive ID (template) and process run. For example, you cannot specify that you want to restore data for a particular transaction to the source tables.

While you can restore data to the source tables from the history tables, the compatible structure of the source and history tables must be maintained over time to successfully restore data.

Note: After you delete data from the history tables, you cannot restore the data to the active source database tables unless you maintain flat files as backup and manually restore the data to the history tables from the flat file and then to the active database tables from the history tables.

See PeopleTools documentation: Data Management, "Using PeopleSoft Data Archive Manager."