Search Results num_proposed_years




Overview
Explore in AI Chat

Overview

PSBBV_BUDGET_WORKSHEETS is a read-only view belonging to the Public Sector Budgeting (PSB) product, which is marked as obsolete in Oracle E-Business Suite 12.1.1 and 12.2.2. The view presents budget worksheet definitions along with the control parameters, allocation options, currency-balance handling flags, and workbook metadata required to drive the budgeting process. Its role is chiefly informational and reporting-oriented: it consolidates the metadata stored in the PSB worksheet tables into a single, responsibility-filtered result set that exposes the configuration of worksheets belonging to the budget groups accessible to the current user's responsibility.

The view is created WITH READ ONLY, so it cannot be used for DML. It is intended purely for query and reporting purposes. Because the underlying budget-group filter depends on FND_GLOBAL.RESP_ID, the set of rows returned is automatically restricted to budget groups reachable through the responsibility's hierarchical group assignments. This makes the view a natural source for responsibility-aware inquiry screens, custom reports, and integration extracts.

Underlying Base Objects

The view text selects from a single driving table, PSB_WORKSHEETS (aliased WS), which supplies every projected column. Filtering is performed against two further PSB tables:

Although the ETRM documentation records no referenced base objects, the view text clearly establishes PSB_WORKSHEETS as the primary source table, with PSB_BUDGET_GROUPS and PSB_BUDGET_GROUP_RESP providing the responsibility-scoped security filter. The dictionary is exposed in the PSB schema and is closely associated with the worksheet logic of the legacy Public Sector Budgeting module.

Key Columns

Common Use Cases and Queries

Typical uses include reporting on worksheet configuration, verifying the GL cutoff period applied to a worksheet, auditing submission status, and building integration extracts that reconcile worksheets with their GL budget sets. Because the view is responsibility-filtered, it is also used to confirm which budget groups and worksheets a given responsibility can access.

Sample query listing worksheets with their type and GL cutoff period:

SELECT worksheet_name,
       "_LA:WORKSHEET_TYPE"      AS worksheet_type,
       gl_cutoff_period,
       current_stage_seq,
       freeze_flag,
       date_submitted
FROM   psbbv_budget_worksheets
ORDER  BY worksheet_name;

Sample query identifying worksheets awaiting submission or frozen worksheets:

SELECT w.worksheet_name,
       w.budget_group_id,
       w.gl_budget_set_id,
       w.gl_cutoff_period,
       w.freeze_flag
FROM   psbbv_budget_worksheets w
WHERE  w.date_submitted IS NULL
   OR  w.freeze_flag = 'Y';

Because the view enforces group-level and responsibility-level security internally, queries do not need to reimplement the PSB_BUDGET_GROUP_RESP hierarchy filter. Users should be aware that the PSB product is obsolete in 12.1.1 and 12.2.2, so the view is retained primarily for backward compatibility and historical data inquiry rather than active new implementations.