Search Results psbbv_budget_revisions

Overview

PSBBV_BUDGET_REVISIONS is an Oracle E-Business Suite view owned by the APPS schema and defined in the Public Sector Budgeting (PSB) product. It presents budget revision records that are visible to the currently logged-in responsibility, filtered through the responsibility-to-budget-group assignment hierarchy. The view is defined WITH READ ONLY, meaning it cannot be used as the target of DML; it is intended exclusively for querying, reporting, and integration extraction.

The view is particularly relevant to users searching for PERMANENT_REVISION, since it exposes that column directly. In Oracle EBS 12.1.1 and 12.2.2 the view behaves identically from a functional standpoint; the primary difference between the two releases is the surrounding technology stack, not the view definition itself. It serves as the reporting and query entry point for revision metadata such as revision justification, balance type, submission status, and the permanent-revision indicator.

Underlying Base Objects

The documented base object underpinning the view is PSB_BUDGET_REVISIONS (aliased BR), the transaction table that stores budget revision headers. The view joins or subqueries against two additional PSB tables:

• PSB_BUDGET_GROUPS — restricts results to budget groups of type 'R' whose effective date range includes SYSDATE.
• PSB_BUDGET_GROUP_RESP — used in the START WITH clause of the hierarchical query to seed the budget group tree from the current responsibility (FND_GLOBAL.RESP_ID).

The hierarchical CONNECT BY PRIOR BUDGET_GROUP_ID = PARENT_BUDGET_GROUP_ID clause walks the budget group hierarchy downward, so any revision belonging to a descendant group of the responsibility's assigned group is visible. The ETRM metadata lists no additional referenced base objects beyond these.

Key Columns

• BUDGET_REVISION_ID — primary identifier for the budget revision header.
• PERMANENT_REVISION — flag indicating whether the revision is a permanent revision affecting base budget balances, as opposed to a temporary or working revision. This is the column most commonly sought in searches.
• BUDGET_GROUP_ID — the budget group to which the revision belongs; drives the view's row-level filtering and the hierarchical visibility.
• BALANCE_TYPE, GL_BUDGET_SET_ID — the balance type and GL budget set used in the revision.
• FROM_GL_PERIOD_NAME, TO_GL_PERIOD_NAME — the GL period range covered.
• "_LA:BUDGET_REVISION_TYPE" and "_LA:TRANSACTION_TYPE" — lookup-derived, translatable (language attribute) descriptions resolved from FND_LOOKUPS for PSB_REVISION_SOURCE_TYPE and PSB_REVISION_TRANSACTION_TYPES respectively.
• REVISE_BY_POSITION — indicates whether the revision is applied position-by-position.
• REQUESTOR, SUBMISSION_DATE, SUBMISSION_STATUS — the initiator and workflow state of the revision.
• CONSTRAINT_SET_ID, PARAMETER_SET_ID — parameter and constraint set references governing processing.
• FREEZE_FLAG, BASE_LINE_REVISION, GLOBAL_BUDGET_REVISION, GLOBAL_BUDGET_REVISION_ID — status and lineage controls, including global-budget revision linkage.

Common Use Cases and Queries

Typical uses include confirming whether a revision is permanent, reporting on submission status, and auditing revision activity by budget group. Because visibility is filtered by responsibility, any query returns only revisions the current user's responsibility is entitled to see.

• Listing permanent revisions and their status:

SELECT BUDGET_REVISION_ID, BUDGET_GROUP_ID, PERMANENT_REVISION,
       REVISE_BY_POSITION, REQUESTOR, SUBMISSION_STATUS, SUBMISSION_DATE
FROM   APPS.PSBBV_BUDGET_REVISIONS
WHERE  PERMANENT_REVISION = 'Y';

• Retrieving revisions with lookup-translated types:

SELECT BUDGET_REVISION_ID, JUSTIFICATION,
       "_LA:BUDGET_REVISION_TYPE" AS REVISION_TYPE,
       "_LA:TRANSACTION_TYPE" AS TRANSACTION_TYPE
FROM   APPS.PSBBV_BUDGET_REVISIONS
WHERE  BUDGET_GROUP_ID = :budget_group_id
AND    FREEZE_FLAG = 'N';

• Joining the view to PSB_BUDGET_GROUPS for reporting by group name, or to GL budget set tables (GL_BUDGET_SETS) for the budget set description.
• Extracting revisions for interface programs and analytics where attribute or reconstruction control (ARC) is preferred over direct base-table access, given the view's responsibility-based security filter.

Because the view is read-only and directly reflects PSB_BUDGET_REVISIONS, it is a safe and supported source for query and reporting interfaces in both 12.1.1 and 12.2.2.