Search Results cip_balances_rpt




Overview
Explore in AI Chat

Overview

FARX_BL is a private PL/SQL package in the Oracle E-Business Suite Fixed Assets module, owned by the APPS schema and classified as an "OTHER" API in ETRM 12.2.2. Its name denotes "Fixed Assets Reports – Balances," and its sole business purpose is to generate the standard Fixed Assets balance reports — the asset cost, accumulated depreciation, capital-in-progress (CIP), and revaluation reserve balances reports. These reports present the opening balance, period activity, and closing balance of asset cost and depreciation for a given book and accounting period range, and are central to the period-close and reconciliation process performed by fixed asset accountants.

The package is declared with AUTHID CURRENT_USER, meaning that referenced objects are resolved in the calling user's schema, consistent with the APPS synonym convention used throughout Oracle EBS. It is a private implementation package; the public concurrent program wrappers reside elsewhere, and FARX_BL is referenced by three other packages within the Fixed Assets codebase.

Key Procedures and Functions

Five procedures are documented for FARX_BL:

  • BALANCES_REPORTS — The core, intended-as-private driver procedure. It accepts a book, start and end period names, a report type, an adjustment mode, an optional MRC set of books identifier, a report style (default 'S', with 'D' indicating drill-down), the concurrent request and user identifiers, a calling function name, and returns an output message and success flag. All report-specific procedures ultimately funnel through this routine.
  • CIP_BALANCES_RPT — Concurrent-request wrapper for the CIP (Construction-in-Progress) balances report. It returns the standard retcode and errbuf OUT parameters expected by concurrent program callers.
  • ASSET_COST_BALANCES_RPT — Wrapper for the asset cost balances report, supporting an optional MRC set of books identifier and a report style parameter to enable drill-down output.
  • ACCUM_DEPRN_BALANCES_RPT — Wrapper for the accumulated depreciation balances report, likewise supporting MRC set of books and drill-down style.
  • REVAL_RESERVE_BALANCES_RPT — Wrapper for the revaluation reserve balances report.

The procedural pattern is consistent: thin concurrent wrappers collect the standard EBS request parameters and delegate to the common BALANCES_REPORTS engine.

Tables Accessed

FARX_BL reads and writes a defined set of Fixed Assets tables via APPS synonyms. Asset master and transaction data are drawn from FA_ADDITIONS, FA_ADJUSTMENTS, FA_ASSET_HISTORY, FA_DEPRN_DETAIL, and FA_DISTRIBUTION_HISTORY. Book and period definitions come from FA_BOOKS, FA_BOOK_CONTROLS, FA_CATEGORY_BOOKS, and FA_DEPRN_PERIODS. Lookup values are resolved through FA_LOOKUPS. For multiple reporting currency (MRC) support, FA_MC_ADJUSTMENTS, FA_MC_BOOKS, and FA_MC_BOOK_CONTROLS are referenced. The two global temporary / interface tables, FA_BALANCES_REPORT_GT and FA_BALANCES_REP_ITF, hold the intermediate and final report rows produced by the balance calculations.

Usage Notes

FARX_BL is not a public API and should not be called directly by customer extensions. It is invoked internally by Oracle's Fixed Assets concurrent program wrappers to produce the balances reports submitted from the Fixed Assets responsibility or the Standard Request Submission (SRS) window. Custom code requiring equivalent balance data should call the supported public report APIs rather than FARX_BL, since the package is private and subject to change without notice. Administrators encountering the package name during debugging of balance-report concurrent requests should treat it as an internal reporting engine linking the documented FA tables to the balances report interface tables.