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 )

Oracle Community | User517853-OC | 3 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

    Error when i try to run ARI_INVOICE_PAYMENT_PAGE.xml on local jdeveloper

    Oracle Community | 3 years ago | User517853-OC
    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 )
  2. 0

    Help deleting VO substitution

    Oracle Community | 5 years ago | User285476
    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_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, to_number(: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) AND org_id=:4 GROUP BY customer_id, currency_code )
  3. 0

    Extended VO errors after upgrading to 12.1.3

    Oracle Community | 4 years ago | elcaro
    oracle.apps.fnd.framework.OAException: oracle.jbo.AttributeLoadException: JBO-27022: Failed to load value at index 23 with java object of type java.lang.String due to java.sql.SQLException.
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    EO Substitution

    Oracle Community | 1 decade ago | 542163
    oracle.apps.fnd.framework.OAException: oracle.jbo.PersistenceException: JBO-26038: Cannot find an entity usage for entity Perc2382PerQualificationsEOEx in view link definition IrcCandidateEduQualVL, view link end IrcCandidateEduQualVO.
  6. 0

    variable not in select list -- Error in Custom VO

    Oracle Community | 9 years ago | 636095
    oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT * FROM (select PO_HEADER_ID, PO_LINE_ID, LINE_NUM, ATTRIBUTE1, ATTRIBUTE_CATEGORY from po_lines_all) QRSLT WHERE (PO_HEADER_ID = :1) ORDER BY LINE_NUM

    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 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()
    2. oracle.apps.fnd
      OAViewObjectImpl.invokeMethod
      1. oracle.apps.fnd.framework.OAException.wrapperException(OAException.java:888)
      2. oracle.apps.fnd.framework.OAException.wrapperException(OAException.java:862)
      3. oracle.apps.fnd.framework.OAException.wrapperInvocationTargetException(OAException.java:985)
      4. oracle.apps.fnd.framework.server.OAUtility.invokeMethod(OAUtility.java:210)
      5. oracle.apps.fnd.framework.server.OAUtility.invokeMethod(OAUtility.java:132)
      6. oracle.apps.fnd.framework.server.OAViewObjectImpl.invokeMethod(OAViewObjectImpl.java:1123)
      6 frames
    3. oracle.apps.ar
      QuickPaymentCO.processRequest
      1. oracle.apps.ar.irec.accountDetails.pay.webui.QuickPaymentCO.processRequest(QuickPaymentCO.java:53)
      1 frame
    4. oracle.apps.fnd
      OAPageBean.preparePage
      1. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:581)
      2. oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(OAWebBeanContainerHelper.java:247)
      3. oracle.apps.fnd.framework.webui.beans.layout.OAHeaderBean.processRequest(OAHeaderBean.java:389)
      4. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:932)
      5. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:899)
      6. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:640)
      7. oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(OAWebBeanContainerHelper.java:247)
      8. oracle.apps.fnd.framework.webui.beans.layout.OAFlowLayoutBean.processRequest(OAFlowLayoutBean.java:351)
      9. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:932)
      10. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:899)
      11. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:640)
      12. oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(OAWebBeanContainerHelper.java:247)
      13. oracle.apps.fnd.framework.webui.beans.layout.OAFlowLayoutBean.processRequest(OAFlowLayoutBean.java:351)
      14. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:932)
      15. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:899)
      16. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:640)
      17. oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(OAWebBeanContainerHelper.java:247)
      18. oracle.apps.fnd.framework.webui.beans.layout.OAStackLayoutBean.processRequest(OAStackLayoutBean.java:350)
      19. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:932)
      20. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:899)
      21. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:640)
      22. oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(OAWebBeanContainerHelper.java:247)
      23. oracle.apps.fnd.framework.webui.OAPageLayoutHelper.processRequest(OAPageLayoutHelper.java:1095)
      24. oracle.apps.fnd.framework.webui.beans.layout.OAPageLayoutBean.processRequest(OAPageLayoutBean.java:1569)
      25. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:932)
      26. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:899)
      27. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:640)
      28. oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(OAWebBeanContainerHelper.java:247)
      29. oracle.apps.fnd.framework.webui.beans.form.OAFormBean.processRequest(OAFormBean.java:385)
      30. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:932)
      31. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:899)
      32. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:640)
      33. oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(OAWebBeanContainerHelper.java:247)
      34. oracle.apps.fnd.framework.webui.beans.OABodyBean.processRequest(OABodyBean.java:353)
      35. oracle.apps.fnd.framework.webui.OAPageBean.processRequest(OAPageBean.java:2298)
      36. oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:1711)
      37. oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:497)
      38. oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:418)
      38 frames
    5. Unknown
      _OA._jspService
      1. _OA._jspService(OA.jsp:40)
      1 frame
    6. com.orionserver.http
      OrionHttpJspPage.service
      1. com.orionserver.http.OrionHttpJspPage.service(OrionHttpJspPage.java:56)
      1 frame
    7. oracle.jsp.runtimev2
      JspServlet.service
      1. oracle.jsp.runtimev2.JspPageTable.service(JspPageTable.java:317)
      2. oracle.jsp.runtimev2.JspServlet.internalService(JspServlet.java:465)
      3. oracle.jsp.runtimev2.JspServlet.service(JspServlet.java:379)
      3 frames
    8. JavaServlet
      HttpServlet.service
      1. javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
      1 frame
    9. com.evermind.server
      HttpRequestHandler.run
      1. com.evermind.server.http.ServletRequestDispatcher.invoke(ServletRequestDispatcher.java:727)
      2. com.evermind.server.http.ServletRequestDispatcher.forwardInternal(ServletRequestDispatcher.java:306)
      3. com.evermind.server.http.HttpRequestHandler.processRequest(HttpRequestHandler.java:767)
      4. com.evermind.server.http.HttpRequestHandler.run(HttpRequestHandler.java:259)
      5. com.evermind.server.http.HttpRequestHandler.run(HttpRequestHandler.java:106)
      5 frames
    10. Dough Lea's util.concurrent package
      PooledExecutor$Worker.run
      1. EDU.oswego.cs.dl.util.concurrent.PooledExecutor$Worker.run(PooledExecutor.java:803)
      1 frame
    11. Java RT
      Thread.run
      1. java.lang.Thread.run(Thread.java:534)
      1 frame