Search Results psbfv_budget_worksheets




Overview
Explore in AI Chat

Overview

The view PSBFV_BUDGET_WORKSHEETS belongs to the Oracle EBS Public Sector Budgeting (PSB) module, which is documented as obsolete in the ETRM repository. It is a "form view" (signaled by the FV naming convention) designed to support the PSB Budget Worksheets form rather than to serve as a general-purpose reporting object. The view flattens a worksheet record together with the names of its associated budget group, calendar, stage, data extract, and entity sets, and it includes several literal lookup directives (such as _LA:WORKSHEET_TYPE:FND_LOOKUPS:PSB_WORKSHEET_TYPES:MEANING) that are consumed by the EBS form layer for descriptive flexfield and lookup rendering.

Because the view's WHERE clause restricts rows by the current responsibility (FND_GLOBAL.RESP_ID) and by effective-dated, responsibility-assigned budget groups, it presents only worksheets the logged-in user is entitled to see. It is therefore primarily a form-support and authorization-scoping view, not a data-extract view. Its role in integration is limited: it is intended for interactive PSB worksheet maintenance and submission, and it exposes the worksheet's configuration and status columns along with related descriptive names. The metadata notes it is "Not implemented in this database," meaning the view exists in the E-Business Suite data dictionary but is not instantiated in the current environment.

Underlying Base Objects

The view text is defined over the following base tables:

The join logic is driven by BUDGET_GROUP_ID and BUDGET_CALENDAR_ID to the worksheet, with a hierarchical CONNECT BY that walks PARENT_BUDGET_GROUP_ID from the responsibility's assigned budget groups. Notably, the ETRM record documents no referenced base objects, so the relationships above are taken directly from the embedded view SQL rather than from cataloged dependencies.

Key Columns

Common Use Cases and Queries

The view is used by the PSB Budget Worksheet form to display and manage worksheets for the current responsibility. A typical query retrieves worksheets for a given budget group:

SELECT NAME, BUDGET_GROUP_ID, CURRENT_STAGE_SEQ, FREEZE_FLAG
FROM PSBFV_BUDGET_WORKSHEETS
WHERE BUDGET_GROUP_ID = :p_budget_group_id;

Because the view enforces responsibility-based access via FND_GLOBAL.RESP_ID, it should be queried within an EBS application session rather than from an external tool, where the global context may not be initialized. Analysts investigating the budget hierarchy can also traverse from the view into PSB_BUDGET_GROUPS using BUDGET_GROUP_ID to identify parent groups. Given the module's obsolete status, new reporting requirements are generally better served by querying the underlying PSB_WORKSHEETS table directly.