Learner Self-Service: Search for a Class or Course Results in "JBO-27122: SQL error during statement preparation" (Doc ID 1969974.1)

Last updated on MARCH 08, 2017

Applies to:

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

Symptoms

Learner Home, Search for Course Or Class Results in "Unexpected Error" being generated.

Course Search Error:
=================

Exception Details.
oracle.apps.fnd.framework.OAException:
oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement
preparation. Statement: SELECT Activity_Version_Id,
  Activity_Version_Name,
  Activity_Version_Code,
  Course_Image_Name,
  Course_Image_Switch,
  Activity_Description,
  Activity_Keywords,
  Activity_Objectives
FROM (
SELECT avtl.activity_version_id Activity_Version_Id,
  avtl.version_name Activity_Version_Name,
  av.version_code Activity_Version_Code,
  ooi.object_image_name Course_Image_Name,
  decode(ooi.object_image_name,NULL,'NO_IMAGE','COURSE_IMAGE')
Course_Image_Switch,
  avtl.Description Activity_Description,
  avtl.Keywords Activity_Keywords,
  avtl.Objectives Activity_Objectives
FROM ota_activity_versions_tl avtl, ota_activity_versions av,(select *
from OTA_OBJECT_IMAGES where object_type = 'ACT') ooi
WHERE avtl.activity_version_id = av.activity_version_id
AND TRUNC(SYSDATE) BETWEEN NVL(TRUNC(av.start_date),TRUNC(SYSDATE)) and
NVL(TRUNC(av.end_date),TRUNC(SYSDATE+1))
AND avtl.language = USERENV('LANG')
AND UPPER(avtl.version_name) like UPPER(:1)
AND ooi.object_id (+) = av.activity_version_id
UNION
SELECT avtl.activity_version_id Activity_Version_Id,
  avtl.version_name Activity_Version_Name,
  av.version_code Activity_Version_Code,
  ooi.object_image_name Course_Image_Name,
  decode(ooi.object_image_name,NULL,'NO_IMAGE','COURSE_IMAGE')
Course_Image_Switch,
  avtl.Description Activity_Description,
  avtl.Keywords Activity_Keywords,
  avtl.Objectives Activity_Objectives
FROM ota_activity_versions_tl avtl, ota_activity_versions av, (select *
from OTA_OBJECT_IMAGES where object_type = 'ACT') ooi
WHERE avtl.activity_version_id = av.activity_version_id
AND TRUNC(SYSDATE) BETWEEN NVL(TRUNC(av.start_date),TRUNC(SYSDATE)) and
NVL(TRUNC(av.end_date),TRUNC(SYSDATE+1))
AND avtl.language = USERENV('LANG')
AND UPPER(avtl.Keywords) like UPPER(:2)
AND ooi.object_id (+) = av.activity_version_id
) WHERE
ota_learner_access_util.learner_has_access_to_course(:3,:4,Activity_Version_Id)
= 'Y'
at
oracle.apps.fnd.framework.OAException.wrapperException(OAException.java:912)

This can also result in
Error Ora-1843: Not A Valid Month.

 

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