'Jbo-27122: Sql Error During Statement Preparation' Error When Search For Class

(Doc ID 850671.1)

Last updated on AUGUST 25, 2017

Applies to:

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

Symptoms

-- Problem Statement:
On 12.0.6 in Production:
When attempting to update enrollment status, on the Enrollment update page, for the field Class , when clicking for Class search, on the LOV page, whenever the search is done, without any search string , the lov page errors out with following error ,

ERROR

JBO-27122: SQL error during statement preparation. Statement: SELECT * FROM (SELECT
EVT.EVENT_ID,
ETL.TITLE CLASS_NAME,
OFF.NAME OFFERING_NAME,
ATL.VERSION_NAME COURSE_NAME,
EVT.COURSE_START_DATE START_DATE,
EVT.COURSE_END_DATE END_DATE,
ORG.NAME TRAINING_CENTRE,
EVT.currency_code,
EVT.event_status,
EVT.event_type,
EVT.enrolment_end_date,
oft.learning_object_id,
EVT.price_basis
,evt.standard_price
,tav.inventory_item_id
FROM
OTA_EVENTS EVT,
OTA_EVENTS_TL ETL,
OTA_ACTIVITY_VERSIONS_TL ATL,
OTA_OFFERINGS_TL OFF,
HR_ALL_ORGANIZATION_UNITS_TL ORG,
hr_lookups sta,
hr_lookups cen,
ota_offerings oft,
ota_activity_versions tav

and java.sql.SQLException: ORA-01843 : not a valid month

-- Steps To Reproduce:
The issue can be reproduced at will with the following steps:
1. Update enrollment status for enrollment(s) . Enrollment page may be reached by any of the four
navigation .

=== Navigation : OLM Admin > Learner > Enrollments and Subscriptions > Search for class :
Class 1 > Select the listed enrollments > Update Enrollments
=== Navigation : OLM Admin > Learner > Enrollments and Subscriptions > Search for class :
Class 1 > for the desired enrollment, click on the Update icon in the listed enrollment row
=== Navigation : OLM Admin > Catalog > navigate to respective class > Enrollments >
Select the listed enrollments > Update Enrollments
=== Navigation : OLM Admin > Catalog > navigate to respective class > Enrollments >
for the desired enrollment, click on the Update icon in the listed enrollment row

-- Business Impact:
The issue has the following business impact:
Due to this issue, users cannot update enrollment status for the enrollments .

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms