Search Results do_rollback

Overview

APPS.FA_DEPRN_ROLLBACK_PKG is a server-side PL/SQL package within the Oracle E-Business Suite Fixed Assets (FA) module. Its business function is to reverse, or roll back, a previously executed depreciation run for a specified asset book and accounting period. Depreciation is normally processed through the standard FA depreciation concurrent programs, which populate the depreciation summary and roll forward balances held in the depreciation periods table. When a depreciation run is found to be incorrect — for example because of post-run asset additions, transfers, adjustments, or data corrections — the rollback package provides a controlled mechanism to undo the posted depreciation so that the period can be reprocessed cleanly. The package header declares AUTHID CURRENT_USER, meaning procedures execute with the privileges of the invoking schema rather than the definer, a common convention for FA public APIs invoked from other APPS-owned code. The original source header indicates the file FAXDRS.pls at version 120.2, last modified in 2009, confirming the object is a long-standing, stable FA utility.

Key Procedures and Functions

The ETRM metadata documents a single procedure:

• DO_ROLLBACK — The sole documented entry point. It performs the rollback of depreciation for a given book and period. Its signature includes an error buffer and return code (conventional concurrent-program outputs) together with a book type code and a period name identifying the depreciation run to be reversed. According to the documented parameter list, the procedure accepts p_book_type_code and p_period_name as inputs and returns errbuf and retcode as outputs. No further procedures or functions are exposed in the package specification, and the parameter definitions should be taken only as documented above.

Tables Accessed

The package references three FA tables through APPS synonyms:

• FA_BOOK_CONTROLS — Stores book-level control information, including the current depreciation period and the state of the depreciation process for each book. The rollback logic reads this to validate that the requested book and period are eligible for rollback and to update the book's processing status.
• FA_DEPRN_PERIODS — Holds period-level depreciation and roll-forward information for each book. The procedure reads and updates this table to reverse the depreciation amounts and restore prior-period balances.
• FA_DEPRN_SUMMARY — Contains the per-asset depreciation amounts for each period. The rollback deletes or adjusts the summary rows generated by the depreciation run being reversed.

Collectively these tables allow the package to validate the target run, remove the depreciation generated for the period, and reset the book's processing indicators so that depreciation may be rerun.

Usage Notes

FA_DEPRN_ROLLBACK_PKG is typically invoked from an FA concurrent program or from custom PL/SQL code that needs to programmatically reverse a depreciation run. The errbuf and retcode parameters follow Oracle concurrent manager conventions, allowing DO_ROLLBACK to be registered or called within a concurrent program wrapper. In standard use, the rollback should be executed only for the most recent depreciation period, and only after confirming that subsequent FA transactions will not be invalidated. Because the package is documented as API classification OTHER and is referenced by zero other packages in the ETRM metadata, it is not a general-purpose public API dependency and should be used with care. Direct invocation requires the caller to supply a valid book type code and the exact period name, and to interpret the returned error buffer for failure diagnostics. As with all FA period-processing operations, the procedure should be run in an environment where the relevant accounting period is open or appropriately controlled, and it should be preceded by a backup or a documented rollback plan.