oracle.apps.fnd.framework.OAException: 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 ,op.currency ,op.payment_method ,opi.invoice_amount ,opi.invoice_payment_status ,op.vendor_name ,op.vendor_site_code from ofsap_paid_invoices opi join ofsap_payments op on opi.INVOICE_PAYMENT_ID=op.PAYMENT_ID) QRSLT WHERE (( UPPER(VIEW_ATTR) like :1 AND (VIEW_ATTR like :2 OR VIEW_ATTR like :3 OR VIEW_ATTR like :4 OR VIEW_ATTR like :5)AND UPPER(VIEW_ATTR) like :6 AND (VIEW_ATTR like :7 OR VIEW_ATTR like :8 OR VIEW_ATTR like :9 OR VIEW_ATTR like :10)))

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 862079, 1 year ago
,op.currency ,op.payment_method ,opi.invoice_amount ,opi.invoice_payment_status ,op.vendor_name ,op.vendor_site_code from ofsap_paid_invoices opi join ofsap_payments op on opi.INVOICE_PAYMENT_ID=op.PAYMENT_ID) QRSLT WHERE (( UPPER(VIEW_ATTR) like :1 AND
via Oracle Community by 862079, 1 year ago
,op.currency ,op.payment_method ,opi.invoice_amount ,opi.invoice_payment_status ,op.vendor_name ,op.vendor_site_code from ofsap_paid_invoices opi ,ofsap_payments op where opi.INVOICE_PAYMENT_ID=op.PAYMENT_ID) QRSLT WHERE (( UPPER(PaymentAmountFrom) like :1 AND
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 ,op.check_date ,op.check_number ,op.currency ,op.payment_method
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 Kaushal Bhati, 1 year ago
.MGR_CODE, Emp1.DESIGNATION, Emp1.SALARY FROM EMP Emp1 WHERE (( UPPER(Emp1.EMP_NAME) like :2 AND (Emp1.EMP_NAME like :3 OR Emp1.EMP_NAME like :4 OR Emp1.EMP_NAME like :5 OR Emp1.EMP_NAME like :6)))
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)))
oracle.apps.fnd.framework.OAException: 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 ,op.currency ,op.payment_method ,opi.invoice_amount ,opi.invoice_payment_status ,op.vendor_name ,op.vendor_site_code from ofsap_paid_invoices opi join ofsap_payments op on opi.INVOICE_PAYMENT_ID=op.PAYMENT_ID) QRSLT WHERE (( UPPER(VIEW_ATTR) like :1 AND (VIEW_ATTR like :2 OR VIEW_ATTR like :3 OR VIEW_ATTR like :4 OR VIEW_ATTR like :5)AND UPPER(VIEW_ATTR) like :6 AND (VIEW_ATTR like :7 OR VIEW_ATTR like :8 OR VIEW_ATTR like :9 OR VIEW_ATTR like :10)))
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.processFormRequest(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 week 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

Write tip

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