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.

  • How to sort based on date
    via by 807913,
  • Null pointer exception
    via by 828271,
  • Search based on a shuttle
    via by 27091988,
  • Add search parameter in oaf page
    via by Renu Gupta,
  • Fnd Load Issue
    via by Unknown author,
  • SEPL and VO Extension
    via by 567494,
    • oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT pc.competence_id ,pc.name ,pc.competence_alias as short_name ,pc.unit_standard_id ,qual_ctype.meaning credit_type ,pc.credits ,qual_level_type.meaning level_type ,qual_level.meaning level_number ,qual_field.meaning field ,qual_sub_field.meaning sub_field ,qual_provider.meaning provider ,pc.min_level ,pc.max_level ,qual_qa_org.meaning qa_organization ,pc.description ,pc.behavioural_indicator ,to_number(null) view_detail ,decode(PC.competence_cluster,'UNIT_STANDARD',1,0) isUnitStdComp ,hr_general.decode_lookup('YES_NO',decode(pc.business_group_id, null, 'Y', 'N')) global ,null select_flg ,null comp_reqd ,null comp_type ,pc.business_group_id ,null qual_type ,pc.competence_cluster ,hr_util_misc_ss.getCompSourceInfo(pc.competence_id, :1) comp_src_info ,to_number(null) Reqd_Min ,to_number(null) Reqd_Max ,null Source FROM per_competences_vl pc , fnd_lookup_values_vl qual_ctype , fnd_lookup_values_vl qual_level , fnd_lookup_values_vl qual_level_type , fnd_lookup_values_vl qual_field , fnd_lookup_values_vl qual_sub_field , fnd_lookup_values_vl qual_provider , fnd_lookup_values_vl qual_qa_org WHERE trunc(sysdate) between pc.date_from and nvl(date_to, trunc(sysdate)) AND nvl(pc.business_group_id, :2) = :3 /* exclude in-session competences */ AND NOT EXISTS (select 'e' from per_interim_entity_list where pk2 = pc.competence_id) /* exclude personal competences */ AND pc.competence_id NOT IN (select pce.competence_id from per_competence_elements pce where pce.person_id = :4 and pce.type = 'PERSONAL' and trunc(sysdate) between nvl(pce.effective_date_from,sysdate) and nvl(pce.effective_date_to,sysdate)) /* exclude in session competences */ AND pc.competence_id NOT IN (select to_number(ts.information1) from hr_api_transaction_steps ts, hr_api_transactions t where ts.api_name = 'HR_COMPETENCE_ELEMENT_SWI.PROCESS_API' and ts.transaction_id = t.transaction_id and t.status in ('Y', 'YS', 'RI', 'RIS', 'RO', 'ROS') and ts.object_name = 'oracle.apps.per.schema.server.PerCompetenceElementsEO' and nvl(ts.object_state,100) not in ('3', '4') and ts.information_category = 'PERSONAL' and t.selected_person_id = :5) AND pc.credit_type = qual_ctype.lookup_code (+) AND qual_ctype.lookup_type (+) = 'PER_QUAL_FWK_CREDIT_TYPE' AND pc.level_type = qual_level_type.lookup_code (+) AND qual_level_type.lookup_type (+) = 'PER_QUAL_FWK_LEVEL_TYPE' AND pc.level_number = qual_level.lookup_code (+) AND qual_level.lookup_type (+) = 'PER_QUAL_FWK_LEVEL' AND pc.field = qual_field.lookup_code (+) AND qual_field.lookup_type (+) = 'PER_QUAL_FWK_FIELD' AND pc.sub_field = qual_sub_field.lookup_code (+) AND qual_sub_field.lookup_type (+) = 'PER_QUAL_FWK_SUB_FIELD' AND pc.provider = qual_provider.lookup_code (+) AND qual_provider.lookup_type (+) = 'PER_QUAL_FWK_PROVIDER' AND pc.qa_organization = qual_qa_org.lookup_code (+) AND qual_qa_org.lookup_type (+) = 'PER_QUAL_FWK_QA_ORG' 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.OAPageErrorHandler.processErrors(OAPageErrorHandler.java:1435) at oracle.apps.fnd.framework.webui.OAPageBean.processFormRequest(OAPageBean.java:2867) at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:1840) at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:538) at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:426)

    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,
    14 more bugmates