1 2 Previous Next 25 Replies Latest reply: Dec 19, 2012 12:58 AM by Gaurav Bhardwaj RSS

    Error java.sql.SQLException: Attempt to set a parameter name that does not

    Gaurav Bhardwaj
      Hello
      Good Day!

      we have a leave type called 'Special Leave', this leave should not be available in self service at all and can be applied from PUI form only. When this leave applied for a employee from PUI form, employee should not be able to edit it (update, delete etc.) so we modified the AbsenceSummaryVO.xml VO to disable edit icons if the leave type is Special Leave. We made the following changes to VO :

      Old VO Logic :

      decode (
      paa.date_start,null,
      decode(paa.date_projected_start, null, 'HrCancelDisabled', 'HrCancelEnabled'),

      decode(
      sign(trunc(paa.date_start)-trunc(sysdate)),1,'HrCancelEnabled',
      decode(paa.date_end,null,'HrCancelEnabled','HrCancelDisabled')
      )
      )
      cancel_icon

      Modified VO Logic :

      case paattl.name when 'Special Leave' then 'HrCancelDisabled'
      else
      (
      DECODE (
      paa.date_start,
      NULL, DECODE (paa.date_projected_start,
      NULL, 'HrCancelDisabled',
      'HrCancelEnabled'),
      DECODE (
      SIGN (TRUNC (paa.date_start) - TRUNC (SYSDATE)),
      1, 'HrCancelEnabled',
      DECODE (paa.date_end,
      NULL, 'HrCancelEnabled',
      'HrCancelDisabled')))
      ) end cancel_icon,

      Same logic we applied for confirm_icon and for update_icon. This works fine and employees are not able update Special Leave in self service. But for few employees we are getting below error when they click on Apply Leave in self service –

      Exception Details. oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT NVL(paa.date_start,paa.date_projected_start) start_date
      ,NVL(paa.date_end,paa.date_projected_end) end_date
      .
      .
      .
      .
      .

      .
      .
      .
      .
      *. ## Detail 0 ##*
      java.sql.SQLException: Attempt to set a parameter name that does not occur in the SQL: 4

      Kindly please advise! Any help would be really appreciated.

      Thanks
      Gaurav
        • 1. Re: Error java.sql.SQLException: Attempt to set a parameter name that does not
          Sushant Sharma
          Hi,

          The query has only uptol :3 bind parameters, but you might be trying to set the value for the bind parameter :4. Check the code usingl setWhereClauseParams.
          Or just check by replacing bind parameter from :4 to :3.

          --Sushant                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   
          • 2. Re: Error java.sql.SQLException: Attempt to set a parameter name that does not
            Gaurav Bhardwaj
            Hi Sushant

            Thanks for the response, but i checked the code and it has only 3 bind parameters and moreover we have not changed any thing in the where clause of VO.

            Thanks
            Gaurav
            • 3. Re: Error java.sql.SQLException: Attempt to set a parameter name that does not
              Sushant Sharma
              Hi,

              When we set params using setWhereClauseParam, it starts from 0.
              If you are having only 3 bind parameters, then where clause param will be 0,1,2. This is the reason you are getting this error, as there is nothing to set at :4 position.

              --Sushant
              sushantsh51@gmail.com
              • 4. Re: Error java.sql.SQLException: Attempt to set a parameter name that does not
                Gaurav Bhardwaj
                Hi Sushant

                I understand your point now, but as i mentioned we have not modified anything in the whereclause of VO so it same as seeded then why we are getting error only after VO modification, we never had such errors earlier. Moreover, issue is not coming for all employees, it is only coming for few.

                Please advise!

                Thanks
                Gaurav
                • 5. Re: Error java.sql.SQLException: Attempt to set a parameter name that does not
                  Gaurav Bhardwaj
                  Hello Guys

                  Any help on my issue?

                  Thanks
                  Gaurav
                  • 6. Re: Error java.sql.SQLException: Attempt to set a parameter name that does not
                    keerthioaf
                    Gaurav ,

                    Copy and run the query which is getting printed in error trace , see whether its getting executed successfully .
                    Run from Toad / sql developer

                    I mean below query ( copy the complete query in the error trace )

                    SELECT NVL(paa.date_start,paa.date_projected_start) start_date
                    ,NVL(paa.date_end,paa.date_projected_end) end_date
                    ...........................

                    Keerthi
                    • 7. Re: Error java.sql.SQLException: Attempt to set a parameter name that does not
                      Gaurav Bhardwaj
                      Hi Keerthi

                      Thanks for the response, I just executed the complete query on Toad and was able to execute it without any error.

                      Thanks
                      Gaurav
                      • 8. Re: Error java.sql.SQLException: Attempt to set a parameter name that does not
                        keerthioaf
                        Gaurav,

                        looks like VO have 3 bind parameters, but somewhere in the code you are trying to pass the index 4.

                        Please make sure you have started the index from 0.

                        Regards,
                        Keerthi
                        • 9. Re: Error java.sql.SQLException: Attempt to set a parameter name that does not
                          Gaurav Bhardwaj
                          Hello
                          Good Day!

                          I changed the Binding Style from 'Oracle Named' to 'Oracle Positional' , as the seeded VO had the 'Oracle Positional' as Binding Style so the earlier error is not appearing but a new error *'## Detail 0 ##java.sql.SQLException: Invalid column index'* is coming.

                          This is really urgent issue for us so kindly please advise, any help will be highly appreciated!

                          Many Thanks
                          Gaurav
                          • 10. Re: Error java.sql.SQLException: Attempt to set a parameter name that does not
                            keerthioaf
                            Gaurav ,

                            Please share the complete error trace .

                            Keerthi
                            • 11. Re: Error java.sql.SQLException: Attempt to set a parameter name that does not
                              Gaurav Bhardwaj
                              Hi Keerthi

                              For testing purpose, i just extended the VO without making any changes to the Seeded VO but still getting the below error-

                              Exception Details.
                              oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT NVL(paa.date_start,paa.date_projected_start) start_date
                              ,NVL(paa.date_end,paa.date_projected_end) end_date
                              ,paattl.name absence_type
                              ,paat.absence_attendance_type_id absence_attendance_type_id
                              ,fcl.meaning absence_category
                              ,paat.absence_category absence_category_code
                              ,paa.absence_hours
                              ,(SELECT meaning from hr_lookups where 'A' = lookup_code(+) and 'LEAVE_STATUS' = lookup_type(+))
                              approval_status
                              , 'A' approval_status_code
                              ,decode(paa.date_start,null,
                              (SELECT meaning from fnd_lookup_values
                              where lookup_type ='ABSENCE_STATUS' and lookup_code ='PLANNED'
                              and language = userenv('LANG')),
                              (SELECT meaning from fnd_lookup_values
                              where lookup_type ='ABSENCE_STATUS' and lookup_code ='CONFIRMED'
                              and language = userenv('LANG')))
                              absence_status
                              , decode(paa.date_start,null,'PLANNED','CONFIRMED') absence_status_code
                              ,(nvl((SELECT 'Y'
                              from fnd_attached_documents
                              where entity_name='PER_ABSENCE_ATTENDANCES'
                              and pk1_value = to_char(paa.absence_attendance_id) and rownum = 1),'N')) supporting_documents

                              ,decode (
                              paa.date_start,null,
                              decode(paa.date_projected_start, null, 'HrCancelDisabled', 'HrCancelEnabled'),

                              decode(
                              sign(trunc(paa.date_start)-trunc(sysdate)),1,'HrCancelEnabled',
                              decode(paa.date_end,null,'HrCancelEnabled','HrCancelDisabled')
                              )
                              )
                              cancel_icon

                              ,decode(paa.date_end,NULL,
                              decode(paa.date_start,Null, 'HrConfirmEnabled','HrConfirmDisabled'), 'HrConfirmDisabled' )
                              confirm_icon
                              ,decode ( paa.date_start,null,
                              'HrUpdateEnabled',
                              decode(sign(nvl(paa.date_end,sysdate+1)-sysdate),1,'HrUpdateEnabled','HrUpdateDisabled'))
                              update_icon
                              ,NULL
                              details_icon
                              ,paa.absence_attendance_id
                              ,null transaction_id
                              ,to_char(paa.absence_attendance_id) supportingDocKey
                              ,paa.absence_days
                              ,decode(fnd_profile.value('HR_LOCAL_OR_GLOBAL_NAME_FORMAT'),'G',p.global_name,p.local_name) full_name
                              FROM per_absence_attendances paa
                              ,per_absence_attendance_types paat
                              ,per_abs_attendance_types_tl paattl
                              ,hr_lookups fcl
                              , per_all_people_f p
                              WHERE paa.person_id = :1
                              and (trunc(sysdate)
                              between p.effective_start_date and p.effective_end_date)
                              and paa.person_id = p.person_id
                              and paa.business_group_id+0 = :2
                              and paa.absence_attendance_type_id = paat.absence_attendance_type_id
                              and paat.absence_attendance_type_id = paattl.absence_attendance_type_id
                              and paattl.language = userenv('LANG')
                              and fcl.lookup_type(+) = 'ABSENCE_CATEGORY'
                              and paat.absence_category = fcl.lookup_code(+)
                              and ((hr_api.return_legislation_code(paat.business_group_id) = 'GB'
                              and nvl(paat.absence_category,'#') not in
                              ('M','GB_PAT_ADO','GB_PAT_BIRTH','GB_ADO'))
                              or
                              (hr_api.return_legislation_code(paat.business_group_id) <> 'GB'
                              and nvl(paat.absence_category,'#') not in
                              ('GB_PAT_ADO','GB_PAT_BIRTH','GB_ADO')))
                              and not exists
                              ( select 'e'
                              from hr_api_transactions t
                              WHERE
                              t.selected_person_id = paa.person_id
                              -- and t.CREATOR_PERSON_ID = nvl(:3,t.CREATOR_PERSON_ID)
                              and t.transaction_ref_table='PER_ABSENCE_ATTENDANCES'
                              and t.transaction_ref_id = paa.absence_attendance_id
                              and not(hr_absutil_ss.getabsencetype(t.transaction_id, NULL) IS NULL
                              and t.status = 'W')
                              and t.status not in ('D','E','AC')
                              )

                              union all

                              select hr_absutil_ss.getStartDate(hat.transaction_id,null) start_date
                              ,hr_absutil_ss.getEndDate(hat.transaction_id,null) end_date
                              ,hr_absutil_ss.getAbsenceType(hat.transaction_id,null) absence_type
                              , to_number(hats.Information5) absence_attendance_type_id
                              ,hr_absutil_ss.getAbsenceCategory(hat.transaction_id,null) absence_category
                              , hats.Information6 absence_category_code
                              ,hr_absutil_ss.getAbsenceHoursDuration(hat.transaction_id,null) absence_hours
                              ,hr_absutil_ss.getApprovalStatus(hat.transaction_id,null) approval_status
                              ,hr_absutil_ss.getApprovalStatusCode(hat.transaction_id,null) approval_status_code
                              ,hr_absutil_ss.getAbsenceStatus(hat.transaction_id,null) absence_status
                              , hats.Information9 absence_status_code
                              ,hr_absutil_ss.hasSupportingDocuments(hat.transaction_id,hat.TRANSACTION_REF_ID) supporting_documents
                              ,hr_absutil_ss.isCancelAllowed(hat.transaction_id,null,hat.status) cancel_icon
                              ,hr_absutil_ss.isConfirmAllowed(hat.transaction_id,null) confirm_icon
                              ,hr_absutil_ss.isUpdateAllowed(hat.transaction_id,null,hat.status) update_icon
                              ,null details_icon
                              ,hat.TRANSACTION_REF_ID absence_attendance_id
                              ,hat.transaction_id transaction_id
                              ,to_char(hat.TRANSACTION_REF_ID||'_'||hat.transaction_id) supportingDocKey
                              ,hr_absutil_ss.getAbsenceDaysDuration(hat.transaction_id,null) absence_days
                              ,decode(fnd_profile.value('HR_LOCAL_OR_GLOBAL_NAME_FORMAT'),'G',p.global_name,p.local_name) full_name
                              from hr_api_transactions hat
                              ,hr_api_transaction_steps hats
                              ,per_all_people_f p
                              where hat.TRANSACTION_REF_TABLE='PER_ABSENCE_ATTENDANCES'
                              and hat.TRANSACTION_GROUP='ABSENCE_MGMT'
                              and hat.TRANSACTION_IDENTIFIER='ABSENCES'
                              and hat.TRANSACTION_REF_ID is not null
                              and hat.SELECTED_PERSON_ID =:3
                              --and hat.CREATOR_PERSON_ID  = nvl(:5,hat.CREATOR_PERSON_ID)
                              and (nvl(start_date,sysdate)
                              between p.effective_start_date and p.effective_end_date)
                              and hat.SELECTED_PERSON_ID = p.person_id
                              and hat.transaction_id=hats.transaction_id(+)
                              and hat.status not in ('D','E','AC')
                              and not (hr_absutil_ss.getabsencetype(hat.transaction_id,null) is null and hat.status='W')
                                   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.OAApplicationModuleImpl.invokeMethod(OAApplicationModuleImpl.java:797)
                                   at oracle.apps.per.selfservice.absence.webui.AbsenceSubTabCO.processRequest(AbsenceSubTabCO.java:47)
                                   at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:600)
                                   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.OASubTabLayoutHelper.processRequest(OASubTabLayoutHelper.java:434)
                                   at oracle.apps.fnd.framework.webui.beans.layout.OASubTabLayoutBean.processRequest(OASubTabLayoutBean.java:465)
                                   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.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:1940)
                                   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.ServletRequestDispatcher.invoke(ServletRequestDispatcher.java:734)
                                   at com.evermind.server.http.ServletRequestDispatcher.forwardInternal(ServletRequestDispatcher.java:391)
                                   at com.evermind.server.http.ServletRequestDispatcher.unprivileged_forward(ServletRequestDispatcher.java:280)
                                   at com.evermind.server.http.ServletRequestDispatcher.access$100(ServletRequestDispatcher.java:68)
                                   at com.evermind.server.http.ServletRequestDispatcher$2.oc4jRun(ServletRequestDispatcher.java:214)
                                   at oracle.oc4j.security.OC4JSecurity.doPrivileged(OC4JSecurity.java:284)
                                   at com.evermind.server.http.ServletRequestDispatcher.forward(ServletRequestDispatcher.java:219)
                                   at com.evermind.server.http.EvermindPageContext.forward(EvermindPageContext.java:395)
                                   at OA.jspService(_OA.java:221)
                                   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.ServletRequestDispatcher.invoke(ServletRequestDispatcher.java:734)
                                   at com.evermind.server.http.ServletRequestDispatcher.forwardInternal(ServletRequestDispatcher.java:391)
                                   at com.evermind.server.http.ServletRequestDispatcher.unprivileged_forward(ServletRequestDispatcher.java:280)
                                   at com.evermind.server.http.ServletRequestDispatcher.access$100(ServletRequestDispatcher.java:68)
                                   at com.evermind.server.http.ServletRequestDispatcher$2.oc4jRun(ServletRequestDispatcher.java:214)
                                   at oracle.oc4j.security.OC4JSecurity.doPrivileged(OC4JSecurity.java:284)
                                   at com.evermind.server.http.ServletRequestDispatcher.forward(ServletRequestDispatcher.java:219)
                                   at com.evermind.server.http.EvermindPageContext.forward(EvermindPageContext.java:395)
                                   at RF.jspService(_RF.java:225)
                                   at com.orionserver.http.OrionHttpJspPage.service(OrionHttpJspPage.java:59)
                                   at oracle.jsp.runtimev2.JspPageTable.service(JspPageTable.java:473)
                                   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:662)
                              ## Detail 0 ##
                              java.sql.SQLException: Invalid column index
                                   at oracle.jdbc.driver.OraclePreparedStatement.setStringInternal(OraclePreparedStatement.java:5168)
                                   at oracle.jdbc.driver.OraclePreparedStatement.setObjectCritical(OraclePreparedStatement.java:8098)
                                   at oracle.jdbc.driver.OraclePreparedStatement.setObjectInternal(OraclePreparedStatement.java:8034)
                                   at oracle.jdbc.driver.OraclePreparedStatement.setObjectInternal(OraclePreparedStatement.java:8767)


                                   
                              Thanks
                              Gaurav
                              • 12. Re: Error java.sql.SQLException: Attempt to set a parameter name that does not
                                Gaurav Bhardwaj
                                Error Message Continue-

                                at oracle.jdbc.driver.OraclePreparedStatement.setObject(OraclePreparedStatement.java:8748)
                                     at oracle.jdbc.driver.OraclePreparedStatementWrapper.setObject(OraclePreparedStatementWrapper.java:230)
                                     at oracle.jbo.server.BaseSQLBuilderImpl.bindParamValue(BaseSQLBuilderImpl.java:1847)
                                     at oracle.jbo.server.OracleSQLBuilderImpl.bindParamValue(OracleSQLBuilderImpl.java:3940)
                                     at oracle.jbo.server.BaseSQLBuilderImpl.bindParametersForStmt(BaseSQLBuilderImpl.java:3335)
                                     at oracle.jbo.server.ViewObjectImpl.bindParametersForCollection(ViewObjectImpl.java:14008)
                                     at oracle.jbo.server.QueryCollection.buildResultSet(QueryCollection.java:804)
                                     at oracle.jbo.server.QueryCollection.executeQuery(QueryCollection.java:669)
                                     at oracle.jbo.server.ViewObjectImpl.executeQueryForCollection(ViewObjectImpl.java:3754)
                                     at oracle.jbo.server.OAJboViewObjectImpl.executeQueryForCollection(Unknown Source)
                                     at oracle.apps.fnd.framework.server.OAViewObjectImpl.executeQueryForCollection(OAViewObjectImpl.java:4560)
                                     at oracle.jbo.server.ViewRowSetImpl.execute(ViewRowSetImpl.java:743)
                                     at oracle.jbo.server.ViewRowSetImpl.executeQueryForMasters(ViewRowSetImpl.java:892)
                                     at oracle.jbo.server.ViewRowSetImpl.executeQueryForMode(ViewRowSetImpl.java:806)
                                     at oracle.jbo.server.ViewRowSetImpl.executeQuery(ViewRowSetImpl.java:800)
                                     at oracle.jbo.server.ViewObjectImpl.executeQuery(ViewObjectImpl.java:3674)
                                     at oracle.apps.fnd.framework.server.OAViewObjectImpl.executeQuery(OAViewObjectImpl.java:439)
                                     at oracle.apps.per.selfservice.absence.server.AbsenceSummaryVOImpl.initQuery(AbsenceSummaryVOImpl.java:53)
                                     at oracle.apps.per.selfservice.absence.server.AbsenceSummaryAMImpl.initQuery(AbsenceSummaryAMImpl.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.OAApplicationModuleImpl.invokeMethod(OAApplicationModuleImpl.java:797)
                                     at oracle.apps.per.selfservice.absence.webui.AbsenceSubTabCO.processRequest(AbsenceSubTabCO.java:47)
                                     at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:600)
                                     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.OASubTabLayoutHelper.processRequest(OASubTabLayoutHelper.java:434)
                                     at oracle.apps.fnd.framework.webui.beans.layout.OASubTabLayoutBean.processRequest(OASubTabLayoutBean.java:465)
                                     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.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:1940)
                                     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.ServletRequestDispatcher.invoke(ServletRequestDispatcher.java:734)
                                     at com.evermind.server.http.ServletRequestDispatcher.forwardInternal(ServletRequestDispatcher.java:391)
                                     at com.evermind.server.http.ServletRequestDispatcher.unprivileged_forward(ServletRequestDispatcher.java:280)
                                     at com.evermind.server.http.ServletRequestDispatcher.access$100(ServletRequestDispatcher.java:68)
                                     at com.evermind.server.http.ServletRequestDispatcher$2.oc4jRun(ServletRequestDispatcher.java:214)
                                     at oracle.oc4j.security.OC4JSecurity.doPrivileged(OC4JSecurity.java:284)
                                     at com.evermind.server.http.ServletRequestDispatcher.forward(ServletRequestDispatcher.java:219)
                                     at com.evermind.server.http.EvermindPageContext.forward(EvermindPageContext.java:395)
                                     at OA.jspService(_OA.java:221)
                                     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.ServletRequestDispatcher.invoke(ServletRequestDispatcher.java:734)
                                     at com.evermind.server.http.ServletRequestDispatcher.forwardInternal(ServletRequestDispatcher.java:391)
                                     at com.evermind.server.http.ServletRequestDispatcher.unprivileged_forward(ServletRequestDispatcher.java:280)
                                     at com.evermind.server.http.ServletRequestDispatcher.access$100(ServletRequestDispatcher.java:68)
                                     at com.evermind.server.http.ServletRequestDispatcher$2.oc4jRun(ServletRequestDispatcher.java:214)
                                     at oracle.oc4j.security.OC4JSecurity.doPrivileged(OC4JSecurity.java:284)
                                     at com.evermind.server.http.ServletRequestDispatcher.forward(ServletRequestDispatcher.java:219)
                                     at com.evermind.server.http.EvermindPageContext.forward(EvermindPageContext.java:395)
                                     at RF.jspService(_RF.java:225)
                                     at com.orionserver.http.OrionHttpJspPage.service(OrionHttpJspPage.java:59)
                                     at oracle.jsp.runtimev2.JspPageTable.service(JspPageTable.java:473)
                                     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:662)
                                java.sql.SQLException: Invalid column index
                                     at oracle.jdbc.driver.OraclePreparedStatement.setStringInternal(OraclePreparedStatement.java:5168)
                                     at oracle.jdbc.driver.OraclePreparedStatement.setObjectCritical(OraclePreparedStatement.java:8098)
                                     at oracle.jdbc.driver.OraclePreparedStatement.setObjectInternal(OraclePreparedStatement.java:8034)
                                     at oracle.jdbc.driver.OraclePreparedStatement.setObjectInternal(OraclePreparedStatement.java:8767)
                                     at oracle.jdbc.driver.OraclePreparedStatement.setObject(OraclePreparedStatement.java:8748)
                                     at oracle.jdbc.driver.OraclePreparedStatementWrapper.setObject(OraclePreparedStatementWrapper.java:230)
                                     at oracle.jbo.server.BaseSQLBuilderImpl.bindParamValue(BaseSQLBuilderImpl.java:1847)
                                     at oracle.jbo.server.OracleSQLBuilderImpl.bindParamValue(OracleSQLBuilderImpl.java:3940)
                                     at oracle.jbo.server.BaseSQLBuilderImpl.bindParametersForStmt(BaseSQLBuilderImpl.java:3335)
                                     at oracle.jbo.server.ViewObjectImpl.bindParametersForCollection(ViewObjectImpl.java:14008)
                                     at oracle.jbo.server.QueryCollection.buildResultSet(QueryCollection.java:804)
                                     at oracle.jbo.server.QueryCollection.executeQuery(QueryCollection.java:669)
                                     at oracle.jbo.server.ViewObjectImpl.executeQueryForCollection(ViewObjectImpl.java:3754)
                                     at oracle.jbo.server.OAJboViewObjectImpl.executeQueryForCollection(Unknown Source)
                                     at oracle.apps.fnd.framework.server.OAViewObjectImpl.executeQueryForCollection(OAViewObjectImpl.java:4560)
                                     at oracle.jbo.server.ViewRowSetImpl.execute(ViewRowSetImpl.java:743)
                                     at oracle.jbo.server.ViewRowSetImpl.executeQueryForMasters(ViewRowSetImpl.java:892)
                                     at oracle.jbo.server.ViewRowSetImpl.executeQueryForMode(ViewRowSetImpl.java:806)
                                     at oracle.jbo.server.ViewRowSetImpl.executeQuery(ViewRowSetImpl.java:800)
                                     at oracle.jbo.server.ViewObjectImpl.executeQuery(ViewObjectImpl.java:3674)
                                     at oracle.apps.fnd.framework.server.OAViewObjectImpl.executeQuery(OAViewObjectImpl.java:439)
                                     at oracle.apps.per.selfservice.absence.server.AbsenceSummaryVOImpl.initQuery(AbsenceSummaryVOImpl.java:53)
                                     at oracle.apps.per.selfservice.absence.server.AbsenceSummaryAMImpl.initQuery(AbsenceSummaryAMImpl.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.OAApplicationModuleImpl.invokeMethod(OAApplicationModuleImpl.java:797)
                                     at oracle.apps.per.selfservice.absence.webui.AbsenceSubTabCO.processRequest(AbsenceSubTabCO.java:47)
                                     at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:600)
                                     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.OASubTabLayoutHelper.processRequest(OASubTabLayoutHelper.java:434)
                                     at oracle.apps.fnd.framework.webui.beans.layout.OASubTabLayoutBean.processRequest(OASubTabLayoutBean.java:465)
                                     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.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:1940)
                                     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.ServletRequestDispatcher.invoke(ServletRequestDispatcher.java:734)
                                     at com.evermind.server.http.ServletRequestDispatcher.forwardInternal(ServletRequestDispatcher.java:391)
                                     at com.evermind.server.http.ServletRequestDispatcher.unprivileged_forward(ServletRequestDispatcher.java:280)
                                     at com.evermind.server.http.ServletRequestDispatcher.access$100(ServletRequestDispatcher.java:68)
                                     at com.evermind.server.http.ServletRequestDispatcher$2.oc4jRun(ServletRequestDispatcher.java:214)
                                     at oracle.oc4j.security.OC4JSecurity.doPrivileged(OC4JSecurity.java:284)
                                     at com.evermind.server.http.ServletRequestDispatcher.forward(ServletRequestDispatcher.java:219)
                                     at com.evermind.server.http.EvermindPageContext.forward(EvermindPageContext.java:395)
                                     at OA.jspService(_OA.java:221)
                                     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.ServletRequestDispatcher.invoke(ServletRequestDispatcher.java:734)
                                     at com.evermind.server.http.ServletRequestDispatcher.forwardInternal(ServletRequestDispatcher.java:391)
                                     at com.evermind.server.http.ServletRequestDispatcher.unprivileged_forward(ServletRequestDispatcher.java:280)
                                     at com.evermind.server.http.ServletRequestDispatcher.access$100(ServletRequestDispatcher.java:68)
                                     at com.evermind.server.http.ServletRequestDispatcher$2.oc4jRun(ServletRequestDispatcher.java:214)
                                     at oracle.oc4j.security.OC4JSecurity.doPrivileged(OC4JSecurity.java:284)
                                     at com.evermind.server.http.ServletRequestDispatcher.forward(ServletRequestDispatcher.java:219)
                                     at com.evermind.server.http.EvermindPageContext.forward(EvermindPageContext.java:395)
                                     at RF.jspService(_RF.java:225)
                                     at com.orionserver.http.OrionHttpJspPage.service(OrionHttpJspPage.java:59)
                                     at oracle.jsp.runtimev2.JspPageTable.service(JspPageTable.java:473)
                                     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:662)

                                Thanks
                                Gaurav
                                • 13. Re: Error java.sql.SQLException: Attempt to set a parameter name that does not
                                  keerthioaf
                                  Hi ,

                                  Since you have extended the VO , try to run the query again which got generated in error trace and see
                                  if its running fine from TOAD / Sql developer .


                                  Keerthi
                                  • 14. Re: Error java.sql.SQLException: Attempt to set a parameter name that does not
                                    Gaurav Bhardwaj
                                    Hi Keerthi,

                                    I just ran the Query in Toad and it is running fine.

                                    Thanks
                                    Gaurav
                                    1 2 Previous Next