Results for “jtf_terr_types_u1”

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

Overview

JTF_TERR_TYPES_ALL is a CRM Foundation (JTF) table that stores the definition of territory types within Oracle E-Business Suite. In the context of Oracle EBS 12.1.1 and 12.2.2, territory types represent the classification header under which individual territory records are grouped, such as geographic territories, organizational territories, or custom classification schemes used by the sales and resource management modules. The table functions as a foundational reference object for the Enterprise Territory Management (ETRM) tier of the CRM suite, enabling downstream components to categorize territories consistently across applications.

From a Data Vault modeling perspective, the metadata classifies this object as hub-leaning, meaning it behaves primarily as a business-key hub that anchors a set of descriptive and contextualization records. It is the parent of several satellite-style and link-style tables, including qualification rules, usage assignments, and question-type mappings, making it the central reference point for the territory type dimension.

Key Information Stored

The table contains 34 documented columns. The most significant of these are:

• TERR_TYPE_ID — The system-generated surrogate primary key, defined by the constraint JTF_TERR_TYPES_ALL_PK. This column uniquely identifies each territory type and is the value propagated into all dependent tables.
• ORG_ID — Identifies the operating unit or organization that owns the territory type. Together with TERR_TYPE_ID it forms the unique index JTF_TERR_TYPES_U1, making the pair the documented business-key candidate.
• NAME — The user-facing name of the territory type, used in list-of-values selections and reports.
• DESCRIPTION — Free-text elaboration of the territory type's purpose.
• ENABLED_FLAG — Controls whether the territory type is available for assignment and use.
• APPLICATION_SHORT_NAME — Identifies the owning application context for the type.
• START_DATE_ACTIVE and END_DATE_ACTIVE — Date-effective range defining the active lifespan of the territory type.
• SECURITY_GROUP_ID — Foreign key to FND_SECURITY_GROUPS, enforcing multi-tenant data isolation.
• ORIG_SYSTEM_REFERENCE and ORIG_SYSTEM_REFERENCE_ID — Track the originating system and identifier for imported or synchronized records.
• ATTRIBUTE_CATEGORY and ATTRIBUTE1 through ATTRIBUTE15 — Descriptive flexfield storage for client-specific extensions.
• OBJECT_VERSION_NUMBER — Optimistic locking column used to detect concurrent updates.
• Audit columns — CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, and LAST_UPDATE_LOGIN capture standard who-column auditing.

Common Use Cases and Queries

Typical scenarios include populating territory type list-of-values in territory administration forms, validating territory creation against an enabled and date-active type, and reporting on the distribution of territories by type. A representative query listing active types for an organization is:

SELECT terr_type_id, name, description
FROM   jtf_terr_types_all
WHERE  org_id = :p_org_id
AND    enabled_flag = 'Y'
AND    TRUNC(SYSDATE) BETWEEN start_date_active
                          AND NVL(end_date_active, SYSDATE);

Reporting use cases frequently join this table to JTF_TERR_ALL to count territories per type, or to AMS_TERR_LEVELS_ALL and OZF_TERR_LEVELS_ALL to analyze level hierarchies by territory type. Integration scenarios read ORIG_SYSTEM_REFERENCE and ORIG_SYSTEM_REFERENCE_ID to reconcile records loaded from external CRM systems, while security-conscious queries filter on SECURITY_GROUP_ID to respect multi-tenant boundaries.

Related Objects

• JTF_TERR_ALL — References this table through TERRITORY_TYPE_ID; holds the individual territory instances belonging to each type.
• JTF_TERR_TYPE_QUAL_ALL — Qualification rules applied to a territory type, joined on TERR_TYPE_ID.
• JTF_TERR_TYPE_USGS_ALL — Usage assignments defining how each type may be used, joined on TERR_TYPE_ID.
• JTF_TYPE_QTYPE_USGS_ALL — Question-type usage mappings tied to the type via TERR_TYPE_ID.
• JTY_WEBADI_OTH_TERR_INTF — WebADI interface table referencing territory types for import processing.
• AMS_TERR_LEVELS_ALL and OZF_TERR_LEVELS_ALL — Marketing and trade-management level definitions referencing TERR_TYPE_ID.
• FND_SECURITY_GROUPS — Parent of the SECURITY_GROUP_ID foreign key, governing row-level access.

In summary, JTF_TERR_TYPES_ALL is the authoritative reference table for territory type definitions in Oracle EBS CRM Foundation, serving as the hub from which territories, qualification rules, usages, and level hierarchies derive their type context.