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

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

Samebug tips

Do you know how to solve this issue? Write a tip to help other users and build your expert profile.

Solutions on the web

via Oracle Community by 862079, 1 year ago
,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')
via Oracle Community by 862079, 1 year ago
,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 (( UPPER(PaymentAmountFrom) like :1 AND
via Oracle Community by 862079, 1 year ago
,op.currency ,op.payment_method ,opi.invoice_amount ,opi.invoice_payment_status ,op.vendor_name ,op.vendor_site_code from ofsap_paid_invoices opi join ofsap_payments op on opi.INVOICE_PAYMENT_ID=op.PAYMENT_ID) QRSLT WHERE (( UPPER(VIEW_ATTR) like :1 AND
via Oracle Community by 574833, 1 year ago
oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: select null node_id ,null version_id ,null status_name ,rs.SALESREP_ID ,rse.source_name ,rse.source_email SRP_EMAIL_ID ,rse.source_number SRP_EMPLOYEE_NUMBER
via Oracle Community by 667099, 1 year ago
oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT * FROM (select msi.secondary_inventory_name as SubInventoryName, msi.description as Description, msi.locator_type, msi.organization_id
via Oracle Community by Asmirnov-Oracle, 1 year ago
oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT * FROM (SELECT FTHeaderEO.HEADER_ID, FTHeaderEO.SUPPLIER, ………………………………… and NVL(op.operation_seq_num,'-99') = NVL(FTHeaderEO.operation_seq_num,'-99
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

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

Write tip

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