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.

  • Tab vs Mouse Click
    via by 480597,
  • Fnd Load Issue
    via by Unknown author,
  • SEPL and VO Extension
    via by 567494,
  • Hide/Show within a table
    via by 489141,
  • Getting JBO-25002 for VO substitution
    via by 501447,
  • db:: 3.55::FND_MESSAGE.PUT 1c
    via by Unknown author,
  • Tycast error in Extension
    via by 568541,
    • oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT * FROM (select invoice_number,supplier_number,supplier_site,invoice_amount,null invoice_date,null Source,'Invoices' record_location from audit_invoices where invoice_number like :1 and supplier_number = :2 union all select invoice_num,vendor_num,vendor_site_code,invoice_amount,invoice_date,null Source,'InvoiceIT' record_location from xxit3_invoices where invoice_num like :1 and vendor_num = :2 union all select ai.invoice_num,pv.segment1 sup_number,pvs.vendor_site_code,ai.invoice_amount,ai.invoice_date,ai.source,'Payables' record_location from ap_invoices_all ai,po_vendor_sites_all pvs,po_vendors pv where invoice_num like :1 and ai.vendor_id = pv.vendor_id and ai.vendor_site_id = pvs.vendor_site_id and pv.segment1 = :2) QRSLT WHERE (( UPPER(INVOICE_NUMBER) like :3 AND (INVOICE_NUMBER like :4 OR INVOICE_NUMBER like :5 OR INVOICE_NUMBER like :6 OR INVOICE_NUMBER like :7))) 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.processFormData(OAPageBean.java:2555) at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:1677) at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:509) at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:430)

    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