Search Results ota_training_plan_upgrade




Overview
Explore in AI Chat

Overview

OTA_TRAINING_PLAN_UPGRADE is an APPS-owned PL/SQL package classified under Oracle EBS's Oracle Training Administration (OTA) product family. It is not a runtime business API; rather, it is a data migration and upgrade utility whose purpose is to transform legacy "Training Plan" structures into the current Learning Path model used in Oracle EBS 12.1.1 and 12.2.2. The package exists to support the OTA schema evolution in which older training plan constructs were superseded by learning paths, learning path sections, and learning path members. As populations of learners, managers, and talent management assignments moved from the older plan architecture, this package reconciled that data by inserting the corresponding learning path rows, section rows, and enrollment records.

Key Procedures and Functions

The package exposes six documented procedures, each scoped to a specific migration path or cleanup activity:

  • POPULATE_PATH_SOURCE_CODE — Populates the source code attribute on learning path records, identifying the origin of converted training plans so downstream logic can distinguish migrated rows from natively created learning paths.
  • UPG_TP_FOR_LRNR_AND_MGR_TO_LP — Upgrades training plans assigned to learners and managers into learning paths, preserving the audience and assignment semantics of the original plan.
  • UPG_TP_TO_LP_FOR_TALENT_MGMT — Performs the equivalent conversion for training plans originating from Talent Management, ensuring talent-driven learning assignments are represented as learning paths.
  • REMOVE_DATE_REST — Removes date restrictions carried over from legacy training plan definitions that are no longer appropriate for the learning path model.
  • UPG_CAT_LP_TO_SECTION — Converts catalog learning path constructs into learning path sections, restructuring the hierarchy into the section-based model.
  • UPG_ENROL_TO_CAT_LP — Migrates enrollment records onto catalog learning paths, aligning learner enrollments with the new learning path target structure.

No parameter signatures are documented; the procedures are invoked as part of the upgrade sequence rather than as general-purpose APIs.

Tables Accessed

The package operates across the OTA learning path schema and reads supporting Oracle Application Object Library (FND) flexfield metadata. It writes and reads OTA_LEARNING_PATHS, OTA_LEARNING_PATHS_TL, OTA_LEARNING_PATH_MEMBERS, OTA_LP_SECTIONS, and OTA_LP_SECTIONS_TL to build the destination learning path and section structures. Enrollment targets are handled through OTA_LP_ENROLLMENTS and OTA_LP_MEMBER_ENROLLMENTS, while OTA_DELEGATE_BOOKINGS supports booking-related conversion. Source plan and event data are read from OTA_EVENTS, OTA_EVENT_ASSOCIATIONS, and OTA_BOOKING_STATUS_TYPES. The FND_DESCRIPTIVE_FLEXS, FND_DESCR_FLEX_COLUMN_USAGES, FND_DESCR_FLEX_CONTEXTS, and FND_FLEX_VALUE_SETS tables are referenced for flexfield and value-set resolution during the transformation.

Usage Notes

Because this package is upgrade infrastructure rather than a supported public API, it is normally invoked by Oracle-supplied upgrade or patch drivers during the transition from legacy training plans to learning paths, and is not intended for direct invocation by application forms. Its dependency list confirms a low-level position in the object graph: it references only SYS.STANDARD and is referenced by no other APPS packages, indicating it is a leaf-level utility driven by external scripts. The status is VALID in both 12.1.1 and 12.2.2. Customers should not call these procedures directly in custom code; any post-upgrade data correction should instead use supported learning path and enrollment APIs or concurrent programs. Administrators troubleshooting migration inconsistencies may inspect this package under the APPS schema to understand how legacy plan rows were mapped.