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

    Create Grant causes JBO-25058 error in SOA Integration Repository

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