6 Replies Latest reply on Aug 10, 2012 2:13 PM by 761975

    JBO-27022: Failed to load value at index 20 with java object of type java

    761975
      Hi,

      I'm getting this error for Advanced Search page extended for resultstable VO..
      Actually i have extended seeded VO to include new item (calling database function) as last column with data type java.lang.string.The new column is attribute so most of the time data is NULL in it.
      I have tried changing VO binding style to Oracle positional but it didn't help.
      This error occurs when i click on GO button for default search of 4 criteria itself even before choosing new search.
      Can someone give inputs??

      Exception Details.
      oracle.apps.fnd.framework.OAException: oracle.jbo.AttributeLoadException: JBO-27022: Failed to load value at index 20 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.OAException.wrapperException(OAException.java:886)
           at oracle.apps.fnd.framework.OAException.wrapperInvocationTargetException(OAException.java:1009)
           at oracle.apps.fnd.framework.server.OAUtility.invokeMethod(OAUtility.java:211)
           at oracle.apps.fnd.framework.server.OAUtility.invokeMethod(OAUtility.java:133)
           at oracle.apps.fnd.framework.server.OAViewObjectImpl.invokeMethod(OAViewObjectImpl.java:1173)
           at oracle.apps.eam.asset.webui.ResultsTableCO.processRequest(ResultsTableCO.java:67)
           at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:600)
           at oracle.apps.fnd.framework.webui.OAWebBeanTableHelper.processRequest(OAWebBeanTableHelper.java:2144)
           at oracle.apps.fnd.framework.webui.OAAdvancedTableHelper.processRequest(OAAdvancedTableHelper.java:662)
           at oracle.apps.fnd.framework.webui.beans.table.OAAdvancedTableBean.processRequest(OAAdvancedTableBean.java:739)
           at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:968)
           at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:935)
           at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:659)
           at oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(OAWebBeanContainerHelper.java:252)
           at oracle.apps.fnd.framework.webui.beans.layout.OACellFormatBean.processRequest(OACellFormatBean.java:411)
           at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:968)
           at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:935)
           at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:659)
           at oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(OAWebBeanContainerHelper.java:252)
           at oracle.apps.fnd.framework.webui.beans.layout.OARowLayoutBean.processRequest(OARowLayoutBean.java:347)
           at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:968)
           at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:935)
           at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:659)
           at oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(OAWebBeanContainerHelper.java:252)
           at oracle.apps.fnd.framework.webui.beans.layout.OATableLayoutBean.processRequest(OATableLayoutBean.java:353)
           at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:968)
           at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:935)
           at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:659)
           at oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(OAWebBeanContainerHelper.java:252)
           at oracle.apps.fnd.framework.webui.beans.layout.OATableLayoutBean.processRequest(OATableLayoutBean.java:353)
           at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:968)
           at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:935)
           at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:659)
           at oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(OAWebBeanContainerHelper.java:252)
           at oracle.apps.fnd.framework.webui.beans.layout.OAStackLayoutBean.processRequest(OAStackLayoutBean.java:350)
           at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:968)
           at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:935)
           at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:659)
           at oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(OAWebBeanContainerHelper.java:252)
           at oracle.apps.fnd.framework.webui.beans.layout.OAHeaderBean.processRequest(OAHeaderBean.java:391)
           at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:968)
           at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:935)
           at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:659)
           at oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(OAWebBeanContainerHelper.java:252)
           at oracle.apps.fnd.framework.webui.beans.layout.OAStackLayoutBean.processRequest(OAStackLayoutBean.java:350)
           at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:968)
           at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:935)
           at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:659)
           at oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(OAWebBeanContainerHelper.java:252)
           at oracle.apps.fnd.framework.webui.OAQueryHelper.processRequest(OAQueryHelper.java:563)
           at oracle.apps.fnd.framework.webui.beans.layout.OAStackLayoutBean.processRequest(OAStackLayoutBean.java:350)
           at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:968)
           at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:935)
           at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:659)
           at oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(OAWebBeanContainerHelper.java:252)
           at oracle.apps.fnd.framework.webui.beans.layout.OAStackLayoutBean.processRequest(OAStackLayoutBean.java:350)
           at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:968)
           at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:935)
           at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:659)
           at oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(OAWebBeanContainerHelper.java:252)
           at oracle.apps.fnd.framework.webui.OAPageLayoutHelper.processRequest(OAPageLayoutHelper.java:1183)
           at oracle.apps.fnd.framework.webui.beans.layout.OAPageLayoutBean.processRequest(OAPageLayoutBean.java:1569)
           at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:968)
           at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:935)
           at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:659)
           at oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(OAWebBeanContainerHelper.java:252)
           at oracle.apps.fnd.framework.webui.beans.form.OAFormBean.processRequest(OAFormBean.java:385)
           at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:968)
           at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:935)
           at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:659)
           at oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(OAWebBeanContainerHelper.java:252)
           at oracle.apps.fnd.framework.webui.beans.OABodyBean.processRequest(OABodyBean.java:353)
           at oracle.apps.fnd.framework.webui.OAPageBean.processRequest(OAPageBean.java:2620)
           at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:1786)
           at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:543)
           at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:431)
           at OA.jspService(_OA.java:212)
           at com.orionserver.http.OrionHttpJspPage.service(OrionHttpJspPage.java:59)
           at oracle.jsp.runtimev2.JspPageTable.service(JspPageTable.java:390)
           at oracle.jsp.runtimev2.JspServlet.internalService(JspServlet.java:594)
           at oracle.jsp.runtimev2.JspServlet.service(JspServlet.java:518)
           at javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
           at com.evermind.server.http.ResourceFilterChain.doFilter(ResourceFilterChain.java:64)
           at oracle.apps.jtf.base.session.ReleaseResFilter.doFilter(ReleaseResFilter.java:26)
           at com.evermind.server.http.EvermindFilterChain.doFilter(EvermindFilterChain.java:15)
           at oracle.apps.fnd.security.AppsServletFilter.doFilter(AppsServletFilter.java:318)
           at com.evermind.server.http.ServletRequestDispatcher.invoke(ServletRequestDispatcher.java:642)
           at com.evermind.server.http.ServletRequestDispatcher.forwardInternal(ServletRequestDispatcher.java:391)
           at com.evermind.server.http.HttpRequestHandler.doProcessRequest(HttpRequestHandler.java:908)
           at com.evermind.server.http.HttpRequestHandler.processRequest(HttpRequestHandler.java:458)
           at com.evermind.server.http.AJPRequestHandler.run(AJPRequestHandler.java:313)
           at com.evermind.server.http.AJPRequestHandler.run(AJPRequestHandler.java:199)
           at oracle.oc4j.network.ServerSocketReadHandler$SafeRunnable.run(ServerSocketReadHandler.java:260)
           at com.evermind.util.ReleasableResourcePooledExecutor$MyWorker.run(ReleasableResourcePooledExecutor.java:303)
           at java.lang.Thread.run(Thread.java:619)
      ## 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)
           at oracle.jbo.server.QueryCollection.get(QueryCollection.java:1504)
           at oracle.jbo.server.ViewRowSetImpl.getRow(ViewRowSetImpl.java:3697)
           at oracle.jbo.server.ViewRowSetIteratorImpl.doFetch(ViewRowSetIteratorImpl.java:2815)
           at oracle.jbo.server.ViewRowSetIteratorImpl.ensureRefreshed(ViewRowSetIteratorImpl.java:2671)
           at oracle.jbo.server.ViewRowSetIteratorImpl.ensureRefreshed(ViewRowSetIteratorImpl.java:2631)
           at oracle.jbo.server.ViewRowSetIteratorImpl.hasNext(ViewRowSetIteratorImpl.java:1788)
           at oracle.apps.eam.asset.server.AssetSearchVOImpl.getSelectedAsset(AssetSearchVOImpl.java:60)
           at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
           at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
           at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
           at java.lang.reflect.Method.invoke(Method.java:597)
           at oracle.apps.fnd.framework.server.OAUtility.invokeMethod(OAUtility.java:190)
           at oracle.apps.fnd.framework.server.OAUtility.invokeMethod(OAUtility.java:133)
           at oracle.apps.fnd.framework.server.OAViewObjectImpl.invokeMethod(OAViewObjectImpl.java:1173)
           at oracle.apps.eam.asset.webui.ResultsTableCO.processRequest(ResultsTableCO.java:67)
           at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:600)
           at oracle.apps.fnd.framework.webui.OAWebBeanTableHelper.processRequest(OAWebBeanTableHelper.java:2144)
           at oracle.apps.fnd.framework.webui.OAAdvancedTableHelper.processRequest(OAAdvancedTableHelper.java:662)
           at oracle.apps.fnd.framework.webui.beans.table.OAAdvancedTableBean.processRequest(OAAdvancedTableBean.java:739)
           at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:968)
           at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:935)
           at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:659)
           at oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(OAWebBeanContainerHelper.java:252)
           at oracle.apps.fnd.framework.webui.beans.layout.OACellFormatBean.processRequest(OACellFormatBean.java:411)
           at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:968)
           at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:935)
           at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:659)
           at oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(OAWebBeanContainerHelper.java:252)
           at oracle.apps.fnd.framework.webui.beans.layout.OARowLayoutBean.processRequest(OARowLayoutBean.java:347)
           at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:968)
           at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:935)
           at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:659)
           at oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(OAWebBeanContainerHelper.java:252)
           at oracle.apps.fnd.framework.webui.beans.layout.OATableLayoutBean.processRequest(OATableLayoutBean.java:353)
           at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:968)
           at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:935)
           at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:659)
           at oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(OAWebBeanContainerHelper.java:252)
           at oracle.apps.fnd.framework.webui.beans.layout.OATableLayoutBean.processRequest(OATableLayoutBean.java:353)
           at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:968)
           at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:935)
           at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:659)
           at oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(OAWebBeanContainerHelper.java:252)
           at oracle.apps.fnd.framework.webui.beans.layout.OAStackLayoutBean.processRequest(OAStackLayoutBean.java:350)
           at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:968)
           at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:935)
           at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:659)
           at oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(OAWebBeanContainerHelper.java:252)
           at oracle.apps.fnd.framework.webui.beans.layout.OAHeaderBean.processRequest(OAHeaderBean.java:391)
           at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:968)
           at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:935)
           at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:659)
           at oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(OAWebBeanContainerHelper.java:252)
           at oracle.apps.fnd.framework.webui.beans.layout.OAStackLayoutBean.processRequest(OAStackLayoutBean.java:350)
           at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:968)
           at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:935)
           at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:659)
           at oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(OAWebBeanContainerHelper.java:252)
           at oracle.apps.fnd.framework.webui.OAQueryHelper.processRequest(OAQueryHelper.java:563)
           at oracle.apps.fnd.framework.webui.beans.layout.OAStackLayoutBean.processRequest(OAStackLayoutBean.java:350)
           at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:968)
           at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:935)
           at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:659)
           at oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(OAWebBeanContainerHelper.java:252)
           at oracle.apps.fnd.framework.webui.beans.layout.OAStackLayoutBean.processRequest(OAStackLayoutBean.java:350)
           at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:968)
           at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:935)
           at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:659)
           at oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(OAWebBeanContainerHelper.java:252)
           at oracle.apps.fnd.framework.webui.OAPageLayoutHelper.processRequest(OAPageLayoutHelper.java:1183)
           at oracle.apps.fnd.framework.webui.beans.layout.OAPageLayoutBean.processRequest(OAPageLayoutBean.java:1569)
           at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:968)
           at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:935)
           at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:659)
           at oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(OAWebBeanContainerHelper.java:252)
           at oracle.apps.fnd.framework.webui.beans.form.OAFormBean.processRequest(OAFormBean.java:385)
           at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:968)
           at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:935)
           at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:659)
           at oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(OAWebBeanContainerHelper.java:252)
           at oracle.apps.fnd.framework.webui.beans.OABodyBean.processRequest(OABodyBean.java:353)
           at oracle.apps.fnd.framework.webui.OAPageBean.processRequest(OAPageBean.java:2620)
           at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:1786)
           at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:543)
           at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:431)
           at OA.jspService(_OA.java:212)
           at com.orionserver.http.OrionHttpJspPage.service(OrionHttpJspPage.java:59)
           at oracle.jsp.runtimev2.JspPageTable.service(JspPageTable.java:390)
           at oracle.jsp.runtimev2.JspServlet.internalService(JspServlet.java:594)
           at oracle.jsp.runtimev2.JspServlet.service(JspServlet.java:518)
           at javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
           at com.evermind.server.http.ResourceFilterChain.doFilter(ResourceFilterChain.java:64)
           at oracle.apps.jtf.base.session.ReleaseResFilter.doFilter(ReleaseResFilter.java:26)
           at com.evermind.server.http.EvermindFilterChain.doFilter(EvermindFilterChain.java:15)
           at oracle.apps.fnd.security.AppsServletFilter.doFilter(AppsServletFilter.java:318)
           at com.evermind.server.http.ServletRequestDispatcher.invoke(ServletRequestDispatcher.java:642)
           at com.evermind.server.http.ServletRequestDispatcher.forwardInternal(ServletRequestDispatcher.java:391)
           at com.evermind.server.http.HttpRequestHandler.doProcessRequest(HttpRequestHandler.java:908)
           at com.evermind.server.http.HttpRequestHandler.processRequest(HttpRequestHandler.java:458)
           at com.evermind.server.http.AJPRequestHandler.run(AJPRequestHandler.java:313)
           at com.evermind.server.http.AJPRequestHandler.run(AJPRequestHandler.java:199)
           at oracle.oc4j.network.ServerSocketReadHandler$SafeRunnable.run(ServerSocketReadHandler.java:260)
           at com.evermind.util.ReleasableResourcePooledExecutor$MyWorker.run(ReleasableResourcePooledExecutor.java:303)
           at java.lang.Thread.run(Thread.java:619)

      thanks,
      mallik

      Edited by: 758972 on Aug 8, 2012 1:00 PM
        • 1. Re: JBO-27022: Failed to load value at index 20 with java object of type java
          933532
          Hi Mallik,

          Did you check the parameter binding style in the VO?

          Regards,
          Naren.
          • 2. Re: JBO-27022: Failed to load value at index 20 with java object of type java
            761975
            Hi Naren,

            How can i check parameter binding style??
            When I check SQL Statment of extended VO there is binding style listed below as Oracle Named. I did try changing it to Oracle Positional but no help.

            I have done debugging in-depth, looks like SQL statement of VO has got two transient items (listed in attribute mapping but not in SQL statement of VO) at the end.
            My new extended item inserted after these two transient items.
            I'm thinking there is clash or some kind of issue as newbie dont know how to troubleshoot.
            As per error, the 20th item when i counted it is pointing to transient item but not the new extended VO item.

            Please let me know.

            thanks,
            mallik

            Edited by: 758972 on Aug 9, 2012 6:37 AM
            • 3. Re: JBO-27022: Failed to load value at index 20 with java object of type java
              933532
              Hi Mallik,

              can you check that the SQL type and Java type for the transient item are compatible or not?

              Can you paste your query here?

              Regards,
              Naren.
              • 4. Re: JBO-27022: Failed to load value at index 20 with java object of type java
                761975
                Hi Naren,

                I can see VO_DATAYPE for transient item as java.lang.string in attribute mapping..
                How can i check SQL type and Java Type?

                The transient items are only seen while attribute mapping but not in SQL.
                Here is VO extended query:

                SELECT concatenated_segments,
                          serial_number,
                     CASE
                WHEN
                (fnd_profile.value('EAM_HIERARCHY_DESCRIPTION_LENGTH') is NULL) AND (length(descriptive_text ) > 30 )
                THEN
                concat(substr(descriptive_text , 1, 30), '...')
                WHEN
                (fnd_profile.value('EAM_HIERARCHY_DESCRIPTION_LENGTH') is NULL) AND (length(descriptive_text ) < 30 )
                THEN
                descriptive_text
                WHEN
                (fnd_profile.Value('EAM_HIERARCHY_DESCRIPTION_LENGTH') is NOT NULL) AND (length(descriptive_text ) > To_Number(fnd_profile.Value('EAM_HIERARCHY_DESCRIPTION_LENGTH')))
                THEN
                Concat(substr(descriptive_text , 1,To_Number(fnd_profile.value('EAM_HIERARCHY_DESCRIPTION_LENGTH'))), '...')
                WHEN
                (fnd_profile.Value('EAM_HIERARCHY_DESCRIPTION_LENGTH') is NOT NULL) AND (length(descriptive_text ) < To_Number(fnd_profile.Value('EAM_HIERARCHY_DESCRIPTION_LENGTH')))
                THEN
                descriptive_text
                ELSE
                descriptive_text
                END AS descriptive_text,
                          asset_criticality,
                          area eam_location,
                          owning_department,
                          current_organization_id,
                          inventory_item_id,
                          'N' select_flag,
                          eam_item_type,
                          maintenance_object_id,
                          maintenance_object_type,
                          category_name as asset_category,
                          nvl(network_asset_flag,'N') network_asset_flag,
                          current_subinventory_code,
                          nvl(checkin_status,1) checkin_status,
                          instance_number,
                          descriptive_text full_description,
                get_asset_attr10 (inventory_item_id, serial_number) assoc_with ----HERE IS NEW ITEM ADDED
                     FROM      mtl_eam_asset_numbers_v

                Here is the attribute mappings for newly added item

                Name:assocwith
                Type:String
                Alias:assoc_with
                Expression:assoc_with varchar2(260)

                Under attribute List here is order:

                fulldescription
                transient item1
                transient item2
                assocwith


                Thanks,
                mallik

                Edited by: 758972 on Aug 9, 2012 12:08 PM
                • 5. Re: JBO-27022: Failed to load value at index 20 with java object of type java
                  933532
                  Hi Mallik,

                  Here 'assoc_with' is varchar2(260) & what is the data type of the field on page to which you are mapping to this
                  'assoc_with'?

                  Regards,
                  Naren.
                  • 6. Re: JBO-27022: Failed to load value at index 20 with java object of type java
                    761975
                    Hi Naren,

                    I disabled all personalization on the page for testing to find the issue.
                    I have given varchar2 for the page item to which i mapped this new item..

                    Let me know your thoughts.

                    thanks,
                    mallik