Search Results get_mau

Overview

EDW_CURRENCY is an Oracle E-Business Suite PL/SQL package owned by the APPS schema and classified under the ETRM "OTHER" API category. Its defined purpose is to support currency conversion within the Enterprise Data Warehouse (EDW) architecture, specifically for translating transaction and base amounts into the global warehouse currency. This is a warehouse-level concern rather than an operational subledger or General Ledger concern: distributed source systems record transactions in their own functional and transactional currencies, and the EDW must consolidate them into a single reporting currency. EDW_CURRENCY provides the conversion primitives that make that consolidation possible, using the exchange rate type configured in the global warehouse administration setup when the caller does not explicitly supply one. The header comment ($Header: FIICACRS.pls 120.1 2002/10/22) indicates the package originated in the Financial Intelligence/EDW product family and has remained stable across releases. ETRM documents four procedures and functions in total and records that the package is referenced by 62 other packages, confirming that it acts as a shared low-level utility for the EDW currency layer rather than as an entry point invoked directly by end users.

Key Procedures and Functions

• CONVERT_GLOBAL_AMOUNT — Converts a given transaction amount to its equivalent value in the global warehouse currency. The function is designed to skip conversion when either the base currency or the transaction currency already matches the global warehouse currency. Callers are not required to supply base amounts or base currency codes, but doing so allows the function to avoid redundant conversions and improve performance. If an exchange rate type is omitted, the API applies the global rate type configured in global warehouse administration. The function signals failure through return values: -1 when no rate is available, and -2 when the input currency is invalid. It also raises an exception when global warehouse parameters, such as the global currency, have not been set up, or when an SQL error occurs during execution.
• GET_RATE — Retrieves the exchange rate used for warehouse currency conversion. It supports the rate lookup requirements of the conversion routines and the wider EDW currency layer, providing the rate applicable for a given currency pair, exchange date, and rate type.
• GET_MAU — The object sought by the "get_mau" search. It is a documented function of this package and forms part of its currency-related utility surface. Since it is invoked in the currency conversion context, it is consumed by the same EDW packages that perform global amount translation.
• CONVERT_GLOBAL_AMOUNT (second documented entry) — ETRM records CONVERT_GLOBAL_AMOUNT twice among the four documented routines; the second entry corresponds to its specification header before the source excerpt is truncated. No additional procedure name is documented beyond the truncated text.

Tables Accessed

• EDW_LOCAL_SYSTEM_PARAMETERS — Accessed to read the global warehouse setup, most importantly the global currency and the global exchange rate type. These values determine whether a conversion is required at all and which rate type is applied by default when the caller does not pass one.
• GL_CURRENCIES — Accessed to validate currency codes and obtain currency attributes needed for conversion. Invalid currency input is the condition that drives the -2 return code.

Usage Notes

EDW_CURRENCY is a server-side utility package intended for programmatic invocation rather than direct end-user execution. The absence of a form-bound interface and the presence of a RESTRICT_REFERENCES pragma (WNDS, WNPS, RNPS) on the conversion function indicate that it is safe to call from SQL and from other PL/SQL units, including those executed inside concurrent programs. Typical invocation patterns include EDW extraction, transformation, and load routines; warehouse summary and reporting generation programs; and custom code that must express amounts in the global warehouse currency. The package is normally called after global warehouse parameters have been configured, since missing setup causes an exception. Because 62 other packages reference it, changes to its behavior have a wide blast radius, and callers should handle the -1 and -2 return codes explicitly rather than assuming successful conversion. The identical source header across 12.1.1 and 12.2.2 confirms consistent behavior in both releases.