Error JBO-27022 When Clicking The Requisitions Tab In IProcurement

(Doc ID 1626152.1)

Last updated on JANUARY 17, 2018

Applies to:

Oracle iProcurement - Version 12.1.3 and later
Information in this document applies to any platform.


When attempting to open the requisition tab, the following error occurs.

"oracle.apps.fnd.framework.OAException: Application: FND, Message Name: FND_GENERIC_MESSAGE. Tokens: MESSAGE = oracle.jbo.AttributeLoadException: JBO-27022: Failed to load value at index 22 with java object of type java.lang.Boolean due to java.sql.SQLException.;
at oracle.apps.fnd.framework.OAException.wrapperException(
at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(
at com.evermind.util.ReleasableResourcePooledExecutor$
## 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(
at oracle.jbo.server.ViewDefImpl.createInstanceFromResultSet(
at oracle.jbo.server.ViewObjectImpl.createRowFromResultSet(
at oracle.jbo.server.ViewObjectImpl.createInstanceFromResultSet(

The issue can be reproduced at will with the following steps:
1. Go to iProcurement -> Requisitions Tab
2. See the error


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