Search Results jtf_tty_admin_bin_summ_u1

Overview

JTF.JTF_TTY_ADMIN_BIN_SUMM is a summary table in the Oracle E-Business Suite Territory Management (JTF/TTY) product family. As its name implies, it stores pre-aggregated counts and key performance indicators for territory administrator bins, keyed at the level of an administrator bin territory group. Rather than recomputing territory assignment metrics on the fly from transactional tables, Oracle EBS persists periodic rollups here so that administrator-facing dashboards and bin summary pages render quickly. The table resides in the APPS_TS_TX_DATA tablespace and is owned by the JTF schema; its indexes are placed in APPS_TS_TX_IDX.

The ETRM metadata classifies this object, by heuristic analysis of its foreign key structure, as standalone — that is, it does not participate in a classic parent-child Data Vault link pattern. In Data Vault modeling terms, this suggests treating JTF_TTY_ADMIN_BIN_SUMM as a satellite-like snapshot: a periodically refreshed set of measures keyed to a single territory group dimension, not as a hub or a link. The single documented foreign key (TERR_GROUP_ID referencing JTF_TTY_TERR_GROUPS) reinforces that it is a denormalized measurement container rather than a relationship resolver.

Key Information Stored

The primary key is ADMIN_BIN_TERR_GRP_ID, a surrogate identifier for the administrator bin territory group row. The unique index JTF_TTY_ADMIN_BIN_SUMM_U1 enforces uniqueness on this column, and it is the documented business-key candidate for the object. A secondary non-unique index, JTF_TTY_ADMIN_BIN_SUMM_N1, supports lookups by TERR_GROUP_ID.

• ADMIN_BIN_TERR_GRP_ID — surrogate primary key for the summary row.
• TERR_GROUP_ID — foreign key to JTF_TTY_TERR_GROUPS; the real-world territory group this summary describes.
• TERR_GROUP_NAME — the human-readable territory group name (VARCHAR2(150)), useful for reporting without joining the parent table.
• LEADS, OPPORTUNITIES, ACCOUNTS — numeric counters summarizing leads, opportunities, and accounts in the bin.
• TOTAL_NAMED_ACCOUNT — total named accounts associated with the group.
• MAPPED_NAMED_ACC_PER, ASSIGNED_NAMED_ACC_PER — percentage measures for mapped and assigned named accounts, both stored as VARCHAR2(50).
• CATCH_ALL_UPDATE_DATE, KPI_UPDATE_DATE — timestamps recording when the catch-all aggregation and the KPI rollup were last refreshed.
• OBJECT_VERSION_NUMBER — the standard Oracle EBS optimistic-locking column used by the framework to detect concurrent updates.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — the standard WHO columns capturing audit information.

Common Use Cases and Queries

The primary use case is administrator bin summary reporting: displaying counts of leads, opportunities, and accounts per territory group, plus KPI percentages and the freshness dates indicating when the rollup was last refreshed. A typical query pattern filters by TERR_GROUP_ID via the N1 index or retrieves a single row by the U1 unique index:

SELECT a.TERR_GROUP_NAME, a.LEADS, a.OPPORTUNITIES, a.ACCOUNTS, a.TOTAL_NAMED_ACCOUNT, a.MAPPED_NAMED_ACC_PER, a.ASSIGNED_NAMED_ACC_PER, a.KPI_UPDATE_DATE FROM JTF.JTF_TTY_ADMIN_BIN_SUMM a WHERE a.TERR_GROUP_ID = :terr_group_id;

To identify stale summaries, report on KPI_UPDATE_DATE older than a threshold, or compare CATCH_ALL_UPDATE_DATE against KPI_UPDATE_DATE to detect partial refreshes. Because TERR_GROUP_NAME is stored locally, reporting tools can avoid joining JTF_TTY_TERR_GROUPS. Inventory and data-lineage audits frequently target the JTF_TTY_ADMIN_BIN_SUMM_U1 index and the ADM

_BIN_TERR_GRP_ID key when reconciling summary volumes against source territory data.

Related Objects

The following objects are most significant in relation to this table, based on the documented FK and dependency data:

• JTF.JTF_TTY_TERR_GROUPS — the parent territory group table, joined on TERR_GROUP_ID; this is the only documented foreign key relationship.
• JTF_TTY_ADMIN_BIN_SUMM# — the public synonym or editioned handle generated for this table.
• JTF_TTY_ADMIN_BIN_SUMM_PK — the primary-key constraint on ADMIN_BIN_TERR_GRP_ID.
• JTF_TTY_ADMIN_BIN_SUMM_U1 — the unique index on ADMIN_BIN_TERR_GRP_ID (the business-key candidate searched for).
• JTF_TTY_ADMIN_BIN_SUMM_N1 — the non-unique index on TERR_GROUP_ID supporting the parent join.
• FND Design Data JTF.JTF_TTY_ADMIN_BIN_SUMM — the AOL registration entry governing the table within the applications schema.

No other database objects are documented as referencing this table, consistent with its classification as a standalone summary container populated by territory administration refresh processes rather than through direct transactional DML.