Results for “jtf_terr_cnr_groups”

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

Overview

JTF_TERR_CNR_GROUPS is a CRM Foundation (JTF) table that stores Customer Name Range Groups within the Oracle E-Business Suite Territory Management (ETRM) data model. A Customer Name Range group defines a reusable, named container that bundles together one or more value ranges applied against customer name attributes, allowing territory definitions to qualify accounts by name-based criteria rather than by explicit customer identifiers. The table resides in the JTF schema and is registered as VALID across both 12.1.1 and 12.2.2.

The object participates in the territory qualifier framework, where territory rules evaluate whether a given customer belongs to a territory by testing membership against qualifier values. Customer Name Range groups provide the grouping construct that ties individual ranges together so that a single group can be referenced from multiple territory qualifier definitions and from territory value records. Because a single group is referenced by many downstream rows, the entity behaves as a reference or hub-like structure. Under a heuristic Data Vault classification, the metadata suggests a hub-leaning classification, since the table carries a surrogate primary key plus descriptive and auditing columns and is the target of multiple foreign key references. This classification is a modeling suggestion only and does not reflect an Oracle-implemented Data Vault design.

Key Information Stored

The table contains 28 documented columns. The most significant are:

• CNR_GROUP_ID — the surrogate primary key, enforced by JTF_TERR_CNR_GROUPS_PK and also carried by the unique index JTF_TERR_CNR_GROUPS_U1. This is the column referenced by all dependent tables.
• NAME — the user-visible identifier of the Customer Name Range group, used when administrators attach the group to territory qualifiers.
• DESCRIPTION — free-text explanation of the group's intent or scope.
• START_DATE_ACTIVE and END_DATE_ACTIVE — the effective date window during which the group is considered active for territory qualification.
• SECURITY_GROUP_ID — foreign key to FND_SECURITY_GROUPS, supporting multi-tenant or operating-unit level data isolation.
• OBJECT_VERSION_NUMBER — optimistic locking column used by the EBS framework to detect concurrent updates.
• ATTRIBUTE_CATEGORY and ATTRIBUTE1 through ATTRIBUTE15 — the standard EBS descriptive flexfield columns for customer-defined extensions.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — the standard WHO audit columns.

The unique index on CNR_GROUP_ID is a business-key candidate, although in practice the identifier is system-generated. No natural or alternate unique business key beyond the primary key is documented.

Common Use Cases and Queries

Typical uses include auditing which Customer Name Range groups exist, validating active date windows before a territory assignment run, and joining groups to their constituent ranges for reporting. A basic listing query is:

• SELECT cnr_group_id, name, description, start_date_active, end_date_active FROM jtf.jtf_terr_cnr_groups WHERE security_group_id = :sgid ORDER BY name;
• SELECT g.cnr_group_id, g.name, v.* FROM jtf.jtf_terr_cnr_groups g, jtf.jtf_terr_cnr_group_values v WHERE g.cnr_group_id = v.cnr_group_id AND g.name = :group_name;
• SELECT g.name, t.territory_id FROM jtf.jtf_terr_cnr_groups g, jtf.jtf_terr_values_all t WHERE g.cnr_group_id = t.cnr_group_id AND TRUNC(SYSDATE) BETWEEN g.start_date_active AND NVL(g.end_date_active, SYSDATE);

Reporting scenarios commonly surface active versus expired groups, groups unused by any territory value, and groups filtered by security group for delegated administration.

Related Objects

• JTF_TERR_CNR_GROUP_VALUES — child table holding the individual ranges within each group, joined on CNR_GROUP_ID.
• JTF_TERR_VALUES_ALL — territory qualifier values referencing the group via CNR_GROUP_ID.
• FND_SECURITY_GROUPS — parent reference for SECURITY_GROUP_ID.
• JTF_TERR_QUALIFIERS / territory qualifier definitions — consume groups when evaluating customer name criteria.
• JTF_TERR_CNR_GROUPS_PK / JTF_TERR_CNR_GROUPS_U1 — the enforcing primary key and unique index.