Search Results obj_map_id

Overview

The JTF_PERZ_OBJ_MAP table is a core data object within the Oracle E-Business Suite CRM Foundation (JTF) module, specifically for versions 12.1.1 and 12.2.2. It functions as a central mapping table within the personalization framework, which governs the look and feel of the application. Its primary role is to store the concrete linkage between a defined look and feel object instance and the specific attribute values that personalize its appearance or behavior for a given context. This table is essential for the runtime resolution of personalized UI components, enabling the CRM application to dynamically render interfaces based on user, responsibility, or site-level customizations.

Key Information Stored

The table's structure is designed to establish and maintain these instance-to-value mappings. The most critical column is OBJ_MAP_ID, which serves as the unique primary key identifier for each mapping record. Other significant foreign key columns define the relationships that give the map its context. The MAP_ID column links to the JTF_PERZ_OBJ_TYPE_MAP table, connecting this specific instance mapping to a broader object type mapping definition. The OBJECT_ID column references the JTF_PERZ_LF_OBJECT table, identifying the exact look and feel object instance being configured. While the provided metadata does not list all columns, the table's description confirms it stores the mapping to "actual values for the attributes," implying it holds or references the concrete data that populates the object's attributes.

Common Use Cases and Queries

This table is primarily accessed for troubleshooting, auditing, and administrative reporting of personalization setups. A common scenario involves identifying all personalized attribute values associated with a particular look and feel object instance. A sample query to achieve this would join JTF_PERZ_OBJ_MAP to JTF_PERZ_LF_VALUE via the OBJ_MAP_ID. Another frequent use case is tracing the inheritance or source of a specific personalization rule by joining through MAP_ID to the type mapping definitions. Database administrators or functional consultants may run diagnostic queries against this table to resolve conflicts where multiple personalization rules apply to the same object, using the OBJ_MAP_ID as the key traceable element.

Related Objects

The JTF_PERZ_OBJ_MAP table exists within a tightly defined schema of personalization objects, as evidenced by its documented foreign key relationships.

• Referenced By (Parent Tables):
  • JTF_PERZ_OBJ_TYPE_MAP: Linked via JTF_PERZ_OBJ_MAP.MAP_ID. This defines the higher-level mapping of an object type to a source.
  • JTF_PERZ_LF_OBJECT: Linked via JTF_PERZ_OBJ_MAP.OBJECT_ID. This defines the look and feel object instance itself.
• Referencing Table (Child Table):
  • JTF_PERZ_LF_VALUE: References this table via JTF_PERZ_LF_VALUE.OBJ_MAP_ID. This table stores the actual attribute values, completing the personalization chain by linking specific data to the mapping instance defined here.