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 laterInformation in this document applies to any platform.
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
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
Symptoms |
Changes |
Cause |
Solution |
References |