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 680096, 1 year ago
.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)))
via Oracle Community by 862079, 1 year ago
oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT * FROM (select opi.invoice_num ,opi.purchase_orders ,op.payment_num ,opi.amount_paid Amountpaid ,op.check_date paymentDate ,op.check_number
via Oracle Community by 862079, 1 year ago
oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT * FROM (select opi.invoice_num ,opi.purchase_orders ,op.payment_num ,opi.amount_paid Amountpaid ,op.check_date paymentDate ,op.check_number
via Oracle Community by Myvizhi Selvi, 1 year ago
f where f.user_id = a.user_id and a.document_type = 'CM' order by 2) QRSLT WHERE (( UPPER(CURRENCY_CODE) like UPPER(:1) AND (CURRENCY_CODE like :2 OR CURRENCY_CODE like :3 OR CURRENCY_CODE like :4 OR CURRENCY_CODE like :5))) ORDER BY DESCRIPTION asc
via Oracle Community by Harrrry, 1 year ago
= msix.organization_id)) QRSLT WHERE (organization_id = :1 and inv_direct_item_type = :2 AND ( UPPER(ITEM_NAME) like UPPER(:3) AND (ITEM_NAME like :4 OR ITEM_NAME like :5 OR ITEM_NAME like :6 OR ITEM_NAME like :7)))
via Oracle Community by 839403, 1 year ago
oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT * FROM (select fu.user_name, ppf.full_name, HR_GENERAL.DECODE_POSITION_LATEST_NAME (paf.POSITION_ID) POSITION_NAME, ppf.email_address from fnd_user fu
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)