Search Results out_of_balanceformula

Overview

APPS.FA_FASCASR_XMLP_PKG is the PL/SQL package generated to support the Oracle E-Business Suite Fixed Assets concurrent report known as the Asset Additions / Asset Retirements report (FASCASR). Its name follows the standard Oracle Reports XML Publisher wrapper convention: a report-specific package that holds the report parameters, maintains the SQL and formula bindings used by the report definition, and executes the logic executed at report start and completion. The package body-less specification shown here exposes the report parameter state and the function interfaces consumed by the Oracle Reports engine during execution of the XML Publisher output.

The package serves as the glue between the concurrent program definition and the underlying Fixed Assets data model. It resolves the reporting book, accounting period range, currency and accounting flexfield structure, and calculates derived values such as out-of-balance adjustments presented in the report output. Because it is a report generator package rather than a business API, it is not consumed by other application packages; the ETRM metadata confirms it is referenced by zero other packages.

Key Procedures and Functions

• BookFormula — returns the value for the Book report parameter, validating and formatting the book identifier for the concurrent run.
• Period1Formula and Period2Formula — return the formatted accounting period values for the two report period parameters (start and end).
• Report_NameFormula — returns the display name used in the report header.
• BeforeReport — executed before the report query runs; initializes package state such as accounting flexfield structure, currency code, period start/end dates and precision.
• AfterReport — executes at report completion to finalize report state.
• out_of_balanceformula — computes whether the asset and invoice adjustments for a given row sum to an out-of-balance condition. This is the function most relevant to the user's search term. It accepts asset adjustment, invoice adjustment, and an IS_INV_TRANS flag and returns the formatted value displayed in the report.
• Accounting_Flex_Structure_p — returns the accounting flexfield structure identifier used for the report's account display.
• Currency_Code_p — returns the reporting currency code.
• Period1_POD_p and Period2_PCD_p — return the period opening date and period close date used to define the accounting period bounds.
• PRECISION_p — returns the currency precision applied to amounts.
• RP_REPORT_NAME_p — returns the report name used at runtime.

Tables Accessed

The package reads FA_BOOK_CONTROLS to resolve book attributes such as the associated accounting flexfield and currency; FA_DEPRN_PERIODS to determine period opening and closing dates; FND_CURRENCIES to obtain currency precision and formatting details; and FND_CONCURRENT_REQUESTS to correlate execution with the concurrent request record and retrieve the request identifier used to populate P_CONC_REQUEST_ID. These queries either populate the package variables or drive the before-report initialization.

Usage Notes

FA_FASCASR_XMLP_PKG is invoked automatically by the Oracle Reports runtime when the FASCASR concurrent program or its equivalent report is submitted from the Fixed Assets responsibility. It is not intended to be called directly from custom forms or PL/SQL. Differences between EBS 12.1.1 and 12.2.2 relate primarily to the Online Patching editioning framework and the shared XML Publisher location; the package content, parameter interface and the out_of_balanceformula function remain consistent across both releases. Developers diagnosing out-of-balance amounts in FASCASR output should review this function together with the Fixed Assets accounting equations for asset and invoice adjustments.