Search Results cf_begin_balanceformula

Overview

APPS.JG_JGZZFAAD_XMLP_PKG is the generated PL/SQL package that backs the Oracle EBS Fixed Assets report identified internally as JGZZFAAD. The suffix _XMLP_PKG indicates that the report is rendered through the XML Publisher (BI Publisher) engine, with this package supplying the data model, formulas, and formatting logic consumed by the report template. The report belongs to the Global Accounting / statutory reporting family (the JG prefix denotes the global accounting and statutory ledger modules), and its purpose is to produce a fixed asset activity and balance report for a given ledger, book, and accounting period range.

The package defines the report parameters, global report variables, and a large set of column formulas that transform raw query results into the presentation values required by the report layout. A $Header entry dated 2007 confirms its lineage as a standard Oracle-delivered object; it is classified in ETRM with the API classification OTHER, meaning it is not a supported public API and is intended solely as an internal report implementation unit.

Key Procedures and Functions

The package exposes thirty documented procedures and functions. The core entry points are AFTERREPORT, which performs post-report housekeeping, and DISP_OBJECT, which governs conditional display of report elements.

The remaining documented members are column-level formula functions. They fall into two groups. The first group operates on a single period's activity figures and typically accepts a running total parameter and an activity amount: CF_ADDITIONS_CFFORMULA, CF_BEGIN_BALANCEFORMULA, CF_END_BALANCE_CFFORMULA, CF_RETIREMENTS_CFFORMULA, CF_REVALUATIONS_CFFORMULA, CF_RECLASSES_CFFORMULA, CF_ADJUSTMENTS_CFFORMULA, and CF_COST_BEGIN_BALANCE_CFFORMUL. The second group mirrors these calculations for report-level or cost-basis totals: CF_COST_BEGIN_BALANCE_REPTOTFO, CF_BEGIN_BALANCE_REPTOTFORMULA, CF_ADDITIONS_REPTOTFORMULA, CF_ADJUSTMENTS_REPTOTFORMULA, CF_RECLASES_REPTOTFORMULA, CF_RETIREMENTS_REPTOTFORMULA, CF_REVALUATIONS_REPTOTFORMULA, and CF_END_BALANCE_REPTOTFORMULA.

Two additional functions support account hierarchy display: CF_PAREANT_ACCT_DESCRFORMULA derives the descriptive text for a parent account, and CF_PAGE_PARENT_ACCT_DESCRFORMU performs the equivalent derivation at page or section level.

The function CF_END_BALANCE_CFFORMULA, referenced in the user's search, computes the closing balance line of the asset roll-forward by combining the incoming begin balance with additions, revaluations, reclasses, and adjustments, and by deducting retirements and transfers, subject to the report's precision setting.

Tables Accessed

The package accesses three tables through APPS synonyms. FA_BOOK_CONTROLS supplies the depreciation book definition, including the book type code and ledger association referenced by parameters such as P_BOOK_TYPE_CODE and RP_SOB_ID. FA_SYSTEM_CONTROLS provides installation-level Fixed Assets setup values that govern report defaults and precision behavior. FND_CURRENCIES supplies currency descriptions and, in conjunction with CP_DATE_FORMAT, supports the formatting of monetary and date values in the report output.

Usage Notes

This package is not intended to be called directly from custom code and is not referenced by any other documented package. It is invoked automatically by the XML Publisher concurrent program that runs the JGZZFAAD report. When the concurrent request executes, Oracle XML Publisher binds the report parameters, calls the package to generate the XML data, applies the template, and then invokes AFTERREPORT. Any customization should be performed at the report template or parameter level rather than by modifying this generated package, since patches and upgrades to Oracle EBS 12.1.1 or 12.2.2 may re-generate or replace its body. Values such as P_PRECISION and P_PRECISION_WIDTH influence rounding in the balance formulas, so changes to report precision requirements should be handled through the report parameters.