Search Results ota_classic_upgrade

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.

PACKAGE: APPS.OTA_CLASSIC_UPGRADE 12.1.1
owner:APPS, object_type:PACKAGE, object_name:OTA_CLASSIC_UPGRADE, status:VALID,
PACKAGE: APPS.OTA_CLASSIC_UPGRADE 12.2.2
owner:APPS, object_type:PACKAGE, object_name:OTA_CLASSIC_UPGRADE, status:VALID,
SYNONYM: APPS.OTA_RESOURCE_USAGES_S 12.1.1
owner:APPS, object_type:SYNONYM, object_name:OTA_RESOURCE_USAGES_S, status:VALID,
PACKAGE BODY: APPS.OTA_CLASSIC_UPGRADE 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:OTA_CLASSIC_UPGRADE, status:VALID,
PACKAGE BODY: APPS.OTA_CLASSIC_UPGRADE 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:OTA_CLASSIC_UPGRADE, status:VALID,
SYNONYM: APPS.FND_LANGUAGES_TL 12.2.2
owner:APPS, object_type:SYNONYM, object_name:FND_LANGUAGES_TL, status:VALID,
SYNONYM: APPS.OTA_PERFORMANCES 12.1.1
owner:APPS, object_type:SYNONYM, object_name:OTA_PERFORMANCES, status:VALID,
SYNONYM: APPS.OTA_OFFERINGS_TL 12.2.2
owner:APPS, object_type:SYNONYM, object_name:OTA_OFFERINGS_TL, status:VALID,
SYNONYM: APPS.OTA_PERFORMANCES 12.2.2
owner:APPS, object_type:SYNONYM, object_name:OTA_PERFORMANCES, status:VALID,
PACKAGE: APPS.OTA_ADT_INS 12.2.2
owner:APPS, object_type:PACKAGE, object_name:OTA_ADT_INS, status:VALID,
PACKAGE: APPS.OTA_TAD_API 12.1.1
owner:APPS, object_type:PACKAGE, object_name:OTA_TAD_API, status:VALID,
PACKAGE: APPS.OTA_OFF_INS 12.2.2
owner:APPS, object_type:PACKAGE, object_name:OTA_OFF_INS, status:VALID,
PACKAGE: APPS.OTA_CATEGORY_USAGE_API 12.2.2
owner:APPS, object_type:PACKAGE, object_name:OTA_CATEGORY_USAGE_API, status:VALID,
SYNONYM: APPS.OTA_UPGRADE_LOG 12.2.2
owner:APPS, object_type:SYNONYM, object_name:OTA_UPGRADE_LOG, status:VALID,
SYNONYM: APPS.OTA_LEARNING_OBJECTS 12.1.1
owner:APPS, object_type:SYNONYM, object_name:OTA_LEARNING_OBJECTS, status:VALID,
PACKAGE: APPS.OTA_TAD_API 12.2.2
owner:APPS, object_type:PACKAGE, object_name:OTA_TAD_API, status:VALID,
SYNONYM: APPS.FND_LANGUAGES_TL 12.1.1
owner:APPS, object_type:SYNONYM, object_name:FND_LANGUAGES_TL, status:VALID,
PACKAGE: APPS.OTA_CTU_INS 12.2.2
owner:APPS, object_type:PACKAGE, object_name:OTA_CTU_INS, status:VALID,
PACKAGE BODY: APPS.OTA_TIMEZONE_UPGRADE 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:OTA_TIMEZONE_UPGRADE, status:VALID,
SYNONYM: APPS.OTA_RESOURCE_USAGES 12.1.1
owner:APPS, object_type:SYNONYM, object_name:OTA_RESOURCE_USAGES, status:VALID,
SYNONYM: APPS.OTA_RESOURCE_USAGES 12.2.2
owner:APPS, object_type:SYNONYM, object_name:OTA_RESOURCE_USAGES, status:VALID,
SYNONYM: APPS.PER_COMPETENCE_ELEMENTS_S 12.1.1
owner:APPS, object_type:SYNONYM, object_name:PER_COMPETENCE_ELEMENTS_S, status:VALID,
SYNONYM: APPS.OTA_RESOURCE_USAGES_S 12.2.2
owner:APPS, object_type:SYNONYM, object_name:OTA_RESOURCE_USAGES_S, status:VALID,
SYNONYM: APPS.PER_COMPETENCE_ELEMENTS_S 12.2.2
owner:APPS, object_type:SYNONYM, object_name:PER_COMPETENCE_ELEMENTS_S, status:VALID,
SYNONYM: APPS.FND_NATURAL_LANGUAGES 12.2.2
owner:APPS, object_type:SYNONYM, object_name:FND_NATURAL_LANGUAGES, status:VALID,
SYNONYM: APPS.FND_NATURAL_LANGUAGES 12.1.1
owner:APPS, object_type:SYNONYM, object_name:FND_NATURAL_LANGUAGES, status:VALID,
PACKAGE: APPS.OTA_TDB_API_UPD2 12.2.2
owner:APPS, object_type:PACKAGE, object_name:OTA_TDB_API_UPD2, status:VALID,
PACKAGE: APPS.OTA_CATEGORY_USAGE_API 12.1.1
owner:APPS, object_type:PACKAGE, object_name:OTA_CATEGORY_USAGE_API, status:VALID,
SYNONYM: APPS.OTA_UPGRADE_LOG 12.1.1
owner:APPS, object_type:SYNONYM, object_name:OTA_UPGRADE_LOG, status:VALID,
PACKAGE: APPS.OTA_ADT_INS 12.1.1
owner:APPS, object_type:PACKAGE, object_name:OTA_ADT_INS, status:VALID,
PACKAGE: APPS.OTA_MLS_UTILITY 12.2.2
owner:APPS, object_type:PACKAGE, object_name:OTA_MLS_UTILITY, status:VALID,
PACKAGE: APPS.OTA_MLS_UTILITY 12.1.1
owner:APPS, object_type:PACKAGE, object_name:OTA_MLS_UTILITY, status:VALID,
PACKAGE: APPS.OTA_OFF_INS 12.1.1
owner:APPS, object_type:PACKAGE, object_name:OTA_OFF_INS, status:VALID,
PACKAGE: APPS.OTA_CTU_INS 12.1.1
owner:APPS, object_type:PACKAGE, object_name:OTA_CTU_INS, status:VALID,
SYNONYM: APPS.OTA_ACTIVITY_DEFINITIONS_TL 12.1.1
owner:APPS, object_type:SYNONYM, object_name:OTA_ACTIVITY_DEFINITIONS_TL, status:VALID,
SYNONYM: APPS.OTA_ACT_CAT_INCLUSIONS 12.1.1
owner:APPS, object_type:SYNONYM, object_name:OTA_ACT_CAT_INCLUSIONS, status:VALID,
SYNONYM: APPS.OTA_COMPETENCE_LANGUAGES 12.1.1
owner:APPS, object_type:SYNONYM, object_name:OTA_COMPETENCE_LANGUAGES, status:VALID,
SYNONYM: APPS.OTA_COMPETENCE_LANGUAGES 12.2.2
owner:APPS, object_type:SYNONYM, object_name:OTA_COMPETENCE_LANGUAGES, status:VALID,
SYNONYM: APPS.OTA_OFFERINGS_TL 12.1.1
owner:APPS, object_type:SYNONYM, object_name:OTA_OFFERINGS_TL, status:VALID,
PACKAGE BODY: APPS.OTA_TRAINING_PLAN_UPGRADE 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:OTA_TRAINING_PLAN_UPGRADE, status:VALID,
SYNONYM: APPS.OTA_LEARNING_OBJECTS 12.2.2
owner:APPS, object_type:SYNONYM, object_name:OTA_LEARNING_OBJECTS, status:VALID,
SYNONYM: APPS.OTA_EVENT_ASSOCIATIONS 12.2.2
owner:APPS, object_type:SYNONYM, object_name:OTA_EVENT_ASSOCIATIONS, status:VALID,
SYNONYM: APPS.OTA_EVENT_ASSOCIATIONS 12.1.1
owner:APPS, object_type:SYNONYM, object_name:OTA_EVENT_ASSOCIATIONS, status:VALID,
SYNONYM: APPS.OTA_ACTIVITY_DEFINITIONS_TL 12.2.2
owner:APPS, object_type:SYNONYM, object_name:OTA_ACTIVITY_DEFINITIONS_TL, status:VALID,
PACKAGE BODY: APPS.OTA_TIMEZONE_UPGRADE 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:OTA_TIMEZONE_UPGRADE, status:VALID,
PACKAGE BODY: APPS.OTA_REPROCESS_CLASSIC_UPGRADE 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:OTA_REPROCESS_CLASSIC_UPGRADE, status:VALID,
PACKAGE BODY: APPS.OTA_REPROCESS_CLASSIC_UPGRADE 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:OTA_REPROCESS_CLASSIC_UPGRADE, status:VALID,
PACKAGE BODY: APPS.OTA_TRAINING_PLAN_UPGRADE 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:OTA_TRAINING_PLAN_UPGRADE, status:VALID,
PACKAGE: APPS.FND_FLEX_DSC_API 12.2.2
owner:APPS, object_type:PACKAGE, object_name:FND_FLEX_DSC_API, status:VALID,
SYNONYM: APPS.OTA_CATEGORY_USAGES_TL 12.2.2
owner:APPS, object_type:SYNONYM, object_name:OTA_CATEGORY_USAGES_TL, status:VALID,