Search Results psb_flex_mapping_set_values




Overview
Explore in AI Chat

Overview

The table PSB_FLEX_MAPPING_SET_VALUES is a core data repository within the Oracle E-Business Suite Public Sector Budgeting (PSB) module. It functions as a child table in the flexfield mapping architecture, which is essential for translating and aligning descriptive flexfield (DFF) segment values across different budgeting contexts. Its primary role is to store the specific, user-defined value mappings that link source and target flexfield segments, enabling consistent data validation and automated value population during budget preparation and maintenance processes in releases 12.1.1 and 12.2.2.

Key Information Stored

The table stores the individual mapping rules that constitute a flexfield mapping set. While the full column list is not detailed in the provided metadata, the documented foreign keys and primary key define its critical structure. The primary key column, FLEX_MAPPING_VALUE_ID, uniquely identifies each mapping value record. The FLEX_MAPPING_SET_ID column links each value to its parent mapping set defined in PSB_FLEX_MAPPING_SETS. The BUDGET_YEAR_TYPE_ID column ties the mapping value to a specific budget calendar or year type from the PSB_BUDGET_YEAR_TYPES table, allowing for mappings that are specific to certain fiscal periods. Other typical columns would include source and target flexfield segment values, enabling the cross-reference logic.

Common Use Cases and Queries

This table is central to configuration tasks and troubleshooting within PSB's flexfield mapping feature. A common use case is reviewing all value mappings for a specific mapping set to validate configuration. Administrators may run queries to audit mappings or diagnose issues where budget data is not inheriting expected flexfield values. A typical reporting query would join to parent tables to provide context.

  • Sample Query: To list all value mappings for a specific mapping set name:
    SELECT v.* FROM psb_flex_mapping_set_values v, psb_flex_mapping_sets s WHERE v.flex_mapping_set_id = s.flex_mapping_set_id AND s.flex_mapping_set_name = '&SET_NAME';
  • Integration Point: During budget entry, the PSB engine references this table to determine the correct target segment value based on a provided source value, budget year, and mapping set.

Related Objects

PSB_FLEX_MAPPING_SET_VALUES has defined dependencies on two key PSB tables, as per the provided relationship data.

  • PSB_FLEX_MAPPING_SETS: This is the parent table. The foreign key relationship is PSB_FLEX_MAPPING_SET_VALUES.FLEX_MAPPING_SET_ID → PSB_FLEX_MAPPING_SETS. A mapping set contains one or more mapping values.
  • PSB_BUDGET_YEAR_TYPES: This table provides context for the budget calendar. The foreign key relationship is PSB_FLEX_MAPPING_SET_VALUES.BUDGET_YEAR_TYPE_ID → PSB_BUDGET_YEAR_TYPES. This allows mapping rules to be effective only for specific budget year types.

As a child table with a system-generated primary key, it is typically populated and maintained via the PSB application's flexfield mapping administration screens, not via direct SQL manipulation.