1 Reply Latest reply: Mar 29, 2013 12:30 PM by RaviNuka RSS

    JBO-27122: SQL error during statement preparation

    samme4life
      Hi guys,
      There are so many queries regarding this. My scenario is as following (My JDev version : 11.1.2.0.0),
      I have a page which is used to add master detail records.
      When I am going to insert a detail record I am getting following error :

      -------------------------------------------------------------------
      oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT allowedTransactionEO.FROM_ACC_SUB_TYPE, allowedTransactionEO.FROM_ACC_TYPE, allowedTransactionEO.TO_ACC_SUB_TYPE, allowedTransactionEO.TO_ACC_TYPE, allowedTransactionEO.TRANSACTION_TYPE FROM ALLOWED_TRANSACTIONS allowedTransactionEO WHERE ((allowedTransactionEO.TRANSACTION_TYPE = :Bind_TransactionType) AND allowedTransactionEO.FROM_ACC_SUB_TYPE = :fbkKy__0)
           at oracle.jbo.server.QueryCollection.buildResultSet(QueryCollection.java:1213)
           at oracle.jbo.server.QueryCollection.executeQuery(QueryCollection.java:893)
           at oracle.jbo.server.ViewObjectImpl.executeQueryForCollection(ViewObjectImpl.java:7154)
           at oracle.jbo.server.ViewRowSetImpl.execute(ViewRowSetImpl.java:1227)
           at oracle.jbo.server.ViewRowSetImpl.executeQueryForMasters(ViewRowSetImpl.java:1413)
           at oracle.jbo.server.ViewRowSetImpl.executeQueryForMode(ViewRowSetImpl.java:1319)
           at oracle.jbo.server.ViewRowSetImpl.executeQuery(ViewRowSetImpl.java:1304)
           at oracle.jbo.server.ViewObjectImpl.retrieveByKey(ViewObjectImpl.java:17205)
           at oracle.jbo.server.ViewObjectImpl.retrieveByKey(ViewObjectImpl.java:16853)
           at oracle.jbo.server.ViewObjectImpl.retrieveByKey(ViewObjectImpl.java:16847)
           at oracle.jbo.server.ViewRowSetImpl.findByKey(ViewRowSetImpl.java:5523)
           at oracle.jbo.server.ViewRowSetImpl.findByKey(ViewRowSetImpl.java:5286)
           at oracle.jbo.server.ViewRowSetImpl.findByKey(ViewRowSetImpl.java:5280)
           at oracle.jbo.server.ViewObjectImpl.findByKey(ViewObjectImpl.java:11497)
           at oracle.jbo.uicli.binding.JUCtrlHierBinding.bringNodeToRangeKeyPath(JUCtrlHierBinding.java:792)
           at oracle.adfinternal.view.faces.model.binding.FacesCtrlHierBinding.bringNodeToRangeKeyPath(FacesCtrlHierBinding.java:111)
           at oracle.adfinternal.view.faces.model.binding.RowDataManager.setRowKey(RowDataManager.java:130)
           at oracle.adfinternal.view.faces.model.binding.FacesCtrlHierBinding$FacesModel.setRowKey(FacesCtrlHierBinding.java:830)
           at org.apache.myfaces.trinidad.component.UIXCollection.setRowKey(UIXCollection.java:513)
           at oracle.adfinternal.view.faces.renderkit.rich.TableRendererUtils._processStampedChildrenForActiveRow(TableRendererUtils.java:2187)
           at oracle.adfinternal.view.faces.renderkit.rich.TableRendererUtils.processFacetsAndChildrenForClickToEdit(TableRendererUtils.java:1525)
           at oracle.adfinternal.view.faces.renderkit.rich.TableRenderer.processFacetsAndChildrenForClickToEdit(TableRenderer.java:343)
           at oracle.adfinternal.view.faces.renderkit.rich.TableRenderer.decodeChildren(TableRenderer.java:184)
           at org.apache.myfaces.trinidad.component.UIXComponentBase.decodeChildren(UIXComponentBase.java:1176)
           at org.apache.myfaces.trinidad.component.UIXCollection.processDecodes(UIXCollection.java:200)
           at org.apache.myfaces.trinidad.component.UIXComponentBase.decodeChildrenImpl(UIXComponentBase.java:1194)
           at org.apache.myfaces.trinidad.component.UIXComponentBase.decodeChildren(UIXComponentBase.java:1180)
           at org.apache.myfaces.trinidad.component.UIXComponentBase.processDecodes(UIXComponentBase.java:952)
           at org.apache.myfaces.trinidad.component.UIXComponentBase.decodeChildrenImpl(UIXComponentBase.java:1194)
           at org.apache.myfaces.trinidad.component.UIXComponentBase.decodeChildren(UIXComponentBase.java:1180)
           at org.apache.myfaces.trinidad.component.UIXComponentBase.processDecodes(UIXComponentBase.java:952)
           at org.apache.myfaces.trinidad.component.UIXShowDetail.processDecodes(UIXShowDetail.java:104)
           at org.apache.myfaces.trinidad.component.UIXComponentBase.decodeChildrenImpl(UIXComponentBase.java:1194)
           at org.apache.myfaces.trinidad.component.UIXComponentBase.decodeChildren(UIXComponentBase.java:1180)
           at org.apache.myfaces.trinidad.component.UIXComponentBase.processDecodes(UIXComponentBase.java:952)
           at org.apache.myfaces.trinidad.component.UIXComponentBase.decodeChildrenImpl(UIXComponentBase.java:1194)
           at org.apache.myfaces.trinidad.component.UIXComponentBase.decodeChildren(UIXComponentBase.java:1180)
           at org.apache.myfaces.trinidad.component.UIXComponentBase.processDecodes(UIXComponentBase.java:952)
           at org.apache.myfaces.trinidad.component.UIXComponentBase.decodeChildrenImpl(UIXComponentBase.java:1194)
           at org.apache.myfaces.trinidad.component.UIXComponentBase.decodeChildren(UIXComponentBase.java:1180)
           at org.apache.myfaces.trinidad.component.UIXComponentBase.processDecodes(UIXComponentBase.java:952)
           at org.apache.myfaces.trinidad.component.UIXComponentBase.decodeChildrenImpl(UIXComponentBase.java:1194)
           at org.apache.myfaces.trinidad.component.UIXComponentBase.decodeChildren(UIXComponentBase.java:1180)
           at org.apache.myfaces.trinidad.component.UIXComponentBase.processDecodes(UIXComponentBase.java:952)
           at oracle.adf.view.rich.component.fragment.ContextSwitchingComponent.access$001(ContextSwitchingComponent.java:41)
           at oracle.adf.view.rich.component.fragment.ContextSwitchingComponent$2.run(ContextSwitchingComponent.java:149)
           at oracle.adf.view.rich.component.fragment.ContextSwitchingComponent._processPhase(ContextSwitchingComponent.java:461)
           at oracle.adf.view.rich.component.fragment.ContextSwitchingComponent.processDecodes(ContextSwitchingComponent.java:152)
           at org.apache.myfaces.trinidad.component.UIXComponentBase.decodeChildrenImpl(UIXComponentBase.java:1194)
           at org.apache.myfaces.trinidad.component.UIXComponentBase.decodeChildren(UIXComponentBase.java:1180)
           at org.apache.myfaces.trinidad.component.UIXComponentBase.processDecodes(UIXComponentBase.java:952)
           at org.apache.myfaces.trinidad.component.UIXComponentBase.decodeChildrenImpl(UIXComponentBase.java:1194)
           at org.apache.myfaces.trinidad.component.UIXComponentBase.decodeChildren(UIXComponentBase.java:1180)
           at org.apache.myfaces.trinidad.component.UIXComponentBase.processDecodes(UIXComponentBase.java:952)
           at org.apache.myfaces.trinidad.component.UIXComponentBase.decodeChildrenImpl(UIXComponentBase.java:1194)
           at org.apache.myfaces.trinidad.component.UIXComponentBase.decodeChildren(UIXComponentBase.java:1180)
           at org.apache.myfaces.trinidad.component.UIXComponentBase.processDecodes(UIXComponentBase.java:952)
           at org.apache.myfaces.trinidad.component.UIXComponentBase.decodeChildrenImpl(UIXComponentBase.java:1194)
           at org.apache.myfaces.trinidad.component.UIXComponentBase.decodeChildren(UIXComponentBase.java:1180)
           at org.apache.myfaces.trinidad.component.UIXComponentBase.processDecodes(UIXComponentBase.java:952)
           at org.apache.myfaces.trinidad.component.UIXComponentBase.decodeChildrenImpl(UIXComponentBase.java:1194)
           at org.apache.myfaces.trinidad.component.UIXComponentBase.decodeChildren(UIXComponentBase.java:1180)
           at org.apache.myfaces.trinidad.component.UIXComponentBase.processDecodes(UIXComponentBase.java:952)
           at org.apache.myfaces.trinidad.component.UIXComponentBase.decodeChildrenImpl(UIXComponentBase.java:1194)
           at org.apache.myfaces.trinidad.component.UIXComponentBase.decodeChildren(UIXComponentBase.java:1180)
           at org.apache.myfaces.trinidad.component.UIXComponentBase.processDecodes(UIXComponentBase.java:952)
           at org.apache.myfaces.trinidad.component.UIXComponentBase.decodeChildrenImpl(UIXComponentBase.java:1194)
           at org.apache.myfaces.trinidad.component.UIXComponentBase.decodeChildren(UIXComponentBase.java:1180)
           at org.apache.myfaces.trinidad.component.UIXComponentBase.processDecodes(UIXComponentBase.java:952)
           at org.apache.myfaces.trinidad.component.UIXComponentBase.decodeChildrenImpl(UIXComponentBase.java:1194)
           at org.apache.myfaces.trinidad.component.UIXComponentBase.decodeChildren(UIXComponentBase.java:1180)
           at org.apache.myfaces.trinidad.component.UIXComponentBase.processDecodes(UIXComponentBase.java:952)
           at org.apache.myfaces.trinidad.component.UIXComponentBase.decodeChildrenImpl(UIXComponentBase.java:1194)
           at org.apache.myfaces.trinidad.component.UIXComponentBase.decodeChildren(UIXComponentBase.java:1180)
           at org.apache.myfaces.trinidad.component.UIXComponentBase.processDecodes(UIXComponentBase.java:952)
           at oracle.adf.view.rich.component.fragment.ContextSwitchingComponent.access$001(ContextSwitchingComponent.java:41)
           at oracle.adf.view.rich.component.fragment.ContextSwitchingComponent$2.run(ContextSwitchingComponent.java:149)
           at oracle.adf.view.rich.component.fragment.ContextSwitchingComponent._processPhase(ContextSwitchingComponent.java:461)
           at oracle.adf.view.rich.component.fragment.ContextSwitchingComponent.processDecodes(ContextSwitchingComponent.java:152)
           at org.apache.myfaces.trinidad.component.UIXComponentBase.decodeChildrenImpl(UIXComponentBase.java:1194)
           at org.apache.myfaces.trinidad.component.UIXComponentBase.decodeChildren(UIXComponentBase.java:1180)
           at org.apache.myfaces.trinidad.component.UIXForm.processDecodes(UIXForm.java:75)
           at org.apache.myfaces.trinidad.component.UIXComponentBase.decodeChildrenImpl(UIXComponentBase.java:1194)
           at org.apache.myfaces.trinidad.component.UIXComponentBase.decodeChildren(UIXComponentBase.java:1180)
           at org.apache.myfaces.trinidad.component.UIXComponentBase.processDecodes(UIXComponentBase.java:952)
           at javax.faces.component.UIComponentBase.processDecodes(UIComponentBase.java:1047)
           at javax.faces.component.UIViewRoot.processDecodes(UIViewRoot.java:926)
           at oracle.adfinternal.view.faces.lifecycle.LifecycleImpl$ApplyRequestValuesCallback.invokeContextCallback(LifecycleImpl.java:1548)
           at oracle.adfinternal.view.faces.lifecycle.LifecycleImpl._executePhase(LifecycleImpl.java:364)
           at oracle.adfinternal.view.faces.lifecycle.LifecycleImpl.execute(LifecycleImpl.java:204)
           at javax.faces.webapp.FacesServlet.service(FacesServlet.java:312)
           at weblogic.servlet.internal.StubSecurityHelper$ServletServiceAction.run(StubSecurityHelper.java:227)
           at weblogic.servlet.internal.StubSecurityHelper.invokeServlet(StubSecurityHelper.java:125)
           at weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.java:300)
           at weblogic.servlet.internal.TailFilter.doFilter(TailFilter.java:26)
           at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56)
           at oracle.adf.model.servlet.ADFBindingFilter.doFilter(ADFBindingFilter.java:173)
           at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56)
           at oracle.adfinternal.view.faces.webapp.rich.RegistrationFilter.doFilter(RegistrationFilter.java:121)
           at org.apache.myfaces.trinidadinternal.webapp.TrinidadFilterImpl$FilterListChain.doFilter(TrinidadFilterImpl.java:468)
           at oracle.adfinternal.view.faces.activedata.AdsFilter.doFilter(AdsFilter.java:60)
           at org.apache.myfaces.trinidadinternal.webapp.TrinidadFilterImpl$FilterListChain.doFilter(TrinidadFilterImpl.java:468)
           at org.apache.myfaces.trinidadinternal.webapp.TrinidadFilterImpl._doFilterImpl(TrinidadFilterImpl.java:293)
           at org.apache.myfaces.trinidadinternal.webapp.TrinidadFilterImpl.doFilter(TrinidadFilterImpl.java:199)
           at org.apache.myfaces.trinidad.webapp.TrinidadFilter.doFilter(TrinidadFilter.java:92)
           at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56)
           at oracle.adf.library.webapp.LibraryFilter.doFilter(LibraryFilter.java:180)
           at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56)
           at oracle.security.jps.ee.http.JpsAbsFilter$1.run(JpsAbsFilter.java:111)
           at java.security.AccessController.doPrivileged(Native Method)
           at oracle.security.jps.util.JpsSubject.doAsPrivileged(JpsSubject.java:313)
           at oracle.security.jps.ee.util.JpsPlatformUtil.runJaasMode(JpsPlatformUtil.java:413)
           at oracle.security.jps.ee.http.JpsAbsFilter.runJaasMode(JpsAbsFilter.java:94)
           at oracle.security.jps.ee.http.JpsAbsFilter.doFilter(JpsAbsFilter.java:161)
           at oracle.security.jps.ee.http.JpsFilter.doFilter(JpsFilter.java:71)
           at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56)
           at oracle.dms.servlet.DMSServletFilter.doFilter(DMSServletFilter.java:136)
           at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56)
           at weblogic.servlet.internal.RequestEventsFilter.doFilter(RequestEventsFilter.java:27)
           at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56)
           at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.wrapRun(WebAppServletContext.java:3715)
           at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.run(WebAppServletContext.java:3681)
           at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:321)
           at weblogic.security.service.SecurityManager.runAs(SecurityManager.java:120)
           at weblogic.servlet.internal.WebAppServletContext.securedExecute(WebAppServletContext.java:2277)
           at weblogic.servlet.internal.WebAppServletContext.execute(WebAppServletContext.java:2183)
           at weblogic.servlet.internal.ServletRequestImpl.run(ServletRequestImpl.java:1454)
           at weblogic.work.ExecuteThread.execute(ExecuteThread.java:209)
           at weblogic.work.ExecuteThread.run(ExecuteThread.java:178)
      Caused by: java.sql.SQLException: Attempt to set a parameter name that does not occur in the SQL: fbkKy__1
           at oracle.jdbc.driver.OraclePreparedStatement.setNullAtName(OraclePreparedStatement.java:5357)
           at oracle.jdbc.driver.OraclePreparedStatementWrapper.setNullAtName(OraclePreparedStatementWrapper.java:1447)
           at weblogic.jdbc.wrapper.PreparedStatement_oracle_jdbc_driver_OraclePreparedStatementWrapper.setNullAtName(Unknown Source)
           at oracle.jbo.server.OracleSQLBuilderImpl.bindParamValue(OracleSQLBuilderImpl.java:4690)
           at oracle.jbo.server.BaseSQLBuilderImpl.bindParametersForStmt(BaseSQLBuilderImpl.java:3673)
           at oracle.jbo.server.ViewObjectImpl.bindParametersForCollection(ViewObjectImpl.java:21075)
           at oracle.jbo.server.QueryCollection.buildResultSet(QueryCollection.java:1171)
           ... 128 more
      ## Detail 0 ##
      java.sql.SQLException: Attempt to set a parameter name that does not occur in the SQL: fbkKy__1
           at oracle.jdbc.driver.OraclePreparedStatement.setNullAtName(OraclePreparedStatement.java:5357)
           at oracle.jdbc.driver.OraclePreparedStatementWrapper.setNullAtName(OraclePreparedStatementWrapper.java:1447)
           at weblogic.jdbc.wrapper.PreparedStatement_oracle_jdbc_driver_OraclePreparedStatementWrapper.setNullAtName(Unknown Source)
           at oracle.jbo.server.OracleSQLBuilderImpl.bindParamValue(OracleSQLBuilderImpl.java:4690)
           at oracle.jbo.server.BaseSQLBuilderImpl.bindParametersForStmt(BaseSQLBuilderImpl.java:3673)
           at oracle.jbo.server.ViewObjectImpl.bindParametersForCollection(ViewObjectImpl.java:21075)
           at oracle.jbo.server.QueryCollection.buildResultSet(QueryCollection.java:1171)
           at oracle.jbo.server.QueryCollection.executeQuery(QueryCollection.java:893)
           at oracle.jbo.server.ViewObjectImpl.executeQueryForCollection(ViewObjectImpl.java:7154)
           at oracle.jbo.server.ViewRowSetImpl.execute(ViewRowSetImpl.java:1227)
           at oracle.jbo.server.ViewRowSetImpl.executeQueryForMasters(ViewRowSetImpl.java:1413)
           at oracle.jbo.server.ViewRowSetImpl.executeQueryForMode(ViewRowSetImpl.java:1319)
           at oracle.jbo.server.ViewRowSetImpl.executeQuery(ViewRowSetImpl.java:1304)
           at oracle.jbo.server.ViewObjectImpl.retrieveByKey(ViewObjectImpl.java:17205)
           at oracle.jbo.server.ViewObjectImpl.retrieveByKey(ViewObjectImpl.java:16853)
           at oracle.jbo.server.ViewObjectImpl.retrieveByKey(ViewObjectImpl.java:16847)
           at oracle.jbo.server.ViewRowSetImpl.findByKey(ViewRowSetImpl.java:5523)
           at oracle.jbo.server.ViewRowSetImpl.findByKey(ViewRowSetImpl.java:5286)
           at oracle.jbo.server.ViewRowSetImpl.findByKey(ViewRowSetImpl.java:5280)
           at oracle.jbo.server.ViewObjectImpl.findByKey(ViewObjectImpl.java:11497)
           at oracle.jbo.uicli.binding.JUCtrlHierBinding.bringNodeToRangeKeyPath(JUCtrlHierBinding.java:792)
           at oracle.adfinternal.view.faces.model.binding.FacesCtrlHierBinding.bringNodeToRangeKeyPath(FacesCtrlHierBinding.java:111)
           at oracle.adfinternal.view.faces.model.binding.RowDataManager.setRowKey(RowDataManager.java:130)
           at oracle.adfinternal.view.faces.model.binding.FacesCtrlHierBinding$FacesModel.setRowKey(FacesCtrlHierBinding.java:830)
           at org.apache.myfaces.trinidad.component.UIXCollection.setRowKey(UIXCollection.java:513)
           at oracle.adfinternal.view.faces.renderkit.rich.TableRendererUtils._processStampedChildrenForActiveRow(TableRendererUtils.java:2187)
           at oracle.adfinternal.view.faces.renderkit.rich.TableRendererUtils.processFacetsAndChildrenForClickToEdit(TableRendererUtils.java:1525)
           at oracle.adfinternal.view.faces.renderkit.rich.TableRenderer.processFacetsAndChildrenForClickToEdit(TableRenderer.java:343)
           at oracle.adfinternal.view.faces.renderkit.rich.TableRenderer.decodeChildren(TableRenderer.java:184)
           at org.apache.myfaces.trinidad.component.UIXComponentBase.decodeChildren(UIXComponentBase.java:1176)
           at org.apache.myfaces.trinidad.component.UIXCollection.processDecodes(UIXCollection.java:200)
           at org.apache.myfaces.trinidad.component.UIXComponentBase.decodeChildrenImpl(UIXComponentBase.java:1194)
           at org.apache.myfaces.trinidad.component.UIXComponentBase.decodeChildren(UIXComponentBase.java:1180)
           at org.apache.myfaces.trinidad.component.UIXComponentBase.processDecodes(UIXComponentBase.java:952)
           at org.apache.myfaces.trinidad.component.UIXComponentBase.decodeChildrenImpl(UIXComponentBase.java:1194)
           at org.apache.myfaces.trinidad.component.UIXComponentBase.decodeChildren(UIXComponentBase.java:1180)
           at org.apache.myfaces.trinidad.component.UIXComponentBase.processDecodes(UIXComponentBase.java:952)
           at org.apache.myfaces.trinidad.component.UIXShowDetail.processDecodes(UIXShowDetail.java:104)
           at org.apache.myfaces.trinidad.component.UIXComponentBase.decodeChildrenImpl(UIXComponentBase.java:1194)
           at org.apache.myfaces.trinidad.component.UIXComponentBase.decodeChildren(UIXComponentBase.java:1180)
           at org.apache.myfaces.trinidad.component.UIXComponentBase.processDecodes(UIXComponentBase.java:952)
           at org.apache.myfaces.trinidad.component.UIXComponentBase.decodeChildrenImpl(UIXComponentBase.java:1194)
           at org.apache.myfaces.trinidad.component.UIXComponentBase.decodeChildren(UIXComponentBase.java:1180)
           at org.apache.myfaces.trinidad.component.UIXComponentBase.processDecodes(UIXComponentBase.java:952)
           at org.apache.myfaces.trinidad.component.UIXComponentBase.decodeChildrenImpl(UIXComponentBase.java:1194)
           at org.apache.myfaces.trinidad.component.UIXComponentBase.decodeChildren(UIXComponentBase.java:1180)
           at org.apache.myfaces.trinidad.component.UIXComponentBase.processDecodes(UIXComponentBase.java:952)
           at org.apache.myfaces.trinidad.component.UIXComponentBase.decodeChildrenImpl(UIXComponentBase.java:1194)
           at org.apache.myfaces.trinidad.component.UIXComponentBase.decodeChildren(UIXComponentBase.java:1180)
           at org.apache.myfaces.trinidad.component.UIXComponentBase.processDecodes(UIXComponentBase.java:952)
           at oracle.adf.view.rich.component.fragment.ContextSwitchingComponent.access$001(ContextSwitchingComponent.java:41)
           at oracle.adf.view.rich.component.fragment.ContextSwitchingComponent$2.run(ContextSwitchingComponent.java:149)
           at oracle.adf.view.rich.component.fragment.ContextSwitchingComponent._processPhase(ContextSwitchingComponent.java:461)
           at oracle.adf.view.rich.component.fragment.ContextSwitchingComponent.processDecodes(ContextSwitchingComponent.java:152)
           at org.apache.myfaces.trinidad.component.UIXComponentBase.decodeChildrenImpl(UIXComponentBase.java:1194)
           at org.apache.myfaces.trinidad.component.UIXComponentBase.decodeChildren(UIXComponentBase.java:1180)
           at org.apache.myfaces.trinidad.component.UIXComponentBase.processDecodes(UIXComponentBase.java:952)
           at org.apache.myfaces.trinidad.component.UIXComponentBase.decodeChildrenImpl(UIXComponentBase.java:1194)
           at org.apache.myfaces.trinidad.component.UIXComponentBase.decodeChildren(UIXComponentBase.java:1180)
           at org.apache.myfaces.trinidad.component.UIXComponentBase.processDecodes(UIXComponentBase.java:952)
           at org.apache.myfaces.trinidad.component.UIXComponentBase.decodeChildrenImpl(UIXComponentBase.java:1194)
           at org.apache.myfaces.trinidad.component.UIXComponentBase.decodeChildren(UIXComponentBase.java:1180)
           at org.apache.myfaces.trinidad.component.UIXComponentBase.processDecodes(UIXComponentBase.java:952)
           at org.apache.myfaces.trinidad.component.UIXComponentBase.decodeChildrenImpl(UIXComponentBase.java:1194)
           at org.apache.myfaces.trinidad.component.UIXComponentBase.decodeChildren(UIXComponentBase.java:1180)
           at org.apache.myfaces.trinidad.component.UIXComponentBase.processDecodes(UIXComponentBase.java:952)
           at org.apache.myfaces.trinidad.component.UIXComponentBase.decodeChildrenImpl(UIXComponentBase.java:1194)
           at org.apache.myfaces.trinidad.component.UIXComponentBase.decodeChildren(UIXComponentBase.java:1180)
           at org.apache.myfaces.trinidad.component.UIXComponentBase.processDecodes(UIXComponentBase.java:952)
           at org.apache.myfaces.trinidad.component.UIXComponentBase.decodeChildrenImpl(UIXComponentBase.java:1194)
           at org.apache.myfaces.trinidad.component.UIXComponentBase.decodeChildren(UIXComponentBase.java:1180)
           at org.apache.myfaces.trinidad.component.UIXComponentBase.processDecodes(UIXComponentBase.java:952)
           at org.apache.myfaces.trinidad.component.UIXComponentBase.decodeChildrenImpl(UIXComponentBase.java:1194)
           at org.apache.myfaces.trinidad.component.UIXComponentBase.decodeChildren(UIXComponentBase.java:1180)
           at org.apache.myfaces.trinidad.component.UIXComponentBase.processDecodes(UIXComponentBase.java:952)
           at org.apache.myfaces.trinidad.component.UIXComponentBase.decodeChildrenImpl(UIXComponentBase.java:1194)
           at org.apache.myfaces.trinidad.component.UIXComponentBase.decodeChildren(UIXComponentBase.java:1180)
           at org.apache.myfaces.trinidad.component.UIXComponentBase.processDecodes(UIXComponentBase.java:952)
           at org.apache.myfaces.trinidad.component.UIXComponentBase.decodeChildrenImpl(UIXComponentBase.java:1194)
           at org.apache.myfaces.trinidad.component.UIXComponentBase.decodeChildren(UIXComponentBase.java:1180)
           at org.apache.myfaces.trinidad.component.UIXComponentBase.processDecodes(UIXComponentBase.java:952)
           at oracle.adf.view.rich.component.fragment.ContextSwitchingComponent.access$001(ContextSwitchingComponent.java:41)
           at oracle.adf.view.rich.component.fragment.ContextSwitchingComponent$2.run(ContextSwitchingComponent.java:149)
           at oracle.adf.view.rich.component.fragment.ContextSwitchingComponent._processPhase(ContextSwitchingComponent.java:461)
           at oracle.adf.view.rich.component.fragment.ContextSwitchingComponent.processDecodes(ContextSwitchingComponent.java:152)
           at org.apache.myfaces.trinidad.component.UIXComponentBase.decodeChildrenImpl(UIXComponentBase.java:1194)
           at org.apache.myfaces.trinidad.component.UIXComponentBase.decodeChildren(UIXComponentBase.java:1180)
           at org.apache.myfaces.trinidad.component.UIXForm.processDecodes(UIXForm.java:75)
           at org.apache.myfaces.trinidad.component.UIXComponentBase.decodeChildrenImpl(UIXComponentBase.java:1194)
           at org.apache.myfaces.trinidad.component.UIXComponentBase.decodeChildren(UIXComponentBase.java:1180)
           at org.apache.myfaces.trinidad.component.UIXComponentBase.processDecodes(UIXComponentBase.java:952)
           at javax.faces.component.UIComponentBase.processDecodes(UIComponentBase.java:1047)
           at javax.faces.component.UIViewRoot.processDecodes(UIViewRoot.java:926)
           at oracle.adfinternal.view.faces.lifecycle.LifecycleImpl$ApplyRequestValuesCallback.invokeContextCallback(LifecycleImpl.java:1548)
           at oracle.adfinternal.view.faces.lifecycle.LifecycleImpl._executePhase(LifecycleImpl.java:364)
           at oracle.adfinternal.view.faces.lifecycle.LifecycleImpl.execute(LifecycleImpl.java:204)
           at javax.faces.webapp.FacesServlet.service(FacesServlet.java:312)
           at weblogic.servlet.internal.StubSecurityHelper$ServletServiceAction.run(StubSecurityHelper.java:227)
           at weblogic.servlet.internal.StubSecurityHelper.invokeServlet(StubSecurityHelper.java:125)
           at weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.java:300)
           at weblogic.servlet.internal.TailFilter.doFilter(TailFilter.java:26)
           at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56)
           at oracle.adf.model.servlet.ADFBindingFilter.doFilter(ADFBindingFilter.java:173)
           at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56)
           at oracle.adfinternal.view.faces.webapp.rich.RegistrationFilter.doFilter(RegistrationFilter.java:121)
           at org.apache.myfaces.trinidadinternal.webapp.TrinidadFilterImpl$FilterListChain.doFilter(TrinidadFilterImpl.java:468)
           at oracle.adfinternal.view.faces.activedata.AdsFilter.doFilter(AdsFilter.java:60)
           at org.apache.myfaces.trinidadinternal.webapp.TrinidadFilterImpl$FilterListChain.doFilter(TrinidadFilterImpl.java:468)
           at org.apache.myfaces.trinidadinternal.webapp.TrinidadFilterImpl._doFilterImpl(TrinidadFilterImpl.java:293)
           at org.apache.myfaces.trinidadinternal.webapp.TrinidadFilterImpl.doFilter(TrinidadFilterImpl.java:199)
           at org.apache.myfaces.trinidad.webapp.TrinidadFilter.doFilter(TrinidadFilter.java:92)
           at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56)
           at oracle.adf.library.webapp.LibraryFilter.doFilter(LibraryFilter.java:180)
           at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56)
           at oracle.security.jps.ee.http.JpsAbsFilter$1.run(JpsAbsFilter.java:111)
           at java.security.AccessController.doPrivileged(Native Method)
           at oracle.security.jps.util.JpsSubject.doAsPrivileged(JpsSubject.java:313)
           at oracle.security.jps.ee.util.JpsPlatformUtil.runJaasMode(JpsPlatformUtil.java:413)
           at oracle.security.jps.ee.http.JpsAbsFilter.runJaasMode(JpsAbsFilter.java:94)
           at oracle.security.jps.ee.http.JpsAbsFilter.doFilter(JpsAbsFilter.java:161)
           at oracle.security.jps.ee.http.JpsFilter.doFilter(JpsFilter.java:71)
           at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56)
           at oracle.dms.servlet.DMSServletFilter.doFilter(DMSServletFilter.java:136)
           at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56)
           at weblogic.servlet.internal.RequestEventsFilter.doFilter(RequestEventsFilter.java:27)
           at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56)
           at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.wrapRun(WebAppServletContext.java:3715)
           at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.run(WebAppServletContext.java:3681)
           at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:321)
           at weblogic.security.service.SecurityManager.runAs(SecurityManager.java:120)
           at weblogic.servlet.internal.WebAppServletContext.securedExecute(WebAppServletContext.java:2277)
           at weblogic.servlet.internal.WebAppServletContext.execute(WebAppServletContext.java:2183)
           at weblogic.servlet.internal.ServletRequestImpl.run(ServletRequestImpl.java:1454)
           at weblogic.work.ExecuteThread.execute(ExecuteThread.java:209)
           at weblogic.work.ExecuteThread.run(ExecuteThread.java:178)

      -------------------------------------------------------------------

      This is my detail VO's (allowedTransactionVO) query
      -------------------------------------------------------------------
      SELECT allowedTransactionEO.FROM_ACC_SUB_TYPE,
      allowedTransactionEO.FROM_ACC_TYPE,
      allowedTransactionEO.TO_ACC_SUB_TYPE,
      allowedTransactionEO.TO_ACC_TYPE,
      allowedTransactionEO.TRANSACTION_TYPE
      FROM ALLOWED_TRANSACTIONS allowedTransactionEO
      -------------------------------------------------------------------

      Note that I can update,delete detail record. This error occurs only when inserting a detail record.
      Please help me to get this solved.

      Regards !
      Sameera
        • 1. Re: JBO-27122: SQL error during statement preparation
          RaviNuka
          Hi,

          Have you created the association between parentEO and childEO and also did you create your view link based on Association (instead of using vo)? If you do so, during new inserts, parentkey will be updated in childvo as foreign key automatically and will not cause this issue.

          If you have followed this already, ensure if you have created any view criterias in your child VO and made them as mandatory fields where some of the bind variables are expending some values always. Try to make them optional and try.

          Thanks,
          Ravi Nuka.