oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT * FROM (select stores.store_id, storestl.store_name from icx_cat_stores_b stores, icx_cat_stores_tl storestl where stores.store_id = storestl.store_id and storestl.language = :1 and stores.store_type <> 'NON_CATALOG' and exists ( select 1 from icx_cat_store_org_assignments store_org where store_org.store_id = stores.store_id and store_org.org_id in (:2, -2) ) and exists ( select 1 from icx_cat_store_catalogs icsc, icx_por_item_sources isrc where icsc.store_id = stores.store_id and isrc.item_source_id = icsc.item_source_id and isrc.type <> 'CNTRCTR' )) QRSLT ORDER BY lower(store_name)

Searched on Google with the first line of a JAVA stack trace?

We can recommend more relevant solutions and speed up debugging when you paste your entire stack trace with the exception message. Try a sample exception.

Recommended solutions based on your search

Solutions on the web

via Oracle Community by 945846, 1 year ago
oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT * FROM (select stores.store_id, storestl.store_name from icx_cat_stores_b stores, icx_cat_stores_tl storestl where stores.store_id = storestl.store_id
via Oracle Community by user12119208, 1 year ago
oracle.jbo.NoDefException: JBO-25002: Definition ReqLineNum of type Attribute not found
via Oracle Community by user573991, 1 year ago
oracle.jbo.NoDefException: JBO-25002: Definition SupplierName of type Attribute not found
via Oracle Community by 501484, 4 months ago
oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: select pil.per_in_ler_id , to_char(pil.lf_evt_ocrd_dt, 'rrrr/mm/dd') lf_evt_ocrd_dt from ben_per_in_ler pil, ben_ler_f ler where pil.ler_id = ler.ler_id and
via Oracle Community by user520892, 1 year ago
oracle.jbo.domain.GenericDomainException: JBO-25028: Number.bigDecimalValue Creation Error :java.lang.ArrayIndexOutOfBoundsException: 0
via Oracle Community by 521069, 1 year ago
oracle.jbo.AttrValException: JBO-27019: Get method for attribute "Meaning" in UpsExRcvHomeSearchAttributesVO_11 could not be resolved.
oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT * FROM (select stores.store_id, storestl.store_name from icx_cat_stores_b stores, icx_cat_stores_tl storestl where stores.store_id = storestl.store_id and storestl.language = :1 and stores.store_type <> 'NON_CATALOG' and exists ( select 1 from icx_cat_store_org_assignments store_org where store_org.store_id = stores.store_id and store_org.org_id in (:2, -2) ) and exists ( select 1 from icx_cat_store_catalogs icsc, icx_por_item_sources isrc where icsc.store_id = stores.store_id and isrc.item_source_id = icsc.item_source_id and isrc.type <> 'CNTRCTR' )) QRSLT ORDER BY lower(store_name)
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.OAPageBean.renderDocument(OAPageBean.java:2958)
at oracle.apps.fnd.framework.webui.OAPageBean.renderDocument(OAPageBean.java:2755)
at oa_html._OA._jspService(_OA.java:101)
at oracle.jsp.runtime.HttpJsp.service(HttpJsp.java:119)
at oracle.jsp.app.JspApplication.dispatchRequest(JspApplication.java:417)
at oracle.jsp.JspServlet.doDispatch(JspServlet.java:267)
at oracle.jsp.JspServlet.internalService(JspServlet.java:186)
at oracle.jsp.JspServlet.service(JspServlet.java:156)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:588)
at oracle.jsp.provider.Jsp20RequestDispatcher.forward(Jsp20RequestDispatcher.java:162)
at oracle.jsp.runtime.OraclePageContext.forward(OraclePageContext.java:187)
at oa_html._OA._jspService(_OA.java:94)
at oracle.jsp.runtime.HttpJsp.service(HttpJsp.java:119)
at oracle.jsp.app.JspApplication.dispatchRequest(JspApplication.java:417)
at oracle.jsp.JspServlet.doDispatch(JspServlet.java:267)
at oracle.jsp.JspServlet.internalService(JspServlet.java:186)
at oracle.jsp.JspServlet.service(JspServlet.java:156)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:588)
at oracle.jsp.provider.Jsp20RequestDispatcher.forward(Jsp20RequestDispatcher.java:162)
at oracle.jsp.runtime.OraclePageContext.forward(OraclePageContext.java:187)
at oa_html._OA._jspService(_OA.java:94)
at oracle.jsp.runtime.HttpJsp.service(HttpJsp.java:119)
at oracle.jsp.app.JspApplication.dispatchRequest(JspApplication.java:417)
at oracle.jsp.JspServlet.doDispatch(JspServlet.java:267)
at oracle.jsp.JspServlet.internalService(JspServlet.java:186)
at oracle.jsp.JspServlet.service(JspServlet.java:156)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:588)
at oracle.jsp.provider.Jsp20RequestDispatcher.forward(Jsp20RequestDispatcher.java:162)
at oracle.jsp.runtime.OraclePageContext.forward(OraclePageContext.java:187)
at oa_html._RF._jspService(_RF.java:102)
at oracle.jsp.runtime.HttpJsp.service(HttpJsp.java:119)
at oracle.jsp.app.JspApplication.dispatchRequest(JspApplication.java:417)
at oracle.jsp.JspServlet.doDispatch(JspServlet.java:267)
at oracle.jsp.JspServlet.internalService(JspServlet.java:186)
at oracle.jsp.JspServlet.service(JspServlet.java:156)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:588)
at org.apache.jserv.JServConnection.processRequest(JServConnection.java:456)
at org.apache.jserv.JServConnection.run(JServConnection.java:294)
at java.lang.Thread.run(Thread.java:595)

Users with the same issue

Samebug visitor profile picture
Unknown user
Once, 1 year ago
Samebug visitor profile picture
Unknown user
Once, 1 year ago
Samebug visitor profile picture
Unknown user
Once, 1 year ago
Samebug visitor profile picture
Unknown user
Once, 1 year ago
Samebug visitor profile picture
Unknown user
Once, 1 year ago
9 more bugmates

Know the solutions? Share your knowledge to help other developers to debug faster.