Search Results psb_account_position_sets




Overview
Explore in AI Chat

Overview

The PSB_ACCOUNT_POSITION_SETS table is a core data definition table within the now-obsolete Public Sector Budgeting (PSB) module of Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2. Its primary role was to serve as a master repository for defining reusable sets of accounts and positions. These sets functioned as templates or groupings, enabling budget administrators to efficiently apply consistent budgeting rules, controls, and reporting criteria across multiple budget structures without redundant manual entry. The table's design links these definitions to a specific Set of Books (the precursor to Ledgers) and to Data Extract processes, centralizing configuration for complex public sector budgeting workflows.

Key Information Stored

While the full column list is not detailed in the provided metadata, the primary and foreign key relationships define its critical data elements. The central column is ACCOUNT_POSITION_SET_ID, the unique primary key identifier for each set definition. The table stores the SET_OF_BOOKS_ID, anchoring each set to a specific financial ledger for data isolation and security. It also holds DATA_EXTRACT_ID, linking set definitions to broader data extraction and integration configurations within PSB. Other likely columns would include a name, description, effective dates, and type indicators to distinguish between account sets and position sets.

Common Use Cases and Queries

This table was central to setup and reporting operations. Administrators would query it to review or audit defined sets before launching budget cycles. A typical use case involved identifying all account sets for a specific ledger to validate budget coverage. A common reporting query would join this table to its lines table to list all members of a specific set.

  • Sample Query to List Sets for a Ledger:
    SELECT set_name, description
    FROM psb_account_position_sets
    WHERE set_of_books_id = :ledger_id;
  • Sample Query for Set Membership:
    SELECT s.set_name, l.account_segment_value
    FROM psb_account_position_sets s,
    psb_account_position_set_lines l
    WHERE s.account_position_set_id = l.account_position_set_id
    AND s.account_position_set_id = :set_id;

Related Objects

As indicated by its foreign key constraints, PSB_ACCOUNT_POSITION_SETS is a pivotal parent table with several key dependencies. PSB_ACCOUNT_POSITION_SET_LINES stores the individual account or position members belonging to each set. PSB_BUDGET_ACCOUNTS and PSB_BUDGET_POSITIONS reference the set to apply predefined groupings to specific budget entries. PSB_SET_RELATIONS likely used it to define hierarchical relationships between different sets. Furthermore, it references the foundational GL_SETS_OF_BOOKS_11I (GL Ledgers) and is referenced by PSB_DATA_EXTRACTS, highlighting its role in data extraction processes. This network of relationships underscores its function as a central configuration hub within the obsolete PSB module.