Search Results users




The JTF_AUTH_PRINCIPAL_MAPS table in Oracle E-Business Suite (EBS) versions 12.1.1 and 12.2.2 is a critical component of the Java Topology Framework (JTF) security infrastructure. It serves as a mapping table that associates security principals (users, roles, or groups) with their corresponding authorization contexts, enabling fine-grained access control within the application. This table is part of the broader Oracle Application Framework (OAF) and plays a pivotal role in enforcing role-based security policies.

Purpose and Functionality

The primary purpose of JTF_AUTH_PRINCIPAL_MAPS is to store mappings between security principals and the resources or functions they are authorized to access. It acts as a bridge between the authentication layer and authorization rules, ensuring that users or roles have appropriate permissions to perform specific actions. The table supports Oracle EBS's modular security model by allowing administrators to define access controls at a granular level, such as restricting access to specific pages, regions, or business objects.

Key Columns and Structure

The table consists of several important columns, including:
  • PRINCIPAL_ID: A unique identifier for the security principal (user, role, or group).
  • PRINCIPAL_TYPE: Specifies whether the principal is a user (USER), role (ROLE), or group (GROUP).
  • RESOURCE_ID: Identifies the secured resource (e.g., a page, function, or data object).
  • RESOURCE_TYPE: Defines the type of resource being secured (e.g., PAGE, REGION, or BUSINESS_OBJECT).
  • ACCESS_LEVEL: Indicates the level of access granted (e.g., READ, WRITE, or ADMIN).
  • START_DATE and END_DATE: Optional columns for time-based access control.

Integration with Oracle EBS Security

The JTF_AUTH_PRINCIPAL_MAPS table integrates with Oracle EBS's security framework by working alongside other key tables such as JTF_AUTH_PRINCIPALS (stores principal details) and JTF_AUTH_RESOURCES (defines securable resources). When a user attempts to access a resource, the system queries this table to validate permissions, ensuring compliance with configured security policies. This mechanism is particularly important in multi-org environments where access must be restricted based on responsibilities or organizational hierarchies.

Customization and Extensibility

Oracle EBS allows customization of security mappings through APIs or direct table updates (with caution). Administrators can extend the default security model by adding custom principals or resources, leveraging the JTF_AUTH_PRINCIPAL_MAPS table to enforce new access rules. However, modifications should be performed using supported methods to avoid compromising system integrity.

Performance Considerations

Given its role in authorization checks, the JTF_AUTH_PRINCIPAL_MAPS table must be optimized for quick lookups. Oracle EBS employs indexing strategies on key columns like PRINCIPAL_ID and RESOURCE_ID to ensure efficient query performance. Regular maintenance, such as purging obsolete mappings, is recommended to prevent bloating and degradation in security validation speed.

Conclusion

