Search Results fa_adjustment_pub




Overview
Explore in AI Chat

Overview

FA_ADJUSTMENT_PUB is a public PL/SQL API package in the Oracle E-Business Suite Applications (APPS) schema that exposes the adjustment processing logic of the Oracle Assets (FA) module. Its principal responsibility is to create and validate asset cost and financial adjustments — such as cost adjustments, depreciation expense adjustments, and financial adjustments against asset books — while enforcing the standard Oracle Assets validation rules, calendar and period constraints, and accounting integrity. As a "PUB" classified API, it is intended to be called by external programs and other product modules, in contrast to the private ("PVT") packages that implement the underlying business logic.

The package participates in the core Oracle Assets transaction flow alongside other public APIs such as FA_TRANS_API_PUB and FA_INV_XFR_PUB, and it is a foundational dependency for a wide range of Oracle Assets, mass transaction, tax, reclassification, and Leasing (OKL) packages. This positioning makes it a central integration point for any process that needs to adjust asset data programmatically rather than through the standard Assets forms.

Key Procedures and Functions

The documented metadata exposes a single public procedure:

  • DO_ADJUSTMENT — The primary entry point for performing an adjustment against an asset. It encapsulates the validation and processing required to record an adjustment for an asset and book combination, applying the appropriate Oracle Assets business rules before the adjustment is committed. This single procedure serves as the public interface through which calling packages (mass additions, mass changes, mass copies, reclassifications, interfacing packages such as FA_XADJ_ITF_PKG, and the Leasing activation and termination routines) request an adjustment.

Because the published documentation identifies only this one procedure, custom code should treat DO_ADJUSTMENT as the supported public surface of the package and avoid reliance on internal or undocumented program units.

Tables Accessed

The package operates against the core Oracle Assets adjustment and depreciation tables. Through APPS synonyms it references:

These accesses ensure the adjustment is consistent with the asset's book setup, calendar, and depreciation configuration before and after posting.

Usage Notes

FA_ADJUSTMENT_PUB is not typically called directly by end users. It is invoked programmatically by concurrent programs, Oracle Assets forms, and other PL/SQL packages. The dependency metadata lists numerous callers, including FA_CREATE_GROUP_ASSET_PKG, FA_CUA_MASS_UPDATE1_PKG and FA_CUA_MASS_UPDATE2_PKG, FA_INV_XFR_PUB, FA_MASSADD_PKG, FA_MASSCHG_PKG, FA_MASSCP_PKG, FA_RECLASS_PVT, FA_SUPER_GROUP_CHANGE_PKG, FA_TAX_UPLOAD_PKG, FA_TRANS_API_PUB, and FA_XADJ_ITF_PKG, as well as the Leasing packages OKL_ACTIVATE_ASSET_PVT, OKL_AM_ASSET_DISPOSE_PVT, OKL_AM_CNTRCT_LN_TRMNT_PVT, OKL_AM_LEASE_TRMNT_PVT, OKL_AM_PROCESS_ASSET_TRX_PVT, OKL_LIKE_KIND_EXCHANGE_PVT, and OKL_SPLIT_ASSET_PVT. In total, the package is referenced by 21 other packages.

When invoking the API from custom code, standard Oracle EBS API conventions should be observed: initialize the FND_GLOBAL session context, supply values consistent with FA_API_TYPES structures, honor the open period and book controls, and check the returned API status before committing. The package relies on FND_API and FND_GLOBAL for message handling and session context, and on FA_API_TYPES for its parameter structures and constants.