Search Results jtf_tty_acct_qual_maps_s




Overview
Explore in AI Chat

Overview

JTF_TERR_NA_MERGE_PUB is a public PL/SQL package body owned by the APPS schema in Oracle E-Business Suite Release 12.1.1 and 12.2.2. It belongs to the CRM/TeleSales territory management component of the Oracle Trade Management and Territory infrastructure. Its purpose is to reconcile territory-related named account data when customer master records are merged. In Oracle EBS, party and party site merges performed through Oracle Trading Community Architecture (TCA) or the Customer Merge concurrent program consolidate duplicate records in HZ_PARTIES, HZ_PARTY_SITES, and HZ_LOCATIONS. When those entities participate in territory assignments, the territory named account tables retain references to the surviving (or obsolete) party identifiers. This package provides the merge-time logic required to re-point or remove those territory assignment records so that territory definitions remain consistent after a customer merge operation completes. The package is classified as a public API (PUB), meaning it is intended to be callable from external code rather than being strictly internal to another package.

Key Procedures and Functions

  • PARTY_MERGE — Handles the merge of a party (customer or prospect) within the territory management model. It receives the merge context and applies the appropriate updates and deletions to named account and territory group assignment records so that the surviving party retains its territory memberships and the obsolete party no longer holds assignments.
  • PARTY_SITE_MERGE — Handles the corresponding merge logic at the party site level. Because named account assignments can be qualified at the site level as well as the party level, this procedure reconciles JTF_TTY_NAMED_ACCTS and related resource and group assignment rows keyed by party site identifiers.

No further procedures or functions are documented for this package beyond these two entry points.

Tables Accessed

  • HZ_PARTIES, HZ_PARTY_SITES, HZ_LOCATIONS — Read to resolve the party and site identifiers involved in the merge and to validate the surviving entities.
  • JTF_TTY_NAMED_ACCTS — Stores the named account records assigned to territories; updated or deleted to reflect the merged party.
  • JTF_TTY_NAMED_ACCT_RSC — Stores the resources associated with named accounts; reconciled when the underlying named account assignment changes.
  • JTF_TTY_TERR_GROUPS and JTF_TTY_TERR_GRP_ACCTS — Define territory groups and their associated accounts; adjusted to preserve group membership consistency after the merge.
  • JTF_TTY_ACCT_QUAL_MAPS and JTF_TTY_ACCT_QUAL_MAPS_S — Account qualification map tables (the latter being the sequence-backed table) that hold the qualification criteria linking accounts to territories; these rows are re-keyed or removed as part of the merge cleanup. This is the object most closely associated with the user's search term.
  • DUAL — Referenced for standard PL/SQL structure and single-row queries.

Usage Notes

This package is typically not called directly by end users. It is invoked programmatically as part of the customer merge process, commonly orchestrated through TCA merge infrastructure or Oracle Sales/TeleSales territory management flows that detect territory assignment conflicts during a party or party site merge. It is not referenced by any other database object according to the ETRM dependency report, and it depends on standard API and messaging infrastructure including FND_API, FND_MSG_PUB, FND_MESSAGE, FND_GLOBAL, and FND_FILE. Because the package is classified as a public API, customizations and extensions may call PARTY_MERGE and PARTY_SITE_MERGE directly, but this should be done only after the corresponding merge identifiers have been established. Oracle does not expose formal parameter lists for these programs, so integrators should reference the package specification at their specific patch level before invoking them.