Search Results budget_revision_acct_line_id




Overview
Explore in AI Chat

Overview

The PSB_BUDGET_REVISION_LINES table is a core data object within the Oracle E-Business Suite Public Sector Budgeting (PSB) module, specifically for releases 12.1.1 and 12.2.2. It functions as a critical junction or matrix table, establishing the many-to-many relationship between budget revision headers (PSB_BUDGET_REVISIONS) and the detailed account-level adjustments (PSB_BUDGET_REVISION_ACCOUNTS). Its primary role is to link a single budget revision transaction to the multiple general ledger account lines that are being modified, thereby enabling the complex reallocation of budget amounts across funds, departments, and other accounting flexfields that is central to public sector budgetary control.

Key Information Stored

The table's structure is defined by its composite primary key, which consists of two foreign key columns. This design enforces the integrity of the relationships it manages. The key columns are:

  • BUDGET_REVISION_ID: References the unique identifier from the PSB_BUDGET_REVISIONS table. This links the line to a specific budget revision document, which contains header-level information such as revision number, status, and description.
  • BUDGET_REVISION_ACCT_LINE_ID: References the unique identifier from the PSB_BUDGET_REVISION_ACCOUNTS table. This links the line to a specific account-level adjustment record, which holds details like the accounting flexfield combination, the budget period, and the revision amount (increase or decrease).

While the provided metadata emphasizes these relational keys, the table may also contain other columns for control and sequencing, such as a line number or creation metadata.

Common Use Cases and Queries

This table is essential for any reporting or data extraction process that requires a complete view of a budget revision's impact. A primary use case is generating a detailed audit trail or report showing all account lines affected by a specific revision request. Technical consultants and report developers frequently query this table to join revision headers with account details. A common SQL pattern is:

SELECT rev.revision_num, rev.description, acct.*
FROM psb_budget_revisions rev,
psb_budget_revision_lines lines,
psb_budget_revision_accounts acct
WHERE rev.budget_revision_id = lines.budget_revision_id
AND lines.budget_revision_acct_line_id = acct.budget_revision_acct_line_id
AND rev.revision_num = 'REV-10001';

Another critical use case is during data validation or reconciliation processes, where the integrity of the links between revisions and their lines is verified, ensuring no orphaned records exist in the junction table.

Related Objects

PSB_BUDGET_REVISION_LINES sits at the center of a key relationship within the PSB schema. Its existence is defined by its dependencies on two primary tables:

  • PSB_BUDGET_REVISIONS: The parent table for revision headers. The foreign key on BUDGET_REVISION_ID enforces that every line must belong to a valid revision document.
  • PSB_BUDGET_REVISION_ACCOUNTS: The parent table for account-level detail. The foreign key on BUDGET_REVISION_ACCT_LINE_ID ensures every line references a valid account adjustment.

This table is also likely referenced by various PSB application forms, concurrent programs, and public APIs (e.g., PSB_BUDGET_REVISIONS_PUB) that process budget revision data. Reports and integrations that consume budget revision data will invariably traverse this junction table to assemble a complete transaction.