Search Results psb_budget_revisions_v




Overview
Explore in AI Chat

Overview

PSB_BUDGET_REVISIONS_V is a reporting view owned by the APPS schema within the Public Sector Budgeting (PSB) product of Oracle E-Business Suite. As documented in ETRM for releases 12.1.1 and 12.2.2, the view is defined on the PSB_BUDGET_REVISIONS base table and presents information about budget revisions together with denormalized descriptive attributes drawn from associated budget groups, parameter (entity) sets, and application users. Its status is VALID, and it is intended to provide a single, read-consistent projection of revision header data that reporting tools, concurrent programs, and custom integrations can query without reproducing the necessary joins themselves.

In the PSB model, a budget revision records a controlled change to an existing budget — its scope, justification, effective period, and routing through the approval process. The view exposes that header context alongside human-readable identifiers, which makes it suitable for operational reports, approval-status dashboards, and extracts that feed external budget or grants systems.

Underlying Base Objects

The view is defined over four objects, joined as follows:

The BUDGET_GROUP and REQUESTOR joins are inner joins, so a revision row is returned only when both a valid budget group and a valid requestor user exist. The parameter set join is an outer join, so revisions without a parameter set are still returned, with a null name.

Key Columns

Common Use Cases and Queries

The view most commonly supports revision status reporting, pending-approval worklists, and audit extracts. A representative query lists current revisions with their group and requestor:

  • SELECT budget_revision_id, budget_group_name, justification, submission_status, requestor, user_name, effective_start_date, effective_end_date FROM apps.psb_budget_revisions_v WHERE submission_status = 'SUBMITTED';
  • Pending-approval counts by group: SELECT budget_group_name, COUNT(*) FROM apps.psb_budget_revisions_v WHERE submission_status <> 'APPROVED' GROUP BY budget_group_name;
  • Date-bounded audit extract: SELECT budget_revision_id, requestor, user_name, submission_date FROM apps.psb_budget_revisions_v WHERE submission_date BETWEEN :from_date AND :to_date;

Because the view resolves group, parameter set, and user names, it removes the need for ad-hoc joins and is well suited to Oracle Reports, BI Publisher, and OBIEE sources within PSB.