Search Results ar_obalrev_pkg




Overview
Explore in AI Chat

Overview

AR_OBALREV_PKG is a PL/SQL package owned by APPS in the Oracle E-Business Suite Receivables module. Its documented purpose is to generate the AR Open Balance Revaluation Report for Slovakia, a statutory reporting requirement that restates open customer balances into a reporting currency using defined exchange rates. The package specification is created from script AROBRRPB.pls, with a header version of 120.8 last modified on 27-DEC-2007. The original creation is attributed to Mallikarjun Gupta on 11-MAR-2007, and version 1.1 by Ravi Kiran G on 24-DEC-2007 added logic to pick up credit memo (CM) details. The package is classified as OTHER rather than as a public Oracle API, indicating it is intended principally for internal use by the report's data template rather than for general customer invocation.

Key Procedures and Functions

The package exposes four documented procedures and functions. Their naming and the header comments indicate the following roles:

  • BEFOREREPORT — A public function that initializes global variables used to build the report queries in the Data Template dynamically. The source excerpt shows it validating and populating global values such as the customer name (gc_customer_name) from HZ_PARTIES when a customer parameter is supplied, and it references an exception for an invalid exchange rate type.
  • GET_RATE — A function that returns an exchange rate. The header documentation describes an exch_rate_calc function taking the as-of date, exchange rate type, functional currency and currency as parameters; GET_RATE corresponds to this rate-derivation logic used by the revaluation calculation.
  • AMTDUEFILTER — A function returning a Boolean value, used to dynamically filter the data fetched by the Data Template, typically to restrict rows to those amounts that are due under the report's criteria.
  • TEST — A diagnostic or validation routine, consistent with the convention of providing a standalone test entry point within report-supporting packages.

The user search term gc_currency_where corresponds to a global variable in this family: package-level globals prefixed with gc_ hold dynamically assembled query fragments (here, a currency predicate) populated by BEFEREPORT and consumed by the Data Template. Parameter lists are not enumerated in the documented metadata and are therefore not restated here.

Tables Accessed

The package accesses the following tables through APPS synonyms:

  • HZ_PARTIES and HZ_CUST_ACCOUNTS — used to resolve customer and party names, as illustrated by the BEFOREREPORT logic that selects hp.party_name.
  • GL_DAILY_CONVERSION_TYPES — supplies the valid exchange rate types used by the rate calculation.
  • GL_LEDGERS — provides ledger context, including functional currency, for the revaluation.
  • GL_ACCESS_SET_NORM_ASSIGN — supports determination of the ledger or access set applicable to the reporting run.

Usage Notes

Because the object is registered as a package body supporting the Slovak Open Balance Revaluation Report, it is invoked through that report's concurrent program and its Oracle Reports or BI Publisher data template rather than directly by end users. BEFOREREPORT executes before the query is issued to seed globals, GET_RATE and AMTDUEFILTER are called from within the template's query or formula columns, and TEST serves development and validation purposes. No other packages are documented as referencing it, so dependencies flow outward only. Customizations should avoid modifying the packaged globals and instead use supported report parameters; site-specific extensions should be applied at the template level. The package depends on no other packaged APIs, but it does assume valid Receivables and General Ledger setup for conversion types, ledgers and access sets.