My Oracle Support Banner

Process Mandatory Enrollments Program Is Failing With ORA-01843 Error (Doc ID 2733859.1)

Last updated on DECEMBER 07, 2020

Applies to:

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

Symptoms

On : 12.1.3 version, Learner Component

Process mandatory enrollments program is failing for a specific class with below error messages

ERROR
-----------------------
ORACLE error 1843 in FDPSTP

Cause: FDPSTP failed due to ORA-01843: not a valid month
ORA-06512: at "APPS.OTA_LEARNER_ACCESS_UTIL", line 715
ORA-06512: at "APPS.OTA_MANDATORY_ENROLL_UTIL", line 1164
ORA-06512: at "APPS.OTA_MANDATORY_ENROLL_UTIL", line 23024-NOV-2020 13:10:54


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Learning Administrator Responsibility
2. View Requests > Submit Request> Select “Process Mandatory Enrollments” concurrent program,
3. Select the class in Class LoV, and submit request
4. Program completed with error



Cause

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
Symptoms
Cause
Solution
References


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