Search Results qrm_fx_formulas




Overview
Explore in AI Chat

Overview

QRM_FX_FORMULAS is a PL/SQL package owned by the APPS schema that provides the core foreign exchange (FX) valuation and risk-sensitivity calculation routines used within the Oracle E-Business Suite Treasury (ETRM) module. Its role is to compute fair value and Greek-style sensitivities — delta, rho, and related measures — for FX instruments such as forwards, options, and foreign exchange combinations. The package is classified as OTHER under the ETRM API taxonomy, indicating that it functions as an internal computational engine rather than a public, versioned API. It is a dependency of higher-level calculation drivers, notably QRM_CALCULATORS_P and QRM_PA_CALCULATION_P, which orchestrate portfolio-level valuation and profit-and-loss attribution.

Key Procedures and Functions

The documented public surface of QRM_FX_FORMULAS contains seven procedures and functions:

  • FV_FX — Computes the fair value of an FX instrument or position, forming the base valuation output consumed by downstream reporting and accounting.
  • FV_FXO — Computes the fair value of an FX option, applying option-pricing logic to the instrument's terms and market data.
  • FX_FORWARD_DELTA_SPOT — Returns the forward contract's delta measured against the spot rate, quantifying sensitivity of the forward's value to movements in the underlying spot exchange rate.
  • FX_FORWARD_RHO — Returns the rho sensitivity of an FX forward, measuring the change in value with respect to shifts in interest rates.
  • FX_GK_OPTION_SENS — Derives option sensitivities using the Garman-Kohlhagen framework, the standard model for valuing European currency options.
  • FX_GK_OPTION_SENS_CV — A variant of the Garman-Kohlhagen sensitivity routine, typically oriented toward a specific calculation or valuation context (the CV suffix).
  • GET_BASE_CONTRA — Retrieves the base or contra currency amount associated with a transaction, supporting currency-leg identification in cross-currency calculations.

No parameter signatures are asserted here; the above reflects documented naming and purpose only.

Tables Accessed

The package references two documented tables via APPS synonyms:

  • XTR_BUY_SELL_COMBINATIONS — Stores buy/sell combination definitions used to resolve currency-leg direction (buy versus sell) when computing net FX exposure and valuation.
  • PLITBLM — A standard Oracle Applications numeric/date table used as a scratch or pl/sql table structure during computation.

Additional dependencies include FND_LOG for logging and XTR_MD_NUM_TABLE for numeric market-data handling. These support diagnostic logging and market-data retrieval respectively.

Usage Notes

QRM_FX_FORMULAS is not intended for direct invocation by end users. It is called programmatically by QRM_CALCULATORS_P and QRM_PA_CALCULATION_P during FX valuation and P&L attribution processing, which may run from Treasury forms, concurrent programs, or scheduled calculation batches. Because it depends on FND_LOG, execution generates standard EBS debug log entries useful for troubleshooting. Customizations should avoid modifying the package directly; extending behavior is better achieved through supported calculator configuration. Any dependency changes in 12.1.1 versus 12.2.2 should be validated against the specific patch level, as the ETRM market-data and calculator stacks were refined across those releases.