Search Results budget_revision_justification




Overview
Explore in AI Chat

Overview

APPS.PSBFV_BUDGET_REVISION_POSITION is a Business Intelligence System (BIS) view in the Oracle E-Business Suite PSB (Public Sector Budgeting) product family. It exposes position-level budget revision data together with the justification narrative and associated notes, presenting a denormalized, reporting-friendly projection of revision records. The view carries a status of VALID and is owned by the APPS schema. Its FND Design Data designation is PSB.PSBFV_BUDGET_REVISION_POSITION, indicating that the object is registered in the application's design metadata and shipped as a seeded component rather than a customer-defined artifact.

The view is of particular relevance to users searching for budget_revision_justification, since it exposes a dedicated BUDGET_REVISION_JUSTIFICATION column of type VARCHAR2(240). This column captures the textual rationale recorded when a position budget revision is created or adjusted, making the view a convenient single source for audit and reporting queries that need to correlate revision amounts with their stated business reasons.

Underlying Base Objects

According to the documented dependency information, APPS.PSBFV_BUDGET_REVISION_POSITION is defined over the following APPS objects:

The view does not reference any customer-defined or external objects, and no database object references it, confirming that it is a terminal reporting view rather than a component in an update path. Because it is a BIS view, it is read-only in practice; all maintenance occurs against the underlying PSB base tables.

h4>Key Columns

Common Use Cases and Queries

Typical scenarios include auditing why position budgets changed, reconciling revision amounts to justifications, and reporting effective-dated revisions by budget group.

SELECT BUDGET_REVISION_ID
     , POSITION_ID
     , _KF:POSITION_NAME
     , BUDGET_REVISION_JUSTIFICATION
     , REVISION_TYPE
     , REVISION_VALUE
     , EFFECTIVE_START_DATE
     , EFFECTIVE_END_DATE
  FROM APPS.PSBFV_BUDGET_REVISION_POSITION
 WHERE BUDGET_REVISION_JUSTIFICATION IS NOT NULL
   AND EFFECTIVE_START_DATE BETWEEN :start_date AND :end_date
 ORDER BY BUDGET_GROUP_SHORT_NAME, POSITION_ID, EFFECTIVE_START_DATE;

Aggregate queries grouping by BUDGET_GROUP_SHORT_NAME and REVISION_TYPE provide summary views of revision activity, while joins to PSB base tables allow drill-down into individual revision lines. Because the view is valid and fully resolved in both 12.1.1 and 12.2.2, it can be queried without additional setup.