Search Results mrc_enabled

Overview

APPS.GL_CA_UTILITY_PKG is a general-purpose utility package body in the Oracle General Ledger (GL) module of Oracle E-Business Suite. The "CA" prefix denotes Currency Accounting, and the package provides shared currency-related helper routines used throughout the multi-currency and multiple reporting currency (MRC) architecture of General Ledger. Its principal business function is to abstract commonly needed currency and set-of-books queries — determining the book type of a set of books, detecting whether Multiple Reporting Currencies is enabled, resolving associated reporting sets of books, and retrieving currency conversion rates — so that other GL packages can reuse consistent logic rather than embed such queries directly.

The package is classified as API classification OTHER, indicating that it is an internal utility rather than a public, supported integration API. It is a substantial hub in the GL dependency graph: ETRM documents that it is referenced by 32 other packages, which confirms its role as a low-level shared service consumed by higher-level currency and MRC processing code. The object is VALID in the APPS schema.

Key Procedures and Functions

The ETRM metadata documents four procedures and functions within the package body:

• GET_SOB_TYPE — Returns the type of a given set of books (for example, whether it is a primary or reporting set of books). This is used by callers that must alter behavior depending on the accounting book definition they are processing.
• MRC_ENABLED — Indicates whether Multiple Reporting Currencies is enabled for the environment or for the set of books in question. Callers use this flag to branch between single-currency and MRC-aware processing paths.
• GET_ASSOCIATED_SOBS — Returns the set (or sets) of books associated with a given set of books, typically the reporting books linked to a primary book. This supports processing that must propagate transactions or balances across the MRC book hierarchy.
• GET_RATE — Retrieves a currency conversion rate for the requested currencies and context, centralizing rate lookup so that callers obtain consistent, validated rates rather than querying GL daily rates directly.

Parameter lists are not enumerated in the documented metadata and are therefore not restated here; each routine is described only by its purpose.

Tables Accessed

ETRM documents only two tables referenced through APPS synonyms: DUAL and PLITBLM. DUAL is the standard single-row utility table used for evaluating expressions and returning scalar results without touching application data — consistent with routines such as GET_SOB_TYPE and MRC_ENABLED that return computed flags or type values. PLITBLM is an Oracle Tools internal table used in PL/SQL runtime operations.

The dependency listing additionally shows that GL_CA_UTILITY_PKG references GL_MC_CURRENCY_PKG and GL_MC_INFO, both of which are Multiple Reporting Currencies components. These dependencies reflect the package's role in MRC-aware currency logic, even though the primary data access for such logic is delegated to the GL_MC_* packages rather than performed inline.

Usage Notes

GL_CA_UTILITY_PKG is not designed for direct end-user invocation. It is an internal utility package called by other PL/SQL packages, and the ETRM dependency record notes that it is not referenced by any non-package database object while 32 packages reference it. Typical callers are General Ledger currency conversion, revaluation, translation, and MRC processing routines that need to resolve book type, MRC status, associated sets of books, or a conversion rate before performing their work.

Because it is not a public API, customizations should not call this package directly; supported integration points in GL should be used instead. It is also not exposed through a standalone concurrent program or form. Custom code that does reference it must accept that signatures and behavior are subject to change across patch levels in 12.1.1 and 12.2.2, and any dependency on it should be reviewed after upgrading or applying GL patches.