Results for “psb_acct_position_set_lines_u1”

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

Overview

PSB_ACCOUNT_POSITION_SET_LINES is a transactional configuration table in the PSB schema of Oracle E-Business Suite, owned by the ETRM (Enterprise Territory and Resource Management / Trade Management) product family. It stores the individual line-level details that make up an account set or a position set. An account set is composed of one or more Include or Exclude account ranges, and each row in this table represents a single such range. A position set, by contrast, is defined through position attributes; each row in this table identifies the attribute that must be evaluated for a given set, with the required match values held in the companion PSB_POSITION_SET_LINE_VALUES table. A position set may be configured to require that all conditions match, or that at least one condition matches.

The object carries 82 documented columns and is classified, via heuristic Data Vault analysis of its foreign-key structure, as satellite-leaning. This is a modeling suggestion rather than a physical implementation fact: the table behaves as a descriptive child attribute store hanging off the PSB_ACCOUNT_POSITION_SETS parent, recording the qualifying detail rows for each set rather than acting as an independent hub or a pure associative link.

Key Information Stored

The primary key is enforced by the unique index PSB_ACCT_POSITION_SET_LINES_U1, defined on LINE_SEQUENCE_ID, a NUMBER(15) surrogate that provides the unique line identifier within an account position set. This is the business-key candidate named in the user's search and the most reliable single-column lookup path.

• LINE_SEQUENCE_ID — surrogate primary key; unique line identifier within the account position set.
• ACCOUNT_POSITION_SET_ID — the owning set; foreign key to PSB_ACCOUNT_POSITION_SETS and the leading column of the nonunique index PSB_ACCT_POSITION_SET_LINES_N1.
• ATTRIBUTE_ID — identifies the position attribute evaluated by this line; foreign key to PSB_ATTRIBUTES.
• INCLUDE_OR_EXCLUDE_TYPE — flag distinguishing an Include range from an Exclude range when the line defines account selection.
• DESCRIPTION — a VARCHAR2(80) label for the set line.
• BUSINESS_GROUP_ID — the business group that scopes position sets, supporting multi-organization partitioning.
• SEGMENT*n*_LOW — up to thirty account range low segment values (SEGMENT1_LOW through SEGMENT30_LOW), each VARCHAR2(25).
• SEGMENT*n*_HIGH — the corresponding high segment values (SEGMENT1_HIGH through SEGMENT30_HIGH), which together with the LOW columns define the inclusive account range.
• ATTRIBUTE1 through ATTRIBUTE10, CONTEXT — the standard EBS descriptive flexfield columns for site-specific extension of line content.
• LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN, CREATED_BY, CREATION_DATE — standard audit columns.

Common Use Cases and Queries

The most frequent operational access pattern retrieves all lines for a given set. Because PSB_ACCT_POSITION_SET_ID is indexed nonuniquely, this query is efficient:

• SELECT line_sequence_id, description, include_or_exclude_type, attribute_id FROM psb_account_position_set_lines WHERE account_position_set_id = :p_set_id ORDER BY line_sequence_id;
• Point lookup by the unique key: SELECT * FROM psb_account_position_set_lines WHERE line_sequence_id = :p_line_id;
• Attribute-driven reporting: join to PSB_ATTRIBUTES on ATTRIBUTE_ID to identify which position attributes a set uses, which is useful when auditing or migrating position set definitions.
• Value expansion: join to PSB_POSITION_SET_LINE_VALUES on LINE_SEQUENCE_ID to resolve the actual match values for each position line, since the parent line stores only the attribute reference.
• Account range reconstruction: report the SEGMENTn_LOW/SEGMENTn_HIGH pairs and INCLUDE_OR_EXCLUDE_TYPE to reproduce the effective account hierarchy defined by an account set.

Typical reporting scenarios include reconciling account sets to the chart of accounts, documenting which position attributes drive eligibility rules, and validating that Include and Exclude ranges do not overlap.

Related Objects

• PSB_ACCOUNT_POSITION_SETS — parent table; PSB_ACCOUNT_POSITION_SET_LINES.ACCOUNT_POSITION_SET_ID references it.
• PSB_ATTRIBUTES — referenced by ATTRIBUTE_ID; supplies the definition of each position attribute.
• PSB_POSITION_SET_LINE_VALUES — child table; its LINE_SEQUENCE_ID references this table, holding the values an attribute must match.
• PSB_ACCT_POSITION_SET_LINES_U1 — unique index on LINE_SEQUENCE_ID (APPS_TS_TX_IDX).
• PSB_ACCT_POSITION_SET_LINES_N1 — nonunique index on ACCOUNT_POSITION_SET_ID (APPS_TS_TX_IDX).

All lines reside in the APPS_TS_TX_DATA tablespace with PCTFREE 10, consistent with the transactional nature of set configuration data.