My Oracle Support Banner

Get "JBO-27022: Failed to load value at index 66 with java object of type java.lang.String due to java.sql.SQLException" When Trying to Access the Project Setup Page (Doc ID 3057038.1)

Last updated on NOVEMBER 04, 2024

Applies to:

Oracle Project Billing - Version 12.2.9 and later
Information in this document applies to any platform.

Symptoms

When trying to access the Project Setup page, get the error page below:

"You have encountered an unexpected error. Please contact your System Administrator for assistance."

 

The exception details shows error:

oracle.apps.fnd.framework.OAException: oracle.jbo.AttributeLoadException: JBO-27022: Failed to load value at index 66 with java object of type java.lang.String due to java.sql.SQLException.
at oracle.jbo.server.OracleSQLBuilderImpl.doLoadFromResultSet(OracleSQLBuilderImpl.java:1243)
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)
...

 

This issue occurs with all Projects responsibility and users.

 

Steps
====

1. Login a Projects Super User responsibility

2. Navigate to Projects: Delivery > Search Project
Open an existing project.

3. Go to Project > Setup. Get the Unexpected Error.  The exception details shows error:
"JBO-27022: Failed to load value at index 66 with java object of type java.lang.String due to java.sql.SQLException."



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
Cause
Solution
References


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