Search Results psb_position_set_line_values_v




Overview
Explore in AI Chat

Overview

The view PSB_POSITION_SET_LINE_VALUES_V belongs to the PSB – Public Sector Budgeting product within Oracle E-Business Suite. The ETRM metadata classifies PSB as obsolete, and the view itself is explicitly documented as Not implemented in this database. Consequently, the object should be understood as a legacy dictionary definition retained for historical and reference purposes rather than an active reporting or integration interface in Oracle EBS 12.1.1 or 12.2.2.

Functionally, the view was designed to present the attribute values that are assigned to the line records of an account position set. Each row associates a position set line with a specific attribute and the corresponding attribute value, effectively denormalizing the value, line, attribute, and attribute-value dimensions into a single read model. In its original role, this construct supported budget preparation and position-based reporting within Public Sector Budgeting, allowing forms, reports, or batch processes to retrieve line-level attribute values without repeatedly joining the underlying detail tables.

Because the view is not implemented in the current database, no runtime dependencies, grants, or synonyms should be assumed. References to it in custom code, concurrent programs, or legacy BI Publisher reports indicate a dependency on a retired PSB feature set and normally require replacement or removal during upgrades.

Underlying Base Objects

The documented view text defines the object over four PSB base tables using outer joins:

Although the ETRM 12.2.2 metadata records no referenced base objects, the embedded view text above provides the authoritative join definition. The outer-join operators indicate that lines may exist without a matching attribute, and values may exist without a matching attribute value decode, so the view tolerates incomplete configuration data. Because the underlying tables are also part of the obsolete PSB schema, the join integrity cannot be relied upon in a supported 12.2.2 environment.

Key Columns

The view exposes the following columns, whose meanings are as follows:

  • ROW_ID — the row identifier of the underlying PSB_POSITION_SET_LINE_VALUES record.
  • VALUE_SEQUENCE_ID — primary surrogate key of the line value record.
  • LINE_SEQUENCE_ID — foreign key to the position set line to which the value belongs.
  • ATTRIBUTE_VALUE_ID — foreign key to the stored attribute value.
  • ATTRIBUTE_VALUE — the raw value held on the line value record.
  • LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN, CREATED_BY, CREATION_DATE — standard WHO audit columns tracking creation and modification.
  • ATTRIBUTE_ID — the attribute associated with the line, sourced from PSB_ACCOUNT_POSITION_SET_LINES.
  • ATTRIBUTE_NAME — descriptive name of the attribute from PSB_ATTRIBUTES.
  • ATTRIBUTE_VALUE_TABLE_FLAG — flag indicating whether the attribute draws its values from a value table.
  • ATTRIBUTE_TABLE_VALUE — the decoded value from PSB_ATTRIBUTE_VALUES.

Common Use Cases and Queries

In historical PSB implementations, the view was queried to list the attribute values attached to each position set line, typically for budget worksheets, position control reports, and interface extracts feeding downstream budgeting processes. A representative query follows:

SELECT line_sequence_id, attribute_name, attribute_value, attribute_table_value
FROM psb_position_set_line_values_v
WHERE attribute_value IS NOT NULL
ORDER BY line_sequence_id;

Another common pattern filtered by attribute to reconcile all lines carrying a given attribute:

SELECT attribute_name, line_sequence_id, attribute_table_value
FROM psb_position_set_line_values_v
WHERE attribute_value_table_flag = 'Y';

Given the obsolete status and the Not implemented designation, these queries will not execute successfully in a standard 12.1.1 or 12.2.2 environment unless the legacy PSB schema objects were manually preserved. Any dependency should be re-pointed to supported budget or position data sources during remediation.