My Oracle Support Banner

Error Page When Adding Absences to Absence Case (Doc ID 2412846.1)

Last updated on JUNE 19, 2018

Applies to:

Oracle Self-Service Human Resources - Version 12.2 HRMS RUP10 and later
Information in this document applies to any platform.

Symptoms

Problem Statement:

When attempting to add Associated Absences to any Absence Case the following error occurs:

Exception Details.
oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT * FROM (SELECT ABSENCE_ATTENDANCE_ID, BUSINESS_GROUP_ID, ABSENCE_ATTENDANCE_TYPE_ID, ABS_ATTENDANCE_REASON_ID,
PERSON_ID, AUTHORISING_PERSON_ID, REPLACEMENT_PERSON_ID, PERIOD_OF_INCAPACITY_ID, ABSENCE_DAYS, ABSENCE_HOURS, COMMENTS, DATE_END, DATE_NOTIFICATION, DATE_PROJECTED_END, DATE_PROJECTED_START, DATE_START, OCCURRENCE, SSP1_ISSUED, TIME_END, TIME_PROJECTED_END, TIME_PROJECTED_START, TIME_START, ATTRIBUTE_CATEGORY, ATTRIBUTE1, ATTRIBUTE2, ATTRIBUTE3, ATTRIBUTE4, ATTRIBUTE5, ATTRIBUTE6, ATTRIBUTE7, ATTRIBUTE8, ATTRIBUTE9, ATTRIBUTE10, ATTRIBUTE11, ATTRIBUTE12, ATTRIBUTE13, ATTRIBUTE14, ATTRIBUTE15, ATTRIBUTE16, ATTRIBUTE17, ATTRIBUTE18, ATTRIBUTE19, ATTRIBUTE20, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN, CREATED_BY, CREATION_DATE, ABSENCE_TYPE, AUTHORIZER_NAME, AUTHORIZER_NO, REPLACEMENT_NAME, REPLACEMENT_NO, ABSENCE_REASON, ABSENCE_CATEGORY, ABSENCE_CASE_ID FROM PER_ABSENCE_ATTENDANCES_V3 WHERE PERSON_ID = :1 /*AND DATE_START BETWEEN NVL(:2,DATE_START) AND NVL(:3,DATE_START)*/) QRSLT WHERE (absence_case_id is null AND (Date_start is not null or date_end is not null) AND (DATE_START IS NULL OR DATE_START >= nvl(:6,DATE_START))) ORDER BY DATE_START ASC
at oracle.apps.fnd.framework.OAException.wrapperException(OAException.java:912)
at oracle.apps.fnd.framework.OAException.wrapperException(OAException.java:886)
at oracle.apps.fnd.framework.OAException.wrapperInvocationTargetException(OAException.java:1009)
at oracle.apps.fnd.framework.server.OAUtility.invokeMethod(Unknown Source)

----- ----- ----- ----- ----- ----- ----- ----- ----- ----- ----- ----- ----- ----- ----- ----- ----- ----- ----- ----- ----- ----- ----- -----

## Detail 0 ##
java.sql.SQLException: Invalid column index
at oracle.jdbc.driver.OraclePreparedStatement.setNullCritical(OraclePreparedStatement.java:5190)
at oracle.jdbc.driver.OraclePreparedStatement.setNull(OraclePreparedStatement.java:5159)
at oracle.jdbc.driver.OraclePreparedStatementWrapper.setNull(OraclePreparedStatementWrapper.java:1435)
at weblogic.jdbc.wrapper.PreparedStatement.setNull(PreparedStatement.java:622)

 

 

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

  1. Responsibility: US Super HRMS Manager

  2. Navigate: FastPath > Absence Cases > Query Employee
     
  3. Click Create Absence Case

  4. Click Finish

  5. Navigate back to the Absence Case and click Update

  6. Click Add Absences

  7. On the page: Add Absences to Absence Case > Enter any Search Criteria and Click Go

 

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!


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