“Go To Receiving” Link From The Confirm Receipt Notification Is Erroring Out With JBO-27021: Failed to Load CustomDatum Value at Index 51 (Doc ID 2253255.1)

Last updated on APRIL 08, 2017

Applies to:

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

Symptoms

On : 12.1.3 version,


When attempting to Go to Receiving from the notification,
the following error occurs.

ERROR
-----------------------
JBO-27021: Failed to load CustomDatum value at index 51 with java object of type oracle.jbo.domain.Number due to java.sql.SQLException.;
at oracle.apps.fnd.framework.OAException.wrapperException(OAException.java:912)
...
## Detail 0 ##
java.sql.SQLException: Invalid column index
at oracle.jdbc.driver.OracleResultSetImpl.getBytes(OracleResultSetImpl.java:656)
at oracle.jbo.domain.Number$1facClass.createDatum(Number.java:103)
at oracle.jbo.server.OracleSQLBuilderImpl.doLoadFromResultSet(OracleSQLBuilderImpl.java:1196)
at oracle.jbo.server.AttributeDefImpl.loadFromResultSet(AttributeDefImpl.java:1634)
at oracle.jbo.server.ViewRowImpl.populate(ViewRowImpl.java:2221)


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1 Go to .iProcurement > Worklist
2. Click on the ‘confirm receipt of order 99999’ which displays the Confirm Receipt of Order
3. Click on "Go To Receiving" link
4. The error occurs

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