Search Results do_group_reclass




Overview
Explore in AI Chat

Overview

FA_PROCESS_GROUPS_PKG is a PL/SQL package owned by the APPS schema in Oracle E-Business Suite Release 12.1.1 and 12.2.2. It belongs to the Oracle Assets (Fixed Assets, or FA) product family and is classified under the ETRM as an "OTHER" API, meaning it is not one of the formally published open interfaces but is an internal processing package used by Oracle Assets itself. Its documented status is VALID.

The package supports the processing of fixed asset "groups" — sets of assets that are handled collectively for depreciation adjustments, revaluation, and reclassification. Its two procedures, DO_PENDING_GROUPS and DO_GROUP_RECLASS, drive the mass processing of group-level transactions: those still pending in the group pipeline, and those requiring reclassification between asset categories. In the ETRM dependency tree, FA_PROCESS_GROUPS_PKG depends on APPS.FA_API_TYPES (the shared record/collection type definitions that all Oracle Assets APIs use) and on the SYS.STANDARD package. It is referenced by APPS.FA_ADJUSTMENT_PUB, the public adjustment API, which indicates that group processing is invoked as part of adjustment and revaluation flows.

Key Procedures and Functions

Two procedures are documented for this package:

  • DO_PENDING_GROUPS — Processes groups of asset transactions that are in a pending state. It reads the relevant group, transaction header, and adjustment records, applies the pending group activity, and writes the resulting adjustments and transaction references. This is the mechanism by which Oracle Assets clears the backlog of group transactions awaiting final processing.
  • DO_GROUP_RECLASS — Handles group reclassification. It moves assets or groups between categories, updating category book assignments, distribution history, and the associated adjustment records so that the reclassification is reflected consistently across books, including multi-currency (MC) books.

The ETRM metadata documents no additional subprograms and does not expose parameter lists; callers should treat these procedures as internal and reference the published FA_ADJUSTMENT_PUB API where an open interface is required.

Tables Accessed

The package reads and writes a broad set of Oracle Assets base tables through APPS synonyms. Core tables include FA_BOOKS, FA_BOOK_CONTROLS, and FA_MC_BOOKS/FA_MC_BOOK_CONTROLS, which supply book setup, period status, and depreciation controls. Asset transaction data comes from FA_TRANSACTION_HEADERS and FA_TRX_REFERENCES. Adjustment records are handled in FA_ADJUSTMENTS and FA_MC_ADJUSTMENTS. Category assignment and reclassification use FA_CATEGORY_BOOKS, FA_METHODS, and FA_DISTRIBUTION_HISTORY. Invoice-related cost adjustments flow through FA_ASSET_INVOICES and FA_MC_ASSET_INVOICES, while retirements are held in FA_RETIREMENTS and FA_MC_RETIREMENTS. Together these tables represent the full accounting footprint of a group transaction: its book and period context, its category and method, its source invoice or retirement, and the resulting adjustments.

Usage Notes

FA_PROCESS_GROUPS_PKG is invoked internally rather than being called directly from concurrent program parameters or custom PL/SQL in normal circumstances. The principal documented entry point is via FA_ADJUSTMENT_PUB, the public adjustment API, which references this package when group-level adjustments or revaluations are submitted. In practical terms, users trigger the logic through the Oracle Assets forms and concurrent programs — for example, when running group depreciation, group revaluation, or category reclassification — and the package performs the underlying record maintenance. Because it is an "OTHER" classified object, it is not part of Oracle's committed public API surface; customizations should code against FA_ADJUSTMENT_PUB or other supported FA APIs instead of calling DO_PENDING_GROUPS or DO_GROUP_RECLASS directly. Any direct call risks breaking when Oracle patches the package, and callers would have to replicate the FA_API_TYPES structures themselves.