Search Results required_for_import_flag

Overview

PSB_ATTRIBUTES_VL is a seeded, MLS-compliant (Multi-Language Support) view owned by the APPS schema in Oracle E-Business Suite, belonging to the Public Sector Budgeting (PSB) product family. It exposes the descriptive and configuration metadata that drives the definition of budgeting attributes — the user-defined and system-defined data elements used within PSB worksheets, position sets, and budget import processes. Because attribute metadata controls how budget lines are captured, validated, displayed, and imported, this view is central to any reporting or integration effort that must understand which attributes exist, how they behave, and under what constraints they are presented to end users.

The view conforms to Oracle's standard MLS pattern, joining a base (language-independent) table to its translation table on ATTRIBUTE_ID, restricted to the session language via USERENV('LANG'). It also joins PER_BUSINESS_GROUPS to resolve the business group name. For the 12.1.1 and 12.2.2 releases, the object is documented as VALID in ETRM, with the view text published for reference.

Underlying Base Objects

Although the ETRM metadata lists no referenced base objects, the published view text identifies the constituent tables unambiguously:

• PSB_ATTRIBUTES B — the primary language-independent attribute definition table, supplying all configuration and structural columns.
• PSB_ATTRIBUTES_TL T — the translation table storing the user-facing NAME and DISPLAY_PROMPT, joined on ATTRIBUTE_ID and filtered by LANGUAGE = USERENV('LANG').
• PER_BUSINESS_GROUPS C — joined on BUSINESS_GROUP_ID to expose BUSINESS_GROUP_NAME.

The _VL suffix indicates a "view language" object, meaning it presents translated (TL) content joined to base content as a single consumable row per attribute per language. It is read-only and carries no DML triggers of its own.

Key Columns

• ATTRIBUTE_ID — the surrogate primary key linking base and translated records.
• NAME / DISPLAY_PROMPT — the translated attribute label and the prompt rendered in PSB worksheets.
• REQUIRED_FOR_IMPORT_FLAG — indicates whether the attribute must be populated when budgeting data is brought in through an import process. This column is frequently queried to build validation rules or reconciliation reports.
• REQUIRED_FOR_POSITIONS_FLAG — whether the attribute is mandatory for position-based budgeting.
• DATA_TYPE / ATTRIBUTE_TYPE_ID / SYSTEM_ATTRIBUTE_TYPE — classification of the attribute (e.g., numeric, character, date) and whether it is a system-seeded or user-defined type.
• DEFINITION_STRUCTURE / DEFINITION_TABLE / DEFINITION_COLUMN — the physical source of the attribute's values, useful when tracing the origin of an attribute.
• DISPLAY_SEQUENCE / DISPLAY_IN_WORKSHEET — ordering and visibility controls in the worksheet UI.
• BUSINESS_GROUP_ID / BUSINESS_GROUP_NAME — partitioning by business group, essential for multi-org reporting.
• ALLOW_IN_POSITION_SET_FLAG, VALUE_TABLE_FLAG, PROTECTED_FLAG — behavioral flags governing usability and editability.
• APPLICATION_ID, DEFINITION_TYPE — registration metadata for the owning application and attribute definition type.
• Audit columns — CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN, and ROW_ID.

Common Use Cases and Queries

Typical applications include building a catalog of budgeting attributes, auditing mandatory import fields before a budget load, and generating worksheet layout specifications. A representative query locating attributes required during import is:

SELECT attribute_id, name, display_prompt,
       required_for_import_flag, data_type
FROM   apps.psb_attributes_vl
WHERE  required_for_import_flag = 'Y';

To review worksheet display configuration for a business group:

SELECT name, display_prompt, display_sequence
FROM   apps.psb_attributes_vl
WHERE  business_group_id = :p_bg_id
AND    display_in_worksheet = 'Y'
ORDER  BY display_sequence;

These queries support reporting, integration mapping, and pre-import validation in both 12.1.1 and 12.2.2 environments.