Search Results rp_out_of_balanceformula

Overview

APPS.FA_FASRSVED_XMLP_PKG is the generated PL/SQL package that backs the Oracle Assets report "FASRSVED" (a scheduled reserve/depreciation detail report, also referred to in the source header as FASRSVEDS). In the Oracle E-Business Suite Release 12.1.1 and 12.2.2 architecture, every Oracle Reports (XML Publisher / .rdf) concurrent program is accompanied by an auto-generated package that contains the report's parameter bindings, formula columns, and Before/After report triggers. This package therefore serves as the programmatic glue between the Oracle Assets depreciation and reserve calculation tables and the formatted report output. It is classified under ETRM as OWNER APPS with an API classification of OTHER, indicating that it is an internal report-support package rather than a published, supported API.

The package exposes the report's concurrent program parameters (such as P_BOOK, P_PERIOD1, P_PERIOD2, P_REPORT_TYPE, P_MIN_PRECISION, P_ADJ_MODE, and the org/ledger context parameters p_ca_org_id, p_ca_set_of_books_id, and p_mrcsobtype) as package-level variables, along with numerous RP_ display variables that supply report headings and labels at runtime. Its core business purpose is to compute and validate depreciation, reserve, and cost balances for a given book and accounting period range, and to flag any condition where the summarized balances do not reconcile.

Key Procedures and Functions

• BEFOREREPORT / AFTERREPORT — Standard report trigger functions executed at the start and end of report execution; they initialize period context, currency code, and book controls.
• REPORT_NAMEFORMULA — Derives the display report name using the company name.
• PERIOD1_PCFORMULA / PERIOD2_PCFormula — Compute period-close related values for the two reporting periods.
• DO_INSERTFORMULA — Governs conditional insertion of rows into the report's global temporary table.
• OUT_OF_BALANCEFORMULA, CTR_OUT_OF_BALANCEFORMULA, ACCT_OUT_OF_BALANCEFORMULA, BAL_OUT_OF_BALANCEFORMULA, RP_OUT_OF_BALANCEFORMULA — The out-of-balance family. Each variant checks whether the components of a balance roll-forward (beginning balance, additions, depreciation, reclassifications, retirements, adjustments, transfers, and ending balance) reconcile at the asset, cost-center, account, balance, or report level. RP_OUT_OF_BALANCEFORMULA is the report-level function that the user searched for; it returns a flag/message indicating whether the summarized ending balance equals the sum of the movement components.
• ADJUSTFORMULA — Computes adjustment amounts for the report column set.
• REVAL_TAX_FLAGFORMULA — Determines the revaluation and tax book flag used to classify asset rows.
• AFTERPFORM — Post-formula trigger applied after the report parameter form is processed.
• ACCT_BAL_APROMPT_P, ACCT_CC_APROMPT_P, CAT_MAJ_RPROMPT_P, PERIOD1_POD_P, PERIOD1_PCD_P, PERIOD1_FY_P — Prompt/derivation helpers that populate periods, fiscal years, and accounting flexfield prompts shown on the report.

The metadata records 36 documented functions in total, all of which are report-scoped helpers rather than reusable business APIs.

Tables Accessed

The package reads exclusively from Oracle Assets base and control tables via APPS synonyms. FA_BOOKS, FA_BOOK_CONTROLS, FA_BOOKS_GROUPS, FA_CATEGORY_BOOKS, and FA_GROUP_ASSET_DEFAULT/RULES supply book and category setup context. FA_DEPRN_PERIODS defines the accounting period calendar, while FA_DEPRN_SUMMARY and FA_DEPRN_DETAIL provide cost, depreciation, and reserve balances for the roll-forward computation. FA_ADJUSTMENTS, FA_ASSET_HISTORY, and FA_DISTRIBUTION_HISTORY supply transaction and assignment movements (additions, reclasses, retirements, transfers). FA_LOOKUPS and FA_LOOKUPS_B resolve descriptive lookup values, and FA_BALANCES_REPORT_GT is the global temporary table into which the report's intermediate balance rows are loaded via DO_INSERTFORMULA. No non-Assets application tables are referenced.

Usage Notes

This package is invoked indirectly whenever the FASRSVED concurrent program is submitted from the Oracle Assets responsibility. It is not intended to be called from custom forms or external PL/SQL. Customizations should be limited to report-level changes or the underlying Oracle Assets data, since the package body is regenerated from the report definition and any direct modification would be overwritten on patching. In R12.1.1 and 12.2.2, differences in the multi-reporting-currency (MRC) and subledger accounting architecture can affect the p_mrcsobtype and p_ca_set_of_books_id initialization, so validation of the out-of-balance functions should always be performed against the specific release and applied patch level.