oracle.apps.fnd.framework.OAException

There are no available Samebug tips for this exception. Do you have an idea how to solve this issue? A short tip would help users who saw this issue last week.

  • Exception error please suggest
    via by 862079,
  • Export from Advanced Table
    via by 574833,
  • urgent urgent: date in a view
    via by 607060,
  • Data export function is uncorrect
    via by 613172,
  • Concurrent Program Parameters
    via by 539838,
  • Export Button. Invalid Column Type
    via by 541412,
    • 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 ,op.check_date ,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 (1=1 and AMOUNT_PAID between 'null' and 'null' and trunc(Check_date) between 'null' and 'null') 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

    Unknown visitor1 times, last one,
    Unknown visitor1 times, last one,
    Unknown visitor1 times, last one,
    Unknown visitor1 times, last one,
    Unknown visitor1 times, last one,
    14 more bugmates