Search Results fv_budget_user_dtl




Overview
Explore in AI Chat

Overview

FV_BUDGET_USER_DTL is a Federal Financials (FV) product table in the Oracle E-Business Suite 12.1.1 / 12.2.2 data model that stores user budget access level options. It defines the granular privileges and access thresholds granted to specific application users over budget organizations, enabling the Federal Financials budgeting engine to enforce segregation of duties and role-based authorization during budget entry, review, and approval processes. Because the table holds descriptive attribute rows that extend a header entity, its heuristic Data Vault classification (mined from foreign-key structure) is satellite-leaning; modelers should consider treating it as a satellite attached to the FV_BUDGET_USER_HDR hub/link rather than as an independent hub.

Key Information Stored

The table contains 17 documented columns. The most significant columns are:

  • BU_USER_ID — identifies the application user to whom the budget access definition applies.
  • BU_GROUP_ID — foreign key to FV_BUDGET_USER_HDR, tying the detail row to its parent access group header; this is the principal join key and a business-key candidate.
  • BU_ACCESS_LEVEL_FROM and BU_ACCESS_LEVEL_TO — define the numeric range of budget access levels the user may operate within, effectively bounding approved authority.
  • BU_VIEW_FLAG — controls whether the user can view budget records.
  • BU_SU_FLAG — controls subordinate-level budget access (e.g., organization subordinates).
  • BU_SA_FLAG — controls sub-allocation access rights.
  • BU_UPDATE_FLAG — determines whether the user may modify budget data.
  • BU_APPROVE_FLAG — determines whether the user may approve budgets.
  • DEFAULT_APPROVER_ID — identifies the default approver assigned to the user/group combination.
  • FORWARD_TO_FLAG — indicates whether budget documents should be forwarded to the default approver.
  • SET_OF_BOOKS_ID — scopes the access definition to a specific set of books, supporting multi-ledger deployments.
  • LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATED_BY, CREATION_DATE, LAST_UPDATE_LOGIN — the standard EBS audit columns (WHO columns) that track row creation and modification.

No surrogate primary-key column is documented in the provided metadata, so the composite of BU_GROUP_ID plus BU_USER_ID should be treated as the likely business-key candidate for uniqueness enforcement.

Common Use Cases and Queries

Typical use cases include reviewing who may approve or update budgets, auditing segregation-of-duties conflicts, and generating reports of delegated budget authority. A representative query retrieves access privileges joined to the header:

SELECT d.BU_USER_ID,
       d.BU_ACCESS_LEVEL_FROM,
       d.BU_ACCESS_LEVEL_TO,
       d.BU_UPDATE_FLAG,
       d.BU_APPROVE_FLAG,
       d.DEFAULT_APPROVER_ID
FROM   FV.FV_BUDGET_USER_DTL d,
       FV.FV_BUDGET_USER_HDR h
WHERE  d.BU_GROUP_ID = h.BU_GROUP_ID
AND    d.BU_APPROVE_FLAG = 'Y';

Reporting scenarios frequently filter on SET_OF_BOOKS_ID to isolate a ledger, and on BU_UPDATE_FLAG or BU_APPROVE_FLAG to enumerate privileged users. This data also supports reconciliation of the automated budget approval routing configured through the default approver and forward-to settings.

Related Objects

  • FV_BUDGET_USER_HDR — the parent header table; joined via FV_BUDGET_USER_DTL.BU_GROUP_ID = FV_BUDGET_USER_HDR.BU_GROUP_ID. This is the only documented foreign-key relationship.
  • FV_BUDGET_GROUPS — defines the budget organizations to which access levels apply.
  • FV_BUDGET_ENTITIES — the budget entities governed by the access definitions.
  • FND_USER — resolves BU_USER_ID to an application user name.
  • GL_SETS_OF_BOOKS — resolves SET_OF_BOOKS_ID to a ledger name.
  • PER_ALL_PEOPLE_F — resolves DEFAULT_APPROVER_ID and personnel context.
  • FV_BUDGET_INTERFACE / FV_BUDGET_ACCOUNTS — downstream budget processing objects influenced by these privilege settings.

Together these objects form the authorization layer that governs how Federal Financials users interact with budget data across the enterprise.