Restoring Archived Data

This topic describes how to run a process that restores archived data.

Use the Restore Cost/Depreciation (AM_RESTORE) component to restore archived asset cost and depreciation transactions.

Page Used to Restore Archived Data

Page Name Definition Name Usage

Restore Cost/Depreciation Page

RUN_RESTORE

Run the Asset Restore (AM_CD_RESTO) Application Engine process that copies data stored in the archive tables back to the application tables.

Restore Cost/Depreciation Page

Use the Restore Cost/Depreciation page (RUN_RESTORE) to run the Asset Restore (AM_CD_RESTO) Application Engine process that copies data stored in the archive tables back to the application tables.

Navigation:

Asset Management, and then Asset Transactions, and then History, and then Restore Cost/Depreciation, and then Run Restore

Field or Control Description

Unit

Select the business unit from which records will be restored.

Book Name

You must restore an asset in each book associated with the asset.

From Asset ID and To Asset ID

Use these fields to restore a range of archived asset IDs. To restore one archived asset, enter the asset ID in the From Asset field.

Archive ID

Enter the run control ID that the system generated when the data was archived. By default, the system displays the most recent run control ID for the Asset Archive process.

The Asset Restore process restores the archived data by deleting the summed row in the application tables and replacing it with the multiple rows of data stored in the archive tables.

Archiving From Transaction Table Details

PeopleSoft provides the transactions for the Run Mass Transactions component to archive, delete, and retrieve data from high-volume transaction detail tables. The tables available for this process are:

  • ASSET_NBV_TBL: Accumulates detail lines from net book value processing.

  • DEPR_RPT: Accumulates detail lines from depreciation reporting.

  • OPEN_TRANS: Accumulates detail lines from open transactions.

  • DIST_LN: Accumulates information from creating accounting entries.

The transaction detail lines can also be deleted from the tables once they have been archived, or without archive if the transactions are set to be purged. Data that is archived is also available for retrieval as needed for reporting or audit purposes.

The steps for archiving, deleting or retrieving transaction detail from tables are:

  1. Run Calculate Depreciation (AM_DEPR_CALC) process to generate depreciation calculations.

  2. Run Depreciation Reporting (AMDPREPT) process and Load Net Book Value (AMLDNBVT) process to collect the information provided by AM_DEPR_CALC. (If you are working with the OPEN_TRANS or DIST_LN tables, you do not need to run these processes.)

  3. Run the archive mass transaction for the table from which transactions are pulled.

  4. Run the delete mass transaction for the table from which transactions are pulled.

  5. Run the retrieve mass transaction for the table from which transactions are to be viewed.

The mass transactions to archive, delete and retrieve detail are:

  • Archive Asset Depr Rpt entries

  • Archive Asset NBV entries

  • Archive Asset Open Trans

  • Archive Asset Acctng Entries

  • Delete Asset Acctng Entries

  • Delete Asset Depr Rpt entries

  • Delete Asset NBV entries

  • Delete Asset Open Trans

  • Unload DIST_LN_ARCH to file

  • Unload Open Trans to File

  • Upload Asset Open Trans

  • Upload Asset Acctng Entries

Related Topics