Online Payslip Error java.sql.SQLException: Invalid column index and JBO-27022: Failed to load value at index

(Doc ID 2207041.1)

Last updated on DECEMBER 07, 2016

Applies to:

Oracle HRMS (US) - Version 12.1.2 and later
Information in this document applies to any platform.


Attempting to view the online payslip loads the page with the following error:

You have encountered an unexpected error. Please contact the System Administrator for assistance. Click here for exception details

 Replicating the issue with logging enabled captures the following in the log:


Exception Details.
oracle.apps.fnd.framework.OAException: oracle.jbo.AttributeLoadException: JBO-27022: Failed to load value at index 47 with java object of type java.lang.String due to java.sql.SQLException.
at oracle.apps.fnd.framework.OAException.wrapperException(
at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(
at oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(



## Detail 0 ##
java.sql.SQLException: Invalid column index
at oracle.jdbc.driver.OracleResultSetImpl.getObject(
at oracle.jbo.server.OracleSQLBuilderImpl.doLoadFromResultSet(
at oracle.jbo.server.AttributeDefImpl.loadFromResultSet(
at oracle.jbo.server.ViewRowImpl.populate(



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