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

Oracle Community | 818606 | 6 years ago
tip
Your exception is missing from the Samebug knowledge base.
Here are the best solutions we found on the Internet.
Click on the to mark the helpful solution and get rewards for you help.
  1. 0

    java.sql.SQLException: ORA-01008: not all variables bound

    Oracle Community | 6 years ago | 818606
    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)))
  2. 0

    Job Lov Extension ORA-01006: bind variable does not exist

    Oracle Community | 7 years ago | Rakesh S
    oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT * FROM (SELECT pj.job_id, pj.name job, pj.business_group_id, pj.date_from, pj.date_to, hlc.meaning flsa_status, pj.attribute3 xxatc_job_dff FROM per_jobs_v pj, hr_leg_lookups hlc WHERE hlc.lookup_code(+)= pj.job_information3 and hlc.lookup_type(+)='US_EXEMPT_NON_EXEMPT') QRSLT WHERE (JOB like :1 AND ( UPPER(JOB) like :4 AND (JOB like :5 OR JOB like :6 OR JOB like :7 OR JOB like :8))) ORDER BY job
  3. 0

    Tab vs Mouse Click

    Oracle Community | 7 years ago | 480597
    oracle.apps.fnd.framework.OAException: oracle.jbo.NameClashException: JBO-25001: Name LOV_oracle_apps_pqh_selfservice_events_server_EventsBookAM of object type ApplicationModule already exists
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Fnd Load Issue

    wpthm.com | 1 year ago
    oracle.apps.fnd.framework.OAException: Application: FND, Message Name: FND-INVALID APPLICATION. Tokens: APPL = emp;
  6. 0

    SEPL and VO Extension

    Oracle Community | 9 years ago | 567494
    oracle.apps.fnd.framework.OAException: Message not found. Application: FND, Message Name: FND_VIEWOBJECT_NOT_FOUND. Tokens: VONAME = xxEYReqSummaryVO; APPLICATION_MODULE = oracle.apps.icx.por.req.server.RequisitionAM;

    11 unregistered visitors
    Not finding the right solution?
    Take a tour to get the most out of Samebug.

    Tired of useless tips?

    Automated exception search integrated into your IDE

    Root Cause Analysis

    1. 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()
    2. oracle.apps.fnd
      OAPageBean.preparePage
      1. oracle.apps.fnd.framework.OAException.wrapperException(OAException.java:891)
      2. oracle.apps.fnd.framework.webui.OAPageErrorHandler.prepareException(OAPageErrorHandler.java:1145)
      3. oracle.apps.fnd.framework.webui.OAPageErrorHandler.processErrors(OAPageErrorHandler.java:1408)
      4. oracle.apps.fnd.framework.webui.OAPageBean.processFormData(OAPageBean.java:2555)
      5. oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:1677)
      6. oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:509)
      7. oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:430)
      7 frames