Search Results oki_daily_rates




Overview
Explore in AI Chat

Overview

OKI_DAILY_RATES is a table belonging to the OKI – Contracts Intelligence module, an obsolete Oracle E-Business Suite product. Its documented purpose is to hold information about the conversion rates to be used when converting currencies within Contracts Intelligence. In practical terms, the table functions as a currency conversion reference store, mapping a source currency to a target currency on a given conversion date with an associated rate value.

The ETRM metadata indicates that OKI_DAILY_RATES is not implemented in the current database, meaning the object exists in the documented schema of Oracle EBS 12.1.1 but is not physically present or active in the environment surveyed. The documented owner is OKI, and the documented physical schema consists of five columns.

From a Data Vault modeling perspective, the supplied metadata classifies OKI_DAILY_RATES heuristically as standalone. This classification is drawn from foreign-key structure analysis, where the only outgoing relationship is to FND_SECURITY_GROUPS rather than to other OKI business entities. As a modeling suggestion, this object is best treated as an independent reference or lookup table — loosely resembling a satellite of a shared reference hub — rather than as a transactional hub or link within a Data Vault or similar analytical model. Because it does not participate in relationships with other OKI business tables via foreign keys, it should generally be modeled as a standalone dimension-like reference keyed by currency pair and date.

Key Information Stored

The documented schema contains five columns. The most important ones are described below.

  • FROM_CURRENCY – The source currency code being converted from. This is a business-key candidate, as one side of the currency pair.
  • TO_CURRENCY – The target currency code being converted to. Together with FROM_CURRENCY, it forms the currency-pair business key.
  • CONVERSION_RATE – The multiplier used to translate an amount from FROM_CURRENCY into TO_CURRENCY. This is the core fact value of the table.
  • CONVERSION_DATE – The effective date on which the rate applies. This is essential in daily-rate tables because a currency pair typically has a set of time-varying rates. In combination with the currency pair, it defines the effective-dated business key.
  • SECURITY_GROUP_ID – The security grouping used to partition records for access control. This is documented as a foreign key to FND_SECURITY_GROUPS.

The metadata does not document an explicit surrogate primary key, so no distinct single-column primary key is asserted here. Where surrogate keys are used elsewhere, the underlying pattern is typically a system-generated identifier; in this table the business-key candidates are the combination of FROM_CURRENCY, TO_CURRENCY, and CONVERSION_DATE. SECURITY_GROUP_ID serves as the partitioning and security key.

The documented foreign-key relationship is OKI_DAILY_RATES.SECURITY_GROUP_ID → FND_SECURITY_GROUPS.

Common Use Cases and Queries

Because the table provides date-effective, currency-pair conversion factors, it is used whenever OKI must convert monetary amounts across currencies. Typical scenarios include converting contract values, pricing amounts, or reported totals from a transaction currency into a reporting or functional currency.

A representative query retrieves the rate for a given pair and date:

  • SELECT conversion_rate FROM oki_daily_rates WHERE from_currency = :from_ccy AND to_currency = :to_ccy AND conversion_date = :as_of_date;

For reporting, a common pattern is to join the rate table to a contracts or transactions dataset to convert amounts:

  • SELECT t.contract_id, t.amount * r.conversion_rate AS converted_amount FROM oki_transactions t, oki_daily_rates r WHERE t.from_currency = r.from_currency AND t.to_currency = r.to_currency AND t.transaction_date = r.conversion_date;

Security-filtered access adds a predicate on SECURITY_GROUP_ID, and effective-dated lookups often use a greatest-effective-date subquery to select the most recent rate on or before a transaction date.

Related Objects

  • FND_SECURITY_GROUPS – Referenced by OKI_DAILY_RATES.SECURITY_GROUP_ID. This is the documented foreign-key target and governs row-level security partitioning.
  • OKI_CONTRACTS / OKI contract transaction tables – Consume conversion rates for monetary conversion; joined on FROM_CURRENCY, TO_CURRENCY, and CONVERSION_DATE.
  • OKI currency and reference tables – Provide the FROM_CURRENCY and TO_CURRENCY code lists that populate the currency-pair key.

Because the metadata documents only a single foreign-key relationship, the list above represents the significant documented and inferred touchpoints rather than an exhaustive dependency map. Given that the object is obsolete and not implemented, downstream references should be validated against the actual 12.1.1 or 12.2.2 schema before use.