Search Results exch_rate_calc

Overview

APPS.AP_OPEN_BAL_REV_RPT_PKG is a PL/SQL package owned by the APPS schema in Oracle E-Business Suite. Its object status is recorded as VALID in the ETRM metadata for release 12.2.2, and the package is also documented for the 12.1.1 code line. The name of the package identifies its purpose: it supports the Open Balance Revaluation report used by Oracle Payables. The package assembles and evaluates the data required to revalue open accounts payable balances for reporting and accounting purposes. Revaluation is required when foreign-currency liabilities remain unsettled at a period end and their functional-currency equivalent must be restated in accordance with the applicable accounting policy. The package is classified as OTHER in the API classification used by ETRM, indicating that it is an internal report support package rather than a formally published open interface or public API. Its dependencies are limited to the SYS.STANDARD package and to APPS synonyms, and the metadata records no other packages that reference it, confirming its role as a leaf-level reporting component invoked directly by a report definition.

Key Procedures and Functions

The ETRM documentation lists five documented units within the package. Their names indicate the following responsibilities:

• BEFOREREPORT — The standard Oracle Reports entry point executed before the report query is processed. It performs the initialization work required by the report, such as establishing runtime context and setting up the values on which subsequent calculations depend.
• EXCH_RATE_CALC — Performs the exchange rate calculation for the revaluation. It resolves the appropriate conversion rate to be applied to open balances denominated in foreign currencies.
• AMTDUEFILTER — Applies filtering logic to the amounts due, restricting the rows selected to those that qualify for inclusion in the report.
• AMTDUEREVAL — Performs the revaluation of the amounts due, converting the selected balances into the reporting currency using the resolved rates.
• VAT_CALC_AMT — Calculates the tax (VAT) component associated with the revalued amounts, so that the report reflects tax-inclusive positions where applicable.

Parameter lists are not reproduced here, as they are not part of the documented metadata.

Tables Accessed

The package accesses two documented tables through APPS synonyms:

• GL_DAILY_RATES — The General Ledger daily rates table, which stores currency conversion rates by from-currency, to-currency, and effective date. The EXCH_RATE_CALC unit reads this table to obtain the revaluation rate applicable to each foreign-currency balance.
• GL_LEDGERS — The General Ledger ledgers definition table. It provides the ledger and currency context in which revaluation is performed, allowing the package to determine the functional currency and the ledger for which the report output is produced.

Both tables are read-only from the perspective of this package; the revaluation output is presented through the report rather than written back to these definitions.

Usage Notes

AP_OPEN_BAL_REV_RPT_PKG is typically invoked through the Oracle Reports executable that implements the Open Balance Revaluation report in Oracle Payables. The BEFOREREPORT unit runs automatically as the report's initialization trigger, while the remaining units are called from the report's data model and formula columns. Because it is an internal support package and is referenced by no other package, it should not be called from custom PL/SQL as a general-purpose utility. Customers and integrators who require revaluation logic in custom code should use supported open interfaces or the standard Payables revaluation programs instead. The package is release-dependent: the same object name exists in 12.1.1 and 12.2.2, but implementations should rely on the version shipped with their specific application release, since report-driven packages are not part of the committed public API surface.