Search Results root_ps_account_pos_set_name

Overview

APPS.PSBFV_BUDGET_GROUPS is a Business Intelligence System (BIS) view owned by the APPS schema within Oracle E-Business Suite. It is registered under FND Design Data as PSB.PSBFV_BUDGET_GROUPS and carries a status of VALID. The view presents budget group definitions used by Oracle Public Sector Budgeting (PSB), the budgeting module that operates within the ETRM framework alongside Oracle Labor Distribution and Oracle Grants Accounting. Budget groups are the structural containers through which budget hierarchies, account set assignments, and multi-year calculation parameters are organized.

As a reporting-facing view, PSBFV_BUDGET_GROUPS abstracts the underlying budget group base tables and exposes denormalized, human-readable attributes. This design makes it suitable for ad hoc query, BI Publisher report sourcing, and integration extracts that need budget group metadata without navigating the normalized transactional schema directly. The view surface supports both functional users seeking to understand which budget organization, set of books, and currency a given hierarchy rolls up to, and technical developers building interfaces or conversions.

Underlying Base Objects

The documented ETRM metadata lists no referenced base objects for this view, and the query text is truncated at the opening SELECT clause. In practice, a PSB budget group view of this type is defined over the PSB budget group entity tables maintained by the Public Sector Budgeting application, joined to set of books, currency, and account position set reference data to resolve the descriptive name columns exposed in the view. The presence of a _DF CHAR(28) descriptive flexfield column confirms that the view folds in the DFF structure associated with the budget group entity.

Because the view is read-only and BI-oriented, it should be treated as a query surface rather than a DML target. Values originate from the base PSB tables and are refreshed as those tables change; concurrent program or application-driven maintenance of budget groups is expected to flow through to the view.

Key Columns

• BUDGET_GROUP_ID and ROOT_BUDGET_GROUP_ID — Surrogate keys uniquely identifying the budget group and its root ancestor, suitable for joins.
• BUDGET_GROUP_SHORT_NAME and BUDGET_GROUP_NAME — User-facing identifiers and descriptive titles.
• NARRATIVE_DESCRIPTION — VARCHAR2(2000) extended description of the budget group; the column most commonly targeted when searching for descriptive budget group text.
• BUDGET_GROUP_DESCRIPTION — VARCHAR2(240) shorter description field.
• START_EFFECTIVE_DATE and END_EFFECTIVE_DATE — Date-range control establishing when the budget group is active.
• ROOT_BUDGET_GROUP and FREEZE_HIERARCHY_FLAG — Status flags indicating root status and whether the hierarchy is frozen.
• BUDGET_GROUP_NUM_PROPOSED_YRS — Number of years calculated for the group, driving multi-year budgeting behavior.
• ROOT_SET_OF_BOOKS_NAME, ROOT_CURRENCY_CODE, ROOT_PS_ACCOUNT_POS_SET_NAME, ROOT_NPS_ACCOUNT_POS_SET_NAME — Contextual attributes resolving the root group's accounting environment.
• LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATED_BY, CREATION_DATE — Standard Who columns for audit.

Common Use Cases and Queries

Typical uses include validating budget group setup prior to a budgeting cycle, extracting group hierarchies for reporting, and joining to budget line or position data for variance analysis. The NARRATIVE_DESCRIPTION column is frequently selected when analysts require extended descriptive context.

SELECT budget_group_id,
       budget_group_short_name,
       budget_group_name,
       narrative_description,
       start_effective_date,
       end_effective_date,
       root_set_of_books_name,
       root_currency_code
  FROM apps.psbfv_budget_groups
 WHERE TRUNC(SYSDATE) BETWEEN start_effective_date AND NVL(end_effective_date, SYSDATE)
 ORDER BY budget_group_short_name;

To locate a root group and its descendants, filter on the root identifier or flag:

SELECT budget_group_short_name,
       root_short_name,
       freeze_hierarchy_flag,
       budget_group_num_proposed_yrs
  FROM apps.psbfv_budget_groups
 WHERE root_budget_group = 'Y'
   AND root_set_of_books_name = :set_of_books;

Because no base objects are documented, any query relying on join keys beyond the exposed identifiers should be validated against the current schema before use in production reporting.