Search Results psb_ws_folder_v

Overview

PSB_WS_FOLDER_V is a reporting view within the Public Sector Budgeting (PSB) module of Oracle E-Business Suite, a component historically associated with Oracle Public Sector Budgeting and related to the E-Business Tax / ETRM documentation set. The PSB module is designated as obsolete in release 12.1.1 and 12.2.2, meaning the underlying functionality is retained only for backward compatibility with legacy installations and is not intended for new implementations. The view consolidates worksheet-level budgeting information into a single denormalized result set, joining worksheet definitions with budget groups, budget stages, data extracts, global worksheets, and submitters. It is used primarily for reporting and integration purposes, allowing administrators, budget analysts, and custom concurrent programs to retrieve a flattened picture of worksheets and their state without navigating the underlying normalized tables directly. Because PSB is obsolete, the view is documented for reference and migration planning rather than active development.

Underlying Base Objects

Although the ETRM metadata lists no referenced base objects for 12.2.2, the view text explicitly defines the query against six PSB and FND tables. The primary object is PSB_WORKSHEETS, aliased twice as WS (the worksheet being reported) and GWS (the global worksheet referenced by the local copy). PSB_BUDGET_GROUPS provides the budget group identifier and short name. PSB_BUDGET_STAGES supplies the current stage name and stage set linkage. PSB_DATA_EXTRACTS supplies the data extract name through an outer join. FND_USER, joined with an outer join on SUBMITTED_BY, provides the submitter's user name. The join predicates enforce that a worksheet belongs to a budget group, its stage set and current stage sequence map to a valid budget stage, and global worksheets are only surfaced when WS_CREATION_COMPLETE is set to 'Y'. The FEDERAL_WS_FLAG is resolved from the local worksheet, falling back to the global worksheet value via NVL.

Key Columns

• BUDGET_GROUP_ID / BUDGET_GROUP_SHORT_NAME — Identifies the owning budget group.
• WORKSHEET_ID / WORKSHEET_NAME — The worksheet primary key and display name.
• WORKSHEET_TYPE — The category of worksheet, the column that most frequently drives the user search "worksheet_type"; it distinguishes worksheet behavior and reporting scope.
• CURRENT_STAGE_SEQ / CURRENT_STAGE_NAME — The worksheet's position in the budget stage workflow.
• DATA_EXTRACT_ID / DATA_EXTRACT_NAME — The associated data extract, when one exists.
• GLOBAL_WORKSHEET_ID / GLOBAL_WORKSHEET_NAME / GLOBAL_WORKSHEET_FLAG / GLOBAL_WORKSHEET_OPTION — Identify the source global worksheet and its usage options.
• LOCAL_COPY_FLAG / FREEZE_FLAG — Indicate whether the worksheet is a local copy or frozen from editing.
• SUBMITTED_FLAG / SUBMITTED_BY / SUBMITTED_BY_NAME / DATE_SUBMITTED — Submission status and audit information; SUBMITTED_FLAG is derived by DECODE over SUBMITTED_BY.
• CREATED_BY / CREATION_DATE — Standard audit columns.
• FEDERAL_WS_FLAG — Indicates federal worksheet treatment, inherited from the global worksheet where local is null.

Common Use Cases and Queries

The view is typically consumed to list available worksheets for a budget group, to filter submissions by worksheet type or stage, or to reconcile global versus local worksheet relationships. A representative query filters by worksheet type and submission state:

SELECT WORKSHEET_ID, WORKSHEET_NAME, WORKSHEET_TYPE, CURRENT_STAGE_NAME, SUBMITTED_FLAG
FROM PSB_WS_FOLDER_V
WHERE BUDGET_GROUP_ID = :p_group_id
AND WORKSHEET_TYPE = :p_type;

Another common pattern identifies global worksheet propagation:

SELECT WORKSHEET_NAME, GLOBAL_WORKSHEET_NAME, GLOBAL_WORKSHEET_OPTION, LOCAL_COPY_FLAG
FROM PSB_WS_FOLDER_V
WHERE GLOBAL_WORKSHEET_FLAG = 'Y';

Because PSB is obsolete in 12.1.1 and 12.2.2, these queries should be treated as legacy reporting only, and organizations should plan migration to supported budgeting or planning modules.