Search Results psb_position_accounts_u1

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:

• POSITION_ACCOUNT_LINE_ID — a NUMBER(15) surrogate primary key and the sole column of unique index PSB_POSITION_ACCOUNTS_U1. It uniquely identifies each Position Control account distribution row.
• POSITION_ID — NUMBER(20) foreign key to PSB_POSITIONS, identifying the position to which the distribution applies.
• START_DATE and END_DATE — the effective date range over which the cost distribution is maintained.
• CODE_COMBINATION_ID — NUMBER(20) reference to the General Ledger code combination receiving the distribution.
• BUDGET_GROUP_ID and BUDGET_REVISION_ID — foreign keys to PSB_BUDGET_GROUPS and PSB_BUDGET_REVISIONS respectively, tying the distribution to its budgetary context.
• CURRENCY_CODE and AMOUNT — the currency of the position control distribution and the corresponding amount for the position/account combination.
• BASE_LINE_VERSION — indicates whether the baseline derives from Original values (O, from Budget Preparation) or Current values (C, from Position Control).
• HR_POSITION_ID and HR_BUDGET_ID — cross-references to the corresponding HR position and budget records.
• TRANSFER_TO_PC_FLAG — the flag of interest to the searching user, marking whether the row is designated for transfer into Position Control.
• Standard Who columns LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN, CREATED_BY, and CREATION_DATE provide audit lineage.

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.