Search Results psb_flex_mapping_sets




Overview
Explore in AI Chat

Overview

The PSB_FLEX_MAPPING_SETS table is a core repository object within Oracle E-Business Suite Public Sector Budgeting (PSB) modules. It functions as the master definition table for flexfield mapping sets, which are critical configuration components. These mapping sets establish the rules and relationships for translating or mapping values between different flexfield segments, typically between different chart of accounts structures or between budgetary and general ledger accounting flexfields. This enables the complex fund accounting, budgetary control, and financial reporting required by public sector entities, ensuring data integrity and consistency across the budgeting lifecycle.

Key Information Stored

The table's primary purpose is to store the unique identifier and control attributes for each defined mapping set. The central column is FLEX_MAPPING_SET_ID, which serves as the system-generated primary key and unique identifier for a mapping set. While the provided ETRM metadata does not list all columns, typical supporting columns in such a definition table would include a NAME or CODE for the mapping set, a DESCRIPTION, an ENABLED_FLAG to control active status, and columns for tracking creation and modification dates (CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE). This structure allows administrators to define, version, and manage multiple distinct mapping rules for different transactional scenarios or organizational units.

Common Use Cases and Queries

This table is primarily accessed during the setup and maintenance of PSB flexfield mapping rules. A common administrative task is querying all active mapping sets for review or assignment. A typical query would be: SELECT flex_mapping_set_id, name, description FROM psb_flex_mapping_sets WHERE enabled_flag = 'Y' ORDER BY name;. During budget entry or journal import processes, the PSB application logic references these mapping set definitions to determine the correct value translation rules. Troubleshooting often involves joining this table with its child table, PSB_FLEX_MAPPING_SET_VALUES, to verify the complete rule definition: SELECT def.name, val.* FROM psb_flex_mapping_sets def, psb_flex_mapping_set_values val WHERE def.flex_mapping_set_id = val.flex_mapping_set_id AND def.name = '&MAPPING_SET_NAME';.

Related Objects

The PSB_FLEX_MAPPING_SETS table has a direct parent-child relationship with the PSB_FLEX_MAPPING_SET_VALUES table, as documented in the provided foreign key metadata. The relationship is defined as follows:

  • PSB_FLEX_MAPPING_SET_VALUES: This table holds the individual value mapping rules (e.g., specific segment value translations) that belong to a parent mapping set. It references PSB_FLEX_MAPPING_SETS via the foreign key column PSB_FLEX_MAPPING_SET_VALUES.FLEX_MAPPING_SET_ID, which joins to PSB_FLEX_MAPPING_SETS.FLEX_MAPPING_SET_ID.

This table is also likely referenced by various PSB APIs and public sector budgeting forms that manage the configuration and application of flexfield mapping rules during budgetary transactions and integrations.