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

Last updated on MARCH 31, 2017

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
Test Instance - Prior to go live

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

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