Search Results fv_fund_groups_u1

Overview

FV.FV_FUND_GROUPS is the base table underlying the Define Fund Groups window in Oracle E-Business Suite. It stores a distinct fund group code for each Set of Books, providing the grouping mechanism by which federal fund ranges are organized for reporting, rollup, and budgetary control purposes in the Federal Financials (FV) application. Fund groups are used to classify funds into tiers such as 1XXX, 2XXX, 3XXX, 4XXX, and 5XXX series, supporting Treasury reporting and the Statement of Net Cost and other federal financial statements. The table resides in the APPS_TS_TX_DATA tablespace with a PCT Free of 10, and its associated unique index FV_FUND_GROUPS_U1 resides in APPS_TS_TX_IDX. Based on the documented foreign-key and primary-key structure, the object is heuristically classified as standalone in a Data Vault model; it contains no link to other tables through enforced referential constraints, so it may best be modelled as a standalone reference hub or satellite depending on integration requirements.

Key Information Stored

The table contains 30 documented columns, of which the following are most significant for functional and integration purposes:

• FUND_GROUP_CODE — The business identifier for the fund group, stored as VARCHAR2.
• SET_OF_BOOKS_ID — The Set of Books (ledger) identifier, NUMBER(15), scoping each fund group to a specific accounting books definition.
• DESCRIPTION — VARCHAR2(80) fund group description used for display and reporting.
• TYPE — VARCHAR2(20) indicating the fund group type, particularly relevant for the 5XXX series of fund groups.
• ROLLUP_RANGE — Rollup value used to drive fund range aggregation logic.
• HIGH_VALUE / LOW_VALUE — NUMERIC bounds defining the range of fund values included in the group.
• FUND_TYPE and FACTS1_ROLLUP — Additional classification and rollup attributes used in federal reporting.
• Standard Who columns — LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATED_BY, CREATION_DATE, and LAST_UPDATE_LOGIN provide audit and traceability.
• ATTRIBUTE_CATEGORY and ATTRIBUTE1–15 — Descriptive flexfield structure and segment columns enabling user-defined extensibility.

The documented primary key is FV_FUND_GROUPS_PK, composed of (FUND_GROUP_CODE, SET_OF_BOOKS_ID). The unique index FV_FUND_GROUPS_U1 on the same two columns is the business-key candidate, confirming that a fund group code is unique only within the context of a given Set of Books. No separate surrogate key column is documented; the composite natural key serves as the primary identifier.

Common Use Cases and Queries

Functional users and developers typically query this table to resolve fund group definitions for reporting, fund validation, and rollup processing. Common patterns include:

• Listing all fund groups for a ledger: SELECT fund_group_code, description, type FROM fv.fv_fund_groups WHERE set_of_books_id = :p_sob;
• Resolving fund ranges: SELECT fund_group_code, low_value, high_value, rollup_range FROM fv.fv_fund_groups WHERE set_of_books_id = :p_sob ORDER BY low_value;
• Identifying 5XXX-series group types: SELECT fund_group_code, description FROM fv.fv_fund_groups WHERE type = '5' AND set_of_books_id = :p_sob;
• Auditing recent maintenance using last_update_date and last_updated_by.

These queries support Treasury reporting, fund control validation, and descriptive flexfield-driven reporting extensions.

Related Objects

The documented metadata classifies this object as standalone, with no enforced foreign keys. Practically, the following objects commonly reference or interact with FV_FUND_GROUPS:

• GL_SETS_OF_BOOKS — joined on SET_OF_BOOKS_ID to resolve ledger context.
• FND_USER — referenced by LAST_UPDATED_BY and CREATED_BY.
• FND_LOGINS — referenced by LAST_UPDATE_LOGIN.
• FV_FUND_GROUPS descriptive flexfield definition tables (FND_DESCRIPTIVE_FLEXS) keyed by ATTRIBUTE_CATEGORY.
• Federal reporting views and concurrent programs in the FV application that consume fund group codes for Statement of Net Cost and Treasury reporting.