Search Results psb_budget_revision_lines_u1

Overview

The PSB.PSB_BUDGET_REVISION_LINES table is a core transactional entity within Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2, specifically for the Public Sector Budgeting (PSB) module. It functions as a critical junction or matrix table, establishing the many-to-many relationship between budget revisions and the specific account lines being revised. Its primary role is to manage the association and distribution of budget revision details. When a global budget revision is created, this table maps each resulting transactional account line to the overarching revision. Conversely, during the distribution of a budget revision, rows are inserted into this table to link the revision with account lines based on predefined budgetary account ranges within a budget group.

Key Information Stored

The table's structure is designed to manage the association metadata and audit trail. The two primary foreign key columns are BUDGET_REVISION_ID, which references the parent revision header, and BUDGET_REVISION_ACCT_LINE_ID, which references the individual account line detail. Together, they form a unique constraint (PSB_BUDGET_REVISION_LINES_U1). Control flags govern line-level behavior: FREEZE_FLAG indicates whether the associated account line is frozen from further changes, and VIEW_LINE_FLAG controls its visibility. Standard Oracle EBS "Who" columns (CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN) provide a full audit trail for every association record.

Common Use Cases and Queries

This table is central to reporting and auditing the scope and status of budget revisions. Common operational queries include identifying all account lines impacted by a specific budget revision, checking the freeze status of distributed lines, or validating the distribution logic. A typical reporting query to analyze a revision's details would join to the related header and accounts tables:

• Identifying All Lines for a Revision: SELECT * FROM psb.psb_budget_revision_lines WHERE budget_revision_id = :rev_id;
• Reporting on Revision Distribution Status: SELECT brl.budget_revision_id, brl.budget_revision_acct_line_id, brl.freeze_flag, brl.view_line_flag FROM psb.psb_budget_revision_lines brl JOIN psb.psb_budget_revisions br ON brl.budget_revision_id = br.budget_revision_id WHERE br.revision_number = 'REV-1001';
• Audit Trail for a Specific Account Line: SELECT creation_date, created_by, last_update_date, last_updated_by FROM psb.psb_budget_revision_lines WHERE budget_revision_acct_line_id = :acct_line_id;

Related Objects

As a junction table, PSB_BUDGET_REVISION_LINES has fundamental dependencies within the PSB schema. It sits between two key master-detail entities, forming the relational link in the budget revision architecture. Based on the documented column names and unique index, the primary relationships are:

• PSB.PSB_BUDGET_REVISIONS: The BUDGET_REVISION_ID column references the primary key of this header table, which defines the overall budget revision event.
• PSB.PSB_BUDGET_REVISION_ACCOUNTS (or a similarly named detail table): The BUDGET_REVISION_ACCT_LINE_ID column references the unique identifier for individual transactional account lines created or modified by the revision process. The ETRM documentation explicitly names this as the other entity in the matrix relationship.

The table itself is referenced by the APPS synonym PSB_BUDGET_REVISION_LINES, which is used by the application layer for all data operations.