oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT * FROM (SELECT StructureEO.ID, StructureEO.NAME, StructureEO.PARENT_ID, StructureEO.PARENT_OBJ_TYPE, StructureEO.ARTICLE_ID, StructureEO.ARTICLE_VERSION_ID, StructureEO.DISPLAY_SEQ, StructureEO.LABEL, StructureEO.OBJ_TYPE, StructureEO.DOC_ID, StructureEO.DOC_TYPE, StructureEO.MANDATORY_YN, StructureEO.ALTERNATE_YN, StructureEO.STANDARD_YN, StructureEO.ARTICLE_FROM_EXPERT, StructureEO.OBJECT_VERSION_NUMBER, ' '||StructureEO.LABEL||' '||StructureEO.NAME DISPLAY, DECODE(StructureEO.OBJ_TYPE, 'ARTICLE', 'OkcTermsStructDtlsMandatoryEnabled', 'OkcTermsStructDtlsMandatoryDisabled') MANDATORY_CHECKBOX, DECODE(StructureEO.OBJ_TYPE, 'ARTICLE', DECODE(StructureEO.MANDATORY_YN, 'Y', 'OkcTermsStructDtlsMandatory', 'OkcTermsStructDtlsNotMandatory'), 'OkcTermsStructDtlsNotMandatory') MANDATORY_IMAGE, DECODE(StructureEO.ALTERNATE_YN, 'Y', 'OkcTermsStructDtlsAlternatesEnabled', 'N', 'OkcTermsStructDtlsAlternatesNotApplied', 'OkcTermsStructDtlsAlternatesNotApplied') ALTERNATES_IMAGE, okc_terms_util_grp.enable_update( StructureEO.OBJ_TYPE, StructureEO.DOC_TYPE, StructureEO.STANDARD_YN) UPDATE_IMAGE, okc_terms_util_grp.enable_delete( StructureEO.OBJ_TYPE, StructureEO.MANDATORY_YN, StructureEO.STANDARD_YN, StructureEO.DOC_TYPE) REMOVE_IMAGE, DECODE(StructureEO.STANDARD_YN, 'N', 'OkcTermsStructDtlsNonStandard', 'OkcTermsStructDtlsNotApplied') NON_STD_IMAGE, DECODE(StructureEO.ARTICLE_FROM_EXPERT, 'Y', 'OkcTermsStructDtlsFromExpert', 'OkcTermsStructDtlsNotFromExpert') EXPERT_IMAGE, DECODE(StructureEO.OBJ_TYPE, 'ARTICLE', 'tree_document.gif', 'SECTION', NULL, --'folder.gif' 'tree_contract.gif') TREE_ICON, NULL DETAILS_URL, XXLC_LOCK_TEXT(StructureEO.article_id,StructureEO.article_version_id) Unprotected FROM OKC_TERMS_STRUCTURE_V StructureEO WHERE StructureEO.DOC_ID = :1 AND StructureEO.DOC_TYPE = :2 AND ((StructureEO.OBJ_TYPE = 'ARTICLE' AND StructureEO.ARTICLE_VERSION_ID IS NOT NULL) OR (StructureEO.OBJ_TYPE <> 'ARTICLE'))) QRSLT WHERE (:3 = PARENT_ID) AND (:4 = PARENT_OBJ_TYPE) ORDER BY DISPLAY_SEQ

