Search Results modify_flag




Overview
Explore in AI Chat

Overview

APPS.PSB_POSITION_ASSIGN_ATTR_V is a supplementary view in the Oracle EBS Public Sector Budgeting (PSB) module. It is a forms-coding helper view, meaning it was designed to simplify the way Oracle Forms-based application screens display and manipulate position assignment attribute data. The Oracle ETRM metadata explicitly warns that Oracle does not recommend querying or altering data through this view due to its potential to change dramatically across minor or major releases. Despite this caveat, the view remains accessible for read-only reporting and integration scenarios in both 12.1.1 and 12.2.2.

The view combines attribute definitions, attribute values, and position assignment data into a single flattened structure that would otherwise require joining multiple tables. This makes it useful for anyone building reports or extracts that need position assignment attribute information in a denormalized format. The presence of the MODIFY_FLAG column is significant: it indicates whether a particular attribute value in a worksheet may be modified by the user, which is central to understanding how PSB worksheets enforce editing rules.

Underlying Base Objects

The view is defined over several documented base objects in the APPS schema:

The view has no dependents; no other database object references it, confirming its role as a terminal, presentation-oriented construct. Its status is VALID, and its FND design data identifier is PSB.PSB_POSITION_ASSIGN_ATTR_V.

Key Columns

The view exposes a set of columns that together describe a position assignment attribute and its governing rules:

Common Use Cases and Queries

The most common use case is investigating why a position assignment attribute can or cannot be changed within a PSB worksheet. A representative query filters on MODIFY_FLAG:

  • SELECT POSITION_ASSIGNMENT_ID, ATTRIBUTE_NAME, ATTRIBUTE_VALUE, MODIFY_FLAG FROM APPS.PSB_POSITION_ASSIGN_ATTR_V WHERE MODIFY_FLAG = 'Y';
  • SELECT ATTRIBUTE_NAME, ATTRIBUTE_VALUE, EFFECTIVE_START_DATE, EFFECTIVE_END_DATE FROM APPS.PSB_POSITION_ASSIGN_ATTR_V WHERE POSITION_ASSIGNMENT_ID = :assignment_id;
  • SELECT ATTRIBUTE_NAME, GLOBAL_DEFAULT_FLAG, ASSIGNMENT_DEFAULT_RULE_ID FROM APPS.PSB_POSITION_ASSIGN_ATTR_V WHERE POSITION_ID = :position_id;

Because the view is flagged as not recommended for direct querying, production integrations should ideally reproduce its logic against the base tables. Nevertheless, for ad-hoc diagnostics and understanding worksheet behavior, PSB_POSITION_ASSIGN_ATTR_V provides a convenient and informative access point.