oracle.apps.fnd.framework.OAException

oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT customer_id, currency_code, total_due_original, total_due_remaining, total_discount, total_service_charge, total_payment_amount, (total_due_remaining - total_discount - total_payment_amount) as total_balance_due, TO_CHAR(total_due_original , FND_CURRENCY_CACHE.GET_FORMAT_MASK( currency_code , 30 )) || ' ' || currency_code as total_due_original_formatted, TO_CHAR(total_due_remaining , FND_CURRENCY_CACHE.GET_FORMAT_MASK( currency_code , 30 )) || ' ' || currency_code as total_due_remaining_formatted, TO_CHAR(total_service_charge , FND_CURRENCY_CACHE.GET_FORMAT_MASK( currency_code , 30 )) || ' ' || currency_code as total_service_charge_formatted, TO_CHAR( -total_discount , FND_CURRENCY_CACHE.GET_FORMAT_MASK( currency_code , 30 )) || ' ' || currency_code as total_discount_formatted, TO_CHAR(total_payment_amount , FND_CURRENCY_CACHE.GET_FORMAT_MASK( currency_code , 30 )) as total_payment_amount_formatted, TO_CHAR( (total_due_remaining - total_discount - total_payment_amount) , FND_CURRENCY_CACHE.GET_FORMAT_MASK( currency_code , 30 )) || ' ' || currency_code as total_balance_due_formatted, TO_CHAR(TO_NUMBER(TO_CHAR(SYSDATE, 'MM'))) current_month, TO_CHAR(SYSDATE, 'YYYY') current_year, TO_CHAR( (total_service_charge + total_payment_amount) , FND_CURRENCY_CACHE.GET_FORMAT_MASK( currency_code , 30 )) || ' ' || currency_code as grand_payment_total_formatted, :1 as customer_site_use_id, total_number_of_installments, trunc(sysdate) as receipt_date, TO_CHAR( (dispute_amt), FND_CURRENCY_CACHE.GET_FORMAT_MASK( currency_code , 30 ))||' '||currency_code as dispute_amt FROM (SELECT customer_id, currency_code, sum(amount_due_original) total_due_original, sum(amount_due_remaining) total_due_remaining, sum(discount_amount) total_discount, sum(service_charge) total_service_charge, sum(payment_amt) total_payment_amount, sum(number_of_installments) total_number_of_installments, sum(dispute_amt) dispute_amt FROM ar_irec_payment_list_gt WHERE customer_id = :2 AND customer_site_use_id = nvl(:3, customer_site_use_id) GROUP BY customer_id, currency_code )

Samebug tips0

There are no available Samebug tips for this exception. If you know how to solve this issue, help other users by writing a short tip.

Don't give up yet. Paste your full stack trace to get a solution.

