Results for “year_type_name”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

APPS.PSB_WS_BUDGET_YEARS_V is a supplementary database view in the Oracle E-Business Suite (12.1.1 and 12.2.2) owned by the APPS schema. It belongs to the Public Sector Budgeting (PSB) module and is registered under FND Design Data as PSB.PSB_WS_BUDGET_YEARS_V. The view exposes budget period and budget year type information in the context of budgeting worksheets, joining worksheet, calendar, budget period, and year type data into a single flat result set. Its primary purpose is to simplify form coding within the PSB application, presenting denormalized budget year records without requiring the calling form to assemble the joins itself.

Because this is a supplementary view rather than a base table, Oracle explicitly warns that it should not be queried or altered for data-maintenance purposes; its definition and column set may change significantly across minor or major releases. Applications and reports should treat it as a read-only presentation layer. In practice the view is consumed by the PSB Excel integration layer (PSB_EXCEL_PVT), which uses it when exporting or importing worksheet budget year data.

Underlying Base Objects

According to the documented view source, PSB_WS_BUDGET_YEARS_V is defined over four APPS base tables: PSB_WORKSHEETS, PSB_BUDGET_CALENDARS, PSB_BUDGET_PERIODS, and PSB_BUDGET_YEAR_TYPES. Each contributes a portion of the flattened output:

• PSB_WORKSHEETS supplies the worksheet identity (WORKSHEET_ID, WORKSHEET_NAME).
• PSB_BUDGET_CALENDARS supplies the CALENDAR_NAME associated with the budgeting calendar.
• PSB_BUDGET_PERIODS supplies BUDGET_PERIOD_ID and BUDGET_PERIOD_NAME.
• PSB_BUDGET_YEAR_TYPES supplies YEAR_CATEGORY_TYPE, YEAR_TYPE_NAME, and the ordering SEQUENCE_NUMBER.

The view is referenced by APPS.PSB_EXCEL_PVT, confirming its role as a supporting programmatic interface for the Excel worksheet upload/download functionality. No additional base objects beyond the four documented tables are involved.

Key Columns

• WORKSHEET_ID (NUMBER, 20) — Identifier of the budgeting worksheet.
• WORKSHEET_NAME (VARCHAR2, 80) — Descriptive name of the worksheet.
• CALENDAR_NAME (VARCHAR2, 30) — Name of the budget calendar used by the worksheet.
• BUDGET_PERIOD_ID (NUMBER, 20) — Surrogate key of the budget period.
• BUDGET_PERIOD_NAME (VARCHAR2, 15) — The user-facing budget period name, such as a fiscal year or period label. This is the column most commonly searched for by users, as it is the human-readable identifier for a budget period.
• YEAR_CATEGORY_TYPE (VARCHAR2, 30) — Category classification of the budget year type.
• YEAR_TYPE_NAME (VARCHAR2, 30) — Descriptive name of the budget year type.
• SEQUENCE_NUMBER (NUMBER) — Ordering value used to present budget years in the correct sequence.

Common Use Cases and Queries

Typical uses include identifying the budget periods and year types available for a given worksheet, driving Excel export/import logic, and validating budget period names before submission. A representative query returns all budget years for a specific worksheet:

SELECT BUDGET_PERIOD_NAME, YEAR_TYPE_NAME
FROM APPS.PSB_WS_BUDGET_YEARS_V
WHERE WORKSHEET_ID = :p_worksheet_id
ORDER BY SEQUENCE_NUMBER;

To locate a worksheet by budget period name, a join on BUDGET_PERIOD_NAME may be used:

SELECT WORKSHEET_ID, WORKSHEET_NAME, CALENDAR_NAME
FROM APPS.PSB_WS_BUDGET_YEARS_V
WHERE BUDGET_PERIOD_NAME = 'FY2024';

Because the view is a form-oriented supplementary view, custom code should be validated against both 12.1.1 and 12.2.2, and treated as read-only to avoid conflicts with future PSB release changes.