Search Results gl_daily_rates_api

Overview

The APPS.GL_DAILY_RATES_API package is a public Oracle E-Business Suite API that supports the management of daily currency conversion rates within Oracle General Ledger. In a multi-currency environment, General Ledger requires a maintained set of daily rates to translate foreign currency transactions into the ledger's functional currency. This package encapsulates the logic that drives the batch processing of daily rate data, exposing a controlled programmatic entry point for triggering the concurrent process responsible for loading or maintaining those rates. It is declared with AUTHID CURRENT_USER, meaning it executes with the privileges of the calling user rather than the definer, and it is owned by the APPS schema. In the ETRM 12.1.1 and 12.2.2 metadata, this package is classified as an API and is documented as exposing a single callable function.

Key Procedures and Functions

The documented interface of this package consists of one function:

• SUBMIT_CONC_REQUEST — A function that submits a concurrent request. It returns a NUMBER, conventionally the concurrent request identifier assigned by the concurrent manager when the job is enqueued. Its purpose is to provide a programmatic mechanism for launching the daily rates concurrent program rather than requiring a user to navigate the Submit Request form.

The package also declares a package-level Boolean variable, run_conc_req_flag, initialized to TRUE, which governs whether the underlying concurrent request is actually submitted. No additional documented procedures or functions are included in the metadata; parameter lists are not published and therefore should not be assumed.

Tables Accessed

The ETRM metadata for this package records no directly referenced tables via APPS synonyms. This is consistent with the function's role as a submission wrapper: the actual table access for daily rate maintenance occurs inside the concurrent program that SUBMIT_CONC_REQUEST launches, not within the API itself. The daily rate concurrent process operates against the GL daily rates schema objects on behalf of the submitted request. Because no base tables are documented here, implementers should treat this package as an orchestration layer rather than a data-manipulation API.

Usage Notes

This package is typically invoked from custom PL/SQL, client extensions, or wrapper routines that need to programmatically schedule the daily rates concurrent program. The returned request ID can be captured for later status polling through the standard concurrent request monitoring APIs. Because the package runs under AUTHID CURRENT_USER, the calling session must hold sufficient privileges to submit the target concurrent request. The run_conc_req_flag variable allows caller or session logic to suppress actual submission when set to FALSE, which is useful for validation or dry-run scenarios. ETRM records show the package is referenced by zero other packages, indicating it is a terminal utility rather than a dependency of the broader GL codebase. Given the limited documented interface, customizations should call only the published SUBMIT_CONC_REQUEST function and avoid reliance on undocumented internals. Always confirm the target concurrent program and its parameters in the specific EBS release, since behavior can differ between 12.1.1 and 12.2.2.