Search Results hr_budget_id




Overview
Explore in AI Chat

Overview

PSB.PSB_POSITION_ACCOUNTS is a Position Control interface table in Oracle E-Business Suite, owned by the PSB schema and registered in FND Design Data. The table stores position control account distribution information together with baseline values carried forward from budget revisions. Its stated functional purpose is to act as an interface table for Position Control: position account distributions are populated here before being posted into any Position Control system.

The object resides in the APPS_TS_SUMMARY tablespace with PCTFREE of 10, and is documented as VALID in both the 12.1.1 and 12.2.2 object repositories. Under the heuristic Data Vault classification derived from its foreign key structure, the table behaves as a link entity — it resolves many-to-many relationships between positions, budget groups, budget revisions, and GL code combinations, carrying descriptive attributes (currency, amount, effective dates) that would typically be modeled as a satellite attached to that link. This classification should be treated as a modeling suggestion rather than an authoritative design statement.

Key Information Stored

The table contains eighteen documented columns. The most significant include:

Non-unique indexes PSB_POSITION_ACCOUNTS_N1 through N3 support lookups on POSITION_ID, BUDGET_REVISION_ID, and BUDGET_GROUP_ID, confirming that these are the dominant query predicates.

Common Use Cases and Queries

Typical scenarios include verifying which position account distributions are pending transfer into Position Control, reconciling budget revision baselines against current Position Control values, and reporting cost distributions by GL code combination for a given position or budget cycle.

A query to identify rows pending transfer would filter on TRANSFER_TO_PC_FLAG and join to PSB_POSITIONS on POSITION_ID. Reconciliation between original and current baselines uses BASE_LINE_VERSION grouped by BUDGET_REVISION_ID. Distribution reporting joins CODE_COMBINATION_ID to GL_CODE_COMBINATIONS and filters by START_DATE/END_DATE for point-in-time accuracy. Because the table is an interface, extracts are frequently written by concurrent programs and subsequently consumed by downstream Position Control posting logic.

Related Objects

  • PSB.PSB_POSITIONS — joined via POSITION_ID; parent of the position reference.
  • PSB.PSB_BUDGET_REVISIONS — joined via BUDGET_REVISION_ID; supplies baseline revision context.
  • PSB.PSB_BUDGET_GROUPS — joined via BUDGET_GROUP_ID; groups distributions for budget processing.
  • GL.GL_CODE_COMBINATIONS — resolved through CODE_COMBINATION_ID for account validation and reporting.
  • Position Control posting and transfer concurrent programs that consume this interface table, keyed by POSITION_ACCOUNT_LINE_ID and gated by TRANSFER_TO_PC_FLAG.