Search Results psb_account_position_set_lines




Overview
Explore in AI Chat

Overview

The table PSB_ACCOUNT_POSITION_SET_LINES is a core data structure within the Oracle E-Business Suite (EBS) Public Sector Budgeting (PSB) module, specifically for versions 12.1.1 and 12.2.2. As indicated by its description, this table stores the detailed line-level definitions for account and position sets. These sets are logical groupings used to define budgetary controls and allocations. For account sets, the lines define ranges of GL accounts. For position sets, the lines define specific position attributes (e.g., job, grade, organization) that collectively identify a group of positions. It is critical to note that the PSB module is marked as "Obsolete" in the provided metadata, indicating its phased-out status in favor of more modern solutions like Oracle Hyperion Public Sector Planning and Budgeting. Furthermore, the "Not implemented in this database" note suggests this specific table may not be present in all deployments, potentially existing only in legacy or specific upgrade-path instances.

Key Information Stored

The table's primary function is to store the constituent elements of a defined set. Its structure is designed to support both account ranges and position attribute criteria. The key column is LINE_SEQUENCE_ID, which serves as the primary key and uniquely identifies each line within the table. The ACCOUNT_POSITION_SET_ID is a foreign key linking the line back to its parent definition in the PSB_ACCOUNT_POSITION_SETS table. The ATTRIBUTE_ID column is a foreign key to PSB_ATTRIBUTES, which is essential for position sets to specify which position characteristic (e.g., "Position Name," "Job Code") the line is defining criteria for. While the metadata excerpt does not list all columns, typical columns for such a table would include FROM_ACCOUNT and TO_ACCOUNT for defining account ranges, and corresponding VALUE columns or a link to the PSB_POSITION_SET_LINE_VALUES table to store the specific attribute values or value ranges for positions.

Common Use Cases and Queries

This table is queried during budget formulation and control processes to resolve which specific accounts or positions belong to a budgetary set. A common reporting use case is to analyze the composition of a set for audit or review purposes. Sample SQL patterns include joining to the parent set table to retrieve all lines for a specific set name, or querying to find which sets include a particular account. For position sets, queries often involve multi-table joins to decode the attribute values.

  • Retrieve all account ranges for a specific set:
    SELECT * FROM PSB_ACCOUNT_POSITION_SET_LINES apsl, PSB_ACCOUNT_POSITION_SETS aps WHERE apsl.ACCOUNT_POSITION_SET_ID = aps.ACCOUNT_POSITION_SET_ID AND aps.SET_NAME = '&SET_NAME';
  • Find all sets containing a given account:
    SELECT aps.SET_NAME FROM PSB_ACCOUNT_POSITION_SET_LINES apsl, PSB_ACCOUNT_POSITION_SETS aps WHERE apsl.ACCOUNT_POSITION_SET_ID = aps.ACCOUNT_POSITION_SET_ID AND '&ACCOUNT' BETWEEN apsl.FROM_ACCOUNT AND apsl.TO_ACCOUNT;

Related Objects

PSB_ACCOUNT_POSITION_SET_LINES sits at the center of a small hierarchy of related tables that define budgetary sets. Its primary relationships, as defined by its foreign keys, are fundamental to its operation.

  • PSB_ACCOUNT_POSITION_SETS: The parent table. Each record in LINES must belong to a single parent SET. This table holds the set's name, type (account or position), and other header-level information.
  • PSB_ATTRIBUTES: Provides the definition for the ATTRIBUTE_ID used in position set lines, describing the type of position data being constrained (e.g., Department, Job).
  • PSB_POSITION_SET_LINE_VALUES: A child table that stores the specific values or value ranges for the attribute defined on a given line. This table has a foreign key back to LINE_SEQUENCE_ID, creating a one-to-many relationship from a single set line to multiple allowed values.