Archive, Purge, and Restore Process
There are several steps to archive, purge, and restore a fiscal year. Some of these steps you can do using the Mass Purge window. Others you should ask your Database Administrator to perform. To archive and purge a fiscal year, you need to:
1. Archive and purge all earlier fiscal years.
2. Update FA: Archive Table Sizing Factor if necessary (Database Administrator).
3. Run Archive (Fixed Assets Administrator).
4. Export temporary archive tables to storage device (Database Administrator).
5. Run Purge (Fixed Assets Administrator).
6. Drop temporary archive tables (Database Administrator).
7. Export current data from tables from which you purged (Database Administrator).
8. Drop tables from which you purged (Database Administrator).
9. Recreate tables from which you purged (Database Administrator).
10. Import current data into tables from which you purged (Database Administrator).
11. Verify tables and indexes (Database Administrator).
If you later need the data online, you can restore it. To restore a fiscal year you need to:
12. Restore all later fiscal years.
13. Import temporary archive tables from storage device (Database Administrator).
14. Run Restore (Fixed Assets Administrator).
When you perform the archive, Oracle Assets assigns a reference number to it and copies the depreciation expense and adjustment transaction records to three temporary tables:
- FA_ARCHIVE_SUMMARY_<Archive_Number>
- FA_ARCHIVE_DETAIL_<Archive_Number>
- FA_ARCHIVE_ADJUSTMENT_<Archive_Number>
You can export the temporary archive tables onto tape or any storage device. If you need these records again, you can restore them. You must archive records before you can purge them, and Oracle Assets prevents you from running purge if these tables do not exist. You should not drop the tables until after you have exported the tables and run purge.
Oracle Assets prevents you from running purge if the temporary archive tables from the archive transaction do not exist. Since the archive number is part of the temporary table name, Oracle Assets purges only the records that were archived during the archive you specify.
Recreate Database Objects From Which You Purge
After you purge your database, contact your Database Administrator to export, drop, and recreate the tables from which you purged data. By recreating these objects, you can reduce the memory each object occupies in your tablespace and perhaps increase the performance of your system.
You can tell your Database Administrator that you purged from the FA_DEPRN_SUMMARY, FA_DEPRN_DETAIL, and FA_ADJUSTMENTS tables. After recreating the tables and importing the data, check that all the appropriate indexes were recreated. The Oracle Assets Technical Reference Manual provides information on which indexes each database table requires.
To restore records that you have purged from Oracle Assets, you must first import the tables from your archive, then perform the restore. You do not need to archive the records before you purge them again.
Since the archive number is part of the temporary table name, Oracle Assets restores only the records that were archived during that archive you specify.
Controlling Your Archive
Use the Status field to determine the next possible action.
See Also
Archiving and Purging Transaction and Depreciation Data
Resizing the Archive Tables