SSHR > Hire Applicant Error - Missing In Or Out Parameter At Index:: 1 (Doc ID 786037.1)

Last updated on APRIL 16, 2016

Applies to:

Oracle Self-Service Human Resources - Version 12.0.6 to 12.0.6 [Release 12.0]
Information in this document applies to any platform.
Oracle HRMS (Self Service) - Version: 12.0.6


Symptoms

When attempting to hire applicant in SSHR application, the following error occurs:

oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122:
SQL error during statement preparation. Statement: SELECT * FROM (select flv.
lookup_code , flv.meaning
from fnd_lookup_values flv
where :1 between nvl(start_date_active, :2 ) and nvl(end_date_active, :3 )
and lookup_type = :4
and flv.view_application_id = 3
and enabled_flag = 'Y'
and decode(FLV.TAG, NULL, 'Y', decode(substr(FLV.TAG,1,1), '+',
decode(sign(instr(FLV.TAG, :5)), 1, 'Y', 'N'), '-', decode(sign(instr(FLV.TAG,:
6)), 1, 'N', 'Y'), 'Y' ) ) = 'Y'
and flv.language = :7
and flv.security_group_id = :8) QRSLT ORDER BY meaning
at oracle.apps.fnd.framework.OAException.wrapperException(OAException.java:896)
at oracle.apps.fnd.framework.webui.OAPageErrorHandler.
prepareException(OAPageErrorHandler.java:1169)
at oracle.apps.fnd.framework.webui.OAPageBean.renderDocument

...

...

at java.lang.Thread.run(Thread.java:595)
## Detail 0 ##
java.sql.SQLException: Missing IN or OUT parameter at index:: 1

 

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