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 ,ofsap_payments op where opi.INVOICE_PAYMENT_ID=op.PAYMENT_ID) QRSLT WHERE (( UPPER(PaymentAmountFrom) like :1 AND (PaymentAmountFrom like :2 OR PaymentAmountFrom like :3 OR PaymentAmountFrom like :4 OR PaymentAmountFrom like :5)AND UPPER(PaymentAmountTo) like :6 AND (PaymentAmountTo like :7 OR PaymentAmountTo like :8 OR PaymentAmountTo like :9 OR PaymentAmountTo like :10)))

Samebug tips0

We couldn't find tips for this exception.

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

Solutions on the web1658

  • via Unknown by 862079,
  • via Unknown by user609291,
  • via Unknown by 2973180,
  • 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 ,ofsap_payments op where opi.INVOICE_PAYMENT_ID=op.PAYMENT_ID) QRSLT WHERE (( UPPER(PaymentAmountFrom) like :1 AND (PaymentAmountFrom like :2 OR PaymentAmountFrom like :3 OR PaymentAmountFrom like :4 OR PaymentAmountFrom like :5)AND UPPER(PaymentAmountTo) like :6 AND (PaymentAmountTo like :7 OR PaymentAmountTo like :8 OR PaymentAmountTo like :9 OR PaymentAmountTo 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 visitor
    Unknown visitorOnce,
    Unknown visitor
    Unknown visitorOnce,
    Unknown visitor
    Unknown visitorOnce,
    Unknown visitor
    Unknown visitorOnce,
    Unknown visitor
    Unknown visitorOnce,
    14 more bugmates