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

    db:: 3.55::FND_MESSAGE.PUT 1c

    hivmr.com | 8 months ago
    oracle.apps.fnd.framework.OAException: Application: FND, Message Name: FND-INVALID APPLICATION. Tokens: APPL = emp;

    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