0 Replies Latest reply on May 17, 2011 8:23 AM by 680096

    problem in shared LOV

    680096
      Hi,

      I have built a shared region for LOV where the search is based on a single attribute( this is not to be saved in database, so created a transient attribute in VO) the corresponding ID of this is to be saved but not displayed to the user, so I created a form value.

      The problem is when I click on LOV and give the search criteria, I am getting below error although I have not included any bind parameter here. Kindly respond as I am stuck with this.

      oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT * FROM (select distinct mc.SEGMENT1||'.'||mc.SEGMENT2 "Comodity"
      ,poe.SEGMENT_VALUE "Major Account"
      ,poe.RULE_VALUE_ID
      ,poe2.segment_value "CC"
      from po.PO_RULE_EXPENSE_ACCOUNTS poe,
      po.PO_RULE_EXPENSE_ACCOUNTS poe2,
      inv.mtl_categories_b mc,
      apps.fnd_flex_values fv,
      apps.fnd_flex_values_tl tl
      where poe.ORG_ID = 170
      and poe.RULE_VALUE_ID = mc.CATEGORY_ID
      and poe.segment_num = 'SEGMENT3'
      and poe2.RULE_VALUE_ID (+) = mc.CATEGORY_ID
      and poe2.segment_num (+) = 'SEGMENT2'
      and fv.flex_value = poe.segment_value
      and fv.flex_value_set_id = 1004670
      and fv.flex_value_id = tl.flex_value_id
      and fv.enabled_flag = 'Y') QRSLT WHERE (( UPPER(Comodity) like :1 AND (Comodity like :2 OR Comodity like :3 OR Comodity like :4 OR Comodity like :5)))
           at oracle.apps.fnd.framework.OAException.wrapperException(OAException.java:891)
           at oracle.apps.fnd.framework.webui.OAPageErrorHandler.prepareException(OAPageErrorHandler.java:1145)
           at oracle.apps.fnd.framework.webui.OAPageErrorHandler.processErrors(OAPageErrorHandler.java:1408)
           at oracle.apps.fnd.framework.webui.OAPageBean.processFormRequest(OAPageBean.java:2662)
           at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:1665)
           at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:502)
           at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:423)
           at OA.jspService(OA.jsp:40)
           at com.orionserver.http.OrionHttpJspPage.service(OrionHttpJspPage.java:56)
           at oracle.jsp.runtimev2.JspPageTable.service(JspPageTable.java:317)
           at oracle.jsp.runtimev2.JspServlet.internalService(JspServlet.java:465)
           at oracle.jsp.runtimev2.JspServlet.service(JspServlet.java:379)
           at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
           at com.evermind.server.http.ServletRequestDispatcher.invoke(ServletRequestDispatcher.java:727)
           at com.evermind.server.http.ServletRequestDispatcher.forwardInternal(ServletRequestDispatcher.java:306)
           at com.evermind.server.http.HttpRequestHandler.processRequest(HttpRequestHandler.java:767)
           at com.evermind.server.http.HttpRequestHandler.run(HttpRequestHandler.java:259)
           at com.evermind.server.http.HttpRequestHandler.run(HttpRequestHandler.java:106)
           at EDU.oswego.cs.dl.util.concurrent.PooledExecutor$Worker.run(PooledExecutor.java:803)
           at java.lang.Thread.run(Thread.java:534)
      ## Detail 0 ##
      java.sql.SQLException: ORA-00904: "COMODITY": invalid identifier

           at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
           at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:289)
           at oracle.jdbc.ttc7.Oall7.receive(Oall7.java:583)
           at oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1986)
           at oracle.jdbc.ttc7.TTC7Protocol.parseExecuteFetch(TTC7Protocol.java:1144)
           at oracle.jdbc.driver.OracleStatement.doExecuteQuery(OracleStatement.java:2548)
           at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:2933)
           at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:650)
           at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:578)
           at oracle.jbo.server.QueryCollection.buildResultSet(QueryCollection.java:627)
           at oracle.jbo.server.QueryCollection.executeQuery(QueryCollection.java:515)
           at oracle.jbo.server.ViewObjectImpl.executeQueryForCollection(ViewObjectImpl.java:3347)
           at oracle.jbo.server.OAJboViewObjectImpl.executeQueryForCollection(OAJboViewObjectImpl.java:828)
           at oracle.apps.fnd.framework.server.OAViewObjectImpl.executeQueryForCollection(OAViewObjectImpl.java:4504)
           at oracle.jbo.server.ViewRowSetImpl.execute(ViewRowSetImpl.java:574)
           at oracle.jbo.server.ViewRowSetImpl.execute(ViewRowSetImpl.java:544)
           at oracle.jbo.server.ViewRowSetImpl.executeDetailQuery(ViewRowSetImpl.java:619)
           at oracle.jbo.server.ViewObjectImpl.executeDetailQuery(ViewObjectImpl.java:3311)
           at oracle.jbo.server.ViewObjectImpl.executeQuery(ViewObjectImpl.java:3298)
           at oracle.apps.fnd.framework.server.OAViewObjectImpl.executeQuery(OAViewObjectImpl.java:440)
           at oracle.apps.fnd.framework.server.OAViewObjectImpl.initQuery(OAViewObjectImpl.java:715)
           at oracle.apps.fnd.framework.webui.OAWebBeanHelper.setCriteriaOnVO(OAWebBeanHelper.java:2269)
           at oracle.apps.fnd.framework.webui.OAListOfValuesHelper.processFormRequestAfterController(OAListOfValuesHelper.java:1441)
           at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequest(OAWebBeanHelper.java:820)
           at oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processFormRequest(OAWebBeanContainerHelper.java:363)
           at oracle.apps.fnd.framework.webui.OAListOfValuesHelper.processFormRequest(OAListOfValuesHelper.java:1346)
           at oracle.apps.fnd.framework.webui.beans.layout.OAListOfValuesBean.processFormRequest(OAListOfValuesBean.java:389)
           at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequestChildren(OAWebBeanHelper.java:1000)
           at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequestChildren(OAWebBeanHelper.java:966)
           at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequest(OAWebBeanHelper.java:821)
           at oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processFormRequest(OAWebBeanContainerHelper.java:363)
           at oracle.apps.fnd.framework.webui.beans.OABodyBean.processFormRequest(OABodyBean.java:363)
           at oracle.apps.fnd.framework.webui.OAPageBean.processFormRequest(OAPageBean.java:2658)
           at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:1665)
           at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:502)
           at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:423)
           at OA.jspService(OA.jsp:40)
           at com.orionserver.http.OrionHttpJspPage.service(OrionHttpJspPage.java:56)
           at oracle.jsp.runtimev2.JspPageTable.service(JspPageTable.java:317)
           at oracle.jsp.runtimev2.JspServlet.internalService(JspServlet.java:465)
           at oracle.jsp.runtimev2.JspServlet.service(JspServlet.java:379)
           at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
           at com.evermind.server.http.ServletRequestDispatcher.invoke(ServletRequestDispatcher.java:727)
           at com.evermind.server.http.ServletRequestDispatcher.forwardInternal(ServletRequestDispatcher.java:306)
           at com.evermind.server.http.HttpRequestHandler.processRequest(HttpRequestHandler.java:767)
           at com.evermind.server.http.HttpRequestHandler.run(HttpRequestHandler.java:259)
           at com.evermind.server.http.HttpRequestHandler.run(HttpRequestHandler.java:106)
           at EDU.oswego.cs.dl.util.concurrent.PooledExecutor$Worker.run(PooledExecutor.java:803)
           at java.lang.Thread.run(Thread.java:534)