My Oracle Support Banner

Employee Self Service - Special Information (SIT), Errors: JBO-27022 and java.sql.SQLException: Invalid column index (Doc ID 2180461.1)

Last updated on SEPTEMBER 29, 2020

Applies to:

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

Symptoms

On : 12.1 HRMS RUP9 version, EIT and SIT

Employee Self Service - Special Information Java Error - JBO-27022

The following Java error occurs when attempting to access the Special Information function on Employee Self Service.

All Personalizations have been removed from the admin side, however, we are still receiving an error.  The same error is received on the seeded Employee Self Service menu as well.

 


## Detail 0 ##
java.sql.SQLException: Invalid column index
  at oracle.jdbc.driver.OracleResultSetImpl.getObject(OracleResultSetImpl.java:1042)
  at oracle.jbo.server.OracleSQLBuilderImpl.doLoadFromResultSet(OracleSQLBuilderImpl.java:1200)
  at oracle.jbo.server.AttributeDefImpl.loadFromResultSet(AttributeDefImpl.java:1634)
  at oracle.jbo.server.ViewRowImpl.populate(ViewRowImpl.java:2221)
  at oracle.jbo.server.ViewDefImpl.createInstanceFromResultSet(ViewDefImpl.java:1073)
  at oracle.jbo.server.ViewObjectImpl.createRowFromResultSet(ViewObjectImpl.java:3045)
  at oracle.jbo.server.ViewObjectImpl.createInstanceFromResultSet(ViewObjectImpl.java:2917)
  at oracle.jbo.server.QueryCollection.populateRow(QueryCollection.java:2398)
  at oracle.jbo.server.QueryCollection.fetch(QueryCollection.java:2256)
  at oracle.jbo.server.QueryCollection.get(QueryCollection.java:1504)
  at oracle.jbo.server.ViewRowSetImpl.getRow(ViewRowSetImpl.java:3705)
  at oracle.jbo.server.ViewRowSetIteratorImpl.doFetch(ViewRowSetIteratorImpl.java:2815)
  at oracle.jbo.server.ViewRowSetIteratorImpl.ensureRefreshed(ViewRowSetIteratorImpl.java:2671)
  at oracle.jbo.server.ViewRowSetIteratorImpl.ensureRefreshed(ViewRowSetIteratorImpl.java:2631)
  at oracle.jbo.server.ViewRowSetIteratorImpl.first(ViewRowSetIteratorImpl.java:1471)
  at oracle.jbo.server.ViewRowSetImpl.first(ViewRowSetImpl.java:2836)
  at oracle.jbo.server.ViewObjectImpl.first(ViewObjectImpl.java:5831)
  at oracle.apps.per.selfservice.specialinformation.server.SpecialInformationDetailsVOImpl.runQuery(SpecialInformationDetailsVOImpl.java:214)
  at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
...



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

1. Create DFF Segments for SIT - Driver License and Language Proficiency
2. Personalize Employee Self-Service to display these segments
3. Employee receives error when openin SIT for update.


Changes

 12.1.3 RUP 9 was applied to the system.

 

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


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