Search Results allocrule_set_name

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:

• PSB_WORKSHEETS (aliased WS) — the driving table holding worksheet definitions, statuses, and configuration flags.
• PSB_BUDGET_GROUPS (BG) — provides the budget group name; also drives the hierarchical and effective-dating filters.
• PSB_BUDGET_CALENDARS (BC) — the budget calendar name.
• PSB_BUDGET_STAGES (BS) — the stage set name and sequence match.
• PSB_DATA_EXTRACTS (DE) — the data extract name (outer-joined).
• PSB_ENTITY_SET (PESP, PESC, PESA) — parameter, constraint, and allocation rule set names (outer-joined).
• GL_BUDGET_VERSIONS (GLV) and PSB_GL_BUDGET_SETS (GLS) — the GL budget name and GL budget set name.

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

• NAME (WS.NAME) — worksheet name.
• BUDGET_GROUP_ID — the key the user searched for; links the worksheet to its budget group and is central to the authorization filter and hierarchical traversal.
• BUDGET_CALENDAR_ID, STAGE_SET_ID, BUDGET_VERSION_ID, GL_BUDGET_SET_ID — foreign keys binding the worksheet to its calendar, stage set, budget version, and GL budget set.
• CURRENT_STAGE_SEQ — the worksheet's current processing stage.
• FREEZE_FLAG, DATE_SUBMITTED, SUBMITTED_BY — status and submission tracking.
• USE_REVISED_ELEMENT_RATES, BUDGET_BY_POSITION, INCLUDE_TRANSLATED_BALANCE, INCLUDE_ADJUSTMENT_PERIODS, INCLUDE_STAT_BALANCE — worksheet behavioral flags.
• NUM_PROPOSED_YEARS, NUM_YEARS_TO_ALLOCATE, GL_CUTOFF_PERIOD, ROUNDING_FACTOR — budget calculation controls.
• WORKSHEET_ID, GLOBAL_WORKSHEET_ID, DATA_EXTRACT_ID, PARAMETER_SET_ID, CONSTRAINT_SET_ID, ALLOCRULE_SET_ID — identity and supporting object keys.
• LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATED_BY, CREATION_DATE — standard audit 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.