Search Results psb_budget_revision_pos_lines




Overview
Explore in AI Chat

Overview

The PSB_BUDGET_REVISION_POS_LINES table is a core data structure within the Oracle E-Business Suite Public Sector Budgeting (PSB) module, specifically for versions 12.1.1 and 12.2.2. It functions as a junction or matrix table, establishing and managing the many-to-many relationships between budget revision headers and their associated budget revision positions. Its primary role is to link a single budget revision document, stored in PSB_BUDGET_REVISIONS, to one or more detailed budget position lines, stored in PSB_BUDGET_REVISION_POSITIONS. This design is critical for tracking which specific budgetary line items are impacted by a given revision request, enabling detailed audit trails, approval workflows, and financial control within the public sector budgeting process.

Key Information Stored

The table's structure is designed to facilitate the relational link between its parent entities. The primary key, BUDGET_REVISION_POS_LINE_ID, uniquely identifies each record in this junction table. The two critical foreign key columns are BUDGET_REVISION_ID, which references the header revision document, and BUDGET_REVISION_POS_LINE_ID, which references a specific budget revision position detail line. While the provided metadata does not list additional descriptive or amount columns, the table's core purpose is to store these relational identifiers. The existence of a record in this table signifies that a particular budget revision position is included within a specific budget revision.

Common Use Cases and Queries

This table is essential for queries that need to aggregate or report on all position lines tied to a revision. A common operational use case is generating a detailed report for a budget revision, listing all affected positions. For troubleshooting, one might query this table to identify orphaned lines or validate data integrity. A typical SQL pattern involves joining the three core tables:

  • Identifying all positions for a specific revision: SELECT pos.* FROM psb_budget_revision_pos_lines ln, psb_budget_revision_positions pos WHERE ln.budget_revision_pos_line_id = pos.budget_revision_pos_line_id AND ln.budget_revision_id = :rev_id;
  • Finding the parent revision for a given position line: SELECT rev.* FROM psb_budget_revision_pos_lines ln, psb_budget_revisions rev WHERE ln.budget_revision_id = rev.budget_revision_id AND ln.budget_revision_pos_line_id = :pos_line_id;

These queries are foundational for custom reports, audit scripts, and integration points within the PSB module.

Related Objects

The PSB_BUDGET_REVISION_POS_LINES table sits at the intersection of two primary PSB entities, as defined by its documented foreign key relationships:

  • PSB_BUDGET_REVISIONS: This is the parent header table for budget revision documents. The relationship is established via the column PSB_BUDGET_REVISION_POS_LINES.BUDGET_REVISION_ID.
  • PSB_BUDGET_REVISION_POSITIONS: This table stores the detailed line items for budget revisions. The relationship is established via the column PSB_BUDGET_REVISION_POS_LINES.BUDGET_REVISION_POS_LINE_ID.

These relationships are enforced by the primary key constraint PSB_BUDGET_REVISION_PLINE_PK. The table is central to the PSB revision workflow, and any customizations or data fixes involving revision details must consider its integrity constraints.