Search Results fa_group_reclass2_pvt




Overview
Explore in AI Chat

Overview

FA_GROUP_RECLASS2_PVT is a private PL/SQL package owned by the APPS schema in Oracle E-Business Suite Release 12.1.1 and 12.2.2. Its role is to support group reclassification of assets within Oracle Assets (Fixed Assets). Group reclassification is the process by which a set of assets assigned to one asset category is moved to a different category, often together with an associated cost adjustment, without individually processing each asset through the standard asset workbench. The "_PVT" suffix indicates that this package is an internal (private) implementation unit; it is not intended to be called directly by external code, but rather is consumed by public APIs and by the group-processing framework that orchestrates mass asset maintenance.

The package sits at the intersection of the Assets public API layer and the group processing engine. It encapsulates the low-level logic required to compute member-level amounts, generate the adjustment rows that carry the reclassification (and any associated cost change), and persist those rows into the depreciation and adjustment tables. Because it is private, all interaction occurs indirectly through the packages and public interfaces that reference it.

Key Procedures and Functions

The ETRM metadata documents three program units within the package: DO_GROUP_RECLASS, DO_ADJUSTMENT, and POPULATE_MEMBER_AMOUNTS.

  • DO_GROUP_RECLASS — The principal entry point that performs the group reclassification operation. It applies the category change and any related adjustments across the members of the group, driving the two supporting procedures described below.
  • DO_ADJUSTMENT — Creates and processes the adjustment records required to effect the reclassification. Adjustments are the mechanism Oracle Assets uses to record changes in cost or category that flow into depreciation. This procedure interacts with the adjustment tables to stage the financial impact of the reclassification.
  • POPULATE_MEMBER_AMOUNTS — Populates the per-member monetary amounts needed for the group operation. Group processing works from a set of member assets, and each member requires its own computation of cost, adjustment, and related values before the group as a whole can be processed.

Tables Accessed

The package reads and writes a broad set of Assets tables through APPS synonyms. The core adjustment tables FA_ADJUSTMENTS and FA_MC_ADJUSTMENTS hold the adjustment records generated for the reclassification, including the multi-currency (MC) variant. FA_BOOK_CONTROLS, FA_DEPRN_PERIODS, FA_MC_DEPRN_PERIODS, FA_CALENDAR_PERIODS, FA_CALENDAR_TYPES, and FA_FISCAL_YEAR supply the period and calendar context that determines which depreciation period an adjustment is booked into. FA_DEPRN_SUMMARY and FA_MC_DEPRN_SUMMARY store the depreciation results affected by the reclassification. FA_CATEGORY_BOOKS and FA_DEPRN_RULE_DETAILS provide category-to-book associations and depreciation rule detail used to recompute depreciation correctly after a category change. FA_DISTRIBUTION_HISTORY captures the posting distribution impact. Finally, FA_RETIREMENTS and FA_MC_RETIREMENTS are accessed to account for retired assets within the group.

Usage Notes

FA_GROUP_RECLASS2_PVT is invoked indirectly. Within Oracle Assets it is called by FA_ADJUSTMENT_PUB (the public adjustment API), by FA_PROCESS_GROUPS_PKG (the group processing engine that runs group reclassification and similar mass operations), and recursively by itself. It also depends on FA_API_TYPES for shared type definitions and FND_GLOBAL for session context such as user and responsibility. Custom code should never call this private package directly; instead, developers should invoke the public adjustment API or the group processing framework, which supply the appropriate validation, security, and accounting context. Because it is private, signature changes between releases are not governed by the same compatibility guarantees as public APIs, making reliance on it from custom extensions inadvisable.