Results for “fv_budget_user_hdr_u1”

10 results




Overview
Explore in AI Chat

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

FV.FV_BUDGET_USER_HDR is the base table that stores the definition of budget user groups within the Oracle E-Business Suite Grants and Federal Financials budgeting module. In Oracle EBS 12.1.1 and 12.2.2, this table underpins the Define Budget Users window, where the header region captures descriptive information about each budget user group. Budget user groups are used to organize and control the set of users authorized to enter, adjust, or review budget data for a specific set of books, providing a grouping mechanism that links users to budgeting responsibilities.

The object resides in the FV (Federal Financials / Budgeting) schema, is owned by FV, and is stored in the APPS_TS_TX_DATA tablespace with a PCT Free of 10. Its status is VALID, and it carries the FND Design Data reference FV.FV_BUDGET_USER_HDR. The table is classified as hub-leaning under a heuristic Data Vault model: its structure—a stable primary key with descriptive and who-columns, referenced by multiple dependent transaction tables—suggests it functions as a hub entity (budget user group) around which more dynamic budget transaction data revolves. This classification should be treated as a modeling suggestion rather than a physical design characteristic.

Key Information Stored

The table is defined with 25 columns. The most important columns for identification, business meaning, and integration are as follows.

  • BU_GROUP_ID — NUMBER(15), mandatory. The surrogate primary key of the table and the column enforced by the unique index FV_BUDGET_USER_HDR_U1. It uniquely identifies each budget user group.
  • BU_GROUP — VARCHAR2(25). The budget user group name shown to users in the Define Budget Users window.
  • BU_DESCRIPTION — VARCHAR2(80). A free-text description of the budget user group.
  • SET_OF_BOOKS_ID — NUMBER(15). The set of books to which the budget user group applies, providing the accounting context.
  • LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN — Standard WHO (audit) columns recording who created and last modified each group definition.
  • ATTRIBUTE_CATEGORY and ATTRIBUTE1–ATTRIBUTE15 — Descriptive flexfield (DFF) columns enabling customers to extend the budget user group record with site-specific information.

Although FV_BUDGET_USER_HDR_U1 is identified as a business-key candidate on BU_GROUP_ID, that column is a generated surrogate identifier; the human-readable business identifier is BU_GROUP combined with the set of books. The unique index guarantees one row per BU_GROUP_ID and supports the referential integrity of dependent child records.

Common Use Cases and Queries

Typical uses include validating budget user group membership before budget entry, reporting on group definitions by set of books, and joining groups to the transactions they govern. A common lookup retrieves the group header by its identifier:

  • SELECT bu_group_id, bu_group, bu_description, set_of_books_id FROM fv_budget_user_hdr WHERE bu_group_id = :p_group_id;
  • SELECT bu_group, bu_description FROM fv_budget_user_hdr WHERE set_of_books_id = :p_sob ORDER BY bu_group;

For DFF reporting, a query may return ATTRIBUTE_CATEGORY and the relevant ATTRIBUTE columns alongside the group name. Because the table serves as the parent of budget entry transactions and detail lines, an inner join on BU_GROUP_ID is the standard pattern for attributing transactions to their owning budget user group—for example, joining FV_BUDGET_USER_HDR to FV_BUDGET_USER_DTL to list the users or details belonging to each group.

Related Objects

The following objects depend on or are most significant when working with FV_BUDGET_USER_HDR, joined through BU_GROUP_ID.

  • FV_BUDGET_USER_DTL — the detail table for budget users; joins via BU_GROUP_ID to the header.
  • FV_BE_TRX_HDRS — budget entry transaction headers referencing BU_GROUP_ID.
  • FV_BE_RPR_TRANSACTIONS — budget entry transactions that reference BU_GROUP_ID, linking activity to the governing group.
  • The Define Budget Users window — the FND form/UI that reads and writes this table.
  • FND_USER — referenced indirectly through the WHO columns (CREATED_BY, LAST_UPDATED_BY) for audit traceability.