Search Results get_fc_to_sgc_rate




Overview
Explore in AI Chat

Overview

FII_CURRENCY is a currency conversion utility package owned by the APPS schema in Oracle E-Business Suite. Its principal purpose is to support the Global Currency architecture within Oracle Financials, in which an operating ledger maintains amounts not only in its own ledger currency but also in one or more Global Currencies defined in General Ledger. The package abstracts the mechanics of retrieving rates and converting amounts against the primary and secondary Global Currency definitions, shielding callers from the lower-level currency API.

The package is classified as OTHER in the ETRM API registry. It is a dependency of 41 other packages, indicating that it is a foundational utility layer within the Financials Intelligent (FII) product family rather than a user-facing component. The header comment reflects a last build of version 120.7 in 2005, so the interface has been stable across the 12.1.1 and 12.2.2 releases.

Key Procedures and Functions

The twelve documented entry points divide into rate retrieval, amount conversion, and currency validation categories.

  • GET_GLOBAL_RATE_PRIMARY and GET_GLOBAL_RATE_SECONDARY — Return the conversion rate from a supplied source currency and exchange date to the primary or secondary Global Currency respectively. The package delegates to GL_CURRENCY_API.get_closest_rate_sql. Documented return values are -1 when no rate exists and -2 when the supplied currency code is invalid; a SQL error raises an exception.
  • CONVERT_GLOBAL_AMT_PRIMARY and CONVERT_GLOBAL_AMT_SECONDARY — Apply the corresponding Global Currency rate to an incoming amount, yielding the converted amount in the primary or secondary Global Currency.
  • GET_MAU_PRIMARY and GET_MAU_SECONDARY — Return the Monetary Amount Unit (MAU) rounding parameter associated with the primary or secondary Global Currency, used to round converted amounts consistently.
  • GET_RATE — A general-purpose rate retrieval routine used internally and by dependent packages.
  • COMPARE_CURRENCY_CODES — Compares two currency codes, providing a controlled equality test that callers use to short-circuit unnecessary conversion logic.
  • GET_FC_TO_PGC_RATE and GET_FC_TO_SGC_RATE — Return the rate from the functional (ledger) currency to the primary or secondary Global Currency.
  • GET_TC_TO_PGC_RATE and GET_TC_TO_SGC_RATE — Return the rate from a transaction currency to the primary or secondary Global Currency. These are the entry points most frequently referenced when a user searches for a transaction-to-global conversion rate.

Tables Accessed

The package references two objects through APPS synonyms. GL_CURRENCIES is the General Ledger currency definition table, consulted to validate currency codes and obtain currency attributes such as the Monetary Amount Unit used for rounding. PLITBLM is an Oracle Applications internal temporary table used for PL/SQL-side row staging during rate lookups. Rate values themselves are ultimately sourced from the GL daily rates repository via GL_CURRENCY_API, so the package does not maintain its own rate store and performs no DML on the documented tables.

Usage Notes

FII_CURRENCY is not invoked directly from an EBS form or concurrent program. Its 41 dependent packages call it during transaction processing, typically when subledger and financial products must express an amount in a Global Currency in addition to the ledger currency. Custom code should follow the same pattern: call the appropriate GET_*_TO_P*_RATE function for the rate, then apply CONVERT_GLOBAL_AMT_PRIMARY or CONVERT_GLOBAL_AMT_SECONDARY so that rounding honors the Global Currency MAU. Callers must explicitly handle the -1 (rate not found) and -2 (invalid currency) return codes, since these are returned as ordinary numbers rather than raised exceptions. All functions are declared PARALLEL_ENABLE, allowing them to be used safely inside parallel DML and parallel query execution.