My Oracle Support Banner

Missing In or Out Parameter Error When Selecting Salary Basis During the Creation of Offers (Doc ID 2375828.1)

Last updated on JULY 07, 2020

Applies to:

Oracle iRecruitment - Version 12.2 HRMS RUP10 and later
Information in this document applies to any platform.

Symptoms

On : 12.2 HRMS RUP10 version, Offers

When attempting to click the list of values (lov) for the field Salary Basis while creating an offer to an applicant, the following error occurs.

Error:
-----------------------
You have encountered an unexpected error. Please contact the system administrator for assistance.

Exception details

oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT * FROM (SELECT
paybases.pay_basis_id
,paybases.input_value_id
,paybases.name
,paybasis.meaning pay_basis_meaning
,pet.input_currency_code
FROM
PER_PAY_BASES paybases
,HR_LOOKUPS paybasis
,PAY_INPUT_VALUES_F piv
,PAY_ELEMENT_TYPES_F pet
WHERE
paybasis.lookup_code(+) = paybases.pay_basis
AND paybasis.lookup_type(+) = 'PAY_BASIS'
AND piv.input_value_id = paybases.input_value_id
AND :1 BETWEEN piv.effective_start_date AND piv.effective_end_date
AND pet.element_type_id = piv.element_type_id
AND :2 BETWEEN pet.effective_start_date AND pet.effective_end_date
AND paybases.business_group_id = :3) QRSLT
WHERE (( UPPER(NAME) like UPPER(:1) AND (NAME like :2 OR NAME like :3 OR NAME like :4 OR NAME like :5)))
at oracle.apps.fnd.framework.OAException.wrapperException(OAException.java:912)
at oracle.apps.fnd.framework.webui.OAPageErrorHandler.prepareException(OAPageErrorHandler.java:1232)
at oracle.apps.fnd.framework.webui.OAPageErrorHandler.processErrors(OAPageErrorHandler.java:1497)
..
..
## Detail 0 ##
java.sql.SQLException: Missing IN or OUT parameter at index:: 6
at oracle.jdbc.driver.OraclePreparedStatement.processCompletedBindRow(OraclePreparedStatement.java:1899)
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3764)
at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3823)
..
..
at weblogic.servlet.internal.ServletRequestImpl.run(ServletRequestImpl.java:1499)
at weblogic.work.ExecuteThread.execute(ExecuteThread.java:263)
at weblogic.work.ExecuteThread.run(ExecuteThread.java:221)


Steps to Reproduce:

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

1. Log on to the Applications.

2. Choose the responsibility iRecruitment Recruiter.

3. Navigate to iRecruitment Home-> Vacancies.

4. Search for a vacancy.

5. Select a vacancy and click the View Applicants button.

6. Select an applicant and click the Create Offer button.

7. Enter the basic details of the offer.

8. Click on the lov for the field Salary Basis.

 

Changes

 Upgraded to E-Business Suite 12.2.

Cause

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
Symptoms
Changes
Cause
Solution
References


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