Search Results ota_cert_enrollments




Overview
Explore in AI Chat

Overview

OTA_CERT_ENROLLMENTS is a transactional table in the Oracle E-Business Suite Learning Management module (product code OTA). It records every learner subscription into a certification, storing one row for each learner who enrolls in a given certification. The table resides in the OTA schema and is classified as VALID in both Oracle EBS 12.1.1 and 12.2.2. From a Data Vault modeling perspective, the mined foreign key structure suggests this object behaves as a satellite-leaning entity: it hangs off the certification master (OTA_CERTIFICATIONS_B) and carries the descriptive state, dates, and status of an individual learner's certification journey. It is the central record for tracking certification progress, completion, expiration, and unenrollment at the person level.

Key Information Stored

The table contains 40 documented columns. The surrogate primary key is CERT_ENROLLMENT_ID, enforced by the unique index OTA_CERT_ENROLLMENTS_PK. The most significant columns are:

The remaining columns are standard WHO audit fields (CREATED_BY, CREATION_DATE, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN) and the twenty ATTRIBUTE flex columns plus ATTRIBUTE_CATEGORY. No column other than CERT_ENROLLMENT_ID is documented as a unique business key.

Common Use Cases and Queries

Typical reporting scenarios include identifying all learners actively pursuing a certification, measuring completion and expiration rates, and reconciling manual versus automatic subscriptions. A common pattern joins enrollments to the certification master and to learner records:

SELECT e.cert_enrollment_id,
       e.person_id,
       e.certification_status_code,
       e.enrollment_date,
       e.completion_date,
       e.expiration_date
FROM   ota.ota_cert_enrollments e
WHERE  e.certification_id = :cert_id
AND    e.certification_status_code = 'ACTIVE';

Expiration tracking filters on EXPIRATION_DATE within a window, while audit queries isolate rows by CREATION_DATE or IS_HISTORY_FLAG. Dashboards frequently aggregate enrollment counts grouped by CERTIFICATION_ID and BUSINESS_GROUP_ID.

Related Objects

The table participates in two documented foreign key relationships and is referenced downstream:

  • OTA_CERTIFICATIONS_B — parent certification master; joined via OTA_CERT_ENROLLMENTS.CERTIFICATION_ID.
  • OTA_CERT_PRD_ENROLLMENTS — child table capturing per-period certification enrollments; references OTA_CERT_ENROLLMENTS.CERT_ENROLLMENT_ID.
  • OTA_CERT_ENROLLMENTS_PK — the primary key index supporting unique lookups.
  • Learner and person objects (PER_ALL_PEOPLE_F and related OTA learner views) are commonly joined through PERSON_ID for reporting.

Together these objects form the certification enrollment hierarchy used by Learning Management analytics and administrative processes.