Search Results jtf_perz_data




Overview
Explore in AI Chat

Overview

The JTF_PERZ_DATA table is a core data repository within the Oracle E-Business Suite CRM Foundation (JTF) module. It serves as the primary storage location for personalized data objects, which are integral to the personalization and customization features of the CRM applications. Its role is to persistently store the core definitions and metadata for these objects, enabling user-specific or profile-specific customizations of the application's behavior, layout, or data presentation without modifying the underlying base code. This table is fundamental to the personalization engine across EBS versions 12.1.1 and 12.2.2.

Key Information Stored

While the provided metadata does not list specific columns, the documented primary and foreign key relationships define its critical structure. The primary identifier is the PERZ_DATA_ID column, which uniquely defines each personalized data object record. A key relational column is PROFILE_ID, which links each data object to a specific personalization profile defined in the JTF_PERZ_PROFILE table. This linkage associates the stored data object with a particular user, responsibility, or site-level context. The table's core purpose is to store the serialized or structured definition of the personalized object itself, which is then referenced by the system's personalization runtime.

Common Use Cases and Queries

This table is primarily accessed by the EBS personalization framework, not directly by end-users. Common operational scenarios include the system saving a new user-customized view of a CRM page or retrieving the personalized layout for a specific function upon user login. A typical reporting or diagnostic query might join to the profile table to analyze personalizations by user. For example:

  • Identifying all personalized data objects for a specific profile: SELECT * FROM jtf.jtf_perz_data WHERE profile_id = <PROFILE_VALUE>;
  • Joining to attribute details: SELECT pzd.*, pzda.* FROM jtf.jtf_perz_data pzd, jtf.jtf_perz_data_attrib pzda WHERE pzd.perz_data_id = pzda.perz_data_id;

Direct data manipulation (DML) on this table should be performed cautiously, typically via supported personalization APIs or the application's personalization screens.

Related Objects

The JTF_PERZ_DATA table sits at the center of a key personalization data model, with documented relationships to two other core tables.

  • JTF_PERZ_PROFILE: This table is referenced via a foreign key. The column JTF_PERZ_DATA.PROFILE_ID references JTF_PERZ_PROFILE, establishing the profile to which a data object belongs.
  • JTF_PERZ_DATA_ATTRIB: This table references JTF_PERZ_DATA. The column JTF_PERZ_DATA_ATTRIB.PERZ_DATA_ID is a foreign key to JTF_PERZ_DATA, indicating that detailed attribute information for a personalized data object is stored in this child table.

These relationships form a hierarchy: Profile (JTF_PERZ_PROFILE) → Data Object (JTF_PERZ_DATA) → Object Attributes (JTF_PERZ_DATA_ATTRIB).