JBO-27021 Failed to load CustomDatum value at index 51, When Creating A Receipt in Oracle iProcurement (Doc ID 2127497.1)

Last updated on DECEMBER 20, 2016

Applies to:

Oracle iProcurement - Version 12.1.3 to 12.2.4 [Release 12.1 to 12.2]
Information in this document applies to any platform.

Symptoms

In Oracle iProcurement, Release 12.2.2 through 12.2.4, an error occurs during creation of a receipt.
The issue occurs for some, but all not, orders.
Due to this issue, users cannot enter the received quantity of goods and services for their orders/requisitions.


Error

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

 

Exception Details.
 oracle.apps.fnd.framework.OAException: oracle.jbo.AttributeLoadException: 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)
at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:647)
at oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(OAWebBeanContainerHelper.java:267)
at oracle.apps.fnd.framework.webui.OAPageLayoutHelper.processRequest(OAPageLayoutHelper.java:1295)
at oracle.apps.fnd.framework.webui.beans.layout.OAPageLayoutBean.processRequest(OAPageLayoutBean.java:1569)
at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:1003)
at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:970)
at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:690)
at oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(OAWebBeanContainerHelper.java:267)
at oracle.apps.fnd.framework.webui.beans.form.OAFormBean.processRequest(Unknown Source)
at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:1003)
at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:970)
at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:690)
at oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(OAWebBeanContainerHelper.java:267)
at oracle.apps.fnd.framework.webui.beans.OABodyBean.processRequest(OABodyBean.java:353)
at oracle.apps.fnd.framework.webui.OAPageBean.processRequest(OAPageBean.java:2771)
at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:1991)
at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:567)
at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:455)
at _pages.__oa._jspService(__oa.java:233)
..
..
## 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)
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)
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.getRowCountInRange(ViewRowSetIteratorImpl.java:697)
at oracle.jbo.server.ViewRowSetImpl.getRowCountInRange(ViewRowSetImpl.java:3203)
at oracle.jbo.server.ViewObjectImpl.getRowCountInRange(ViewObjectImpl.java:7066)
at oracle.apps.fnd.framework.server.OAViewObjectImpl.getRowCountInRange(OAViewObjectImpl.java:2006)
at oracle.apps.fnd.framework.webui.OAWebBeanBaseTableHelper.adjustViewRange(OAWebBeanBaseTableHelper.java:279)
at oracle.apps.fnd.framework.webui.OATableHelper.prepareNavigatorProperties(OATableHelper.java:1907)
at oracle.apps.fnd.framework.webui.OATableHelper.prepareForRendering(OATableHelper.java:616)
at oracle.apps.fnd.framework.webui.beans.table.OATableBean.prepareForRendering(OATableBean.java:1224)
at oracle.apps.icx.por.rcv.webui.RcvSrchCO.setColumnAlignment(RcvSrchCO.java:162)
at oracle.apps.icx.por.rcv.webui.RcvSrchCO.renderSearchResult(RcvSrchCO.java:592)
at oracle.apps.icx.por.rcv.webui.RcvSrchCO.processRequest(RcvSrchCO.java:138)
at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:631)
at oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(OAWebBeanContainerHelper.java:267)
at oracle.apps.fnd.framework.webui.OAPageLayoutHelper.processRequest(OAPageLayoutHelper.java:1295)
at oracle.apps.fnd.framework.webui.beans.layout.OAPageLayoutBean.processRequest(OAPageLayoutBean.java:1569)
at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:1003)
at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:970)
at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:690)
at oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(OAWebBeanContainerHelper.java:267)
at oracle.apps.fnd.framework.webui.beans.form.OAFormBean.processRequest(Unknown Source)
at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:1003)
at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:970)
at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:690)
at oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(OAWebBeanContainerHelper.java:267)
at oracle.apps.fnd.framework.webui.beans.OABodyBean.processRequest(OABodyBean.java:353)
at oracle.apps.fnd.framework.webui.OAPageBean.processRequest(OAPageBean.java:2771)
at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:1991)
at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:567)
at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:455)
at _pages.__oa._jspService(__oa.java:233)
..
..

 


Steps To Reproduce

The issue can be reproduced at will with the following steps:
1. Log in to Oracle Applications, using an iProcurement responsibility.
2. Click the Receiving tab.
3. Search for the order/line to receive. The error occurs when trying to save/apply the receipt information.



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