The JTF_AUTH_PRINCIPAL_MAPS table is a cornerstone of Oracle EBS's security architecture, enabling precise control over user access to application resources. Its design supports scalability, flexibility, and compliance with enterprise security requirements. Proper understanding and management of this table are essential for maintaining a secure and performant Oracle EBS environment.

  • Concurrent Program: MIGRATE_PRIMARY_USERS 12.2.2

    execution_filename: JTF_UM_USERTYPE_CREDENTIALS.UPGRADE_PRIMARY_USER ,  product: JTF - CRM Foundation ,  user_name: Migration Of Primary Users ,  description: Migrates Primary users of existing organization to Business users ,  argument_method: Standard ,  enabled: Yes ,  execution_method: PL/SQL Stored Procedure , 

  • Concurrent Program: MIGRATE_PRIMARY_USERS 12.1.1

    execution_filename: JTF_UM_USERTYPE_CREDENTIALS.UPGRADE_PRIMARY_USER ,  product: JTF - CRM Foundation ,  user_name: Migration Of Primary Users ,  description: Migrates Primary users of existing organization to Business users ,  argument_method: Standard ,  enabled: Yes ,  execution_method: PL/SQL Stored Procedure , 

  • Lookup Type: JTF_USER_PROFILE_TYPE 12.2.2

    product: JTF - CRM Foundation ,  meaning: JTF_USER_PROFILE_TYPE ,  description: JTF_USER_PROFILE_TYPE , 

  • Lookup Type: JTF_USER_PROFILE_TYPE 12.1.1

    product: JTF - CRM Foundation ,  meaning: JTF_USER_PROFILE_TYPE ,  description: JTF_USER_PROFILE_TYPE , 

  • Table: JTF_AUTH_PRINCIPAL_MAPS 12.1.1

    owner:JTF,  object_type:TABLE,  fnd_design_data:JTF.JTF_AUTH_PRINCIPAL_MAPS,  object_name:JTF_AUTH_PRINCIPAL_MAPS,  status:VALID,  product: JTF - CRM Foundation ,  description: This table will be used to grant roles to users by making users [JTF_AUTH_PARENT_PRINCIPAL_ID] parents of the roles [JTF_AUTH_PRINCIPAL_ID] on a domain basis [JTF_AUTH_DOMAIN_ID] ,  implementation_dba_data: JTF.JTF_AUTH_PRINCIPAL_MAPS , 

  • Table: JTF_AUTH_PRINCIPAL_MAPS 12.2.2

    owner:JTF,  object_type:TABLE,  fnd_design_data:JTF.JTF_AUTH_PRINCIPAL_MAPS,  object_name:JTF_AUTH_PRINCIPAL_MAPS,  status:VALID,  product: JTF - CRM Foundation ,  description: This table will be used to grant roles to users by making users [JTF_AUTH_PARENT_PRINCIPAL_ID] parents of the roles [JTF_AUTH_PRINCIPAL_ID] on a domain basis [JTF_AUTH_DOMAIN_ID] ,  implementation_dba_data: JTF.JTF_AUTH_PRINCIPAL_MAPS , 

  • Table: JTF_RS_TABLE_ATTRIBUTES_B 12.1.1

    owner:JTF,  object_type:TABLE,  fnd_design_data:JTF.JTF_RS_TABLE_ATTRIBUTES_B,  object_name:JTF_RS_TABLE_ATTRIBUTES_B,  status:VALID,  product: JTF - CRM Foundation ,  description: Base Table JTF_RS_TABLE_ATTRIBUTES_B stores general information of Table attributes that can be modified by users ,  implementation_dba_data: JTF.JTF_RS_TABLE_ATTRIBUTES_B , 

  • Table: JTF_RS_TABLE_ATTRIBUTES_B 12.2.2

    owner:JTF,  object_type:TABLE,  fnd_design_data:JTF.JTF_RS_TABLE_ATTRIBUTES_B,  object_name:JTF_RS_TABLE_ATTRIBUTES_B,  status:VALID,  product: JTF - CRM Foundation ,  description: Base Table JTF_RS_TABLE_ATTRIBUTES_B stores general information of Table attributes that can be modified by users ,  implementation_dba_data: JTF.JTF_RS_TABLE_ATTRIBUTES_B , 

  • Table: JTF_IH_MEDIA_ITEMS_STG_LOG 12.1.1

    owner:JTF,  object_type:TABLE,  fnd_design_data:JTF.JTF_IH_MEDIA_ITEMS_STG_LOG,  object_name:JTF_IH_MEDIA_ITEMS_STG_LOG,  status:VALID,  product: JTF - CRM Foundation ,  description: An instance of media that was processed by the system and/or its users. Media Items can be generated by a customer or by the system or an application. Media Items can be inbound (ex. Mail or call from a customer/person ) or outbound (ex. ,  implementation_dba_data: JTF.JTF_IH_MEDIA_ITEMS_STG_LOG , 

  • Table: JTF_IH_MEDIA_ITEMS_STG_LOG 12.2.2

    owner:JTF,  object_type:TABLE,  fnd_design_data:JTF.JTF_IH_MEDIA_ITEMS_STG_LOG,  object_name:JTF_IH_MEDIA_ITEMS_STG_LOG,  status:VALID,  product: JTF - CRM Foundation ,  description: An instance of media that was processed by the system and/or its users. Media Items can be generated by a customer or by the system or an application. Media Items can be inbound (ex. Mail or call from a customer/person ) or outbound (ex. ,  implementation_dba_data: JTF.JTF_IH_MEDIA_ITEMS_STG_LOG , 

  • Table: JTF_IH_MEDIA_ITEMS_STG 12.1.1

    owner:JTF,  object_type:TABLE,  fnd_design_data:JTF.JTF_IH_MEDIA_ITEMS_STG,  object_name:JTF_IH_MEDIA_ITEMS_STG,  status:VALID,  product: JTF - CRM Foundation ,  description: An instance of media that was processed by the system and/or its users. Media Items can be generated by a customer or by the system or an application. Media Items can be inbound (ex. Mail or call from a customer/person ) or outbound (ex. ,  implementation_dba_data: JTF.JTF_IH_MEDIA_ITEMS_STG , 

  • Table: JTF_IH_MEDIA_ITEMS_STG 12.2.2

    owner:JTF,  object_type:TABLE,  fnd_design_data:JTF.JTF_IH_MEDIA_ITEMS_STG,  object_name:JTF_IH_MEDIA_ITEMS_STG,  status:VALID,  product: JTF - CRM Foundation ,  description: An instance of media that was processed by the system and/or its users. Media Items can be generated by a customer or by the system or an application. Media Items can be inbound (ex. Mail or call from a customer/person ) or outbound (ex. ,  implementation_dba_data: JTF.JTF_IH_MEDIA_ITEMS_STG , 

  • Table: JTF_IH_MEDIA_ITEMS 12.1.1

    owner:JTF,  object_type:TABLE,  fnd_design_data:JTF.JTF_IH_MEDIA_ITEMS,  object_name:JTF_IH_MEDIA_ITEMS,  status:VALID,  product: JTF - CRM Foundation ,  description: An instance of media that was processed by the system and/or its users. Media Items can be generated by a customer or by the system or an application. Media Items can be inbound (ex. Mail or call from a customer/person ) or outbound (ex. ,  implementation_dba_data: JTF.JTF_IH_MEDIA_ITEMS , 

  • Table: JTF_IH_MEDIA_ITEMS 12.2.2

    owner:JTF,  object_type:TABLE,  fnd_design_data:JTF.JTF_IH_MEDIA_ITEMS,  object_name:JTF_IH_MEDIA_ITEMS,  status:VALID,  product: JTF - CRM Foundation ,  description: An instance of media that was processed by the system and/or its users. Media Items can be generated by a customer or by the system or an application. Media Items can be inbound (ex. Mail or call from a customer/person ) or outbound (ex. ,  implementation_dba_data: JTF.JTF_IH_MEDIA_ITEMS , 

  • Lookup Type: JTF_MEDIA_TYPE 12.1.1

    product: JTF - CRM Foundation ,  meaning: JTF Media Type ,  description: An instance of media that was processed by the system and/or its users. Media items can be generated by a customer or by a system or an application. Media items can be inbound (e.g., mail or call from a customer). , 

  • Lookup Type: JTF_MEDIA_TYPE 12.2.2

    product: JTF - CRM Foundation ,  meaning: JTF Media Type ,  description: An instance of media that was processed by the system and/or its users. Media items can be generated by a customer or by a system or an application. Media items can be inbound (e.g., mail or call from a customer). , 

  • Lookup Type: JTF_PREFAB_POLICY_LOOKUP_TYPE 12.1.1

    product: JTF - CRM Foundation ,  meaning: JTF Prefab Policy Lookup Type , 

  • Lookup Type: JTF_PREFAB_POLICY_LOOKUP_TYPE 12.2.2

    product: JTF - CRM Foundation ,  meaning: JTF Prefab Policy Lookup Type , 

  • Lookup Type: JTF_OBJECT_USERS 12.1.1

    product: JTF - CRM Foundation ,  meaning: JTF_OBJECT_USERS ,  description: Users for Objects defined in JTF_OBJECTS , 

  • Lookup Type: JTF_OBJECT_USERS 12.2.2

    product: JTF - CRM Foundation ,  meaning: JTF_OBJECT_USERS ,  description: Users for Objects defined in JTF_OBJECTS ,