Error Clicking "Return to Course" From Pre-requisite Course

(Doc ID 1920292.1)

Last updated on DECEMBER 20, 2016

Applies to:

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


Problem Statement:
When attempting to click on "Return to Course" from a selected course pre-requisite, the following error occurs.


e.business_group_id Business_Group_id,
a.activity_version_id Activity_Version_Id,
a.rco_id RCO_Id,
a.version_name Activity_Version_Name,
a.description Activity_Description,
a.objectives Activity_Objectives,
a.intended_audience Activity_Audience,
e.event_id Event_Id,
e.title Event_Title,
--e.course_start_time Event_Start_Time,
ota_timezone_util.get_DateDT_Time(e.course_start_date, e.course_start_time, c.online_flag, e.timezone) Event_Start_Time,
--e.course_start_date Event_Start_Date,
ota_timezone_util.get_DateDT(e.course_start_date, e.course_start_time, c.online_flag, e.timezone) Event_Start_Date,
--decode(e.course_end_date, to_date('4712/12/31','YYYY/MM/DD'),null,e.course_end_date) Event_End_Date,


,e.timezone Timezone_Code,
FROM ota_activity_versions_vl a,
  ota_events_vl e,
  ota_offerings_vl ofr,
  hr_all_organization_units o,
  hr_all_organization_units_tl haotl,
  -- fnd_languages_vl f,
ota_category_usages c,
  ota_conferences cnf
WHERE e.training_center_id = o.organization_id(+)
  AND haotl.organization_id(+) = o.organization_id
  AND haotl.language(+) = USERENV ('LANG')
  AND a.activity_version_id = :8
  AND ofr.offering_id = :9
  AND e.event_id = :10
  --AND f.language_id(+) = ofr.language_id
  AND ofr.delivery_mode_id = c.category_usage_id
  AND e.event_id = cnf.event_id(+)

## Detail 0 ##
java.sql.SQLException: Missing IN or OUT parameter at index:: 1
    at oracle.jdbc.driver.OraclePreparedStatement.processCompletedBindRow(
    at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(
    at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(
    at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(
    at oracle.jbo.server.QueryCollection.buildResultSet(
    at oracle.jbo.server.QueryCollection.executeQuery(

Steps to Reproduce:
Navigate to Learner Self-Service => Learning => Learner Home => Click on "Course Catalog" => Select "Category" => Select "Course" having pre-requisite => Click on course pre-requisite to see the detail => Return to course.


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