Oracle Community | Veejay | 4 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

    Issue with Extending EO based VO

    Oracle Community | 4 years ago | Veejay
    oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT * FROM (SELECT StructureEO.ID, StructureEO.NAME, StructureEO.PARENT_ID, StructureEO.PARENT_OBJ_TYPE, StructureEO.ARTICLE_ID, StructureEO.ARTICLE_VERSION_ID, StructureEO.DISPLAY_SEQ, StructureEO.LABEL, StructureEO.OBJ_TYPE, StructureEO.DOC_ID, StructureEO.DOC_TYPE, StructureEO.MANDATORY_YN, StructureEO.ALTERNATE_YN, StructureEO.STANDARD_YN, StructureEO.ARTICLE_FROM_EXPERT, StructureEO.OBJECT_VERSION_NUMBER, ' '||StructureEO.LABEL||' '||StructureEO.NAME DISPLAY, DECODE(StructureEO.OBJ_TYPE, 'ARTICLE', 'OkcTermsStructDtlsMandatoryEnabled', 'OkcTermsStructDtlsMandatoryDisabled') MANDATORY_CHECKBOX, DECODE(StructureEO.OBJ_TYPE, 'ARTICLE', DECODE(StructureEO.MANDATORY_YN, 'Y', 'OkcTermsStructDtlsMandatory', 'OkcTermsStructDtlsNotMandatory'), 'OkcTermsStructDtlsNotMandatory') MANDATORY_IMAGE, DECODE(StructureEO.ALTERNATE_YN, 'Y', 'OkcTermsStructDtlsAlternatesEnabled', 'N', 'OkcTermsStructDtlsAlternatesNotApplied', 'OkcTermsStructDtlsAlternatesNotApplied') ALTERNATES_IMAGE, okc_terms_util_grp.enable_update( StructureEO.OBJ_TYPE, StructureEO.DOC_TYPE, StructureEO.STANDARD_YN) UPDATE_IMAGE, okc_terms_util_grp.enable_delete( StructureEO.OBJ_TYPE, StructureEO.MANDATORY_YN, StructureEO.STANDARD_YN, StructureEO.DOC_TYPE) REMOVE_IMAGE, DECODE(StructureEO.STANDARD_YN, 'N', 'OkcTermsStructDtlsNonStandard', 'OkcTermsStructDtlsNotApplied') NON_STD_IMAGE, DECODE(StructureEO.ARTICLE_FROM_EXPERT, 'Y', 'OkcTermsStructDtlsFromExpert', 'OkcTermsStructDtlsNotFromExpert') EXPERT_IMAGE, DECODE(StructureEO.OBJ_TYPE, 'ARTICLE', 'tree_document.gif', 'SECTION', NULL, --'folder.gif' 'tree_contract.gif') TREE_ICON, NULL DETAILS_URL, XXLC_LOCK_TEXT(StructureEO.article_id,StructureEO.article_version_id) Unprotected FROM OKC_TERMS_STRUCTURE_V StructureEO WHERE StructureEO.DOC_ID = :1 AND StructureEO.DOC_TYPE = :2 AND ((StructureEO.OBJ_TYPE = 'ARTICLE' AND StructureEO.ARTICLE_VERSION_ID IS NOT NULL) OR (StructureEO.OBJ_TYPE <> 'ARTICLE'))) QRSLT WHERE (:3 = PARENT_ID) AND (:4 = PARENT_OBJ_TYPE) ORDER BY DISPLAY_SEQ
  2. 0

    issue addding custom fields(from custom table)

    Oracle Community | 7 years ago | 712742
    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) AND SECURITY_GROUP_ID = 0
  3. 0

    Create Grant causes JBO-25058 error in SOA Integration Repository

    Oracle Community | 7 years ago | 792108
    oracle.apps.fnd.framework.OAException: oracle.jbo.NoDefException: JBO-25058: Definition isOverloaded of type Attribute not found in AdminMethodsVO
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Extending View object on a Page

    Oracle Community | 7 years ago | 712742
    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) AND SECURITY_GROUP_ID = 0
  6. 0

    Error Occured While Creating Grant From SOA Integration Repository

    Oracle Community | 7 years ago | 792108
    oracle.apps.fnd.framework.OAException: oracle.jbo.NoDefException: JBO-25058: Definition isOverloaded of type Attribute not found in AdminMethodsVO

    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 * FROM (SELECT StructureEO.ID, StructureEO.NAME, StructureEO.PARENT_ID, StructureEO.PARENT_OBJ_TYPE, StructureEO.ARTICLE_ID, StructureEO.ARTICLE_VERSION_ID, StructureEO.DISPLAY_SEQ, StructureEO.LABEL, StructureEO.OBJ_TYPE, StructureEO.DOC_ID, StructureEO.DOC_TYPE, StructureEO.MANDATORY_YN, StructureEO.ALTERNATE_YN, StructureEO.STANDARD_YN, StructureEO.ARTICLE_FROM_EXPERT, StructureEO.OBJECT_VERSION_NUMBER, ' '||StructureEO.LABEL||' '||StructureEO.NAME DISPLAY, DECODE(StructureEO.OBJ_TYPE, 'ARTICLE', 'OkcTermsStructDtlsMandatoryEnabled', 'OkcTermsStructDtlsMandatoryDisabled') MANDATORY_CHECKBOX, DECODE(StructureEO.OBJ_TYPE, 'ARTICLE', DECODE(StructureEO.MANDATORY_YN, 'Y', 'OkcTermsStructDtlsMandatory', 'OkcTermsStructDtlsNotMandatory'), 'OkcTermsStructDtlsNotMandatory') MANDATORY_IMAGE, DECODE(StructureEO.ALTERNATE_YN, 'Y', 'OkcTermsStructDtlsAlternatesEnabled', 'N', 'OkcTermsStructDtlsAlternatesNotApplied', 'OkcTermsStructDtlsAlternatesNotApplied') ALTERNATES_IMAGE, okc_terms_util_grp.enable_update( StructureEO.OBJ_TYPE, StructureEO.DOC_TYPE, StructureEO.STANDARD_YN) UPDATE_IMAGE, okc_terms_util_grp.enable_delete( StructureEO.OBJ_TYPE, StructureEO.MANDATORY_YN, StructureEO.STANDARD_YN, StructureEO.DOC_TYPE) REMOVE_IMAGE, DECODE(StructureEO.STANDARD_YN, 'N', 'OkcTermsStructDtlsNonStandard', 'OkcTermsStructDtlsNotApplied') NON_STD_IMAGE, DECODE(StructureEO.ARTICLE_FROM_EXPERT, 'Y', 'OkcTermsStructDtlsFromExpert', 'OkcTermsStructDtlsNotFromExpert') EXPERT_IMAGE, DECODE(StructureEO.OBJ_TYPE, 'ARTICLE', 'tree_document.gif', 'SECTION', NULL, --'folder.gif' 'tree_contract.gif') TREE_ICON, NULL DETAILS_URL, XXLC_LOCK_TEXT(StructureEO.article_id,StructureEO.article_version_id) Unprotected FROM OKC_TERMS_STRUCTURE_V StructureEO WHERE StructureEO.DOC_ID = :1 AND StructureEO.DOC_TYPE = :2 AND ((StructureEO.OBJ_TYPE = 'ARTICLE' AND StructureEO.ARTICLE_VERSION_ID IS NOT NULL) OR (StructureEO.OBJ_TYPE <> 'ARTICLE'))) QRSLT WHERE (:3 = PARENT_ID) AND (:4 = PARENT_OBJ_TYPE) ORDER BY DISPLAY_SEQ

      at oracle.apps.fnd.framework.OAException.wrapperException()
    2. oracle.apps.fnd
      OAPageBean.renderDocument
      1. oracle.apps.fnd.framework.OAException.wrapperException(OAException.java:896)
      2. oracle.apps.fnd.framework.webui.OAPageErrorHandler.prepareException(OAPageErrorHandler.java:1169)
      3. oracle.apps.fnd.framework.webui.OAPageBean.renderDocument(OAPageBean.java:3136)
      4. oracle.apps.fnd.framework.webui.OAPageBean.renderDocument(OAPageBean.java:2931)
      4 frames