Search Results psb_budget_accounts_pk

Overview

The PSB_BUDGET_ACCOUNTS table is a core data structure within the Oracle E-Business Suite Public Sector Budgeting (PSB) module. It functions as a detailed mapping table, storing the expanded list of General Ledger (GL) accounting flexfield code combinations that are explicitly assigned to a defined account set. Its primary role is to provide the granular, account-level detail necessary for budget formulation, control, and reporting within the specialized requirements of public sector entities. By linking high-level account sets to specific GL accounts, it enables budget administrators to define precise budgetary control rules and reporting dimensions across the chart of accounts.

Key Information Stored

The table's structure centers on linking an account set identifier to specific GL accounts, with key integrity enforced by its primary and foreign keys. The critical columns include:

• ACCOUNT_POSITION_SET_ID: The foreign key to PSB_ACCOUNT_POSITION_SETS, uniquely identifying the parent account set or position set to which the GL accounts belong.
• CODE_COMBINATION_ID: The foreign key to GL_CODE_COMBINATIONS, storing the unique identifier for the specific GL accounting flexfield code combination included in the set.
• SET_OF_BOOKS_ID: The foreign key to GL_SETS_OF_BOOKS, defining the ledger context for the associated code combination, ensuring multi-ledger integrity.

The primary key constraint PSB_BUDGET_ACCOUNTS_PK, defined on ACCOUNT_POSITION_SET_ID and CODE_COMBINATION_ID, ensures that a given GL account is uniquely listed within a specific account set.

Common Use Cases and Queries

This table is central to queries that validate budget account membership, generate budget reports, and support data migration scripts. A common use case is retrieving all GL accounts for a specific budget account set for validation or reporting purposes. A typical SQL pattern would join to the related descriptive tables:

• Account Listing for a Set: SELECT gcc.concatenated_segments FROM psb_budget_accounts pba, gl_code_combinations gcc WHERE pba.code_combination_id = gcc.code_combination_id AND pba.account_position_set_id = :set_id;
• Validation During Data Load: Scripts loading budget data often reference this table to verify if a proposed GL account is a valid member of the designated budgetary control group before processing transactions.
• Budget vs. Actual Reporting: The table provides the foundational account list used to aggregate financial data (from GL tables like GL_BALANCES) for budget-to-actual comparison reports within the PSB framework.

Related Objects

PSB_BUDGET_ACCOUNTS is a junction table with strong dependencies on key GL and PSB master tables, as defined by its foreign keys:

• PSB_ACCOUNT_POSITION_SETS: The parent table defining the header record for the account or position set.
• GL_CODE_COMBINATIONS: The Oracle EBS master table for all valid accounting flexfield combinations, providing the account description and segments.
• GL_SETS_OF_BOOKS (or GL_LEDGERS in later versions): The table defining the ledger, providing the financial reporting entity context.

This table is typically referenced by PSB budget definition, transaction processing, and reporting interfaces, forming a critical link between budgetary control groups and the general ledger.