My Oracle Support Banner

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:

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


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.

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(
at oracle.jbo.domain.Number$1facClass.createDatum(
at oracle.jbo.server.OracleSQLBuilderImpl.doLoadFromResultSet(
at oracle.jbo.server.AttributeDefImpl.loadFromResultSet(
at oracle.jbo.server.ViewRowImpl.populate(
at oracle.jbo.server.ViewDefImpl.createInstanceFromResultSet(
at oracle.jbo.server.ViewObjectImpl.createRowFromResultSet(
at oracle.jbo.server.ViewObjectImpl.createInstanceFromResultSet(
at oracle.jbo.server.QueryCollection.populateRow(
at oracle.jbo.server.QueryCollection.fetch(
at oracle.jbo.server.QueryCollection.getRowCount(
at oracle.jbo.server.ViewRowSetImpl.getRowCount(
at oracle.jbo.server.ViewObjectImpl.getRowCount(

at oracle.apps.csf.admin.resource.setup.server.ResourceSetupAMImpl.initiateRuleVO(
at oracle.apps.csf.admin.resource.setup.server.ResourceSetupAMImpl.initQuery(ResourceSetup

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




To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

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