Click Purchase Order (PO) To See PO Details Gives Error JBO-27022: Failed to Load Value at Index 99 With Java Object of Type
(Doc ID 1915633.1)
Last updated on JUNE 06, 2023
Applies to:
Oracle iSupplier Portal - Version 12.1.3 and laterOracle Purchasing - Version 12.1.3 and later
Information in this document applies to any platform.
Symptoms
Clicking an Order number in iSupplier Portal to view PO Details after <Patch 19239283>:R12.POS.B gets AttributeLoadException: JBO-27022 Failed to load value at index 99
ERROR
Exception Details.
oracle.apps.fnd.framework.OAException: oracle.jbo.AttributeLoadException: JBO-27022: Failed to load value at index 99 with java object of type java.lang.String due to java.sql.SQLException.
at oracle.apps.fnd.framework.OAException.wrapperException(OAException.java:912)
at oracle.apps.fnd.framework.webui.OAPageErrorHandler.prepareException(OAPageErrorHandler.java:1169)
at oracle.apps.fnd.framework.webui.OAPageErrorHandler.processErrors(OAPageErrorHandler.java:1435)
at oracle.apps.fnd.framework.webui.OAPageBean.processRequest(OAPageBean.java:2685)
at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:1950)
at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:550)
at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:438)
at _OA._jspService(_OA.java:212)
...
...
## 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:1200)
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)
...
STEPS TO REPRODUCE
1. Apply <Patch 19239283>:R12.POS.B (or similar)
2. Navigate to iSupplier Portal
3. Orders tab
4. Click an order number
- get the error exception
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 |