Results for “psb_position_set_line_values”

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

Overview

PSB_POSITION_SET_LINE_VALUES is a transactional detail table within the Public Sector Budgeting (PSB) module of Oracle E-Business Suite, present in both 12.1.1 and 12.2.2. It stores the individual attribute values that are attached to a position set line. In the Public Sector Budgeting model, a position set groups positions for budgeting and mass-update purposes; each line in a position set represents a specific position, and this table captures the set of descriptive attributes (for example, grade, step, or other position-level flexfield-style attributes) that qualify that line. It therefore acts as the intersection between position set lines and the attribute value definitions maintained in PSB_ATTRIBUTE_VALUES.

From a Data Vault modeling perspective, the heuristic mined from the foreign-key structure classifies this table as a link. This is a modeling suggestion rather than a documented fact: the table resolves a many-to-many relationship between PSB_ACCOUNT_POSITION_SET_LINES and PSB_ATTRIBUTE_VALUES and carries no natural descriptive payload beyond the attribute value itself, which is characteristic of a link entity. The nine documented columns are relatively lean, reinforcing its role as an association rather than a descriptive satellite.

Key Information Stored

The table is anchored by its surrogate primary key and two foreign keys that define its relationships:

• VALUE_SEQUENCE_ID — the surrogate primary key, backed by the PSB_POS_SET_LINE_VALUES_PK constraint. It uniquely identifies each attribute-value row.
• LINE_SEQUENCE_ID — foreign key to PSB_ACCOUNT_POSITION_SET_LINES; identifies the parent position set line to which this attribute value belongs.
• ATTRIBUTE_VALUE_ID — foreign key to PSB_ATTRIBUTE_VALUES; identifies the attribute value definition being applied.
• ATTRIBUTE_VALUE — the stored value of the attribute for this line, denormalized here for direct retrieval.

The remaining documented columns are standard Oracle EBS audit columns: LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN, CREATED_BY, and CREATION_DATE. These support change tracking and concurrency, and are populated automatically by the EBS audit framework. No additional business-key unique index is documented beyond the primary key, so VALUE_SEQUENCE_ID is the only documented unique identifier; the combination of LINE_SEQUENCE_ID and ATTRIBUTE_VALUE_ID functions as the effective business key even though it is not surfaced as a named unique constraint.

Common Use Cases and Queries

Typical reporting and troubleshooting scenarios involve listing the attributes associated with a position set line, or finding all lines that carry a specific attribute value. A representative join returns the line context alongside its attribute:

• Retrieve attributes for a line: join PSB_POSITION_SET_LINE_VALUES to PSB_ACCOUNT_POSITION_SET_LINES on LINE_SEQUENCE_ID, filtering by the desired line.
• Resolve attribute definitions: join to PSB_ATTRIBUTE_VALUES on ATTRIBUTE_VALUE_ID to obtain attribute names and metadata.
• Audit extraction: filter on LAST_UPDATE_DATE to identify recently modified attribute assignments.

A common query pattern is: SELECT psl.LINE_SEQUENCE_ID, psv.ATTRIBUTE_VALUE_ID, psv.ATTRIBUTE_VALUE FROM PSB.PSB_POSITION_SET_LINE_VALUES psv JOIN PSB.PSB_ACCOUNT_POSITION_SET_LINES psl ON psv.LINE_SEQUENCE_ID = psl.LINE_SEQUENCE_ID WHERE psv.ATTRIBUTE_VALUE_ID = :id;

Related Objects

• PSB_ACCOUNT_POSITION_SET_LINES — parent table; joined via PSB_POSITION_SET_LINE_VALUES.LINE_SEQUENCE_ID.
• PSB_ATTRIBUTE_VALUES — attribute value definitions; joined via PSB_POSITION_SET_LINE_VALUES.ATTRIBUTE_VALUE_ID.
• PSB_POSITION_SET_LINE_VALUES PK constraint PSB_POS_SET_LINE_VALUES_PK — enforces VALUE_SEQUENCE_ID uniqueness.
• Public Sector Budgeting position set and attribute configuration forms, which read and write these records when users maintain position set lines.
• Budgeting validation and mass-update processes that consume attribute values for position lines.