Search Results global_constraint_set_id

Overview

PSB_WORKSHEETS_V is a view in the Oracle E-Business Suite Public Sector Budgeting (PSB) module. In EBS 12.1.1 and 12.2.2, PSB is classified as obsolete, meaning Oracle no longer actively develops or supports the module and it is not implemented in the standard database shipped with these releases. The view nevertheless remains documented in the ETRM metadata, which preserves its definition for reference, upgrade, and legacy-integration purposes. Its role is to present a denormalized, human-readable projection of the PSB_WORKSHEETS entity, enriching the core worksheet record with descriptive names drawn from its related configuration sets. Rather than requiring a report or interface to join six or more base tables manually, the view consolidates worksheet attributes alongside budget group, budget calendar, data extract, parameter set, constraint set, allocation rule set, and flex mapping set names.

The column allocrule_set_id that led to this search is exposed directly by the view, along with its resolved allocation rule set name, which is precisely the kind of convenience the view is designed to provide.

Underlying Base Objects

The view is defined over the following documented objects:

• PSB_WORKSHEETS (aliased WS) — the primary driving table holding worksheet definitions and processing flags.
• PSB_WORKSHEETS (aliased WS1) — a self-join used to resolve global or federal worksheet inheritance, notably in the NVL(WS.FEDERAL_WS_FLAG, WS1.FEDERAL_WS_FLAG) expression.
• PSB_BUDGET_GROUPS (BG) — supplies SHORT_NAME.
• PSB_BUDGET_CALENDARS (BC) — supplies the calendar NAME.
• PSB_DATA_EXTRACTS (DE) — supplies DATA_EXTRACT_NAME.
• PSB_PARAMETER_SETS_V (PPSV) — supplies the parameter set name.
• PSB_CONSTRAINT_SETS_V (PCSV) — supplies the constraint set name.
• PSB_ALLOCRULE_SETS_V (PASV) — supplies the allocation rule set name.
• PSB_FLEX_MAPPING_SETS (FMS) — supplies the flex mapping set name.
• GL_BUDGET_SETS (GLS) — supplies GL_BUDGET_SET_NAME.

Because it depends on several PSB_*_V views, PSB_WORKSHEETS_V is itself a layered view, and ETRM documents no separate base-table breakdown for it.

Key Columns

The projection exposes the full worksheet attribute set. Principal columns include WORKSHEET_ID, BUDGET_GROUP_ID, BUDGET_CALENDAR_ID, WORKSHEET_TYPE, NAME, DESCRIPTION, and FREEZE_FLAG. Workflow and stage columns include STAGE_SET_ID and CURRENT_STAGE_SEQ. Globalization-related columns include NUM_PROPOSED_YEARS, NUM_YEARS_TO_ALLOCATE, GL_CUTOFF_PERIOD, BUDGET_VERSION_ID, and GL_BUDGET_SET_ID. Set references exposed include PARAMETER_SET_ID, CONSTRAINT_SET_ID, ALLOCRULE_SET_ID, and FLEX_MAPPING_SET_ID, each paired with its descriptive name. Inclusion flags such as INCLUDE_STAT_BALANCE, INCLUDE_TRANSLATED_BALANCE, INCLUDE_GL_COMMIT_BALANCE, and INCLUDE_CBC_BUDGET_BALANCE control which balances populate the worksheet. Standard audit columns (CREATED_BY, CREATION_DATE, LAST_UPDATE_DATE) and the DFF ATTRIBUTE1–ATTRIBUTE10 and CONTEXT columns are also included.

Common Use Cases and Queries

The view is typically used to audit worksheet configuration or to identify which worksheets reference a specific allocation rule set — the exact scenario implied by the search term. A representative query:

• Locate worksheets by allocation rule set: SELECT WORKSHEET_ID, NAME, ALLOCRULE_SET_ID, DESCRIPTION FROM PSB_WORKSHEETS_V WHERE ALLOCRULE_SET_ID = :p_allocrule_set_id;
• Report worksheet setup: select worksheet name, budget group, calendar, parameter set, constraint set, and allocation rule set names in a single row.
• Audit globalization configuration by filtering on NUM_PROPOSED_YEARS or GL_CUTOFF_PERIOD.

Because the module is obsolete and the object is not implemented in the standard database, these queries execute only where PSB has been installed and retained.