User Getting " oracle.jbo.AttributeLoadException: JBO-27021: Failed to load CustomDatum value at index 89" Exception When Trying to Update Setup For Some Field Service Resources (Doc ID 2475911.1)

Last updated on JULY 19, 2020

Applies to:

Symptoms

On : 12.1.3 version, Setup Issues

In the "Field Service Resource: Search" page, after query a resource, when click the Setup icon, an exception occurs.

ERROR
-----------------------
Exception Details.
oracle.apps.fnd.framework.OAException: oracle.jbo.AttributeLoadException: JBO-27021: Failed to load CustomDatum value at index 89 with java object of type oracle.jbo.domain.Number due to java.sql.SQLException.
...
## 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)
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.getRowCount(QueryCollection.java:1863)
at oracle.jbo.server.ViewRowSetImpl.getRowCount(ViewRowSetImpl.java:1942)
at oracle.jbo.server.ViewObjectImpl.getRowCount(ViewObjectImpl.java:6050)

at oracle.apps.csf.admin.resource.setup.server.ResourceSetupAMImpl.initiateRuleVO(ResourceSetupAMImpl.java:203)
at oracle.apps.csf.admin.resource.setup.server.ResourceSetupAMImpl.initQuery(ResourceSetup


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Field Service Manager > Field Service Setup > Field Service Resource Setup
2. Query a resource
3. Click the "Setup" icon
4. The reported exception occurs

Changes

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.