Search Results jtf_tty_geo_grp_values




Overview
Explore in AI Chat

Overview

The table JTF_TTY_GEO_GRP_VALUES is a core data object within the CRM Foundation (JTF) module of Oracle E-Business Suite (EBS) versions 12.1.1 and 12.2.2. It functions as a junction or mapping table that stores the specific geography values assigned to a territory group. Its primary role is to support the Territory Manager functionality, enabling the definition of sales or service territories based on geographic criteria. By linking territory groups to specific geographic identifiers, this table provides the foundational data for territory-based routing, assignment, and reporting within the CRM and Order Management flows of Oracle EBS.

Key Information Stored

The table's structure is designed to manage the relationship between a territory group and its constituent geographies. Based on the provided metadata, the central column is GEO_GRP_VALUES_ID, which serves as the primary key for each mapping record. A critical foreign key column is JTF_TTY_GEO_GRP_VALUES.GEO_ID_FROM, which references the JTF_TTY_GEOGRAPHIES table. This column stores the identifier for a specific geography (e.g., a country, state, city, or postal code) that is included in a territory group. While the metadata excerpt does not list all columns, a typical implementation would also include a column to identify the parent territory group (such as a GEO_GROUP_ID), linking back to a master territory definition table.

Common Use Cases and Queries

This table is primarily accessed for territory resolution and validation. Common operational scenarios include determining if a customer's location belongs to a specific sales territory for opportunity assignment or order booking. For reporting, it is used to aggregate data by defined geographic territories. A sample query to list all geographies within a specific territory group would follow this pattern:

  • SELECT geo.geography_name
  • FROM jtf_tty_geo_grp_values grp_val,
  • jtf_tty_geographies geo
  • WHERE grp_val.geo_id_from = geo.geography_id
  • AND grp_val.geo_group_id = :p_territory_group_id;

Data in this table is typically maintained through the Oracle Territory Manager user interface or its underlying APIs, not via direct SQL manipulation.

Related Objects

As indicated by the foreign key constraint, the most directly related object is the JTF_TTY_GEOGRAPHIES table, which holds the master list of all geography definitions. This table is a child of a parent territory group table, which is likely named JTF_TTY_GEO_GROUPS or similar. The primary key constraint JTF_TTY_GEO_GRP_VALUES_PK ensures the uniqueness of each mapping record. This table is integral to the territory engine and is referenced by various views and APIs within the JTF and related modules like Order Management (ONT) and Trade Management for territory-based data security and assignment rules.