Search Results as_accesses_u1

Overview

The APPS.JTF_TTY_POP_TERR_ADMIN_BIN_PVT package body is a private (PVT-classified) PL/SQL component within the Oracle EBS Territory Management and TeleSales/Foundation module. Its primary business function is to populate and maintain the administrative bin summary data used by the Territory Manager to aggregate leads, opportunities, and accounts associated with catch-all territories and KPI-based territory groupings. The package provides the procedural engine behind the "bin" summarization model, ensuring that counts of accounts, leads, and opportunities assigned to territories are correctly reflected in the jtf_tty_admin_bin_summ table for downstream reporting, dashboards, and territory administration forms.

Because the package is classified as a private API, it is intended for internal consumption by other EBS components rather than direct invocation by end users or external integrations. The header comment (revision 120.2, dated 2006) indicates the package originated during the 11i-era TeleSales/Foundation development and has been carried forward into the 12.1.1 and 12.2.2 code lines with minimal structural change.

Key Procedures and Functions

• POPULATE_CATCH_ALL_BIN_INFO — Iterates over territories flagged as catch-all in jtf_terr_all and recomputes aggregate counts of accounts, leads, and opportunities. It resets the summaries in jtf_tty_admin_bin_summ and repopulates them per territory. The cursor driving this logic selects terr_id and terr_group_id where CATCH_ALL_FLAG = 'Y'. It returns a status and an error message via its OUT parameters, and utilizes FND_GLOBAL.USER_ID() for audit columns.
• POPULATE_KPI_BIN_INFO — Populates bin information tied to Key Performance Indicator (KPI) based territory criteria, supporting the KPI summary views used in the Territory Manager interface.
• SYNC_TERR_GROUP — Synchronizes territory group membership and associated account relationships, maintaining consistency between jtf_tty_terr_groups, jtf_tty_terr_grp_accts, and related named-account resource records.

Tables Accessed

• JTF_TERR_ALL — Source of catch-all territory definitions and territory group identifiers.
• JTF_TTY_ADMIN_BIN_SUMM — Target summary table where aggregated lead, opportunity, and account counts are written.
• AS_TERRITORY_ACCESSES — Maps territory identifiers to access identifiers for account, lead, and opportunity joins.
• JTF_TTY_TERR_GROUPS — Stores territory group definitions used during synchronization.
• JTF_TTY_TERR_GRP_ACCTS — Associates accounts with territory groups.
• JTF_TTY_NAMED_ACCT_RSC — Named account resource assignments referenced during territory group reconciliation.

Note the indexed access to as_accesses_all via the as_accesses_u1 index hint, which is the object referenced in the user's search. This hint forces the optimizer to drive the aggregation queries through the unique index on as_accesses_all, a deliberate tuning measure for large access tables.

Usage Notes

This package is typically invoked indirectly through the Territory Manager administrative flows, concurrent programs that refresh bin summaries, or other EBS packages — the ETRM metadata records that it is referenced by one other package. It is not exposed through a standard Oracle Forms menu directly; instead, callers invoke its procedures with the appropriate return status and error message OUT parameters. Because it is a PVT API, customizations should avoid direct calls and instead target the public wrapper API or the underlying concurrent program that triggers the refresh. When performance issues arise with the catch-all computation, the as_accesses_u1 index hint and the underlying statistics on as_accesses_all and as_territory_accesses should be reviewed first.