Results for “fv_fund_parameters_v”
16 results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
FV_FUND_PARAMETERS_V is a reporting view owned by the APPS schema in Oracle E-Business Suite, delivered as part of the FV – Federal Financials product family. Its documented purpose is to store and expose information about the treasury symbol and fund value per set of books. In practice, the view presents a distinct list of treasury symbols together with the set of books under which each symbol is defined, providing a lightweight, query-friendly projection over the underlying fund parameters data.
Because it is a view rather than a table, FV_FUND_PARAMETERS_V carries no storage of its own; it is a virtual construct whose contents are derived at runtime from its base object. This distinction matters for reporting and integration design. The view is not the system of record for fund parameter maintenance. Instead, it functions as a read-only access point that supports lookups, validation, and reporting where the full parameter record set is not required.
The object holds a VALID status in the ETRM metadata for both Oracle EBS 12.1.1 and 12.2.2, indicating that it is a supported, documented database object in the Federal Financials schema across these releases.
Underlying Base Objects
The documented view metadata identifies a single referenced base object: FV_FUND_PARAMETERS, accessed through a synonym. This is the master table in which treasury symbol and fund parameter information is persisted, including the association between a treasury symbol and a given set of books.
The relationship between the view and the base object is one of projection and de-duplication. The view does not expose every column of FV_FUND_PARAMETERS. Instead, it selects two attributes — TREASURY_SYMBOL and SET_OF_BOOKS_ID — and applies a DISTINCT operation to eliminate duplicate combinations. The result is a concise catalog of the treasury-symbol/set-of-books pairings that exist in the fund parameters table.
Any change to the underlying FV_FUND_PARAMETERS data is reflected immediately in the view upon query, since no materialization occurs. This makes the view appropriate for real-time reference and validation queries, though it also means that query cost is borne by the base table at execution time.
Key Columns
The view exposes two documented columns, both derived directly from the base table:
- TREASURY_SYMBOL — The treasury symbol associated with fund parameter configuration. In Federal Financials, the treasury symbol identifies the appropriation, fund, or receipt account structure used for federal reporting and Treasury reporting processes. It is the primary business attribute surfaced by this view.
- SET_OF_BOOKS_ID — The internal identifier of the set of books (ledger) under which the treasury symbol is defined. This column ties the treasury symbol to a specific accounting configuration, reflecting that the same symbol may be established independently across multiple sets of books.
Because the view returns the distinct combination of these two columns, each row represents a unique treasury-symbol and set-of-books pairing. There is no primary key constraint on a view; uniqueness in the result set is enforced solely by the DISTINCT clause.
Common Use Cases and Queries
The view is most commonly used to enumerate the treasury symbols available within a given set of books, to validate that a symbol is defined before submitting federal transactions, and to drive selection lists in custom reporting or integration logic. A typical query to list all symbols for a specific set of books is:
SELECT treasury_symbol FROM apps.fv_fund_parameters_v WHERE set_of_books_id = :p_sob_id ORDER BY treasury_symbol;
To retrieve the full distinct set of symbol/ledger pairings, a straightforward select suffices:
SELECT treasury_symbol, set_of_books_id FROM apps.fv_fund_parameters_v;
An existence check, useful in validation routines, can be expressed as:
SELECT 1 FROM apps.fv_fund_parameters_v WHERE treasury_symbol = :p_symbol AND set_of_books_id = :p_sob_id;
For cross-ledger analysis or joins to ledger and fund reporting tables, the SET_OF_BOOKS_ID column allows the view to be joined to GL sets of books definitions. Note that, since the view strips away columns other than the two documented attributes, queries requiring full fund parameter detail — such as effective dates or additional fund attributes — must reference the base table FV_FUND_PARAMETERS directly rather than the view.
-
View: FV_FUND_PARAMETERS_V 12.2.2
Stores information about treasury symbol and fund value per set of books
APPS.FV_FUND_PARAMETERS_V·↳ FV_FUND_PARAMETERS·Explore FV module →
-
View: FV_FUND_PARAMETERS_V 12.1.1
Stores information about treasury symbol and fund value per set of books
APPS.FV_FUND_PARAMETERS_V·↳ FV_FUND_PARAMETERS·Explore FV module →
-
12.1.1 FND Design Data 12.1.1
-
12.2.2 FND Design Data 12.2.2
-
12.1.1 DBA Data 12.1.1
-
12.2.2 DBA Data 12.2.2
-
eTRM - FV Tables and Views 12.2.2
Temporary table populated during the Year End Closing process
-
eTRM - FV Tables and Views 12.1.1
Temporary table populated during the Year End Closing process
-
12.2.2 DBA Data 12.2.2
-
12.1.1 DBA Data 12.1.1
-
eTRM - FV Tables and Views 12.1.1
Temporary table populated during the Year End Closing process
-
eTRM - FV Tables and Views 12.2.2
Temporary table populated during the Year End Closing process