My Oracle Support Banner

"java.sql.SQLException: Missing IN or OUT Parameter at Index:: 1" Error When Viewing Checklist for Terminated Employee After Final Process Date (Doc ID 1997572.1)

Last updated on DECEMBER 22, 2016

Applies to:

Oracle Human Resources - Version 12.1 HRMS RUP7 and later
Information in this document applies to any platform.


On : 12.1 HRMS RUP7 version, Terminations

When attempting to view checklist after the final process date has passed,
the following error occurs.

java.sql.SQLException: Missing IN or OUT parameter at index:: 1
at oracle.jdbc.driver.OraclePreparedStatement.processCompletedBindRow(

The issue can be reproduced at will with the following steps:
US HRMS Manager > Allocated Checklist > Click on Advanced Search > enter terminated worker > Click Go > Click Action icon and error page displays.


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

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