Search Results admin_bin_terr_grp_id

Overview

JTF.JTF_TTY_ADMIN_BIN_SUMM is a transactional summary table in the Oracle E-Business Suite Customer Relationship Management (CRM) and Trading Community architecture, owned by the JTF (Java Technology Foundation) schema. The table stores summarized data for territory administrator bins, providing pre-aggregated key performance indicators (KPIs) that describe how many leads, opportunities, and accounts fall within a given territory group. In the context of Oracle EBS 12.1.1 and 12.2.2, this object supports territory administration and telemarketing (TTY) reporting, allowing administrators to assess coverage and assignment metrics without executing costly runtime aggregations.

The documented physical schema records the table as VALID, with 17 columns and storage in the APPS_TS_TX_DATA tablespace, with indexes placed in APPS_TS_TX_IDX. All indexes are of type NORMAL. The unique index JTF_TTY_ADMIN_BIN_SUMM_U1 enforces uniqueness on ADMIN_BIN_TERR_GRP_ID, while the non-unique index JTF_TTY_ADMIN_BIN_SUMM_N1 supports lookups by TERR_GROUP_ID.

From a dimensional modeling perspective, the heuristic Data Vault classification for this table is standalone, based on a mined foreign-key structure that is effectively limited and self-contained. This suggests that the table functions as a denormalized reporting summary rather than a transaction hub or link, and that it should be treated as a satellite-like aggregate rather than a source of core business relationships.

Key Information Stored

The primary key of the table is ADMIN_BIN_TERR_GRP_ID, a NUMBER column labeled Administrator Bin Territory Group Identifier. This column is also the business-key candidate enforced by the unique index JTF_TTY_ADMIN_BIN_SUMM_U1. It serves as the surrogate identifier for each summarized administrator bin territory group record.

The most significant columns include:

• TERR_GROUP_ID — The Territory Group Identifier, which links the summary row to a territory group. It is indexed by the non-unique index JTF_TTY_ADMIN_BIN_SUMM_N1.
• TERR_GROUP_NAME — A VARCHAR2(150) label for the territory group, useful in reports without requiring a join.
• LEADS — The count of leads in the bin, stored as NUMBER(30).
• OPPORTUNITIES — The count of opportunities in the bin.
• ACCOUNTS — The count of accounts in the bin.
• TOTAL_NAMED_ACCOUNT — A VARCHAR2(50) representation of total named accounts.
• MAPPED_NAMED_ACC_PER — The percentage of mapped named accounts.
• ASSIGNED_NAMED_ACC_PER — The percentage of assigned named accounts.
• CATCH_ALL_UPDATE_DATE — The date on which catch-all bin data was updated.
• KPI_UPDATE_DATE — The date the KPI bin was updated.
• OBJECT_VERSION_NUMBER — A standard column used for optimistic locking.

The table also carries the standard Oracle EBS audit columns: CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, and LAST_UPDATE_LOGIN.

Common Use Cases and Queries

Typical scenarios include monitoring territory administrator bin coverage, reporting lead and opportunity density by territory group, and validating assignment against mapping percentages. Because the table is pre-summarized, it is commonly queried in dashboards rather than transactional workflows.

A representative query joins the summary to its parent territory group and filters by territory group name:

• SELECT s.TERR_GROUP_NAME, s.LEADS, s.OPPORTUNITIES, s.ACCOUNTS, s.MAPPED_NAMED_ACC_PER, s.ASSIGNED_NAMED_ACC_PER FROM JTF.JTF_TTY_ADMIN_BIN_SUMM s WHERE s.TERR_GROUP_ID = :terr_group_id;
• SELECT s.ADMIN_BIN_TERR_GRP_ID, s.LEADS, s.OPPORTUNITIES, s.ACCOUNTS FROM JTF.JTF_TTY_ADMIN_BIN_SUMM s WHERE s.KPI_UPDATE_DATE >= SYSDATE - 7 ORDER BY s.KPI_UPDATE_DATE DESC;

Reporting use cases include mapping coverage analysis, where MAPPED_NAMED_ACC_PER and ASSIGNED_NAMED_ACC_PER indicate whether territory groups are adequately covered, and lead/opportunity distribution analysis across administrator bins.

Related Objects

The foreign-key relationship documented for this table references JTF.JTF_TTY_TERR_GROUPS via the TERR_GROUP_ID column. The join between JTF_TTY_ADMIN_BIN_SUMM.TERR_GROUP_ID and JTF_TTY_TERR_GROUPS.TERR_GROUP_ID is the primary navigational path from summary KPIs to the underlying territory group definition.

Additional related objects include the unique and non-unique indexes JTF_TTY_ADMIN_BIN_SUMM_U1 and JTF_TTY_ADMIN_BIN_SUMM_N1, which support the primary and secondary access paths. The table also has a dependent object, JTF.JTF_TTY_ADMIN_BIN_SUMM#, which appears in the dependency information and represents the underlying object or package specification associated with this summary. Together, these objects form the territory administrator bin summary layer used by Oracle EBS CRM territory administration reporting.