Results for “psb_ws_position_lines_u1”

5 results




Overview
Explore in AI Chat

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

PSB.PSB_WS_POSITION_LINES is a transaction data table within the Oracle E-Business Suite PSB schema, which supports the Enterprise Resource Planning and budgeting functionality delivered by Oracle Enterprise Trade and Resource Management (ETRM) and related applications. The table stores information for a position instance. A position instance is created for every position for every global worksheet or for every local copy of a worksheet, meaning the table is central to the worksheet-based budgeting and position management model used in Oracle EBS 12.1.1 and 12.2.2.

Because a position instance is materialized per position per worksheet, the same logical position may appear in multiple rows, once for each global worksheet or worksheet copy in which it participates. The table therefore acts as the persistence layer that binds a position to a specific worksheet context and to an associated budget group.

From a Data Vault modeling perspective, the FK topology mined from the schema classifies this object as hub-leaning. This is a heuristic suggestion: PSB_WS_POSITION_LINES behaves primarily like a hub, holding a stable unique identifier (POSITION_LINE_ID) around which dependent satellite and link-style detail is organized. The dependent tables that reference it (account lines, element lines, FTE lines, and line balances) behave as satellites or links attached to this hub.

Key Information Stored

The table contains 21 documented columns. The most significant are:

  • POSITION_LINE_ID (NUMBER(20)) — The position line unique identifier. This is the surrogate primary key, enforced by the unique index PSB_WS_POSITION_LINES_U1 (documented as the business-key candidate and primary key constraint PSB_WS_POSITION_PROJECT_PK).
  • POSITION_ID (NUMBER(20)) — The unique identifier of the position that this instance represents. Indexed non-uniquely by PSB_WS_POSITION_LINES_N1, reflecting that one position may have many instances across worksheets.
  • BUDGET_GROUP_ID (NUMBER) — The budget group to which the position instance belongs. This is a foreign key to PSB_BUDGET_GROUPS.
  • COPY_OF_POSITION_LINE_ID (NUMBER(20)) — Indicates the position instance from which the current instance was copied, supporting worksheet copy lineage and traceability.
  • DESCRIPTION (VARCHAR2(2000)) — A free-text description for the position instance.
  • ATTRIBUTE1 through ATTRIBUTE10 (VARCHAR2(150) each) — Descriptive Flexfield (DFF) segment columns for capturing client-specific position-instance attributes.
  • CONTEXT (VARCHAR2(30)) — The Descriptive Flexfield context that determines which of the ATTRIBUTE segments are meaningful.
  • Standard Who columns — LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN, CREATED_BY, and CREATION_DATE provide audit and concurrency tracking.

Common Use Cases and Queries

Typical scenarios include retrieving all position instances for a worksheet, tracing copied instances back to their source, and reporting positions by budget group.

  • List all instances for a given position: SELECT * FROM PSB.PSB_WS_POSITION_LINES WHERE POSITION_ID = :position_id;
  • Find all instances in a budget group: SELECT * FROM PSB.PSB_WS_POSITION_LINES WHERE BUDGET_GROUP_ID = :budget_group_id;
  • Trace copy lineage: SELECT POSITION_LINE_ID, COPY_OF_POSITION_LINE_ID FROM PSB.PSB_WS_POSITION_LINES WHERE COPY_OF_POSITION_LINE_ID IS NOT NULL;
  • Reporting on DFF usage: filter on CONTEXT and ATTRIBUTE1..10 to surface client-defined position attributes.

Because POSITION_LINE_ID is the driving key for downstream detail, joins to account, element, FTE, and balance tables are the dominant query pattern for worksheet analysis.

Related Objects