Results for “psb_account_position_set_l_pk”

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

Overview

PSB_ACCOUNT_POSITION_SET_LINES is a transactional detail table within the Public Sector Budgeting (PSB) module of Oracle E-Business Suite, documented as valid in both release 12.1.1 and 12.2.2. It stores the individual line-level definitions that make up an Account Position Set. Each Account Position Set is a reusable rule construct used during budget preparation and position control to select a population of accounts, positions, or both. This table captures those selection criteria either as a range of accounting flexfield segments (low and high values) or as a set of position attributes, depending on the nature of the set being defined.

From a Data Vault modeling perspective, the mined foreign-key structure suggests a satellite-leaning classification. The table hangs off the parent PSB_ACCOUNT_POSITION_SETS header through a single foreign key, with each row representing a descriptive line attribute of that parent. It does not function as a hub dispatching multiple business keys, nor as a pure link resolving many-to-many relationships, though its child relationship to PSB_POSITION_SET_LINE_VALUES adds a small degree of associative behavior.

Key Information Stored

The table is defined with 82 columns in the documented 12.1.1 schema. The most significant are as follows:

• LINE_SEQUENCE_ID — the surrogate primary key (constraint PSB_ACCOUNT_POSITION_SET_L_PK) and the sole column in the unique index PSB_ACCT_POSITION_SET_LINES_U1, making it the documented business-key candidate as well.
• ACCOUNT_POSITION_SET_ID — foreign key to PSB_ACCOUNT_POSITION_SETS, tying each line to its parent set definition.
• ATTRIBUTE_ID — foreign key to PSB_ATTRIBUTES, identifying the position attribute used when the line expresses a position-based selection rather than a range.
• SEGMENT1_LOW through SEGMENT30_LOW and SEGMENT1_HIGH through SEGMENT30_HIGH — paired low/high columns accommodating up to 30 accounting flexfield segments, enabling range-based account selection.
• INCLUDE_OR_EXCLUDE_TYPE — indicates whether matching accounts are included in or excluded from the set.
• DESCRIPTION — free-text label describing the purpose of the individual line.
• BUSINESS_GROUP_ID — the operating unit / business group context for multi-tenant partitioning and security.
• ATTRIBUTE1 through ATTRIBUTE10, CONTEXT — the standard Oracle descriptive flexfield (DFF) columns available for client-specific extension.
• LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN, CREATED_BY, CREATION_DATE — the standard WHO audit columns tracking record provenance and maintenance.

Common Use Cases and Queries

The primary use case is reporting on and validating the composition of Account Position Sets. Budget analysts and position control administrators query this table to confirm which account ranges or position attributes are attached to a given set before the set drives budget validation or position funding rules. A typical query joins the header to retrieve all lines for a named set:

• SELECT l.LINE_SEQUENCE_ID, l.DESCRIPTION, l.INCLUDE_OR_EXCLUDE_TYPE, l.SEGMENT1_LOW, l.SEGMENT1_HIGH, l.SEGMENT2_LOW, l.SEGMENT2_HIGH FROM PSB.PSB_ACCOUNT_POSITION_SET_LINES l, PSB.PSB_ACCOUNT_POSITION_SETS s WHERE l.ACCOUNT_POSITION_SET_ID = s.ACCOUNT_POSITION_SET_ID AND s.ACCOUNT_POSITION_SET_ID = :set_id ORDER BY l.LINE_SEQUENCE_ID;
• Attribute-based lines are resolved by joining ATTRIBUTE_ID to PSB_ATTRIBUTES to translate the stored identifier into a human-readable attribute name.
• Child values for each line are retrieved by joining LINE_SEQUENCE_ID to PSB_POSITION_SET_LINE_VALUES.LINE_SEQUENCE_ID, giving the fully expanded selection criteria.
• Inclusion/exclusion audits use INCLUDE_OR_EXCLUDE_TYPE to separate include rules from exclude rules when troubleshooting budget eligibility failures.
• DFF reporting extracts ATTRIBUTE1 through ATTRIBUTE10 and CONTEXT for client-specific analytics or interfaces.

Related Objects

The following objects are the most significant dependencies and references for this table:

• PSB_ACCOUNT_POSITION_SETS — parent header table; joined on ACCOUNT_POSITION_SET_ID.
• PSB_ATTRIBUTES — attribute definition table; joined on ATTRIBUTE_ID for position-attribute lines.
• PSB_POSITION_SET_LINE_VALUES — child table referencing LINE_SEQUENCE_ID, holding the expanded attribute value selections for each line.
• PSB_ACCOUNT_POSITION_SET_L_PK — primary key constraint; PSB_ACCT_POSITION_SET_LINES_U1 — unique index on LINE_SEQUENCE_ID.
• Where used in budget validation or position control logic, the set definitions in this table are consumed indirectly through PSB_ACCOUNT_POSITION_SETS by the budget preparation and position control processes in the PSB module.