Search Results obj_type_map_id




Overview
Explore in AI Chat

Overview

The JTF_PERZ_OBJ_TYPE_MAP table is a core metadata repository within the Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2, specifically under the Oracle Applications Technology (JTF) schema. It serves as a pivotal mapping table for the personalization framework, which governs the look, feel, and behavior of application user interfaces. Its primary role is to define the permissible relationships between object types and their associated attributes, establishing a structured model for how personalization rules and settings are applied. By storing these mappings, the table acts as a control layer, ensuring that only valid and predefined attributes can be linked to a given object type, thereby maintaining data integrity within the personalization engine.

Key Information Stored

The table's structure is designed to capture the mapping relationship along with standard audit information. The key columns include:

Unique indexes enforce data integrity, preventing duplicate mappings for the same combination of object type and attribute.

Common Use Cases and Queries

This table is primarily accessed for metadata queries, troubleshooting, and impact analysis within the personalization framework. Common scenarios include identifying all configurable attributes for a given object type, or verifying if a specific attribute mapping exists before applying a personalization rule. A typical diagnostic query would join to the related lookup tables for clarity:

SELECT m.OBJ_TYPE_MAP_ID, ot.OBJECT_TYPE_NAME, a.ATTRIBUTE_NAME
FROM JTF.JTF_PERZ_OBJ_TYPE_MAP m,
    JTF.JTF_PERZ_LF_OBJECT_TYPE ot,
    JTF.JTF_PERZ_LF_ATTRIB a
WHERE m.OBJECT_TYPE_ID = ot.OBJECT_TYPE_ID
AND m.ATTRIBUTE_ID = a.ATTRIBUTE_ID
AND ot.OBJECT_TYPE_NAME = 'FND_FLEX_VALUE';

This query returns all mappable attributes for the 'FND_FLEX_VALUE' object type. The table is also critical when analyzing dependencies, as changes to a mapping could affect existing personalization rules stored in related tables.

Related Objects

JTF_PERZ_OBJ_TYPE_MAP sits at the center of a key relationship chain in the personalization data model. Based on the provided relationship data:

  • Referenced by Foreign Keys (Parent Tables):
    • JTF_PERZ_LF_OBJECT_TYPE: Via the OBJECT_TYPE_ID column. This table defines the master list of object types.
    • JTF_PERZ_LF_ATTRIB: Via the ATTRIBUTE_ID column. This table defines the master list of available attributes.
  • Referenced by Foreign Key (Child Table):
    • JTF_PERZ_OBJ_MAP: The MAP_ID column in this table references OBJ_TYPE_MAP_ID. This is the most critical relationship, as JTF_PERZ_OBJ_MAP stores the actual personalized values for specific object instances, linking them back to the valid type-attribute mapping defined here.