Exception: JBO-27021: Failed to load CustomDatum value at index 78 with java object of type oracle.jbo.domain.Number When Trying To Open A Repair Job (Doc ID 2112850.1)

Last updated on MARCH 08, 2017

Applies to:

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

Symptoms

On : 12.1.3 version, Repair Execution in Production and Test environment issue

After applying patch Patch No : 22120593:R12.CSD.B When trying to Execute jobs from Repair Jobs Tab of the Repair Order Form ,the following error occurs

ERROR
-----------------------

You have encountered an unexpected error.Please contact the System Administrator for assistance
Error Page
Exception Details.
oracle.apps.fnd.framework.OAException: oracle.jbo.AttributeLoadException: JBO-27021: Failed to load CustomDatum value at index 78 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

at oracle.oc4j.network.ServerSocketAcceptHandler$AcceptHandlerHorse.run(ServerSocketAcceptHandler.java:879)
at com.evermind.util.ReleasableResourcePooledExecutor$MyWorker.run(ReleasableResourcePooledExecutor.java:303)
at java.lang.Thread.run(Thread.java:619) 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:1194)
at oracle.jbo.server.AttributeDefImpl.loadFromResultSet(AttributeDefImpl.java:1633)
at oracle.jbo.server.ViewRowImpl.populate(ViewRowImpl.java:2221)
at oracle.jbo.server.ViewDefImpl.createInstanceFromResultSet(ViewDefImpl.java:1066)
at oracle.jbo.server.ViewObjectImpl.createRowFromResultSet(ViewObjectImpl.java:3014)
at oracle.jbo.server.ViewObjectImpl.createInstanceFromResultSet(ViewObjectImpl.java:2907)


STEPS

The issue can be reproduced at will with the following steps:
1. Apply <Patch:22120593>:R12.CSD.B
2. Navigate to Depot Repair responsibility > Repair Order
3. Find repair order
4. Repair Jobs Tab (There is a Job in released Status) Click Execute Job or from the Repair Technician portal -> Query for a Repair Order and get the same exception details.

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