Search Results invalid_user_rate




Overview
Explore in AI Chat

Overview

CS_CHMC_PKG is a currency conversion utility package in the Oracle E-Business Suite 12.1.1 and 12.2.2 environments, owned by the APPS schema and classified under the OTHER API classification. Its primary purpose is to convert monetary amounts between an input (from) currency and the functional currency of the current ledger, using Oracle General Ledger's currency conversion engine. The package abstracts the complexity of exchange-rate resolution and date-based rate selection, exposing a single callable procedure for multi-currency amount translation. The package name and profile references (CS_MC_CONVERSION_TYPE) indicate that it belongs to the Customer Service / Service (CS) product family and supports multi-currency (MC) processing within that module.

Key Procedures and Functions

The ETRM metadata documents a single procedure within this package.

  • CONVERT_AMOUNT — The conversion workhorse. It accepts a source currency, an amount, a conversion date, a conversion type, and an optional user rate, and returns the converted amount through an OUT parameter. Internally it determines the current set of books from the GL_SET_OF_BKS_ID profile option and reads the corresponding functional currency from GL_SETS_OF_BOOKS. When the source currency matches the functional currency, the amount is returned unchanged. If the conversion date is null, SYSDATE is used; if the conversion type is null, the CS_MC_CONVERSION_TYPE profile value is applied. When the conversion type is 'User', a user rate is required. The procedure invokes GL_CURRENCY_API.CONVERT_CLOSEST_AMOUNT_SQL to perform the actual rate lookup and calculation.

Tables Accessed

  • GL_SETS_OF_BOOKS — Read via an APPS synonym to retrieve the functional (ledger) currency code for the set of books identified by the GL_SET_OF_BKS_ID profile option. This value becomes the target currency of the conversion.

The package additionally relies on the GL_CURRENCY_API package to resolve exchange rates rather than querying GL_DAILY_RATES directly, which enforces GL's own validation and rounding rules.

Usage Notes

CS_CHMC_PKG is typically invoked from within Oracle Service or Order Management processing, and in the context of the user keyword "invalid_currency" it is notably relevant because the procedure declares custom exception handlers — including INVALID_CURRENCY, INVALID_USER_CURRENCY_CODE, INVALID_MC_CONVERSION_TYPE, NO_RATE, and INVALID_USER_RATE — that surface as currency-validation errors when the source currency, functional currency, conversion type, or rate is missing or malformed. Because it depends on GL_CURRENCY_API, the package is invoked during date-driven currency translation where the closest active rate must be found, and it is commonly called from PL/SQL customizations, service workflows, and concurrent processing logic rather than from a standalone form. The package is not referenced by other documented packages, so impact analysis is limited to direct callers in CS custom code. Because the source header indicates a 2003 code level updated through 115.3.1158.2, the same logic is carried through both 12.1.1 and 12.2.2, though the GL_SET_OF_BKS_ID profile remains the ledger resolution mechanism.