Search Results jtf_rs_team_usages

Overview

The JTF_RS_TEAM_USAGES table is a core data object within the Oracle E-Business Suite CRM Foundation (JTF) module, specifically for releases 12.1.1 and 12.2.2. It functions as a junction or assignment table that defines the permissible business contexts, or "usages," for teams defined within the Resource Manager. A team is a logical grouping of resources (employees, partners, etc.), and its usage determines in which application flows and transactions that team can be utilized. This table is essential for enforcing data integrity and ensuring teams are correctly scoped for their intended operational purposes, such as sales, service, or marketing activities.

Key Information Stored

The table's primary purpose is to maintain the association between a team identifier and its assigned usage. The documented structure highlights several critical columns. The TEAM_USAGE_ID column serves as the system-generated unique primary key for each assignment record. The TEAM_ID column is a foreign key that references the base team definition in the JTF_RS_TEAMS_B table. The USAGE column stores the specific business context code assigned to the team. As per the metadata, the combination of TEAM_ID and USAGE is enforced as a unique key, preventing a single team from being assigned the same usage more than once, while allowing a single team to have multiple distinct usages.

Common Use Cases and Queries

A primary use case is validating whether a specific team is authorized for a particular business process before it is selected in a transaction. For instance, an application UI for assigning a service request would query this table to filter and display only teams with a 'Service' usage. Common reporting needs include listing all teams with their assigned usages or identifying teams that lack a specific required usage. Sample SQL to retrieve this information often involves joining with the teams table:

• SELECT t.team_name, tu.usage FROM jtf_rs_team_usages tu, jtf_rs_teams_b t WHERE tu.team_id = t.team_id ORDER BY t.team_name;
• SELECT team_id FROM jtf_rs_team_usages WHERE usage = 'SALES' AND team_id = :p_team_id; (for validation)

Related Objects

The table maintains a direct and documented foreign key relationship critical to its function. The TEAM_ID column references the TEAM_ID column in the JTF_RS_TEAMS_B table, which is the base table for all team definitions. This relationship ensures that a usage can only be assigned to a valid, existing team. Consequently, JTF_RS_TEAMS_B is the primary parent table. This table is also likely referenced by various CRM application programming interfaces (APIs) and views that manage team assignments and visibility, though these are not explicitly detailed in the provided metadata.