Search Results upgrade_act_cat_inclusions

Overview

APPS.OTA_CLASSIC_UPGRADE is a PL/SQL upgrade package belonging to the Oracle Training Administration (OTA) product family within Oracle E-Business Suite. Its principal business function is to migrate legacy, "classic" Oracle Learning Management data structures into the current OTA data model that was introduced with the Online Learning / iLearning architecture. The package handles the one-time conversion of categories, activities, offerings, delivery modes, events, and associated descriptive flexfield contexts so that historical training records remain accessible and consistent after an upgrade to Release 12.1.1 or 12.2.2.

The object is registered in the ETRM as owner APPS, status VALID, and API classification OTHER, indicating that it is an internal upgrade utility rather than a public, supported application programming interface. It is not intended for routine transactional use; it is invoked during the upgrade or patching cycle to reconcile pre-existing data with the revised schema.

Key Procedures and Functions

The documented interface exposes 22 procedures and functions. The most significant include the following.

• UPGRADE_CATEGORY — converts classic training categories into the current catalog hierarchy.
• CREATE_ACTIVITY_FOR_CATEGORY and CREATE_CATEGORY_FOR_ACTIVITY — establish the bidirectional relationships between activities and their owning categories.
• CREATE_OFFERING — generates offering records from legacy scheduling data.
• CREATE_CTG_DM_FOR_ACT_BG and CREATE_ROOT_CTG_AND_DMS — build category–delivery-mode associations, including the root category structure.
• UPGRADE_EVENTS and UPGRADE_EVENT_ASSOCIATIONS — migrate event and event-to-offering linkage data.
• UPGRADE_ACT_CAT_INCLUSIONS and UPGRADE_ROOT_CATEGORY_DATES — manage inclusion rules and effective dating for the catalog.
• UPGRADE_ONLINE_DELIVERY_MODES — converts classic delivery modes to online-capable equivalents.
• UPGRADE_LP_HISTORY_FLAG and MIGRATE_TAD_DFF_CONTEXTS — carry forward learning-path history flags and Training Activity Definition descriptive flexfield contexts.
• MIGRATE_LOOKUP — transfers classic lookup values into FND lookup structures.
• GET_PROCESS_DATE, GET_APPS_TIMEZONE, and GET_OFFERING_NAME_WITH_LANG — utility functions supplying process dating, the application time zone, and language-specific offering names.
• ADD_LOG_ENTRY, SUBMIT_UPGRADE_REPORT, and VALIDATE_PROC_FOR_HR_UPG — logging, reporting, and validation of HR upgrade prerequisites.

Tables Accessed

The package reads and writes OTA transactional tables including OTA_ACTIVITY_DEFINITIONS, OTA_ACTIVITY_DEFINITIONS_TL, OTA_ACTIVITY_VERSIONS, and HR_ALL_ORGANIZATION_UNITS_TL, which hold the training catalog, translated names, activity versions, and owning organizations. Foundation data is drawn from FND_LOOKUP_VALUES, FND_FLEX_VALUE_SETS, FND_DESCRIPTIVE_FLEXS, FND_DESCR_FLEX_CONTEXTS, and FND_DESCR_FLEX_COLUMN_USAGES to drive flexfield and lookup migration. FND_LANGUAGES, FND_LANGUAGES_TL, and FND_NATURAL_LANGUAGES support multilanguage handling; FND_PRODUCT_INSTALLATIONS, FND_RESPONSIBILITY, and FND_USER supply installation and security context.

Usage Notes

OTA_CLASSIC_UPGRADE is referenced by three other packages — OTA_REPROCESS_CLASSIC_UPGRADE, OTA_TIMEZONE_UPGRADE, and OTA_TRAINING_PLAN_UPGRADE — which orchestrate reruns and complementary migration tasks. In practice the package is invoked by the Oracle Learning Management upgrade driver during the standard upgrade or patch application, not from a form. Custom code should avoid direct calls because the interface is undocumented and unsupported; the supported path is to execute the delivered concurrent upgrade programs, which in turn call these procedures.