Search Results treasury_symbol




Overview
Explore in AI Chat

Overview

FV_FUND_PARAMETERS_V is a reporting view owned by the APPS schema in Oracle E-Business Suite, delivered as part of the Treasury (ETRM) product family. It exposes a de-duplicated list of treasury symbols together with the set of books under which they are defined. The view is intentionally narrow: its projection consists of exactly two columns, TREASURY_SYMBOL and SET_OF_BOOKS_ID, derived by applying a DISTINCT operator to the underlying fund parameters table. This design makes the view a canonical lookup source for valid treasury symbols rather than a transactional reporting object.

Because the view is defined with DISTINCT and contains no joins, it is inexpensive to query and suitable for use as a value-set source, an LOV query, or a reference in custom concurrent programs and reports. In an EBS 12.1.1 or 12.2.2 environment, it supports both the multi-org accounting model (by exposing SET_OF_BOOKS_ID) and treasury instrument identification (by exposing TREASURY_SYMBOL).

Underlying Base Objects

The documented metadata identifies a single referenced base object: FV_FUND_PARAMETERS, accessed through a synonym in the APPS schema. The view text is:

SELECT DISTINCT(TREASURY_SYMBOL) TREASURY_SYMBOL, SET_OF_BOOKS_ID FROM FV_FUND_PARAMETERS

FV_FUND_PARAMETERS stores the parameter rows that configure treasury funds and instruments. Each row carries a treasury symbol and an associated set of books identifier. By collapsing those rows with DISTINCT, the view answers a single question: which combinations of treasury symbol and set of books exist. No filtering predicate, hint, or outer join appears in the view text, so the view inherits the base table's data visibility and any row-level security applied through the synonym.

Key Columns

  • TREASURY_SYMBOL — The identifying code for a treasury instrument or fund as configured in ETRM. Because the DISTINCT applies specifically to this column in combination with SET_OF_BOOKS_ID, values recur across sets of books but are unique within each combination.
  • SET_OF_BOOKS_ID — The internal identifier of the accounting set of books (ledger) to which the treasury symbol belongs. This column is the multi-org discriminator and should almost always be constrained in queries to avoid returning data across unrelated ledgers.

No descriptive columns such as names, descriptions, or enable flags are exposed. Consumers requiring those attributes must join back to FV_FUND_PARAMETERS or to related ETRM configuration tables.

Common Use Cases and Queries

The primary use case is populating selection lists and validating treasury symbols before they are entered into transactions or stored in custom staging tables. A typical parameter-driven query is:

SELECT treasury_symbol, set_of_books_id
FROM apps.fv_fund_parameters_v
WHERE set_of_books_id = :p_set_of_books_id
ORDER BY treasury_symbol;

A second common pattern verifies whether a specific symbol is valid for a ledger:

SELECT COUNT(*)
FROM apps.fv_fund_parameters_v
WHERE treasury_symbol = :p_symbol
AND set_of_books_id = :p_set_of_books_id;

The view is also useful as a source for LOV definitions in Oracle Forms personalizations and in Oracle Application Framework value sets, and for reconciliation queries that compare the symbols present in FV_FUND_PARAMETERS_V against those referenced in downstream treasury transactions. Because the view exposes only the symbol and the set of books, any report requiring fund names, maturity dates, or instrument type details must join to FV_FUND_PARAMETERS or the appropriate ETRM instrument tables on TREASURY_SYMBOL and SET_OF_BOOKS_ID. Query analysts should also note that the DISTINCT is computed over both columns, so a symbol assigned to three sets of books produces three rows.