Search Results get_training_details

Overview

APPS.OTA_TRAINING_RECORD is a PL/SQL package in the Oracle E-Business Suite OTA (Oracle Training Administration / Learning Management) schema. It serves as a read-oriented utility that assembles and returns consolidated training and certification details for learners, delegates, and their associated enrollments. The package is classified in ETRM as an OTHER API, meaning it is not a public, fully versioned business API but a supporting package used to resolve informational queries against the training and certification data model. It is validated (STATUS = VALID) and owned by the APPS schema, with the standalone package and package body both present.

Its principal business purpose is to centralize the logic required to retrieve and format training history and certification status, so that callers — typically Oracle Forms, concurrent programs, or custom extensions — do not have to reconstruct that logic directly against the underlying tables. This is consistent with the shared object model used by Oracle Learning Management in release 12.1.1 and 12.2.2.

Key Procedures and Functions

The documented package exposes two callable units, both designed to return detail rather than to modify data:

• GET_TRAINING_DETAILS — Returns training-related detail for a given learner or booking context. It resolves information from the training activity, event, and booking tables (for example OTA_ACTIVITY_VERSIONS, OTA_ACTIVITY_VERSIONS_TL, OTA_EVENTS, OTA_DELEGATE_BOOKINGS, and OTA_BOOKING_STATUS_TYPES_TL), together with competency data, to describe the training a delegate has undertaken and its current state.
• GET_CERTIFICATION_DETAILS — Returns certification-related detail, drawing on the certification definition and enrollment tables such as OTA_CERTIFICATIONS_B, OTA_CERTIFICATIONS_TL, OTA_CERTIFICATION_MEMBERS, OTA_CERT_ENROLLMENTS, OTA_CERT_MBR_ENROLLMENTS, and OTA_CERT_PRD_ENROLLMENTS, along with competency definitions (PER_COMPETENCES_TL, PER_COMPETENCE_ELEMENTS), to describe certification membership, enrollment, and completion status.

Both procedures function as retrieval helpers. Exact parameter lists are not documented in the ETRM metadata and should be confirmed by inspecting the package specification in the database.

Tables Accessed

The package reads from, and in limited cases derives values in, the following documented objects (referenced through APPS synonyms):

• Training/activity: OTA_ACTIVITY_VERSIONS, OTA_ACTIVITY_VERSIONS_TL, OTA_EVENTS, OTA_EVENTS_V, OTA_DELEGATE_BOOKINGS, OTA_BOOKING_STATUS_TYPES_TL — supplying activity version descriptions and booking status information.
• Certification: OTA_CERTIFICATIONS_B, OTA_CERTIFICATIONS_TL, OTA_CERTIFICATION_MEMBERS, OTA_CERT_ENROLLMENTS, OTA_CERT_MBR_ENROLLMENTS, OTA_CERT_PRD_ENROLLMENTS — supplying certification definitions, translations, member enrollments, and period enrollments.
• Competency: PER_COMPETENCES_TL, PER_COMPETENCE_ELEMENTS — supplying competency names and element definitions tied to training and certification outcomes.
• Organization/reference: HR_ALL_ORGANIZATION_UNITS, HR_ALL_ORGANIZATION_UNITS_TL, HR_LOOKUPS — supplying organization context and lookup values.

These tables are joined to produce a unified view of a learner's training and certification record.

Usage Notes

APPS.OTA_TRAINING_RECORD is typically invoked from Oracle Forms in the Learning Management module, from concurrent programs that generate training or certification reports, and from custom PL/SQL that needs learner-facing detail without reimplementing joins. Because it is classified as OTHER rather than a formal public API, it should be treated as an internal supporting package: developers extending Oracle EBS 12.1.1 or 12.2.2 may call it, but should be aware that Oracle does not guarantee its signature across patches. ETRM records zero packages referencing it, so dependencies are one-directional. Any custom usage should pin to the installed package specification and be regression-tested after patching.