oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT * FROM (SELECT C.INVENTORY_ITEM_ID, to_char(C.SEGMENT1) SEGMENT1, C.DESCRIPTION, c.primary_uom_code, K.concatenated_segments, B.CATEGORY_ID, c.organization_id, eme_all_pkg.eme_demand_toe_qty('143','155',to_char(C.INVENTORY_ITEM_ID),:1) qty FROM MTL_CATEGORY_SETS_B A, MTL_ITEM_CATEGORIES B, MTL_SYSTEM_ITEMS_B C , MTL_CATEGORIES_B_KFV K WHERE A.CATEGORY_SET_ID = B.CATEGORY_SET_ID and c.internal_order_flag='Y' and c.internal_order_enabled_flag='Y' AND C.INVENTORY_ITEM_ID = B.INVENTORY_ITEM_ID AND B.ORGANIZATION_ID = C.ORGANIZATION_ID AND A.CATEGORY_SET_ID = 1 AND K.category_id = B.CATEGORY_ID AND C.INVENTORY_ITEM_STATUS_CODE='Active' and c.organization_id=:2) QRSLT WHERE (( UPPER(SEGMENT1) like UPPER(:1) AND (SEGMENT1 like :2 OR SEGMENT1 like :3 OR SEGMENT1 like :4 OR SEGMENT1 like :5)))

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 HaroonAfridi, 1 year ago
, c.organization_id, eme_all_pkg.eme_demand_toe_qty('143','155',to_char(C.INVENTORY_ITEM_ID),:1) qty FROM MTL_CATEGORY_SETS_B A, MTL_ITEM_CATEGORIES B, MTL_SYSTEM_ITEMS_B C , MTL_CATEGORIES_B_KFV K WHERE A.CATEGORY_SET_ID = B.CATEGORY_SET_ID and
via Oracle Community by HaroonAfridi, 1 year ago
oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT * FROM (SELECT C.INVENTORY_ITEM_ID, to_char(C.SEGMENT1) SEGMENT1, C.DESCRIPTION, c.primary_uom_code, K.concatenated_segments, B.CATEGORY_ID
via Oracle Community by 574833, 1 year ago
oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT * FROM (select comp_plan_id,name,org_id from cn_comp_plans_all where sysdate between start_date and nvl(end_date,sysdate+1) and org_id = :1) QRSLT WHERE (( UPPER(NAME) like :2 AND (NAME like :3 OR NAME like :4 OR NAME like :5 OR NAME like :6)))
via Oracle Community by 943606, 1 year ago
oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT * FROM (select vendor_id,vendor_name from po_vendors) QRSLT WHERE (( VENDOR_ID = :1 AND UPPER(VENDOR_NAME) like UPPER(:2) AND (VENDOR_NAME like :3 OR VENDOR_NAME like :4 OR VENDOR_NAME like :5 OR VENDOR_NAME like :6)))
via Oracle Community by 741371, 1 year ago
= jrgt.GROUP_ID AND jrre.resource_id = jrrr.role_resource_id AND jrrr.role_id = jrrb.role_id AND jrgt.group_name = xsts.xo2c_entering_unit AND jrgt.LANGUAGE = 'US' AND jrrb.role_code = 'USS_CSR' AND xsts.xo2c_entering_unit like NVL(:1,'%')) QRSLT WHERE (( UPPER(SOURCE_NAME) like :2 AND (SOURCE_NAME like :3 OR SOURCE_NAME like :4 OR SOURCE_NAME like :5 OR SOURCE_NAME like :6)))
via Oracle Community by 713492, 1 year ago
oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT * FROM (SELECT line_id, NULL, item_code, uom, item_desc,category_id FROM xxcrm_new_item_t xi WHERE xi.master_organization_id = :1 UNION SELECT NULL
oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT * FROM (SELECT C.INVENTORY_ITEM_ID, to_char(C.SEGMENT1) SEGMENT1, C.DESCRIPTION, c.primary_uom_code, K.concatenated_segments, B.CATEGORY_ID, c.organization_id, eme_all_pkg.eme_demand_toe_qty('143','155',to_char(C.INVENTORY_ITEM_ID),:1) qty FROM MTL_CATEGORY_SETS_B A, MTL_ITEM_CATEGORIES B, MTL_SYSTEM_ITEMS_B C , MTL_CATEGORIES_B_KFV K WHERE A.CATEGORY_SET_ID = B.CATEGORY_SET_ID and c.internal_order_flag='Y' and c.internal_order_enabled_flag='Y' AND C.INVENTORY_ITEM_ID = B.INVENTORY_ITEM_ID AND B.ORGANIZATION_ID = C.ORGANIZATION_ID AND A.CATEGORY_SET_ID = 1 AND K.category_id = B.CATEGORY_ID AND C.INVENTORY_ITEM_STATUS_CODE='Active' and c.organization_id=:2) QRSLT WHERE (( UPPER(SEGMENT1) like UPPER(:1) AND (SEGMENT1 like :2 OR SEGMENT1 like :3 OR SEGMENT1 like :4 OR SEGMENT1 like :5)))
at oracle.apps.fnd.framework.OAException.wrapperException(Unknown Source)
at oracle.apps.fnd.framework.webui.OAPageErrorHandler.prepareException(Unknown Source)
at oracle.apps.fnd.framework.webui.OAPageErrorHandler.processErrors(Unknown Source)
at oracle.apps.fnd.framework.webui.OAPageBean.processRequest(Unknown Source)
at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(Unknown Source)
at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(Unknown Source)
at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(Unknown Source)

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
14 more bugmates

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