Search Results fra_price




Overview
Explore in AI Chat

Overview

XTR_MM_FORMULAS is the mathematical engine of the Oracle E-Business Suite Treasury (ETRM) module. It supplies the core financial calculation routines used throughout the money-market and derivatives processing flows — discounted securities, forward rate agreements (FRAs), interest rate instruments, and option pricing. The package centralizes the arithmetic that converts rates, day-count conventions, and annual-basis values into monetary amounts and present/future values, so that every Treasury instrument calculator derives consistent results from a single, audited source of logic.

The package body is owned by APPS and is classified as an OTHER API, meaning it is intended primarily as an internal computational library rather than a public business API. It exposes fifteen documented procedures and functions, most of which accept scalar numeric rate, day-count, and basis parameters and return a computed value. Several routines are explicitly marked as internal: the header comments on PRESENT_VALUE_DISCOUNT_RATE carry a warning that the procedure "should never be called directly" and must instead be invoked through XTR_MM_COVERS.PRESENT_VALUE. This design enforces a single sanctioned entry point for present-value logic while still making the underlying formula reusable.

Key Procedures and Functions

  • GROWTH_FACTOR — Computes the value of one unit of currency after a given day count, using an annual rate and an annual basis. It underpins simple-interest accumulation.
  • PRESENT_VALUE_DISCOUNT_RATE — Derives the present value (fair value) of a discounted security from a future (maturity) value, a discount rate, a day count, and an annual basis. Marked internal; call via XTR_MM_COVERS.PRESENT_VALUE.
  • PRESENT_VALUE_YIELD_RATE — The yield-basis counterpart of the above, discounting a future value using a yield rather than a discount rate.
  • FUTURE_VALUE_YIELD_RATE — Computes the maturity/future value from a present value using a yield rate, day count, and annual basis. This is the counterpart to the query term the user searched for.
  • FUTURE_VALUE_DISCOUNT_RATE — Computes the future value from a present value using a discount-rate convention.
  • FRA_PRICE, FRA_PRICE_LONG, FRA_PRICE_DF — Determine the price of a Forward Rate Agreement, including the long-position and discount-factor variants.
  • FRA_SETTLEMENT_AMOUNT_DISCOUNT and FRA_SETTLEMENT_AMOUNT_YIELD — Calculate the settlement amount of a matured or closing FRA under discount-rate and yield-rate conventions respectively.
  • BS_OPTION_PRICE and BLACK_OPTION_PRICE — Implement the Black-Scholes and Black option pricing models for Treasury option instruments.
  • COUPON_CASHFLOW — Computes coupon cash flows on interest-bearing instruments.
  • PRESENT_VALUE_DISCOUNT_FACTOR — Returns the discount factor used in present-value computations from discount-rate inputs.
  • CUMULATIVE_NORM_DISTRIBUTION — Provides the standard normal cumulative distribution function required by the option-pricing routines.

Tables Accessed

The documented metadata for XTR_MM_FORMULAS lists no directly referenced tables. As a pure computational library, the package operates entirely on its IN and IN OUT parameters and returns values to the calling program; it neither reads nor writes base tables. Persistence of Treasury instrument data is handled by the calling packages, such as XTR_MM_COVERS, which pass stored rates and balances into these formula routines.

Usage Notes

XTR_MM_FORMULAS is normally invoked indirectly. The Treasury instrument calculators in ETRM forms (for example, the Discounted Securities Calculator HLD referenced in the source comments) call higher-level packages that in turn delegate the arithmetic to this package. Three other packages are documented as referencing it, confirming it functions as a shared lower layer.

Custom code should treat the public calculation functions — GROWTH_FACTOR, FUTURE_VALUE_YIELD_RATE, FUTURE_VALUE_DISCOUNT_RATE, PRESENT_VALUE_YIELD_RATE, FRA_PRICE, the FRA settlement routines, and the option-pricing functions — as stable computational helpers. Procedures carrying the explicit "should never be called directly" warning must be reached only through the sanctioned XTR_MM_COVERS entry point. No concurrent program is documented for this object, and the source header ($Header: xtrmmflb.pls 120.2, last modified 2005) indicates the logic has been stable across the 12.1.1 and 12.2.2 releases.