oracle.apps.fnd.framework.OAException

There are no available Samebug tips for this exception. Do you have an idea how to solve this issue? A short tip would help users who saw this issue last week.

  • Issue with Extending EO based VO
    via by Veejay,
  • Extending View object on a Page
    via by 712742,
  • ERROR:java.lang.NullPointerException
    via by 814480,
  • VO extension error -
    via by 774584,
    • 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(OAException.java:896) at oracle.apps.fnd.framework.webui.OAPageErrorHandler.prepareException(OAPageErrorHandler.java:1169) at oracle.apps.fnd.framework.webui.OAPageBean.renderDocument(OAPageBean.java:3136) at oracle.apps.fnd.framework.webui.OAPageBean.renderDocument(OAPageBean.java:2931)

    Users with the same issue

    Unknown visitor1 times, last one,
    Unknown visitor1 times, last one,
    Unknown visitor1 times, last one,
    Unknown visitor1 times, last one,
    Unknown visitor1 times, last one,
    9 more bugmates