Search Results fv_fund_parameters_pk

Overview

FV_FUND_PARAMETERS is a Federal Financials (FV) module table in Oracle E-Business Suite 12.1.1 and 12.2.2 that stores fund parameter configuration and budgetary attribute information for federal agencies. The table is owned by the FV schema and is documented as VALID in ETRM metadata, containing 63 physical columns. Its role is to define the characteristics, restrictions, and accounting classifications that govern individual funds (identified by FUND_VALUE) within a given set of books, enabling compliance with U.S. federal budgetary, treasury, and reporting requirements such as SF224 reporting, BEA (Bureau of Economic Analysis) categorization, and Treasury symbol mapping.

From a Data Vault modeling perspective, the mined foreign key structure suggests a satellite-leaning classification. The table carries descriptive and contextual attributes (fund category, time frame, expiration dates, BEA categories) attached to a principal business entity — the fund — rather than acting as a pure hub or a link between independent hubs. A modeler might treat FUND_PARAMETER_ID as a hub key and place the remaining descriptive attributes in an associated satellite, while relationships to GL_SETS_OF_BOOKS_11I and BOM_DEPARTMENTS form reference links.

Key Information Stored

The surrogate primary key is FUND_PARAMETER_ID, enforced through FV_FUND_PARAMETERS_PK and the unique index FUND_PARAMETER_U1. A documented business-key candidate is the composite unique index FV_FUND_PARAMETERS_U1 over (FUND_VALUE, SET_OF_BOOKS_ID), meaning a fund value is unique within a given set of books. The most operationally significant columns include:

• FUND_VALUE — the fund identifier (e.g., Treasury Account Symbol components) that the parameter set governs.
• SET_OF_BOOKS_ID — foreign key to GL_SETS_OF_BOOKS_11I, binding the record to a ledger.
• TREASURY_SYMBOL / TREASURY_SYMBOL_ID — Treasury account symbol mapping for federal reporting.
• FUND_GROUP_CODE, FUND_CATEGORY, FUND_TIME_FRAME, RESOURCE_TYPE — classification attributes controlling fund behavior.
• ESTABLISHED_FISCAL_YR, FISCAL_YEAR, YEAR_AVAILABLE, YEARS_AVAILABLE — fiscal lifecycle and availability period controls.
• FUND_EXPIRE_DATE / FUND_CANCEL_DATE — expiration and cancellation milestones for the fund.
• BUDGET_AUTHORITY, TRANSFERS_IN, TRANSFERS_OUT, UNLIQUID_COMMITMENTS, UNLIQUID_OBLIGATIONS, EXPENDED_AMOUNT — budgetary execution amounts.
• BEA_CATEGORY, OUTLAYS_BEA_CATEGORY_CODE, BUDGET_SUBFUNCTION — economic and functional classifications used in federal reporting.
• ORG_ID, DEPARTMENT_ID, BUREAU_ID, BUSINESS_LINE — organizational ownership; DEPARTMENT_ID references BOM_DEPARTMENTS.
• MAPPED_TO_TREASURY_SYMBOL_ID, MAPPED_TO_FUND_PARAMETER_ID — self/mapping references used for fund consolidation.
• AUTO_CREATE, AUTO_CREATE_FUND_VALUE, CLOSE_REQUISITIONS, RED_STATUS, DEF_INDEF_FLAG — processing controls.

Common Use Cases and Queries

FV_FUND_PARAMETERS is queried during fund validation, SF224 reporting, Treasury symbol reconciliation, fiscal year close, and reconciliation of budget execution amounts. A typical pattern is to join the table to GL_SETS_OF_BOOKS_11I to resolve ledger names:

• Fund lookup: SELECT fund_value, fund_category, treasury_symbol FROM fv.fv_fund_parameters WHERE set_of_books_id = :ledger AND fund_value = :fund;
• Fiscal availability reporting: filter on ESTABLISHED_FISCAL_YR, YEARS_AVAILABLE, and FUND_EXPIRE_DATE.
• BEA/SF224 extracts: select BEA_CATEGORY, OUTLAYS_BEA_CATEGORY_CODE, and SF224_TYPE_CODE grouped by fund.
• Budget execution reconciliation: compare BUDGET_AUTHORITY versus UNLIQUID_OBLIGATIONS, UNLIQUID_COMMITMENTS, and EXPENDED_AMOUNT.
• Mapping audits: trace MAPPED_TO_FUND_PARAMETER_ID and MAPPED_TO_TREASURY_SYMBOL_ID for consolidation hierarchies.

Because of the composite unique index, queries by (FUND_VALUE, SET_OF_BOOKS_ID) are optimally indexed.

Related Objects

• GL_SETS_OF_BOOKS_11I — joined on FV_FUND_PARAMETERS.SET_OF_BOOKS_ID = GL_SETS_OF_BOOKS_11I.SET_OF_BOOKS_ID.
• BOM_DEPARTMENTS — joined on FV_FUND_PARAMETERS.DEPARTMENT_ID = BOM_DEPARTMENTS.DEPARTMENT_ID.
• FV_FUND_PARAMETERS (self) — mapped via MAPPED_TO_FUND_PARAMETER_ID.
• Treasury symbol reference tables — referenced through TREASURY_SYMBOL_ID and MAPPED_TO_TREASURY_SYMBOL_ID.
• FV budget execution and SF224 reporting objects — consume fund parameters for federal reporting.
• GL_CODE_COMBINATIONS / GL account structures — contextual relationship for fund-to-account derivation.