Search Results adjust_fa_cost_n_unit

Overview

APPS.CSE_ASSET_WIP_PKG is a server-side PL/SQL package in Oracle E-Business Suite that supports asset cost and unit adjustments originating from Oracle Installed Base (formerly Service) configuration data. The package header declares the program as AUTHID CURRENT_USER and its header comment ($Header: CSEFAWPS.pls 115.1) places the source in the CSE (Customer Service/Installed Base) module family. The package has two documented procedures: it walks the immediate children of an Installed Base configuration, and for each depreciable component it applies unit and cost adjustments that are ultimately staged for Oracle Assets.

Functionally, the package bridges Installed Base instances (CSI_ITEM_INSTANCES, CSI_I_ASSETS) with Oracle Assets (FA_ADDITIONS, FA_BOOKS, FA_DISTRIBUTION_HISTORY, FA_MASS_ADDITIONS). Rather than posting adjustments directly to existing asset rows, it inserts records into FA_MASS_ADDITIONS, which is the standard Oracle Assets staging table for mass additions / mass adjustments. This design preserves Oracle Assets audit and validation logic, since mass additions are normally processed by the Post Mass Additions concurrent program.

Key Procedures and Functions

• UPDATE_COMP_ASSETS — Finds the immediate children from the Installed Base configuration and, for each depreciable component, performs unit and cost adjustment. It accepts a top-level instance identifier as input and returns a return status and an error message. This is the driving procedure that traverses a configuration hierarchy and delegates per-component adjustment work.
• ADJUST_FA_COST_N_UNIT — Inserts records into FA_MASS_ADDITIONS for COST and UNIT adjustments. Its parameters (per the documented source) include an asset identifier, book type code, location identifier, expense account CCID, employee identifier, the unit-to-adjust amount, the cost-to-adjust amount, and reviewer comments, with return status and error message outputs. This is the procedure most commonly referenced by users searching for adjust_fa_cost_n_unit, and it is the low-level routine that writes the adjustment payload to the Oracle Assets interface table.

Tables Accessed

• CSI_ITEM_INSTANCES and CSI_I_ASSETS — Installed Base item instances and their associated asset information; used to resolve a configuration's components and link them to assets.
• FA_ADDITIONS and FA_BOOKS — Oracle Assets asset definitions and book assignments; used to validate the asset and its book context before adjustment.
• FA_DISTRIBUTION_HISTORY — Asset distribution history, consulted for the location/expense account context of the adjustment.
• FA_MASS_ADDITIONS — The Oracle Assets mass additions interface; the target of the cost and unit adjustment inserts.
• DUAL — Used for single-row value selection.
• PLITBLM — An internal EBS temporary table, typically employed for transient value storage during PL/SQL processing.

Usage Notes

CSE_ASSET_WIP_PKG is an internal EBS implementation package rather than a published public API, and the ETRM metadata records it as classification OTHER with no other packages referencing it. It is ordinarily invoked indirectly — by Installed Base or Service forms, by concurrent programs that synchronize Installed Base configuration with Oracle Assets, or by internal business logic that adjusts asset cost and units for depreciable components of a configuration. Because the procedure accepts a reviewer comments parameter and stages results in FA_MASS_ADDITIONS, adjustments remain subject to Oracle Assets mass addition posting and review before they affect book balances.

For 12.1.1 and 12.2.2, callers should treat the interfaces as non-public: signatures and behavior may change between patch levels, so custom code should avoid direct calls and instead use supported Oracle APIs. All parameters are passed by position in the documented signature, and error handling flows through the x_return_status and x_error_msg outputs, which callers must check to confirm success.