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