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.

  • PAConrollerImpl not found
    via by 818948,
  • Purchase order Notification Error
    via by Muthu,
  • Fnd Load Issue
    via by Unknown author,
  • SEPL and VO Extension
    via by 567494,
  • Hide/Show within a table
    via by 489141,
  • Getting JBO-25002 for VO substitution
    via by 501447,
    • oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT PCE.COMPETENCE_ELEMENT_ID, PCE.BUSINESS_GROUP_ID, PCE.COMPETENCE_ID, PCE.PROFICIENCY_LEVEL_ID, PCE.HIGH_PROFICIENCY_LEVEL_ID, PCE.WEIGHTING_LEVEL_ID, PCE.RATING_LEVEL_ID, PCE.PERSON_ID, PCE.ENTERPRISE_ID, PCE.JOB_ID, PCE.VALID_GRADE_ID, PCE.POSITION_ID, PCE.ORGANIZATION_ID, PCE.ASSESSMENT_ID, PCE.ASSESSMENT_TYPE_ID, PCE.COMMENTS, PCE.EFFECTIVE_DATE_FROM, PCE.EFFECTIVE_DATE_TO, PCE.LINE_SCORE, PCE.ATTRIBUTE_CATEGORY, PCE.ATTRIBUTE1, PCE.ATTRIBUTE2, PCE.ATTRIBUTE3, PCE.ATTRIBUTE4, PCE.ATTRIBUTE5, PCE.ATTRIBUTE6, PCE.ATTRIBUTE7, PCE.ATTRIBUTE8, PCE.ATTRIBUTE9, PCE.ATTRIBUTE10, PCE.ATTRIBUTE11, PCE.ATTRIBUTE12, PCE.ATTRIBUTE13, PCE.ATTRIBUTE14, PCE.ATTRIBUTE15, PCE.ATTRIBUTE16, PCE.ATTRIBUTE17, PCE.ATTRIBUTE18, PCE.ATTRIBUTE19, PCE.ATTRIBUTE20, PC.NAME, PC.COMPETENCE_ID AS COMPETENCE_ID1, PC.RATING_SCALE_ID, PC.COMPETENCE_ALIAS, DECODE(PCE3.TYPE,'ASSESSMENT','DisableCompDelete','ASSESSMENT_COMPETENCE','DisableCompDelete', nvl(( select distinct 'DisableCompDelete' from per_competence_elements where parent_competence_element_id = pce.competence_element_id),'EnableCompDelete')) AS DELETE_COMP, PCE.PARENT_COMPETENCE_ELEMENT_ID, PRL1.NAME AS PROF_LEVEL, PRL1.RATING_LEVEL_ID AS RATING_LEVEL_ID1, PRL2.NAME AS PERF_LEVEL, PRL2.RATING_LEVEL_ID AS RATING_LEVEL_ID2, PRL3.NAME AS WEIGH_LEVEL, PRL3.RATING_LEVEL_ID AS RATING_LEVEL_ID3, PCE.OBJECT_ID, PCE.OBJECT_NAME, PCE1.COMPETENCE_ELEMENT_ID AS REF1_COMP_ELEMENT_ID, PCE1.PROFICIENCY_LEVEL_ID AS REF1_PROF_LEVEL_ID, PCE1.WEIGHTING_LEVEL_ID AS REF1_WEIGH_LEVEL_ID, PCE1.RATING_LEVEL_ID AS REF1_PERF_LEVEL_ID, PCE1.COMMENTS AS REF1_COMMENTS, PCE1.ATTRIBUTE_CATEGORY AS REF1_ATTRIBUTE_CATEGORY, PCE1.ATTRIBUTE1 AS REF1_ATTRIBUTE1, PCE1.ATTRIBUTE2 AS REF1_ATTRIBUTE2, PCE1.ATTRIBUTE3 AS REF1_ATTRIBUTE3, PCE1.ATTRIBUTE4 AS REF1_ATTRIBUTE4, PCE1.ATTRIBUTE5 AS REF1_ATTRIBUTE5, PCE1.ATTRIBUTE6 AS REF1_ATTRIBUTE6, PCE1.ATTRIBUTE7 AS REF1_ATTRIBUTE7, PCE1.ATTRIBUTE8 AS REF1_ATTRIBUTE8, PCE1.ATTRIBUTE9 AS REF1_ATTRIBUTE9, PCE1.ATTRIBUTE10 AS REF1_ATTRIBUTE10, PCE1.ATTRIBUTE11 AS REF1_ATTRIBUTE11, PCE1.ATTRIBUTE12 AS REF1_ATTRIBUTE12, PCE1.ATTRIBUTE13 AS REF1_ATTRIBUTE13, PCE1.ATTRIBUTE14 AS REF1_ATTRIBUTE14, PCE1.ATTRIBUTE15 AS REF1_ATTRIBUTE15, PCE1.ATTRIBUTE16 AS REF1_ATTRIBUTE16, PCE1.ATTRIBUTE17 AS REF1_ATTRIBUTE17, PCE1.ATTRIBUTE18 AS REF1_ATTRIBUTE18, PCE1.ATTRIBUTE19 AS REF1_ATTRIBUTE19, PCE1.ATTRIBUTE20 AS REF1_ATTRIBUTE20, PCE2.COMPETENCE_ELEMENT_ID AS REF2_COMP_ELEMENT_ID, PCE2.PROFICIENCY_LEVEL_ID AS REF2_PROF_LEVEL_ID, PCE2.WEIGHTING_LEVEL_ID AS REF2_WEIGH_LEVEL_ID, PCE2.RATING_LEVEL_ID AS REF2_PERF_LEVEL_ID, PCE2.COMMENTS AS REF2_COMMENTS, PCE2.ATTRIBUTE_CATEGORY AS REF2_ATTRIBUTE_CATEGORY, PCE2.ATTRIBUTE1 AS REF2_ATTRIBUTE1, PCE2.ATTRIBUTE2 AS REF2_ATTRIBUTE2, PCE2.ATTRIBUTE3 AS REF2_ATTRIBUTE3, PCE2.ATTRIBUTE4 AS REF2_ATTRIBUTE4, PCE2.ATTRIBUTE5 AS REF2_ATTRIBUTE5, PCE2.ATTRIBUTE6 AS REF2_ATTRIBUTE6, PCE2.ATTRIBUTE7 AS REF2_ATTRIBUTE7, PCE2.ATTRIBUTE8 AS REF2_ATTRIBUTE8, PCE2.ATTRIBUTE9 AS REF2_ATTRIBUTE9, PCE2.ATTRIBUTE10 AS REF2_ATTRIBUTE10, PCE2.ATTRIBUTE11 AS REF2_ATTRIBUTE11, PCE2.ATTRIBUTE12 AS REF2_ATTRIBUTE12, PCE2.ATTRIBUTE13 AS REF2_ATTRIBUTE13, PCE2.ATTRIBUTE14 AS REF2_ATTRIBUTE14, PCE2.ATTRIBUTE15 AS REF2_ATTRIBUTE15, PCE2.ATTRIBUTE16 AS REF2_ATTRIBUTE16, PCE2.ATTRIBUTE17 AS REF2_ATTRIBUTE17, PCE2.ATTRIBUTE18 AS REF2_ATTRIBUTE18, PCE2.ATTRIBUTE19 AS REF2_ATTRIBUTE19, PCE2.ATTRIBUTE20 AS REF2_ATTRIBUTE20, PCE3.COMPETENCE_ELEMENT_ID AS PAR_COMP_ELEMENT_ID, PCE1.TYPE AS TYPE1, PCE2.TYPE AS TYPE2, PCE3.TYPE AS TYPE3, PCE.TYPE FROM PER_COMPETENCE_ELEMENTS PCE, PER_COMPETENCES_VL PC, PER_RATING_LEVELS_VL PRL1, PER_RATING_LEVELS_VL PRL2, PER_RATING_LEVELS_VL PRL3, PER_COMPETENCE_ELEMENTS PCE1, PER_COMPETENCE_ELEMENTS PCE2, PER_COMPETENCE_ELEMENTS PCE3 WHERE PCE.COMPETENCE_ID = PC.COMPETENCE_ID AND PCE.PROFICIENCY_LEVEL_ID = PRL1.RATING_LEVEL_ID(+) AND PCE.RATING_LEVEL_ID = PRL2.RATING_LEVEL_ID(+) AND PCE.WEIGHTING_LEVEL_ID = PRL3.RATING_LEVEL_ID(+) AND PCE.COMPETENCE_ID = PCE1.COMPETENCE_ID (+) AND PCE1.OBJECT_ID(+) = :1 AND PCE.ASSESSMENT_ID = PCE1.ASSESSMENT_ID(+) AND PCE1.OBJECT_NAME(+) = :2 AND PCE.COMPETENCE_ID = PCE2.COMPETENCE_ID (+) AND PCE2.OBJECT_ID(+) = :3 AND PCE.ASSESSMENT_ID = PCE2.ASSESSMENT_ID(+) AND PCE2.OBJECT_NAME(+) = :4 AND PCE.PARENT_COMPETENCE_ELEMENT_ID = PCE3.COMPETENCE_ELEMENT_ID(+) AND (NAME LIKE :8) ORDER BY PC.NAME at oracle.apps.fnd.framework.OAException.wrapperException(OAException.java:912) at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:616) at oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(OAWebBeanContainerHelper.java:252) at oracle.apps.fnd.framework.webui.beans.layout.OAHeaderBean.processRequest(OAHeaderBean.java:391) at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:968) at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:935) at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:659) at oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(OAWebBeanContainerHelper.java:252) at oracle.apps.fnd.framework.webui.beans.layout.OAStackLayoutBean.processRequest(OAStackLayoutBean.java:350) at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:968) at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:935) at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:659) at oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(OAWebBeanContainerHelper.java:252) at oracle.apps.fnd.framework.webui.OAPageLayoutHelper.processRequest(OAPageLayoutHelper.java:1182) at oracle.apps.fnd.framework.webui.beans.layout.OAPageLayoutBean.processRequest(OAPageLayoutBean.java:1569) at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:968) at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:935) at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:659) at oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(OAWebBeanContainerHelper.java:252) at oracle.apps.fnd.framework.webui.beans.form.OAFormBean.processRequest(OAFormBean.java:385) at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:968) at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:935) at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:659) at oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(OAWebBeanContainerHelper.java:252) at oracle.apps.fnd.framework.webui.beans.OABodyBean.processRequest(OABodyBean.java:353) at oracle.apps.fnd.framework.webui.OAPageBean.processRequest(OAPageBean.java:2607) at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:1940) at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:543) at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:431)

    Users with the same issue

    Unknown visitor
    Unknown visitor1 times, last one,
    Unknown visitor
    Unknown visitor1 times, last one,
    Unknown visitor
    Unknown visitor1 times, last one,
    Unknown visitor
    Unknown visitor1 times, last one,
    Unknown visitor
    Unknown visitor1 times, last one,
    14 more bugmates