oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT * FROM (SELECT * FROM (select decode(fnd_profile.value('BEN_DISPLAY_EMPLOYEE_NAME'),'FN',ppf.full_name, ppf.first_name||' '|| ppf.last_name) full_name, paf.assignment_number, ppf.employee_number, ppf.npw_number ,hr_person_type_usage_info.get_user_person_type(ppf.effective_end_date, ppf.person_id) person_type ,assignment_type ,HR_GENERAL.DECODE_LOOKUP('YES_NO',paf.primary_flag) primary_flag , ppf.original_date_of_hire, ppf.start_date ,bus.name business_group, org.name organization ,hr_util_misc_ss.getObjectName('JOB', paf.job_id, ppf.business_group_id, j.name) job ,hr_util_misc_ss.getObjectName('GRADE', paf.grade_id, ppf.business_group_id, g.name) grade ,hr_util_misc_ss.getObjectName('POSITION', paf.position_id, ppf.business_group_id, p.name) position ,l.location_code, sup.full_name supervisor ,Decode(paf.assignment_type, 'C', hr_general.decode_lookup('CWK_ASG_CATEGORY', paf.employment_category), hr_general.decode_lookup('EMP_CAT', paf.employment_category) )employment_category ,paf.assignment_category ,ppf.email_address, (select ph.phone_number from per_phones ph where ppf.person_id = ph.parent_id and ph.parent_table = 'PER_ALL_PEOPLE_F' and ph.phone_type = 'W1' and fs.effective_date between ph.date_from and nvl(ph.date_to, fs.effective_date)) work_telephone ,payroll.payroll_name, hr_util_misc_ss.get_employee_salary(paf.assignment_id, fs.effective_date, ppp.proposed_salary_n, pay_annualization_factor, pb.pay_basis) annual_salary ,pb.name pay_basis, (select petf.input_currency_code from pay_input_values_f ivf, pay_element_types_f petf where pb.input_value_id = ivf.input_value_id and ppp.change_date between ivf.effective_start_date and ivf.effective_end_date and ivf.element_type_id = petf.element_type_id and ppp.change_date between petf.effective_start_date and petf.effective_end_date) currency_code ,HR_GENERAL.DECODE_LOOKUP('FREQUENCY',paf.perf_review_period_frequency) perf_freq ,paf.perf_review_period, ppr.review_date , ppr.next_perf_review_date ,appr.overall_performance_level_id ,decode(ppr.performance_rating, null, null, ppr.performance_rating||' - '||hr_general.decode_lookup('PERFORMANCE_RATING',ppr.performance_rating)) last_performance_rating ,hr_mee_views_gen.getYOS(ppf.person_id) years_of_service ,hr_mee_views_gen.get_total_absences(ppf.person_id) total_number_of_absences ,hr_mee_views_gen.get_total_absence_days(ppf.person_id) total_absence_days ,hr_mee_views_gen.get_total_absence_hours(ppf.person_id) total_absence_hours ,nvl(paf.effective_start_date, ppf.effective_start_date) asgn_start_date ,decode(nvl(paf.effective_end_date, ppf.effective_end_date), to_date('31/12/4712','DD/MM/RRRR'), to_date(null), nvl(paf.effective_end_date, ppf.effective_end_date)) asgn_end_date, nvl(pos.date_start, pop.date_start) latest_hire_date, decode(paf.assignment_type, 'E', 1, 0) render_emp, decode(paf.assignment_type, 'C', 1, 0) render_cwk, hr_mee_views_gen.getTrngDays(ppf.person_id) total_training_days, hr_mee_views_gen.getTrngHrs(ppf.person_id) total_training_hours, (select hr_general.decode_lookup('YES_NO',nvl(max('Y'),'N')) from per_applications a where a.person_id = ppf.person_id and fs.effective_date between a.date_received and nvl(a.date_end,to_date('31/12/4712','DD/MM/RRRR'))) applications_exist, paf.assignment_id, paf.primary_flag prim_flag, pos.adjusted_svc_date ,to_char(hr_util_misc_ss.get_employee_salary(paf.assignment_id, fs.effective_date, ppp.proposed_salary_n, pay_annualization_factor, pb.pay_basis),'999,999,999,999') || ' US Dollars' formatted_annual_salary from per_all_people_f ppf, per_all_assignments_f paf ,hr_all_organization_units_tl bus, hr_all_organization_units_tl org ,per_jobs_tl j, per_grades_tl g, hr_all_positions_f_tl p, hr_locations_all_tl l ,per_all_people_f sup, pay_all_payrolls_f payroll ,per_pay_proposals ppp, per_pay_bases pb, per_performance_reviews ppr ,per_events pe, per_appraisals appr ,per_periods_of_service pos, per_periods_of_placement pop, fnd_sessions fs where paf.person_id = :1 and fs.session_id = userenv('sessionid') and ppf.person_id = paf.person_id and paf.assignment_type in ('E','C') and paf.period_of_service_id = pos.period_of_service_id(+) and paf.period_of_placement_date_start = pop.date_start(+) and paf.person_id = pop.person_id(+) and paf.pay_basis_id = pb.pay_basis_id(+) and paf.assignment_id = ppp.assignment_id(+) and ppp.pay_proposal_id(+) = hr_mee_views_gen.getAsgProposalId(paf.assignment_id) and ppp.approved(+) = 'Y' and ppf.person_id = ppr.person_id(+) and ppr.performance_review_id(+) = hr_mee_views_gen.getPrsnPerformanceId(ppf.person_id) and paf.payroll_id = payroll.payroll_id(+) and paf.effective_start_date between payroll.effective_start_date(+) and payroll.effective_end_date(+) and paf.supervisor_id = sup.person_id(+) and paf.effective_end_date between sup.effective_start_date(+) and sup.effective_end_date(+) and ppf.business_group_id = bus.organization_id and bus.language = userenv('LANG') and paf.organization_id = org.organization_id and org.language = userenv('LANG') and paf.job_id = j.job_id(+) and j.language(+) = userenv('LANG') and paf.grade_id = g.grade_id(+) and g.language(+) = userenv('LANG') and paf.position_id = p.position_id(+) and p.language(+) = userenv('LANG') and paf.location_id = l.location_id(+) and l.language(+) = userenv('LANG') and fs.effective_date between ppf.effective_start_date and ppf.effective_end_date and fs.effective_date between paf.effective_start_date and paf.effective_end_date and ppr.event_id = pe.event_id(+) and pe.event_id = appr.event_id(+)) QRSLT WHERE (prim_flag = 'Y')) QRSLT WHERE (prim_flag = 'Y')

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.

  • Refresh picklist VO for message choice
    via by Dan Cretu,
  • OAF
    via by 745071,
  • VO Extension Error
    via by 929077,
    • oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT * FROM (SELECT * FROM (select decode(fnd_profile.value('BEN_DISPLAY_EMPLOYEE_NAME'),'FN',ppf.full_name, ppf.first_name||' '|| ppf.last_name) full_name, paf.assignment_number, ppf.employee_number, ppf.npw_number ,hr_person_type_usage_info.get_user_person_type(ppf.effective_end_date, ppf.person_id) person_type ,assignment_type ,HR_GENERAL.DECODE_LOOKUP('YES_NO',paf.primary_flag) primary_flag , ppf.original_date_of_hire, ppf.start_date ,bus.name business_group, org.name organization ,hr_util_misc_ss.getObjectName('JOB', paf.job_id, ppf.business_group_id, j.name) job ,hr_util_misc_ss.getObjectName('GRADE', paf.grade_id, ppf.business_group_id, g.name) grade ,hr_util_misc_ss.getObjectName('POSITION', paf.position_id, ppf.business_group_id, p.name) position ,l.location_code, sup.full_name supervisor ,Decode(paf.assignment_type, 'C', hr_general.decode_lookup('CWK_ASG_CATEGORY', paf.employment_category), hr_general.decode_lookup('EMP_CAT', paf.employment_category) )employment_category ,paf.assignment_category ,ppf.email_address, (select ph.phone_number from per_phones ph where ppf.person_id = ph.parent_id and ph.parent_table = 'PER_ALL_PEOPLE_F' and ph.phone_type = 'W1' and fs.effective_date between ph.date_from and nvl(ph.date_to, fs.effective_date)) work_telephone ,payroll.payroll_name, hr_util_misc_ss.get_employee_salary(paf.assignment_id, fs.effective_date, ppp.proposed_salary_n, pay_annualization_factor, pb.pay_basis) annual_salary ,pb.name pay_basis, (select petf.input_currency_code from pay_input_values_f ivf, pay_element_types_f petf where pb.input_value_id = ivf.input_value_id and ppp.change_date between ivf.effective_start_date and ivf.effective_end_date and ivf.element_type_id = petf.element_type_id and ppp.change_date between petf.effective_start_date and petf.effective_end_date) currency_code ,HR_GENERAL.DECODE_LOOKUP('FREQUENCY',paf.perf_review_period_frequency) perf_freq ,paf.perf_review_period, ppr.review_date , ppr.next_perf_review_date ,appr.overall_performance_level_id ,decode(ppr.performance_rating, null, null, ppr.performance_rating||' - '||hr_general.decode_lookup('PERFORMANCE_RATING',ppr.performance_rating)) last_performance_rating ,hr_mee_views_gen.getYOS(ppf.person_id) years_of_service ,hr_mee_views_gen.get_total_absences(ppf.person_id) total_number_of_absences ,hr_mee_views_gen.get_total_absence_days(ppf.person_id) total_absence_days ,hr_mee_views_gen.get_total_absence_hours(ppf.person_id) total_absence_hours ,nvl(paf.effective_start_date, ppf.effective_start_date) asgn_start_date ,decode(nvl(paf.effective_end_date, ppf.effective_end_date), to_date('31/12/4712','DD/MM/RRRR'), to_date(null), nvl(paf.effective_end_date, ppf.effective_end_date)) asgn_end_date, nvl(pos.date_start, pop.date_start) latest_hire_date, decode(paf.assignment_type, 'E', 1, 0) render_emp, decode(paf.assignment_type, 'C', 1, 0) render_cwk, hr_mee_views_gen.getTrngDays(ppf.person_id) total_training_days, hr_mee_views_gen.getTrngHrs(ppf.person_id) total_training_hours, (select hr_general.decode_lookup('YES_NO',nvl(max('Y'),'N')) from per_applications a where a.person_id = ppf.person_id and fs.effective_date between a.date_received and nvl(a.date_end,to_date('31/12/4712','DD/MM/RRRR'))) applications_exist, paf.assignment_id, paf.primary_flag prim_flag, pos.adjusted_svc_date ,to_char(hr_util_misc_ss.get_employee_salary(paf.assignment_id, fs.effective_date, ppp.proposed_salary_n, pay_annualization_factor, pb.pay_basis),'999,999,999,999') || ' US Dollars' formatted_annual_salary from per_all_people_f ppf, per_all_assignments_f paf ,hr_all_organization_units_tl bus, hr_all_organization_units_tl org ,per_jobs_tl j, per_grades_tl g, hr_all_positions_f_tl p, hr_locations_all_tl l ,per_all_people_f sup, pay_all_payrolls_f payroll ,per_pay_proposals ppp, per_pay_bases pb, per_performance_reviews ppr ,per_events pe, per_appraisals appr ,per_periods_of_service pos, per_periods_of_placement pop, fnd_sessions fs where paf.person_id = :1 and fs.session_id = userenv('sessionid') and ppf.person_id = paf.person_id and paf.assignment_type in ('E','C') and paf.period_of_service_id = pos.period_of_service_id(+) and paf.period_of_placement_date_start = pop.date_start(+) and paf.person_id = pop.person_id(+) and paf.pay_basis_id = pb.pay_basis_id(+) and paf.assignment_id = ppp.assignment_id(+) and ppp.pay_proposal_id(+) = hr_mee_views_gen.getAsgProposalId(paf.assignment_id) and ppp.approved(+) = 'Y' and ppf.person_id = ppr.person_id(+) and ppr.performance_review_id(+) = hr_mee_views_gen.getPrsnPerformanceId(ppf.person_id) and paf.payroll_id = payroll.payroll_id(+) and paf.effective_start_date between payroll.effective_start_date(+) and payroll.effective_end_date(+) and paf.supervisor_id = sup.person_id(+) and paf.effective_end_date between sup.effective_start_date(+) and sup.effective_end_date(+) and ppf.business_group_id = bus.organization_id and bus.language = userenv('LANG') and paf.organization_id = org.organization_id and org.language = userenv('LANG') and paf.job_id = j.job_id(+) and j.language(+) = userenv('LANG') and paf.grade_id = g.grade_id(+) and g.language(+) = userenv('LANG') and paf.position_id = p.position_id(+) and p.language(+) = userenv('LANG') and paf.location_id = l.location_id(+) and l.language(+) = userenv('LANG') and fs.effective_date between ppf.effective_start_date and ppf.effective_end_date and fs.effective_date between paf.effective_start_date and paf.effective_end_date and ppr.event_id = pe.event_id(+) and pe.event_id = appr.event_id(+)) QRSLT WHERE (prim_flag = 'Y')) QRSLT WHERE (prim_flag = 'Y') at oracle.apps.fnd.framework.OAException.wrapperException(OAException.java:912) at oracle.apps.fnd.framework.OAException.wrapperException(OAException.java:886) at oracle.apps.fnd.framework.OAException.wrapperInvocationTargetException(OAException.java:1009) at oracle.apps.fnd.framework.server.OAUtility.invokeMethod(OAUtility.java:211) at oracle.apps.fnd.framework.server.OAUtility.invokeMethod(OAUtility.java:153) at oracle.apps.fnd.framework.server.OAApplicationModuleImpl.invokeMethod(OAApplicationModuleImpl.java:762) at oracle.apps.per.selfservice.mgrviews.webui.PersonAsgSummaryCO.processRequest(PersonAsgSummaryCO.java:78) at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:600) 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.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.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 visitor1 times, last one,
    Unknown visitor1 times, last one,
    Unknown visitor1 times, last one,
    Unknown visitor1 times, last one,
    Unknown visitor1 times, last one,
    10 more bugmates