Search Results account_position_set_id




Overview
Explore in AI Chat

Overview

The PSB_BUDGET_POSITIONS table is a core data structure within the Oracle E-Business Suite (EBS) Public Sector Budgeting (PSB) module, specifically in versions 12.1.1 and 12.2.2. It functions as a performance-optimized repository for storing the list of positions associated with a defined account position set. Instead of dynamically calculating this membership list during runtime—which can be resource-intensive for budgeting and reporting operations—the table is populated and maintained by a dedicated concurrent process. This design ensures efficient access to position set data, which is critical for budget formulation, control, and analysis processes within the PSB module.

Key Information Stored

The table's primary purpose is to map positions to their parent sets. Its key columns include the ACCOUNT_POSITION_SET_ID, which is the unique identifier for the position set, and the POSITION_ID, which identifies an individual position member. The combination of these two columns forms a unique constraint (PSB_BUDGET_POSITIONS_U1), ensuring a position is not duplicated within a set. Additional context is provided by the DATA_EXTRACT_ID and BUSINESS_GROUP_ID, linking the records to a specific data extract and organizational business group. The table also includes standard Oracle EBS "Who" columns (CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN) for auditing purposes.

Common Use Cases and Queries

This table is central to queries that need to enumerate all positions within a specific set for budgeting workflows. A common use case is generating reports or feeding data to budget worksheets that are scoped by a predefined position set. The following query pattern retrieves all position members for a given ACCOUNT_POSITION_SET_ID, which was the focus of the user's search:

  • Retrieve All Positions for a Set: SELECT POSITION_ID FROM PSB.PSB_BUDGET_POSITIONS WHERE ACCOUNT_POSITION_SET_ID = <set_id>;
  • Validate Position Membership: SELECT COUNT(*) FROM PSB.PSB_BUDGET_POSITIONS WHERE ACCOUNT_POSITION_SET_ID = <set_id> AND POSITION_ID = <position_id>;
  • Audit Data by Extract: SELECT ACCOUNT_POSITION_SET_ID, COUNT(POSITION_ID) FROM PSB.PSB_BUDGET_POSITIONS WHERE DATA_EXTRACT_ID = <extract_id> GROUP BY ACCOUNT_POSITION_SET_ID;

Related Objects

As per the provided dependency information, the PSB_BUDGET_POSITIONS table does not reference other objects but is itself referenced by the APPS schema synonym PSB_BUDGET_POSITIONS. This synonym facilitates access for application code and reports. The table's existence implies a relationship with master data tables for positions (likely such as PER_ALL_POSITIONS) and the parent table defining the account position sets themselves (commonly named PSB_ACCOUNT_POSITION_SETS or similar), though these are not explicitly listed in the provided metadata. The non-unique index PSB_BUDGET_POSITIONS_N1 on ACCOUNT_POSITION_SET_ID optimizes queries filtering by this key column.