Return Receipts Gives Error JBO-27021: Failed To Load CustomDatum Value At Index 30 (Doc ID 2054061.1)

Last updated on JUNE 07, 2016

Applies to:

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

Symptoms

On : 12.2.3 version,

When attempting to search to return,
the following error occurs.

 Performance is also bad for the criteria in the screenshot. It took about 1 minute 40 seconds before erroring out

ERROR
-----------------------
Error Page
Exception Details.
oracle.apps.fnd.framework.OAException: oracle.jbo.AttributeLoadException: JBO-27021: Failed to load CustomDatum value at index 30 with java object of type oracle.jbo.domain.Number due to java.sql.SQLException.
at oracle.apps.fnd.framework.OAException.wrapperException(OAException.java:912)
at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:647)
at oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(OAWebBeanContainerHelper.java:252)

## Detail 0 ##
java.sql.SQLException: Invalid column index
at oracle.jdbc.driver.OracleResultSetImpl.getBytes(OracleResultSetImpl.java:1494)
at weblogic.jdbc.wrapper.ResultSet_oracle_jdbc_driver_OracleResultSetImpl.getBytes(Unknown Source)
at oracle.jbo.domain.Number$1facClass.createDatum(Number.java:103)

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Search by receipt number and requisition


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