Search Results jtf_um_usertypes_b




Overview
Explore in AI Chat

Overview

The table JTF_UM_USERTYPES_B is a core data object within the Oracle E-Business Suite (EBS) CRM Foundation module (JTF). It serves as the base table for defining and managing user types, which are fundamental classifications within the User Management (UM) framework. User types categorize end-users, such as employees, partners, or customers, enabling the systematic assignment of roles, responsibilities, subscriptions, and registration workflows. This table is critical for implementing a structured, role-based access control and provisioning system across CRM and related EBS applications in both versions 12.1.1 and 12.2.2.

Key Information Stored

The table's structure centers on two primary keys, ensuring data integrity and unique identification. The column USERTYPE_ID is the immutable internal primary key (JTF_UM_USERTYPES_B_PK) used for all foreign key relationships. The composite key (JTF_UM_USERTYPES_B_U1) on USERTYPE_KEY and EFFECTIVE_START_DATE supports effective-dated tracking of user type definitions, allowing for changes over time. While the provided ETRM excerpt does not list all columns, the presence of EFFECTIVE_START_DATE implies a corresponding EFFECTIVE_END_DATE column for managing the lifecycle of a user type definition. The USERTYPE_KEY column typically stores a unique, meaningful code for the user type, such as 'EMPLOYEE' or 'PARTNER'.

Common Use Cases and Queries

This table is primarily accessed for user management configuration and security reporting. Common operational scenarios include auditing the assignment of roles and responsibilities by user type, managing subscription lists for mass communications, and configuring self-service registration templates. A typical query retrieves all active user types and their associated translatable names from the corresponding TL (Translation) table.

Sample Query:
SELECT b.usertype_id, b.usertype_key, tl.name
FROM jtf_um_usertypes_b b,
jtf_um_usertypes_tl tl
WHERE b.usertype_id = tl.usertype_id
AND tl.language = USERENV('LANG')
AND SYSDATE BETWEEN b.effective_start_date
AND NVL(b.effective_end_date, SYSDATE+1);

Data in this table is typically maintained via the Oracle User Management administrative screens, not via direct SQL manipulation.

Related Objects

JTF_UM_USERTYPES_B is a central parent table with numerous child relationships, as documented in the ETRM. The USERTYPE_ID column is referenced by the following key tables in the User Management schema:

These relationships illustrate that JTF_UM_USERTYPES_B acts as the primary driver for configuring the entire user provisioning and security model for a given class of users within Oracle EBS.