Search Results farx_rr




Overview
Explore in AI Chat

Overview

FARX_RR is a PL/SQL package owned by APPS within the Oracle E-Business Suite Fixed Assets module. In the context of EBS 12.1.1 and 12.2.2, the package supports the Mass Reclass Review workflow, a component of the asset reclassification feature set. Its declared purpose is to evaluate reclassification transactions that have been defined for a selected group of assets and to record the projected results of those transactions in the mass reclass interface table, FA_MASS_RECLASS_ITF.

The package is defined with AUTHID CURRENT_USER, meaning that its unqualified object references resolve against the privileges of the invoking session rather than the package owner. The source header dates the file to 2009, and the documented API classification is OTHER, indicating it is not part of Oracle's formally supported public API surface. It exists primarily to back the concurrent processing path that generates the Mass Reclass Review output, allowing users to inspect the before-and-after effect of a mass reclassification before committing it.

Key Procedures and Functions

The package exposes a single documented procedure, REVIEW_RECLASS. It performs the mass reclass review for a specified reclassification run and returns status information to the caller.

  • REVIEW_RECLASS — Accepts a mass reclass identifier and a flag indicating whether the invocation originates from the RX report path. It retrieves the user's asset selection and reclass criteria from FA_MASS_RECLASS, evaluates the reclassification effect on every eligible asset, and inserts the resulting reclass transactions into FA_MASS_RECLASS_ITF. It returns an OUT status code (0 for normal completion, 1 for completion with warning, and 2 for completion with error) together with an OUT error buffer conveying the warning or error description.

The procedure is invoked by the concurrent wrapper FARX_C_RR.Mass_Reclass_Review(), which supplies the standard retcode and errbuf OUT parameters expected by concurrent program registration.

Tables Accessed

FARX_RR reads and writes a defined set of Fixed Assets tables, referenced through APPS synonyms:

  • FA_MASS_RECLASS — Stores the user's asset selection and reclass criteria for the run; read to drive processing.
  • FA_MASS_RECLASS_ITF — The interface table into which computed reclass transactions are inserted.
  • FA_ADDITIONS — Provides asset-level information for eligible assets.
  • FA_ASSET_HISTORY — Supplies historical transaction detail used in the review calculation.
  • FA_BOOKS and FA_BOOK_CONTROLS — Provide asset book balances and book-level configuration.
  • FA_CATEGORY_BOOKS — Supplies category-to-book accounting rules.
  • FA_LOOKUPS — Resolves lookup code values used during processing.
  • FA_SYSTEM_CONTROLS — Provides system-level Fixed Assets settings.
  • FA_TRANSACTION_HEADERS — Used to associate the generated transactions with a transaction header.
  • PLITBLM — The standard Oracle Applications table-attribute string handling facility.

Usage Notes

FARX_RR is not intended for direct invocation. In standard use it is called exclusively from the Mass Reclass Review concurrent program through the FARX_C_RR wrapper. The program is submitted when a user has defined a mass reclassification and wishes to preview the resulting transactions before they are posted to the asset books; the review output populates FA_MASS_RECLASS_ITF, from which the conditional review report is generated.

The X_RX_Flag parameter allows the same procedure to serve both the standard processing path and the RX report path, distinguishing report-driven invocations from other callers. The package is referenced by one other package in the documented metadata, consistent with its role as a subordinate worker invoked by the concurrent wrapper rather than a top-level entry point.

Because the package is classified as OTHER and is not published as a supported API, customizations should not call REVIEW_RECLASS directly. Any integration should instead invoke the supported concurrent program, since Oracle may change the internal signature, behavior, or existence of this package without notice in future 12.1.1 or 12.2.2 patches.