Search Results fv_value_of_fund_periods




Overview
Explore in AI Chat

Overview

The FV_VALUE_OF_FUND_PERIODS table resides in the FV (Federal Financials) schema and stores Current Value of Funds (CVF) rates information used by U.S. federal agencies operating within Oracle E-Business Suite 12.1.1 and 12.2.2. The CVF rate is published periodically by the U.S. Department of the Treasury and represents the rate used to compute interest on delinquent federal debt, refunds, and certain receivables under the Debt Collection Improvement Act. Within EBS, this table provides the date-effective rate values that Federal Financials applications consult when calculating interest for overdue customer invoices or reimbursements.

Each row anchors a rate value to a specific ledger (set of books) and an effective date range, allowing the system to derive the correct rate for any given transaction date. From a Data Vault modeling perspective, the metadata's FK composition suggests a satellite-leaning classification: the table holds descriptive, date-effective attributes (the rate percentage and its validity window) attached to a parent ledger key. This is a heuristic suggestion only; the table also exhibits link-like characteristics through its association with GL_SETS_OF_BOOKS_11I.

Key Information Stored

The table is documented with 10 physical columns. The most significant are summarized below.

  • VALUE_OF_FUND_PERIODS_ID — The surrogate primary key, defined by constraint FV_VALUE_OF_FUND_PERIODS_PK. A unique index, FV_VALUE_OF_FUND_PERIODS_U1, also exists on this same column, making it the sole documented business-key candidate. In practice the surrogate key is system-generated and carries no business meaning.
  • CURR_VALUE_OF_FUNDS_PERCENT — The actual Current Value of Funds rate expressed as a percentage. This is the core business attribute used in interest computation and is the column most frequently queried for reporting.
  • EFFECTIVE_START_DATE and EFFECTIVE_END_DATE — Define the date-effective window during which the associated rate applies. Together they enable temporal lookups so the correct rate is selected for a given accounting or transaction date.
  • SET_OF_BOOKS_ID — The foreign key to GL_SETS_OF_BOOKS_11I, tying each rate record to a specific ledger. This supports multi-ledger deployments where rate applicability may vary by set of books.
  • Audit columns — CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, and LAST_UPDATE_LOGIN provide standard EBS who/when auditing and are populated automatically by the application tier.

Common Use Cases and Queries

Typical scenarios include verifying the rate in force on a specific date, reconciling interest calculations on delinquent receivables, and auditing historical rate changes per ledger. A representative query selecting the active rate for a ledger and date is:

  • SELECT curr_value_of_funds_percent FROM fv.fv_value_of_fund_periods WHERE set_of_books_id = :p_sob AND :p_txn_date BETWEEN effective_start_date AND effective_end_date;
  • Reporting all rate history for a ledger ordered by effective_start_date to trace CVF revisions over time.
  • Joining to GL_SETS_OF_BOOKS_11I to present the ledger name alongside the percentage for cross-ledger comparison.
  • Identifying gaps or overlaps in effective date ranges as a data-quality control before period-close interest processing.

Related Objects

The documented foreign key relationship and surrounding Federal Financials objects define the principal dependencies:

  • GL_SETS_OF_BOOKS_11I — Referenced via FV_VALUE_OF_FUND_PERIODS.SET_OF_BOOKS_ID; the parent ledger definition.
  • FV_VALUE_OF_FUND_PERIODS_PK — The primary key constraint on VALUE_OF_FUND_PERIODS_ID.
  • FV_VALUE_OF_FUND_PERIODS_U1 — Unique index reinforcing the surrogate key.
  • Federal Financials interest and receivables processing logic that consumes CURR_VALUE_OF_FUNDS_PERCENT when computing delinquent debt interest.
  • General Ledger period and calendar objects consulted to align effective date ranges with accounting periods.