Search Results jtf_tty_prod_cat_migrate_pvt




Overview
Explore in AI Chat

Overview

JTF_TTY_PROD_CAT_MIGRATE_PVT is a private PL/SQL package in the Oracle E-Business Suite Applications (APPS) schema that supports the migration of legacy territory interest-type and product-category data to the newer seeded qualification model used by Territory Manager. The package is part of the CRM/Territory Management (JTF) module family and carries a version header dated 2005, indicating it was originally delivered for the 11i code line and retained through EBS 12.1.1 and 12.2.2 for upgrade and data-conversion scenarios.

Its business purpose is to convert interest types, primary interest codes, and secondary interest codes associated with Opportunity Expected Purchase and Lead Expected Purchase records into the corresponding seeded qualification values. During this conversion, territory value records in JTF_TERR_VALUES_ALL are rewritten to point at the new qualification usage identifiers, and the associated territory qualification rows in JTF_TERR_QUAL_ALL are updated with the new qual_usg_id values. This ensures that territories defined against the older interest-code model continue to resolve correctly after the seeded qualification framework is applied.

Key Procedures and Functions

  • Migrate_All — The main driver procedure and the entry point most commonly referenced by callers searching for "migrate_all". It orchestrates the migration by invoking the other procedures in the package. It exposes an error buffer, a return code, and a debug flag, following the standard concurrent-program parameter convention, and is designed to be called as a batch or concurrent process.
  • Migrate_Product_Cat_Terr — Migrates interest types, primary interest codes, and secondary interest codes held in the JTF_TERR_VALUES_ALL table. It accepts the existing qualification usage identifier and the replacement qualification usage identifier, along with a debug flag, so that individual qualification usage mappings can be converted in a controlled manner.
  • Migrate_Product_Cat_Role — Migrates interest types in the JTF_TTY_ROLE_PROD_INT table, which stores the relationship between territory roles and product interests. A debug flag controls diagnostic output.

Tables Accessed

The package reads and writes the following tables through APPS synonyms:

  • JTF_TERR_VALUES_ALL — The primary target of the migration, holding territory value records for expected purchase criteria; interest types and primary/secondary interest codes are rewritten here.
  • JTF_TERR_QUAL_ALL — Territory qualification records, updated with new qual_usg_id values as part of the same conversion.
  • JTF_TTY_ROLE_PROD_INT — Territory role-to-product-interest associations, updated by Migrate_Product_Cat_Role.
  • JTF_QUAL_USGS_ALL, JTF_SEEDED_QUAL_ALL_B, and JTF_SEEDED_QUAL_ALL_TL — The seeded qualification usage and seeded qualification definition tables, used as the source of the new qualification usage identifiers and their translated names.
  • AS_INTEREST_CODES_B and AS_INTEREST_TYPES_B — Interest code and interest type base tables consulted to resolve legacy interest values.
  • PLITBLM — The standard PL/SQL table buffer utility referenced for internal collection handling.

Usage Notes

JTF_TTY_PROD_CAT_MIGRATE_PVT is classified as a PVT (private) package, meaning it is not part of Oracle's published, supported API surface. It is not referenced by any other documented package, so invocation is expected to occur from scripts, upgrade drivers, or custom concurrent program wrappers rather than from standard application forms. The Migrate_All signature — ERRBF OUT, RETCODE OUT, and a debug flag — matches the Oracle concurrent program calling convention, which suggests the package was historically registered against a concurrent program for one-time data migration during an upgrade or patch. Administrators should only invoke it in a controlled environment, after backing up the affected territory tables, and should validate results by reviewing JTF_TERR_VALUES_ALL and JTF_TERR_QUAL_ALL for the migrated qualification usage identifiers.