oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: select distinct cont_cd account, cont_cd||' - '||customer acct_desc from spldat.spl_account_map where cont_cd not in (select acct_number from spldat.spl_disposition_accts where disp_code = :1) order by 1

Oracle Community | sreese | 6 years ago
  1. 0

    Adding "where" clause to VO

    Oracle Community | 6 years ago | sreese
    oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: select distinct cont_cd account, cont_cd||' - '||customer acct_desc from spldat.spl_account_map where cont_cd not in (select acct_number from spldat.spl_disposition_accts where disp_code = :1) order by 1
  2. 0

    Urgent!! Help Required.

    Oracle Community | 1 decade ago | user520892
    oracle.apps.fnd.framework.OAException: oracle.jbo.domain.GenericDomainException: JBO-25028: Number.bigDecimalValue Creation Error :java.lang.ArrayIndexOutOfBoundsException: 0
  3. 0

    Error on extending view object

    Oracle Community | 10 years ago | 492297
    oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT LOOKUP_CODE, MEANING FROM FND_LOOKUP_VALUES WHERE LOOKUP_TYPE = :1 AND VIEW_APPLICATION_ID = :2 AND LANGUAGE = USERENV('LANG') AND ENABLED_FLAG = 'Y' AND SYSDATE BETWEEN NVL(START_DATE_ACTIVE, SYSDATE - 1) AND NVL(END_DATE_ACTIVE, SYSDATE + 1)
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    JBO-27019: Get method for attribute "Meaning" in x could not be resolved

    Oracle Community | 10 years ago | 521069
    oracle.apps.fnd.framework.OAException: oracle.jbo.AttrValException: JBO-27019: Get method for attribute "Meaning" in UpsExRcvHomeSearchAttributesVO_11 could not be resolved.
  6. 0

    servletInclude

    Oracle Community | 10 years ago | 53047
    oracle.apps.fnd.framework.OAException: java.lang.NullPointerException

    1 unregistered visitors
    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 distinct cont_cd account, cont_cd||' - '||customer acct_desc from spldat.spl_account_map where cont_cd not in (select acct_number from spldat.spl_disposition_accts where disp_code = :1) order by 1

      at oracle.apps.fnd.framework.OAException.wrapperException()
    2. oracle.apps.fnd
      OAPageBean.renderDocument
      1. oracle.apps.fnd.framework.OAException.wrapperException(OAException.java:891)
      2. oracle.apps.fnd.framework.webui.OAPageErrorHandler.prepareException(OAPageErrorHandler.java:1145)
      3. oracle.apps.fnd.framework.webui.OAPageBean.renderDocument(OAPageBean.java:2928)
      4. oracle.apps.fnd.framework.webui.OAPageBean.renderDocument(OAPageBean.java:2725)
      4 frames