My Oracle Support Banner

Question on Certification Due Dates and Expiration Dates And The Difference Between OTA_CERT_PRD_ENROLLMENTS and OTA_CERT_ENROLLMENTS (Doc ID 2559715.1)

Last updated on SEPTEMBER 29, 2020

Applies to:

Oracle Learning Management - Version 12.2.8 and later
Information in this document applies to any platform.

Goal

Multiple questions about OLM dates, Statuses and Tables

1) What is difference between Due date and Expiration Date

2) How is due date shown on the screen is calculated

3) What is difference between OTA_CERT_ENROLLMENTS and OTA_CERT_PRD_ENROLLMENTS tables

4) Why there are different set of statuses in both of these tables?

OTA_CERT_ENROLLMENTS
---------------------------------
ENROLLED
CANCELLED
AWAITING_APPROVAL
REJECTED
CERTIFIED
EXPIRED
RENEWING


OTA_CERT_PRD_ENROLLMENTS
----------------------------------------
ENROLLED
CANCELLED
EXPIRED
ACTIVE
COMPLETED
 

Solution

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document
Goal
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.