Search Results fa_depreciation

Overview

IGI_IAC_ADJ_AMORT_PKG is an Oracle E-Business Suite PL/SQL package owned by the APPS schema and classified as an "OTHER" API within the ETRM repository. It forms part of the IGI (International Governmental/Public Sector) asset adjustment infrastructure that supports the IAC (Inventory Asset Calculation or Inflation Accounting Correction) functionality, an extension used primarily in public sector implementations to handle adjustment and revaluation processing on fixed assets. As its name indicates, the package addresses Adjustment and Amortization of depreciation, interfacing between the corporate Fixed Assets tables (FA_*) and the IGI-specific adjustment and balance tracking tables (IGI_IAC_*).

The package body carries a header signature of igiiadab.pls 120.17 and is marked "noship," indicating it is an internal support object rather than a customer-facing shipped API. It relies heavily on the IGI_IAC_DEBUG_PKG for FND_LOG-based diagnostic tracing, exposing global variables such as g_path, g_asset_num (typed against fa_additions.asset_number), and the standard state, procedure, event, exception, error, and unexpected logging levels. A local procedure, DEBUG_ADJ_ASSET, prints historic asset information for troubleshooting.

Key Procedures and Functions

The metadata documents a single public procedure, DO_AMORT_DEPRN_REVAL. This routine is the core driver for amortizing depreciation associated with revaluation transactions. When a Fixed Assets adjustment or revaluation is processed under IAC, the cumulative depreciation impact must be spread across the remaining life of the asset. DO_AMORT_DEPRN_REVAL performs this distribution, computing the incremental depreciation amounts and posting them in alignment with the IGI adjustment framework. Internally, it likely invokes debugging routines and validates inputs against logged constants. Its name suggests it is called by higher-level adjustment processing logic that generates the revaluation transaction and then delegates the amortization calculation to this procedure.

Tables Accessed

The package reads and writes a defined set of APPS synonyms. Core Fixed Assets tables include FA_ADDITIONS for asset identification, FA_BOOKS for the depreciation book configuration and current period context, and FA_DEPRN_DETAIL for existing depreciation line history. IGI-specific tables include IGI_IAC_ADJUSTMENTS and its companion IGI_IAC_ADJUSTMENTS_HISTORY, which record adjustment transactions and their audit trail; IGI_IAC_ASSET_BALANCES and IGI_IAC_DET_BALANCES, which hold per-asset and detailed balance snapshots required for amortization; IGI_IAC_FA_DEPRN, which stores IAC-specific depreciation amounts; and IGI_IAC_TRANSACTION_HEADERS for the originating adjustment or revaluation transaction. PLITBLM is an Oracle Forms-supplied table used for transaction control, indicating the package is callable from a Forms-based maintenance screen.

Usage Notes

IGI_IAC_ADJ_AMORT_PKG is invoked primarily from Oracle Forms-based IAC maintenance screens and from concurrent or custom programs that process Fixed Assets adjustment and revaluation transactions. Because it carries a "noship" flag and an OTHER classification, it is not exposed as a formal public API; it is instead called by sibling IGI packages or by the IAC adjustment form as part of a larger flow. Administrators encountering the "fa_depreciation" search term should understand that this package does not itself drive standard FA depreciation—it handles the IAC-specific amortization of depreciation arising from adjustments and revaluations. Any custom integration should mirror the calling contract of the originating form and must honor the logging globals so that FND_LOG diagnostics remain functional. One other package references this object, confirming its role as an internal dependency rather than a top-level entry point.