Search Results account_resource_id

Overview

The JTF_TTY_NAMED_ACCT_RSC table is a core data object within the Oracle E-Business Suite CRM Foundation (JTF) module, specifically supporting the Territory Management functionality. Its primary role is to manage the assignment of specific resources—individuals or groups—to "Named Accounts" within a territory structure. This table acts as the junction point linking a territory account assignment (from JTF_TTY_TERR_GRP_ACCTS) to the responsible sales or service resources (from JTF_RS_RESOURCE_EXTNS or JTF_RS_GROUPS_B). In the context of Oracle EBS 12.1.1 and 12.2.2, it is a critical component for defining and enforcing account coverage models, ensuring that customer accounts are correctly mapped to the appropriate sales teams or individuals for opportunity management, forecasting, and service delivery.

Key Information Stored

While the full column list is not detailed in the provided metadata, the documented foreign key relationships and primary key define its essential structure. The central column is ACCOUNT_RESOURCE_ID, which serves as the unique primary key for each assignment record. The table's foreign key columns establish its core linkages: TERR_GROUP_ACCOUNT_ID connects the record to a specific account within a territory group. RESOURCE_ID links to an individual resource (salesperson), while RSC_GROUP_ID links to a resource group (team). This design allows for flexible assignment of accounts to either individuals or entire teams. Additional columns, typical for such assignment tables, would likely include attributes for assignment start and end dates, creation and last update metadata, and potentially an assignment type indicator.

Common Use Cases and Queries

A primary use case is generating reports to show account coverage, such as listing all accounts assigned to a specific sales representative or identifying which resource is responsible for a given customer. System processes for validating territory-based data access and enforcing security also rely on this table. Common SQL queries involve joining to the related resource and account tables. For example, to list all named account assignments with resource details:

• SELECT nacr.*, res.resource_name, acc.account_name FROM jtf_tty_named_acct_rsc nacr JOIN jtf_rs_resource_extns res ON nacr.resource_id = res.resource_id JOIN jtf_tty_terr_grp_accts tga ON nacr.terr_group_account_id = tga.terr_group_account_id JOIN hz_cust_accounts acc ON tga.cust_account_id = acc.cust_account_id;

Another typical query identifies accounts assigned to a resource group: SELECT * FROM jtf_tty_named_acct_rsc WHERE rsc_group_id = <GROUP_ID>;

Related Objects

The table maintains documented foreign key relationships with three key objects, as specified in the metadata:

• JTF_TTY_TERR_GRP_ACCTS: Linked via TERR_GROUP_ACCOUNT_ID. This is the parent table that defines which accounts are included in a territory group.
• JTF_RS_RESOURCE_EXTNS: Linked via RESOURCE_ID. This table stores detailed information about individual sales and service resources.
• JTF_RS_GROUPS_B: Linked via RSC_GROUP_ID. This table defines resource groups or teams to which an account can be assigned collectively.

These relationships are fundamental, positioning JTF_TTY_NAMED_ACCT_RSC as the central intersection table between the territory account list and the resource hierarchy within Oracle CRM.