Search Results jtf_rs_groups_b




Overview
Explore in AI Chat

Overview

The table JTF_RS_GROUPS_B is a core data entity within the Oracle E-Business Suite (EBS) CRM Foundation module (JTF). It serves as the base table for storing the fundamental definition and attributes of a "Group." In the context of Oracle CRM and related applications, a Group is a logical collection of resources, typically used to model organizational structures such as sales teams, service teams, or approval committees. This table is central to the Resource Manager (RS) functionality, enabling the assignment, management, and reporting of tasks, opportunities, leads, and service requests to teams rather than solely to individuals. Its integrity is critical for workflows across Sales (AS), Service (CS), and Financials (AR) modules that leverage group-based operations.

Key Information Stored

While the provided metadata does not list specific columns, the primary key is documented as GROUP_ID. This unique identifier is the critical column referenced throughout the system. Based on standard JTF_RS_GROUPS_B implementation, other typical columns include GROUP_NUMBER, GROUP_NAME, START_DATE_ACTIVE, END_DATE_ACTIVE, and ENABLED_FLAG, which manage the group's lifecycle. Additional columns often store descriptive information, email addresses, and links to parent groups or categories. The table's "B" suffix indicates it is the base table for a multi-language support (MLS) entity, with corresponding translated data stored in a related "_TL" table (e.g., JTF_RS_GROUPS_TL).

Common Use Cases and Queries

This table is primarily accessed to resolve group identities for transactional data and security rules. A frequent use case, directly relevant to the user's search for "ar_revenue_adjustments_all," is identifying the sales groups involved in revenue adjustments. For example, to report on all revenue adjustments with their associated 'From' and 'To' sales groups, one would join as follows:

  • SELECT adj.*, from_grp.GROUP_NAME FROM_GROUP, to_grp.GROUP_NAME TO_GROUP FROM ar_revenue_adjustments_all adj, jtf_rs_groups_b from_grp, jtf_rs_groups_b to_grp WHERE adj.from_salesgroup_id = from_grp.group_id AND adj.to_salesgroup_id = to_grp.group_id;

Other common scenarios include listing all active sales groups for a forecast, assigning a new lead to a specific team, or determining the approval chain for a quote. Queries often filter on END_DATE_ACTIVE and ENABLED_FLAG to find currently valid groups.

Related Objects

JTF_RS_GROUPS_B is a heavily referenced parent table. As per the documented foreign keys, its GROUP_ID column is joined to numerous transactional and setup tables across EBS. Key relationships include: