Results for “include_or_exclude_type”

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

Overview

PSB_ACCT_POSITION_SET_LINES_V is a view belonging to the Public Sector Budgeting (PSB) product family in Oracle E-Business Suite. PSB provides account position set functionality used by public sector organizations to define inclusion and exclusion rules across the accounting flexfield structure. This view exposes the individual line definitions that make up an account position set, combining the stored line rows from the underlying PSB tables with a decoded lookup meaning for the include or exclude indicator.

ETRM metadata classifies the object under PSB - Public Sector Budgeting (Obsolete) and explicitly records the implementation status as "Not implemented in this database." This is a significant caveat: the view is documented as part of the ETRM reference set, but no physical database object or base table dependency is guaranteed to exist in a given environment. Where the product is not licensed or has been de-supported, querying the view will fail or return no underlying data. The view remains relevant as a reference model for understanding how account position set lines are structured when PSB functionality is present.

The view text joins PSB_ACCOUNT_POSITION_SET_LINES to a second table (aliased FL in the excerpt), selecting FL.MEANING as the final projected column. This pattern is a standard Oracle EBS lookup decode, translating a stored code value into a human-readable description for reporting and integration consumers.

Underlying Base Objects

The documented base object is PSB_ACCOUNT_POSITION_SET_LINES, aliased LINES in the view definition. Each row in this table represents one line within an account position set, identified by LINE_SEQUENCE_ID and linked to its parent set through ACCOUNT_POSITION_SET_ID. The view selects LINES.ROWID, ensuring row-level addressability for downstream processing.

The view references a second table, shown truncated as PSB_ACCOUNT_POSITI... with alias FL, from which the MEANING column is drawn. This is presumed to be a lookup or flex-value table supplying the decoded meaning for the include/exclude indicator. Because the excerpt is truncated, the exact join predicate is not documented in the available metadata; referenced base objects are therefore listed as "none documented" in the ETRM record. Consumers should treat the FL join as a lookup translation and verify the actual join keys in the deployed environment.

Key Columns

• LINE_SEQUENCE_ID — Unique identifier for each position set line.
• ACCOUNT_POSITION_SET_ID — Foreign key to the parent account position set header.
• DESCRIPTION — User-entered description of the line.
• BUSINESS_GROUP_ID — Multi-org / business group ownership column.
• ATTRIBUTE_ID — Links the line to a flexfield attribute definition.
• INCLUDE_OR_EXCLUDE_TYPE — Stored code indicating whether the line includes or excludes matching accounts. This is the column decoded by the view.
• SEGMENT1_LOW through SEGMENT30_LOW — Low range values for each accounting flexfield segment.
• SEGMENT1_HIGH through SEGMENT30_HIGH — High range values, enabling inclusive range specification per segment.
• MEANING — Decoded, user-readable text for INCLUDE_OR_EXCLUDE_TYPE, sourced from the FL alias.
• Standard WHO/audit columns — CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN.
• CONTEXT and ATTRIBUTE1–ATTRIBUTE10 — Descriptive flexfield columns.

The include/exclude meaning is the practical focus of the view: consumers searching for "include_or_exclude_meaning" are seeking the decoded value rather than the raw type code.

Common Use Cases and Queries

Typical reporting scenarios include reconciling which account combinations are included versus excluded within a position set, and feeding budgets or position control logic that depends on range-based account selection.

Listing lines for a specific position set with decoded meaning:

• SELECT LINE_SEQUENCE_ID, DESCRIPTION, INCLUDE_OR_EXCLUDE_TYPE, MEANING FROM PSB_ACCT_POSITION_SET_LINES_V WHERE ACCOUNT_POSITION_SET_ID = :set_id ORDER BY LINE_SEQUENCE_ID;

Filtering to exclusion lines only:

• SELECT LINE_SEQUENCE_ID, MEANING, SEGMENT1_LOW, SEGMENT1_HIGH FROM PSB_ACCT_POSITION_SET_LINES_V WHERE INCLUDE_OR_EXCLUDE_TYPE = 'E';

Because the object is flagged obsolete and not implemented in the documented database, any query should be preceded by an all_objects check to confirm existence before deployment in a report or interface.