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 )

Oracle Community | User285476 | 4 years ago
  1. 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 )
  2. 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 )
  3. 0

    JBO-27022: Failed to load value at index 20 with java object of type java

    Oracle Community | 4 years ago | 761975
    oracle.apps.fnd.framework.OAException: oracle.jbo.AttributeLoadException: JBO-27022: Failed to load value at index 20 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

    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.
  6. 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.

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

      at oracle.apps.fnd.framework.OAException.wrapperException()
    2. oracle.apps.fnd
      OAViewObjectImpl.invokeMethod
      1. oracle.apps.fnd.framework.OAException.wrapperException(OAException.java:912)
      2. oracle.apps.fnd.framework.OAException.wrapperException(OAException.java:886)
      3. oracle.apps.fnd.framework.OAException.wrapperInvocationTargetException(OAException.java:1009)
      4. oracle.apps.fnd.framework.server.OAUtility.invokeMethod(OAUtility.java:211)
      5. oracle.apps.fnd.framework.server.OAUtility.invokeMethod(OAUtility.java:133)
      6. oracle.apps.fnd.framework.server.OAViewObjectImpl.invokeMethod(OAViewObjectImpl.java:1173)
      6 frames
    3. oracle.apps.ar
      QuickPaymentCO.processRequest
      1. oracle.apps.ar.irec.accountDetails.pay.webui.QuickPaymentCO.processRequest(QuickPaymentCO.java:51)
      1 frame
    4. oracle.apps.fnd
      OAWebBeanContainerHelper.processRequest
      1. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:600)
      2. oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(OAWebBeanContainerHelper.java:251)
      3. oracle.apps.fnd.framework.webui.beans.layout.OAHeaderBean.processRequest(OAHeaderBean.java:391)
      4. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:968)
      5. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:935)
      6. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:659)
      7. oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(OAWebBeanContainerHelper.java:251)
      8. oracle.apps.fnd.framework.webui.beans.layout.OAFlowLayoutBean.processRequest(OAFlowLayoutBean.java:351)
      9. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:968)
      10. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:935)
      11. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:659)
      12. oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(OAWebBeanContainerHelper.java:251)
      13. oracle.apps.fnd.framework.webui.beans.layout.OAFlowLayoutBean.processRequest(OAFlowLayoutBean.java:351)
      14. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:968)
      15. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:935)
      16. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:659)
      17. oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(OAWebBeanContainerHelper.java:251)
      17 frames
    5. com.evermind.server
      ResourceFilterChain.doFilter
      1. com.evermind.server.http.ResourceFilterChain.doFilter(ResourceFilterChain.java:64)
      1 frame
    6. oracle.apps.jtf
      ReleaseResFilter.doFilter
      1. oracle.apps.jtf.base.session.ReleaseResFilter.doFilter(ReleaseResFilter.java:26)
      1 frame
    7. com.evermind.server
      EvermindFilterChain.doFilter
      1. com.evermind.server.http.EvermindFilterChain.doFilter(EvermindFilterChain.java:15)
      1 frame
    8. oracle.apps.fnd
      AppsServletFilter.doFilter
      1. oracle.apps.fnd.security.AppsServletFilter.doFilter(AppsServletFilter.java:318)
      1 frame
    9. com.evermind.server
      AJPRequestHandler.run
      1. com.evermind.server.http.ServletRequestDispatcher.invoke(ServletRequestDispatcher.java:621)
      2. com.evermind.server.http.ServletRequestDispatcher.forwardInternal(ServletRequestDispatcher.java:370)
      3. com.evermind.server.http.HttpRequestHandler.doProcessRequest(HttpRequestHandler.java:871)
      4. com.evermind.server.http.HttpRequestHandler.processRequest(HttpRequestHandler.java:453)
      5. com.evermind.server.http.AJPRequestHandler.run(AJPRequestHandler.java:313)
      6. com.evermind.server.http.AJPRequestHandler.run(AJPRequestHandler.java:199)
      6 frames
    10. oracle.oc4j.network
      ServerSocketReadHandler$SafeRunnable.run
      1. oracle.oc4j.network.ServerSocketReadHandler$SafeRunnable.run(ServerSocketReadHandler.java:260)
      1 frame
    11. com.evermind.util
      ReleasableResourcePooledExecutor$MyWorker.run
      1. com.evermind.util.ReleasableResourcePooledExecutor$MyWorker.run(ReleasableResourcePooledExecutor.java:303)
      1 frame
    12. Java RT
      Thread.run
      1. java.lang.Thread.run(Thread.java:619)
      1 frame