Search Results fv_ye_groups




Overview
Explore in AI Chat

Overview

FV_YE_GROUPS is a Federal Financials (FV) product table within the Oracle E-Business Suite 12.1.1 and 12.2.2 data model that stores Year End group definitions. In federal accounting, the fiscal year-end close is not a single monolithic event; agencies frequently partition their close activity into logical groups so that funds, treasury symbols, and reporting entities can be processed independently or in a controlled sequence. FV_YE_GROUPS is the master definition table that records those groupings, together with the processing parameters that govern how each group is treated during the year-end cycle.

The table resides in the FV schema and is classified as VALID in the ETRM repository. Its primary key, FV_YE_GROUPS_U1, is defined on the GROUP_ID column, and the table is referenced by FV_YE_GROUP_SEQUENCES through the GROUP_ID foreign key. From a heuristic Data Vault modeling perspective, the mined foreign-key structure classifies this object as hub-leaning: GROUP_ID acts as a durable business key that other dependent objects reference, making FV_YE_GROUPS a natural hub candidate within a raw-vault representation of the year-end configuration domain.

Key Information Stored

The documented physical schema for 12.2.2 lists 28 columns. The most operationally significant are:

  • GROUP_ID — Surrogate primary key and the unique identifier for each year-end group (FV_YE_GROUPS_U1). It is the column referenced by FV_YE_GROUP_SEQUENCES.
  • SET_OF_BOOKS_ID — The ledger for which the group definition applies, scoping the group to a specific accounting set of books.
  • FUND_TIME_FRAME — The time frame classification used to qualify funds within the group, driving how appropriation and fund balance data is selected.
  • FUND_GROUP_CODE — The code identifying the fund grouping being defined for year-end processing.
  • TREASURY_SYMBOL and TREASURY_SYMBOL_ID — The Treasury symbol (and its surrogate identifier) associated with the group, tying the definition to Treasury reporting accounts.
  • CLOSING_METHOD — Determines the closing approach applied to the group during year-end processing.
  • LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN, CREATION_DATE, CREATED_BY — Standard EBS WHO columns providing audit lineage.
  • ATTRIBUTE_CATEGORY and ATTRIBUTE1 through ATTRIBUTE15 — The standard descriptive-flexfield columns, available for agency-specific group classification.

No descriptive unique index beyond the GROUP_ID primary key is documented, so GROUP_ID is the sole business-key candidate identified in the metadata.

Common Use Cases and Queries

FV_YE_GROUPS is primarily a configuration and reporting object. Typical scenarios include verifying which fund groups exist for a given ledger before running year-end close, and confirming the closing method and Treasury symbol assigned to each group.

  • Listing all year-end groups for a ledger: SELECT group_id, fund_group_code, fund_time_frame, closing_method FROM fv.fv_ye_groups WHERE set_of_books_id = :ledger_id;
  • Joining groups to their sequence steps through the documented FK: SELECT g.group_id, g.fund_group_code, s.* FROM fv.fv_ye_groups g, fv.fv_ye_group_sequences s WHERE g.group_id = s.group_id;
  • Auditing configuration changes by filtering on LAST_UPDATE_DATE and LAST_UPDATED_BY.
  • Reporting on Treasury symbol coverage across groups to validate that all required symbols are represented before Treasury reporting.

Related Objects

The documented foreign-key relationship identifies FV_YE_GROUP_SEQUENCES as the principal dependent object, joined on GROUP_ID. Because FV_YE_GROUPS references SET_OF_BOOKS_ID and TREASURY_SYMBOL_ID, it also relates logically to GL_SETS_OF_BOOKS and the Treasury symbol definition tables maintained in the Federal Financials schema. Reporting extracts and year-end close concurrent programs that consume group definitions read this table together with FV_YE_GROUP_SEQUENCES to determine processing order and scope.