Search Results psb_ws_summary_v




Overview
Explore in AI Chat

Overview

PSB_WS_SUMMARY_V is a reporting view in the Oracle E-Business Suite Public Sector Budgeting (PSB) module, which is documented as obsolete in Release 12.1.1 and 12.2.2. The view consolidates worksheet-level budgeting information, joining each worksheet to its parent budget group, the associated data extract, the current budget stage, and user identity records. It is designed to present a single denormalized row per worksheet, exposing identifiers, descriptive attributes, calendar and set of book context, stage progression, submission status, and audit columns.

Its role in Oracle EBS reporting is to provide a convenient query interface over the core PSB worksheet structures without requiring report authors to reconstruct the multi-table join themselves. Because Public Sector Budgeting functionality has been superseded, the view is effectively retained for historical reference and migration or archival reporting rather than for active budgeting workflows.

Underlying Base Objects

ETRM metadata notes that no base objects are separately documented; however, the view text itself defines the objects referenced. These are:

  • PSB_WORKSHEETS (aliased WS, and again as GWS for global worksheet records)
  • PSB_BUDGET_GROUPS_V (BG) — the budget group view supplying root group, set of books, chart of accounts, and currency context
  • PSB_DATA_EXTRACTS (DE) — data extract associated with the worksheet
  • PSB_BUDGET_STAGES (BS) — stage set and sequence joined to the worksheet's current stage
  • FND_USER (SFND and CFND) — submitting and creating users respectively

Joins are made on BUDGET_GROUP_ID, DATA_EXTRACT_ID, STAGE_SET_ID with CURRENT_STAGE_SEQ, and on CREATED_BY and SUBMITTED_BY against FND_USER. Outer joins permit records where extracts, global worksheet parents, or users are absent. A DECODE on ROOT_BUDGET_GROUP selects root versus leaf budget group attributes.

Key Columns

Common Use Cases and Queries

The most common use is listing worksheets with their owning budget group and current stage for archival or audit reporting:

  • SELECT BUDGET_GROUP_ID, WORKSHEET_ID, NAME, CURRENT_STAGE_SEQ, DATE_SUBMITTED FROM PSB_WS_SUMMARY_V WHERE BUDGET_GROUP_ID = :p_group_id;
  • SELECT WORKSHEET_ID, DATA_EXTRACT_NAME, FREEZE_FLAG FROM PSB_WS_SUMMARY_V WHERE FREEZE_FLAG = 'Y';
  • SELECT WORKSHEET_ID, SUBMITTED_BY, DATE_SUBMITTED FROM PSB_WS_SUMMARY_V WHERE DATE_SUBMITTED IS NOT NULL ORDER BY DATE_SUBMITTED DESC;

Because PSB is obsolete, these queries typically support historical data extraction during upgrades, reconciliations, or migration to replacement budgeting solutions. Users should confirm the view remains deployed in their instance, since the metadata indicates it was not implemented in every database.