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

    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 | 1 decade 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