Results for “jtf_tty_rsc_acct_summ”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

JTF_TTY_RSC_ACCT_SUMM is a CRM Foundation (JTF) table that stores summarized account counts for sales resources, organized by resource group and territory bin. Within Oracle E-Business Suite 12.1.1 and 12.2.2, it supports the Resource Manager and Territory Manager subsystems of CRM Foundation, which underpin sales territory assignment, resource administration, and multi-organization access control. The table holds pre-aggregated counters (number of accounts, number of geographies) so that territory and resource lookup operations do not have to recompute those totals from the underlying transactional assignment tables.

The ETRM metadata classifies this object heuristically as a link in Data Vault terms. This is a modeling suggestion: the table's grain is a composite relationship between a resource (RESOURCE_ID) and a resource group (RSC_GROUP_ID), with a surrogate key (RESOURCE_ACCT_SUMM_ID) rather than a pure descriptive fact set. In practice it behaves as a summary link that carries a small set of numeric measures, so modelers may also treat it as a lightweight link-satellite hybrid.

Key Information Stored

The table is documented with 14 columns. The most significant are:

• RESOURCE_ACCT_SUMM_ID — the surrogate primary key, enforced by JTF_TTY_RSC_ACCT_SUMM_PK and additionally by the unique index JTF_TTY_RSC_ACCT_SUMM_U1. It is the only documented business-key candidate; no alternate natural unique key is defined.
• RESOURCE_ID — foreign key to JTF_RS_RESOURCE_EXTNS, identifying the sales resource (typically a salesperson or resource group member) to which the summary belongs.
• RSC_GROUP_ID — foreign key to JTF_RS_GROUPS_B, identifying the resource group context for the summary row.
• RSC_RESOURCE_TYPE — classifies the resource type being summarized (for example, individual resource versus group), allowing queries to filter by aggregation level.
• SITE_TYPE_CODE — indicates the site or organization context for the account rollup, supporting multi-org filtering.
• NUMBER_ACCOUNTS — the summarized count of accounts associated with the resource/group combination. This is the primary measure consumed by territory and resource reporting.
• NUMBER_GEOS — the summarized count of geographies associated with the resource/group combination.
• MANAGER_ID — the manager resource identifier associated with the summary, used for managerial hierarchy reporting.
• OBJECT_VERSION_NUMBER — the optimistic locking column required for rows maintained through the Oracle Application Framework (OAF) or BC4J-based CRM screens in Release 12.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — the standard WHO columns capturing audit and concurrency information.

Common Use Cases and Queries

Typical usage centers on territory and resource reporting: determining how many accounts a resource or resource group owns, and how widely that ownership is distributed geographically.

• Resource account rollup: SELECT resource_id, SUM(number_accounts) FROM jtf.jtf_tty_rsc_acct_summ GROUP BY resource_id;
• Group-level comparison of account and geography coverage: SELECT rsc_group_id, number_accounts, number_geos FROM jtf.jtf_tty_rsc_acct_summ WHERE rsc_resource_type = :p_type;
• Manager hierarchy reporting filtered on MANAGER_ID to show subordinate resource summaries.
• Joining to JTF_RS_RESOURCE_EXTNS with the WHO columns to reconcile summary counts against underlying resource assignments.
• Refresh or diagnostic checks verifying that NUMBER_ACCOUNTS and NUMBER_GEOS are consistent with the detailed assignment tables after territory realignment or resource reassignment.

Related Objects

The documented foreign keys and dependencies establish the following significant relationships:

• JTF_RS_RESOURCE_EXTNS — joined on RESOURCE_ID; the primary resource master extension table supplying resource names and attributes.
• JTF_RS_GROUPS_B — joined on RSC_GROUP_ID; the base resource groups table providing group definitions.
• JTF_TTY_RSC_ACCT_SUMM_PK / _U1 — the primary key constraint and unique index on RESOURCE_ACCT_SUMM_ID.
• JTF_RS_GROUPS_TL — the translated groups table, frequently joined via RSC_GROUP_ID to obtain group names in reports.
• JTF_RS_RESOURCE_GROUP_MEMBERS — resource-to-group membership, used when reconciling summaries against actual membership.
• JTF_RS_TEAMS / territory assignment tables — consume these summaries during territory and sales-team reporting.
• JTF_RS_RESOURCE_EXTNS_V / JTF_RS_RESOURCE_EXTNS_VL views — common reporting views layered over the resource master for joined queries.