Solutions on the web1059

  • via Oracle Community by User517853-OC, 11 months ago
    oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT customer_id, currency_code, total_due_original, total_due_remaining, total_discount, total_service_charge, total_payment_amount, (total_due_remaining
  • via Oracle Community by User285476, 11 months ago
    , sum(payment_amt) total_payment_amount, sum(number_of_installments) total_number_of_installments, sum(-dispute_amt) dispute_amt FROM ar_irec_payment_list_gt WHERE customer_id = :2 AND customer_site_use_id = nvl(:3, customer_site_use_id) AND org_id=:4 GROUP BY customer_id, currency_code )
  • via Oracle Community by Myvizhi Selvi, 11 months ago
    oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT * FROM (select f.user_name , f.description , a.currency_code, a.amount_to , a.amount_from from seacds.ar_approval_user_limits_nv a , seacds.fnd_user_nv
  • Stack trace

    • oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT customer_id, currency_code, total_due_original, total_due_remaining, total_discount, total_service_charge, total_payment_amount, (total_due_remaining - total_discount - total_payment_amount) as total_balance_due, TO_CHAR(total_due_original , FND_CURRENCY_CACHE.GET_FORMAT_MASK( currency_code , 30 )) || ' ' || currency_code as total_due_original_formatted, TO_CHAR(total_due_remaining , FND_CURRENCY_CACHE.GET_FORMAT_MASK( currency_code , 30 )) || ' ' || currency_code as total_due_remaining_formatted, TO_CHAR(total_service_charge , FND_CURRENCY_CACHE.GET_FORMAT_MASK( currency_code , 30 )) || ' ' || currency_code as total_service_charge_formatted, TO_CHAR( -total_discount , FND_CURRENCY_CACHE.GET_FORMAT_MASK( currency_code , 30 )) || ' ' || currency_code as total_discount_formatted, TO_CHAR(total_payment_amount , FND_CURRENCY_CACHE.GET_FORMAT_MASK( currency_code , 30 )) as total_payment_amount_formatted, TO_CHAR( (total_due_remaining - total_discount - total_payment_amount) , FND_CURRENCY_CACHE.GET_FORMAT_MASK( currency_code , 30 )) || ' ' || currency_code as total_balance_due_formatted, TO_CHAR(TO_NUMBER(TO_CHAR(SYSDATE, 'MM'))) current_month, TO_CHAR(SYSDATE, 'YYYY') current_year, TO_CHAR( (total_service_charge + total_payment_amount) , FND_CURRENCY_CACHE.GET_FORMAT_MASK( currency_code , 30 )) || ' ' || currency_code as grand_payment_total_formatted, :1 as customer_site_use_id, total_number_of_installments, trunc(sysdate) as receipt_date, TO_CHAR( (dispute_amt), FND_CURRENCY_CACHE.GET_FORMAT_MASK( currency_code , 30 ))||' '||currency_code as dispute_amt FROM (SELECT customer_id, currency_code, sum(amount_due_original) total_due_original, sum(amount_due_remaining) total_due_remaining, sum(discount_amount) total_discount, sum(service_charge) total_service_charge, sum(payment_amt) total_payment_amount, sum(number_of_installments) total_number_of_installments, sum(dispute_amt) dispute_amt FROM ar_irec_payment_list_gt WHERE customer_id = :2 AND customer_site_use_id = nvl(:3, customer_site_use_id) GROUP BY customer_id, currency_code ) at oracle.apps.fnd.framework.OAException.wrapperException(OAException.java:888) at oracle.apps.fnd.framework.OAException.wrapperException(OAException.java:862) at oracle.apps.fnd.framework.OAException.wrapperInvocationTargetException(OAException.java:985) at oracle.apps.fnd.framework.server.OAUtility.invokeMethod(OAUtility.java:210) at oracle.apps.fnd.framework.server.OAUtility.invokeMethod(OAUtility.java:132) at oracle.apps.fnd.framework.server.OAViewObjectImpl.invokeMethod(OAViewObjectImpl.java:1123) at oracle.apps.ar.irec.accountDetails.pay.webui.QuickPaymentCO.processRequest(QuickPaymentCO.java:53) at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:581) at oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(OAWebBeanContainerHelper.java:247) at oracle.apps.fnd.framework.webui.beans.layout.OAHeaderBean.processRequest(OAHeaderBean.java:389) at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:932) at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:899) at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:640) at oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(OAWebBeanContainerHelper.java:247) at oracle.apps.fnd.framework.webui.beans.layout.OAFlowLayoutBean.processRequest(OAFlowLayoutBean.java:351) at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:932) at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:899) at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:640) at oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(OAWebBeanContainerHelper.java:247) at oracle.apps.fnd.framework.webui.beans.layout.OAFlowLayoutBean.processRequest(OAFlowLayoutBean.java:351) at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:932) at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:899) at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:640) at oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(OAWebBeanContainerHelper.java:247) at oracle.apps.fnd.framework.webui.beans.layout.OAStackLayoutBean.processRequest(OAStackLayoutBean.java:350) at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:932) at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:899) at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:640) at oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(OAWebBeanContainerHelper.java:247) at oracle.apps.fnd.framework.webui.OAPageLayoutHelper.processRequest(OAPageLayoutHelper.java:1095) at oracle.apps.fnd.framework.webui.beans.layout.OAPageLayoutBean.processRequest(OAPageLayoutBean.java:1569) at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:932) at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:899) at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:640) at oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(OAWebBeanContainerHelper.java:247) at oracle.apps.fnd.framework.webui.beans.form.OAFormBean.processRequest(OAFormBean.java:385) at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:932) at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:899) at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:640) at oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(OAWebBeanContainerHelper.java:247) at oracle.apps.fnd.framework.webui.beans.OABodyBean.processRequest(OABodyBean.java:353) at oracle.apps.fnd.framework.webui.OAPageBean.processRequest(OAPageBean.java:2298) at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:1711) at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:497) at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:418) at _OA._jspService(OA.jsp:40) at com.orionserver.http.OrionHttpJspPage.service(OrionHttpJspPage.java:56) at oracle.jsp.runtimev2.JspPageTable.service(JspPageTable.java:317) at oracle.jsp.runtimev2.JspServlet.internalService(JspServlet.java:465) at oracle.jsp.runtimev2.JspServlet.service(JspServlet.java:379) at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) at com.evermind.server.http.ServletRequestDispatcher.invoke(ServletRequestDispatcher.java:727) at com.evermind.server.http.ServletRequestDispatcher.forwardInternal(ServletRequestDispatcher.java:306) at com.evermind.server.http.HttpRequestHandler.processRequest(HttpRequestHandler.java:767) at com.evermind.server.http.HttpRequestHandler.run(HttpRequestHandler.java:259) at com.evermind.server.http.HttpRequestHandler.run(HttpRequestHandler.java:106) at EDU.oswego.cs.dl.util.concurrent.PooledExecutor$Worker.run(PooledExecutor.java:803) at java.lang.Thread.run(Thread.java:534)

    Write tip

    You have a different solution? A short tip here would help you and many other users who saw this issue last week.

    Users with the same issue

    Unknown user
    Once, 10 months ago
    Unknown user
    Once, 10 months ago
    Unknown user
    Once, 10 months ago
    Unknown user
    Once, 11 months ago
    Unknown user
    Once, 11 months ago
    9 more bugmates