My Oracle Support Banner

FAQ: Oracle Assets Archive, Purge and Restore Processes (Doc ID 144431.1)

Last updated on AUGUST 23, 2021

Applies to:

Oracle Assets - Version 11.5.10.0 and later
Information in this document applies to any platform.

Purpose

 FAQ: Archive, Purge, and Restore Process

Questions and Answers

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Purpose
Questions and Answers
 1.  Why do I need to run Archive and Purge for my Fixed Assets data and what gets removed
 2. Are there any prerequisites/setup steps that must be performed before I can use the Archive, Purge and Restore process?
 3. Why do I still see some data in my tables from fiscal years and/or books that I've archived and purged?
 4. What should I do if the purge process fails while it is running?
 5. Why can I not run the Archive and Purge process from the Standard Request Submission form?
 6. How do I archive and purge financial information for assets that were retired in the prior fiscal year?
 7. The documentation states that after purging and exporting the data, that you should drop and recreate the tables from which you've purged (i.e. FA_DEPRN_SUMMARY, FA_DEPRN_DETAIL and FA_ADJUSTMENTS).  Why is this necessary when you actually just archived, exported and purged the information from those tables?
 8. Are there any other purge programs in FA (other than FAPURG) that should be run periodically due to large table sizes and/or for performance reasons? 
 9. When I run reports (such as Asset Additions Report or Asset Retirements Report), I still see period names shown in the list of values for those periods in which I've already Archived and Purged.  Why?
 10. Under what circumstances would I need to restore the data that I've Archived and Purged?
 Still Have Questions?
References

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.