We got this error message when we are upgrading Oracle11i to R12.1.3 and many of self service screen are not working because of this issue.
Error Message
oracle.apps.fnd.framework.OAException: oracle.jbo.AttributeLoadException: JBO-27022: Failed to load value at index 84 with java object of type java.lang.String due to java.sql.SQLException.
at oracle.apps.fnd.framework.OAException.wrapperException(OAException.java:912)
-----Lines deleted------
## Detail 0 ##
java.sql.SQLException: Invalid column index
at oracle.jdbc.driver.OracleResultSetImpl.getObject(OracleResultSetImpl.java:1042)
at oracle.jbo.server.OracleSQLBuilderImpl.doLoadFromResultSet(OracleSQLBuilderImpl.java:1198)
at oracle.jbo.server.AttributeDefImpl.loadFromResultSet(AttributeDefImpl.java:1633)
at oracle.jbo.server.ViewRowImpl.populate(ViewRowImpl.java:2221)
Solution
The issue is coming because there is a difference between 11i and R12 VO attribute. In nutshell, new attributes has been added in R12 view object.
To resolve this issue, Copy the R12 view object files to Jdev 10G and do the substitution again and deploy the related files to R12 instance and bounce Apache.
Thanks
--Anil
