Archiving and Purging Transaction and Depreciation Data
If you no longer need to run reports for previous fiscal years, you can archive and purge historical data to free hardware resources. You can only restore the most recently purged fiscal year, so you must restore fiscal years in reverse chronological order.
Prerequisites
To archive and purge transaction and depreciation data:
1. Change Responsibilities to Fixed Assets Administrator.
2. Open the Archive and Purge window.
3. Enter the Book and Fiscal Year you want to archive. You must archive and purge in chronological order.
4. Choose Archive to submit a concurrent request that changes the status from New to Archived and creates temporary archive tables with the data to be purged.
Oracle Assets automatically assigns an Archive Number when you save your work.
Note: The temporary table name includes a five-digit archive number.
5. Export the archive tables to a storage device.
6. Return to the Archive and Purge window and use the Archive Number to find the archive you want to purge.
7. Choose Purge to submit a concurrent request that changes the status from Archived to Purged and removes the archived data from Oracle Assets tables. Now your database administrator can drop the temporary archive tables.
You can only purge definitions with a status of Archived or Restored.
To restore archived data to Oracle Assets:
1. Import the archive tables from your storage device.
2. Open the Archive and Purge window under the standard Fixed Assets Administrator responsibility.
3. Use the Archive Number to query the archive you want to restore.
4. Choose Restore to submit a concurrent process that changes the status from Purged to Restored and inserts the previously purged data into Oracle Assets tables.
You can purge the restored data again if necessary.
See Also
Data Archive and Purge
If necessary, update the FA:Archive Table Sizing Factor profile option. See: FA:Archive Table Sizing Factor.