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

Searched on Google with the first line of a JAVA stack trace?

We can recommend more relevant solutions and speed up debugging when you paste your entire stack trace with the exception message. Try a sample exception.

Recommended solutions based on your search

Solutions on the web

via Oracle Community by 818606, 1 year ago
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
via Oracle Community by 648384, 1 year ago
') = 'N' AND nvl(PoVendorSitesAll.ORG_ID, :1) = :2 AND SYSDATE <= NVL(PoVendorSitesAll.INACTIVE_DATE, SYSDATE ) AND UPPER(PoVendorSitesAll.SUPPLIER_NOTIF_METHOD) <> 'EMAIL') QRSLT WHERE (( UPPER(SUPPLIER_NAME) like :3 AND (SUPPLIER_NAME like :4 OR SUPPLIER_NAME like :5 OR SUPPLIER_NAME like :6 OR SUPPLIER_NAME like :7)))
via Oracle Community by 552232, 1 year ago
oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT * FROM (select Order_Number,Header_Id,sold_to_org_id CustomerId from oe_order_headers_all oeoh,Ra_Customers rca where oeoh.sold_to_org_id = rca.customer_id and oeoh.flow_status_code not in ('CANCELLED','CLOSED')) QRSLT WHERE (( ORDER_NUMBER like :1 AND SOLD_TO_ORG_ID = :2 ))
via Oracle Community by 567894, 1 year ago
oracle.jbo.NoDefException: JBO-25002: Definition Check1 of type Attribute not found
via Oracle Community by 583651, 1 year ago
oracle.jbo.InvalidDefNameException: JBO-25004: Definition name for type Entity Definition is invalid
via Oracle Community by user576143, 1 year ago
oracle.jbo.NameClashException: JBO-25001: Name LOV_oracle_apps_fnd_wf_worklist_server_LovReassignToAM of object type ApplicationModule already exists
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

Samebug visitor profile picture
Unknown user
Once, 1 year ago
Samebug visitor profile picture
Unknown user
Once, 1 year ago
Samebug visitor profile picture
Unknown user
Once, 1 year ago
Samebug visitor profile picture
Unknown user
Once, 1 year ago
Samebug visitor profile picture
Unknown user
Once, 1 year ago
14 more bugmates

Know the solutions? Share your knowledge to help other developers to debug faster.