Search Results fv_treasury_check_ranges




Overview
Explore in AI Chat

Overview

The FV_TREASURY_CHECK_RANGES table is a Federal Financials (FV) module object within Oracle E-Business Suite Releases 12.1.1 and 12.2.2. It stores the individual check ranges that belong to a treasury confirmation payment batch. Each treasury confirmation record maintained in FV_TREASURY_CONFIRMATIONS_ALL can be associated with one or more contiguous check-number ranges, and this table persists those ranges so that the confirmation process can reconcile issued payment instruments against the ranges authorized or reported by the treasury. The table resides in the FV schema and is documented as VALID in the ETRM repository.

Under the heuristic Data Vault classification derived from its foreign key structure, FV_TREASURY_CHECK_RANGES is modeled as a standalone object. As a modeling suggestion, this implies the table is neither a pure hub nor a classic link, because it carries its own descriptive attributes (range boundaries) in addition to a foreign key to its parent. Operationally it behaves as a detail or satellite-style child of FV_TREASURY_CONFIRMATIONS_ALL, but the mined classification records it as standalone, so implementers should treat the label as a starting heuristic rather than a rigid rule.

Key Information Stored

The documented physical schema contains nine columns. The most important are summarized below.

  • TREASURY_CONFIRMATION_ID — Foreign key to FV_TREASURY_CONFIRMATIONS_ALL. Identifies the parent treasury confirmation payment batch to which the range belongs.
  • RANGE_SEQUENCE — Ordinal number that distinguishes multiple ranges defined within the same treasury confirmation, preserving the order in which ranges are presented or processed.
  • RANGE_FROM — The starting check number of the range (low boundary).
  • RANGE_TO — The ending check number of the range (high boundary).
  • CREATION_DATE, CREATED_BY — Standard audit columns recording when and by whom the range row was inserted.
  • LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN — Standard audit columns capturing the most recent modification to the row and the login context of the updater.

The unique index FV_TREASURY_CHECK_RANGES_U1 is defined on (TREASURY_CONFIRMATION_ID, RANGE_SEQUENCE), making this composite pair the business-key candidate that guarantees one sequence value per confirmation. No separate single-column surrogate primary key is documented in the ETRM metadata; the concatenated unique index serves that identifying role.

Common Use Cases and Queries

Typical usage centers on reporting and reconciliation of check numbers by confirmation batch. A common query returns all ranges for a given confirmation in sequence order:

  • SELECT range_sequence, range_from, range_to FROM fv.fv_treasury_check_ranges WHERE treasury_confirmation_id = :conf_id ORDER BY range_sequence;
  • Reconciliation reports that compare the count of checks issued in the payment process against the span (RANGE_TO − RANGE_FROM + 1) covered by the confirmation.
  • Audit extracts listing every check-number range assigned to treasury confirmations over a period, joined to FV_TREASURY_CONFIRMATIONS_ALL for batch-level attributes.
  • Validation scripts that detect overlapping or out-of-sequence ranges within a single confirmation by ordering on RANGE_SEQUENCE and comparing adjacent RANGE_FROM/RANGE_TO values.

Related Objects

  • FV_TREASURY_CONFIRMATIONS_ALL — Parent table; joined on FV_TREASURY_CHECK_RANGES.TREASURY_CONFIRMATION_ID = FV_TREASURY_CONFIRMATIONS_ALL.TREASURY_CONFIRMATION_ID.
  • FV_TREASURY_CHECK_RANGES_U1 — Unique index enforcing the (TREASURY_CONFIRMATION_ID, RANGE_SEQUENCE) business key.
  • FV payment and confirmation concurrent programs — Treasury confirmation processes that read these ranges when building or validating payment batches.
  • Federal Financials payment reconciliation reports — Reporting components that consume range data for check-number reconciliation.

Because the relationship data identifies only one documented foreign key, FV_TREASURY_CONFIRMATIONS_ALL is the single authoritative parent object; other dependencies are functional rather than referential.