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 Name |
Definition Name |
Usage |
|---|---|---|
|
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. |
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:
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.
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:
Run Calculate Depreciation (AM_DEPR_CALC) process to generate depreciation calculations.
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.)
Run the archive mass transaction for the table from which transactions are pulled.
Run the delete mass transaction for the table from which transactions are pulled.
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