In The Search Page Under "Add Course Based On Competency Gap" - Error "java.sql.SQLException: Missing IN or OUT parameter" Is Thrown, When Click On "Add Course" Button After Selecting The Competency (Doc ID 2700441.1)

Last updated on AUGUST 12, 2020

Applies to:

Symptoms

When trying to Find a course for a competency where a Gap is found for the Appriasee, following error appears

ERROR
-----------------------

You have encountered an unexpected error. Please contact the System Administrator for assistance.
Click here for exception details.

EXCEPTION LOG
----------------------------

Exception Details.
 oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT * FROM (select
  tav.activity_version_id,
  tav.version_name activity_version_name,
  tav.start_date,
  tav.end_date,
  tav.activity_id,
  tav.business_group_id,
  ce.competence_id,

..............

......................

## Detail 0 ##
java.sql.SQLException: Missing IN or OUT parameter at index:: 7

..............

......................

STEPS
-----------------------

The issue can be reproduced at will with the following steps:

1. Login as Main Appraiser into the Application.

2. Navigate to function "Performance Management".

3. In the launched page, click on the button against the task "Manage Appraisal".

4. In the launched page, click on "Update" against the Appraisee who needs to be appraised.

5. Now in the launched page, Click on "Give Final Rating" button.

6. In the launched page, under the Cluster "Competency Gaps", Under "Courses", Click on the button "Add Courses Based on Competency Gaps".

7. In the launched page, select Single Competency or Multiple Competencies, to which the Appraisee needs some course training.

8. Now click on the "Find Courses" button and got the above error message.

9. On opening the exception log, observed the above log message.

Cause

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