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'

Searched on Google with the first line of a JAVA stack trace?

We can recommend more relevant solutions and speed up debugging when you paste your entire stack trace with the exception message. Try a sample exception.

Recommended solutions based on your search

Solutions on the web

via Oracle Community by 814480, 1 year ago
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
via Oracle Community by 584085, 1 year ago
oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT * FROM (SELECT feb.entity_id, rel.parent_entity_id, fetl.entity_name, pfetl.entity_name parent_entity_name, ccytl.currency_code, ccytl.name AS
via Oracle Community by Bipin Behari Sethy, 1 year ago
oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT * FROM (SELECT NVL(PAA.DATE_START, PAA.DATE_PROJECTED_START) START_DATE, NVL(PAA.DATE_END, PAA.DATE_PROJECTED_END) END_DATE, PAATTL.NAME ABSENCE_TYPE
via Oracle Community by Renu Gupta, 1 year ago
oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT /*+ FIRST_ROWS */ NULL AS SelectFlag, PPF.FULL_NAME AS PERSON_NAME, ADDR.DERIVED_LOCALE, ADDR.ADDRESS_ID, PHN.PHONE_NUMBER, PHN.PHONE_ID
via Oracle Community by user5425941, 1 year ago
oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT * FROM (select 'Select_flag', poh.po_num, poh.comments, poh.creation_date, poh.po_release_id, to_char(null) agent_name, poh.currency_code, to_char(0
via Oracle Community by 881169, 1 year ago
oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT * FROM (select 'Select_flag', poh.po_num, poh.comments, poh.creation_date, poh.po_release_id, to_char(null) agent_name, poh.currency_code, to_char(0
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

Samebug visitor profile picture
Unknown user
Once, 1 year ago
Samebug visitor profile picture
Unknown user
Once, 1 year ago
Samebug visitor profile picture
Unknown user
Once, 1 year ago
Samebug visitor profile picture
Unknown user
Once, 1 year ago
Samebug visitor profile picture
Unknown user
Once, 2 years ago
14 more bugmates

Know the solutions? Share your knowledge to help other developers to debug faster.