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)))

Samebug tips0

There are no available Samebug tips for this exception. If you know how to solve this issue, help other users by writing a short tip.

Don't give up yet. Paste your full stack trace to get a solution.

Solutions on the web1154

  • via Oracle Community by 862079, 11 months 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, 11 months 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 554681, 2 weeks ago
    oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT * FROM (Query of VO ) QRSLT WHERE (( UPPER(EMPLOYEE_NUMBER) like :5 AND (EMPLOYEE_NUMBER like :6 OR EMPLOYEE_NUMBER like :7 OR EMPLOYEE_NUMBER like :8 OR EMPLOYEE_NUMBER like :9)))
  • Stack trace

    • 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)

    Write tip

    You have a different solution? A short tip here would help you and many other users who saw this issue last week.

    Users with the same issue

    Unknown user
    Once, 10 months ago
    Unknown user
    Once, 10 months ago
    Unknown user
    Once, 11 months ago
    Unknown user
    Once, 1 year ago
    Unknown user
    Once, 1 year ago
    14 more bugmates