Search Results fv_fund_parameters_n1

Overview

FV.FV_FUND_PARAMETERS is a transaction-data table in the Oracle U.S. Federal Financials (FV) product family. Its documented purpose is to further classify the balancing segment: users assign parameters for each balancing segment value defined in Oracle U.S. Federal Financials. In effect, the table holds the fund-level attributes required for Treasury reporting, budget execution, and federal year-end processing, keyed by the accounting flexfield balancing segment.

The table resides in the APPS_TS_TX_DATA tablespace with PCTFREE 10 and is registered in FND Design Data as FV.FV_FUND_PARAMETERS. In Oracle EBS 12.1.1 and 12.2.2 the object is unchanged in owner and role, though 12.2.2 documentation records a widened physical schema of 63 columns, extending the earlier attribute set with budget-execution measures such as BUDGET_AUTHORITY, UNLIQUID_OBLIGATIONS, and OUTLAYS_BEA_CATEGORY_CODE.

Applying a Data Vault heuristic to the documented foreign-key structure, the table is satellite-leaning. It is not an independent hub of funds; rather it hangs off the fund identity (FUND_VALUE / balancing segment) and the ledger context (SET_OF_BOOKS_ID), carrying descriptive and derived attributes. The classification should therefore be treated as a modeling suggestion rather than a physical constraint.

Key Information Stored

The surrogate primary key is FUND_PARAMETER_ID, enforced by FV_FUND_PARAMETERS_PK and by the unique index FUND_PARAMETER_U1. Two business-key candidates are documented: FUND_VALUE combined with SET_OF_BOOKS_ID (unique index FV_FUND_PARAMETERS_U1), and the surrogate column itself via FUND_PARAMETER_U1.

• FUND_VALUE — the balancing segment value that identifies the fund; half of the composite business key.
• SET_OF_BOOKS_ID — the set of books/ledger identifier scoping the fund definition; the other half of the composite business key and a foreign key to GL_SETS_OF_BOOKS_11I.
• TREASURY_SYMBOL and TREASURY_SYMBOL_ID — Treasury symbol text and its identifier; indexed non-uniquely by FV_FUND_PARAMETERS_N1.
• FUND_GROUP_CODE, FUND_CATEGORY, and FUND_TIME_FRAME — fund grouping, category, and time-frame classifications.
• SF224_TYPE_CODE — the fund type used for SF224 reporting.
• ESTABLISHED_FISCAL_YR, FUND_EXPIRE_DATE, FUND_CANCEL_DATE, and RESOURCE_TYPE — establishment year, expiration, cancellation, and resource type consumed by year-end processing.
• DEPARTMENT_ID — foreign key to BOM_DEPARTMENTS, linking the fund to an owning department.
• ORG_ID — operating unit context for multi-org security.
• MAPPED_TO_TREASURY_SYMBOL_ID and MAPPED_TO_FUND_PARAMETER_ID — self-referencing mapping pointers for fund consolidation or Treasury-symbol realignment.
• Standard Who columns — LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN, CREATION_DATE, and CREATED_BY provide audit lineage.

Common Use Cases and Queries

Typical usage includes fund validation at transaction entry, Treasury symbol derivation for SF224 and related federal reports, and year-end close logic that reads expiration and cancellation dates. A representative lookup by fund and ledger:

• SELECT fund_parameter_id, fund_value, treasury_symbol, fund_group_code FROM fv.fv_fund_parameters WHERE fund_value = :p_fund AND set_of_books_id = :p_sob;
• Join to the ledger for reporting: SELECT p.fund_value, b.name, p.fund_category FROM fv.fv_fund_parameters p, gl_sets_of_books b WHERE p.set_of_books_id = b.set_of_books_id;
• Year-end exception reporting: SELECT fund_value, fund_expire_date, fund_cancel_date FROM fv.fv_fund_parameters WHERE fund_expire_date < SYSDATE;
• Departmental rollups using the department foreign key to BOM_DEPARTMENTS.

Related Objects

• GL_SETS_OF_BOOKS_11I — referenced by SET_OF_BOOKS_ID; the primary ledger join for fund context.
• BOM_DEPARTMENTS — referenced by DEPARTMENT_ID; organizational ownership of the fund.
• FV.FV_FUND_PARAMETERS (self) — via MAPPED_TO_FUND_PARAMETER_ID for fund remapping.
• GL_CODE_COMBINATIONS / GL_BALANCING_SEGMENT — the balancing segment values classified by FUND_VALUE.
• FV Treasury symbol definitions — resolved through TREASURY_SYMBOL_ID and MAPPED_TO_TREASURY_SYMBOL_ID.
• FV year-end processing programs and concurrent requests — consumers of FUND_EXPIRE_DATE, FUND_CANCEL_DATE, and RESOURCE_TYPE.