Search Results as_forecast_actuals

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:

AR_REVENUE_ADJUSTMENTS_ALL: Links via FROM_SALESGROUP_ID and TO_SALESGROUP_ID to denote groups involved in revenue transfers.
AR_COLLECTORS: Links via RESOURCE_ID, associating a collector with a group.
Sales Force (AS) Objects: Central to sales operations, linked to AS_LEADS_ALL (OWNER_SALES_GROUP_ID), AS_SALES_CREDITS (SALESGROUP_ID), AS_FORECAST_ACTUALS (SALES_GROUP_ID), and others for team-based ownership and crediting.
Service (CS) Objects: Referenced by CS_INCIDENTS_ALL_B (INCIDENT_OWNER_ID) for group-owned service requests.
Approval Objects: Used in ASO_APR_RULE_APPROVERS and ASO_APR_APPROVAL_DET_B (JTF_RS_APPROVER_GROUP_ID) to define group-based approval rules.
Other Dependencies: The table is also referenced by objects in Marketing (AMS), Web Channels (AMV), and Financial Intelligence (FII), underscoring its cross-module importance.

Table: JTF_RS_GROUPS_B 12.2.2
owner:JTF, object_type:TABLE, fnd_design_data:JTF.JTF_RS_GROUPS_B, object_name:JTF_RS_GROUPS_B, status:VALID, product: JTF - CRM Foundation , description: Base Table JTF_RS_GROUPS_B stores general information about a given Group. , implementation_dba_data: JTF.JTF_RS_GROUPS_B ,
Table: JTF_RS_GROUPS_B 12.1.1
owner:JTF, object_type:TABLE, fnd_design_data:JTF.JTF_RS_GROUPS_B, object_name:JTF_RS_GROUPS_B, status:VALID, product: JTF - CRM Foundation , description: Base Table JTF_RS_GROUPS_B stores general information about a given Group. , implementation_dba_data: JTF.JTF_RS_GROUPS_B ,
Table: JTF_RS_RESOURCE_EXTNS 12.1.1
owner:JTF, object_type:TABLE, fnd_design_data:JTF.JTF_RS_RESOURCE_EXTNS, object_name:JTF_RS_RESOURCE_EXTNS, status:VALID, product: JTF - CRM Foundation , description: This is table stores all important information about Resources. These Resources are coming from HR or HZ or Vonder table etc. Primary key is resource_id. Resource_number, user_id sre also unique keys. , implementation_dba_data: JTF.JTF_RS_RESOURCE_EXTNS ,
Table: JTF_RS_RESOURCE_EXTNS 12.2.2
owner:JTF, object_type:TABLE, fnd_design_data:JTF.JTF_RS_RESOURCE_EXTNS, object_name:JTF_RS_RESOURCE_EXTNS, status:VALID, product: JTF - CRM Foundation , description: This is table stores all important information about Resources. These Resources are coming from HR or HZ or Vonder table etc. Primary key is resource_id. Resource_number, user_id sre also unique keys. , implementation_dba_data: JTF.JTF_RS_RESOURCE_EXTNS ,