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 :5) ORDER BY PC.NAME

Samebug tips0

There are no available Samebug tips for this exception. If you know how to solve this issue, help other users by writing a short tip.

Don't give up yet. Paste your full stack trace to get a solution.

Solutions on the web1603

  • via Oracle Community by 949902, 11 months ago
    , 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
  • 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
  • via Oracle Community by 580701, 1 year ago
    oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT Xxg2cRateDimensionEO.ORG_ID AS "OrgId", Xxg2cRateDimensionEO.RATE_DIMENSION_ID AS "RateDimensionId", Xxg2cRateDimensionEO.NAME AS "Name
  • Stack trace

    • 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 :5) 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)

    Write tip

    You have a different solution? A short tip here would help you and many other users who saw this issue last week.

    Users with the same issue

    Unknown user
    Once, 10 months ago
    Unknown user
    Once, 10 months ago
    Unknown user
    Once, 11 months ago
    Unknown user
    Once, 1 year ago
    Unknown user
    Once, 1 year ago
    14 more bugmates