Roll Back Depreciation

Tags:

fa1 technical2 create new tag

Introduction

Roll back depreciation is a concurrent process that is used to restore the system to the same state as before running depreciation. If the period has not been closed, depreciation roll back is an available option. The concurrent process takes the book name and the open period name as parameters.

In R12.0, the depreciation roll back function from R11i has been enhanced to operate at the asset level. When depreciation has been run, the period has not been closed, and assets are selected in asset workbench or mass transactions, FA will automatically roll back depreciation on selected assets and allow normal processing of asset transactions on those assets. The selected assets with processed transactions will be included in the next depreciation run.

Technical Process

The technical process of rolling back depreciation includes the following...

1. Determine if the book to be rolled back is a TAX book from fa_book_controls
2. Make sure the depreciation run status is completed from fa_book_controls
3. Determine the period information from fa_deprn_periods
4. Verify that the annual_rounding_flag has not been updated
5. Verify that no transactions have been made for the open period from fa_transaction_headers. If the book to be rolled back is a TAX book, check the associated corporate book. Check for TRANSFER, RECLASS, PARTIAL RETIREMENT, REINSTATEMENT, TRANSFER OUT and UNIT ADJUSTMENT transaction types
6. Delete from fa_deprn_summary and fa_mc_deprn_summary for the current period and book
7. Delete from fa_deprn_detail and fa_mc_deprn_detail for the current period and book
8. Delete from fa_adjustments the reserve for backdated transfers
9. Delete from fa_adjustments the COST and CLEARING rows for for CIP ADDITION transactions
10. Update fa_additions_b to set the add_cost_je_flag column
11. Update fa_books and fa_mc_books to set the period_counter_fully_reserved column
12. Update fa_books and fa_mc_books to set the period_counter_life_complete column
13. Update fa_books and fa_mc_books to set the adjustment_required_status column
14. Update fa_books and fa_mc_books to set the adjusted_cost column
15. If the rollback period is in a new fiscal year, update fa_books and fa_mc_books to set the annual_deprn_rounding_flag
16. Update fa_book_controls and fa_mc_book_controls to set the last_period_counter and current_fiscal_year columns
17. delete from fa_deprn_periods and fa_mc_deprn_periods for the book and period
18. Update fa_deprn_periods and fa_mc_deprn_periods to set the period_close_date to null for the rollback period
19. Reset posting journal entry and JE batch columns on fa_adjustments, fa_mc_adjustments, fa_deprn_detail, fa_mc_deprn_detail, fa_deprn_periods, and fa_mc_deprn_periods

If the period has been closed and must be reopened and no transactions have been performed in the newly opened period, Oracle Support has a manual depreciation roll back script that can be requested by completing a service request. The script uses the book type code as a parameter and accounts for back dated transactions and usage of MRC.

Comments

Disclaimer

Obviously, don't try this technical process without help from Oracle Support.

Use at Your Own Risk: We provide the material available through this website for informational purposes only. Before you act on any information you've found on this site, you should confirm any facts that are important to your decision. IF YOU RELY ON ANY INFORMATION OR SERVICE AVAILABLE THROUGH THIS WEBSITE, YOU DO SO AT YOUR OWN RISK. YOU UNDERSTAND THAT YOU ARE SOLELY RESPONSIBLE FOR ANY DAMAGE OR LOSS YOU MAY INCUR THAT RESULTS FROM YOUR USE OF ANY SERVICE OR ANY MATERIAL AND/OR DATA DOWNLOADED FROM OR OTHERWISE PROVIDED THROUGH THIS WEBSITE.

Links

• Related: AssetDepreciation, OracleAssets, AssetBooks? , FA12DepreciationRunDepreciation

This Topic Is Referenced By These Topics:
Related Links: AssetDepreciation, AssetsFAQ, FA12DepreciationRunDepreciation, WebStatistics

---

---

Was This Topic Useful to You?

Others rated this topic as shown. Please include your rating.

Choice

Select ...Very UsefulSomewhat UsefulNo OpinionNot Useful

Very Useful (3) Somewhat Useful (1)

Collaborating Authors and Reviewers: -- JimCrum - 04 Mar 2008