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')

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

Samebug tips

Do you know how to solve this issue? Write a tip to help other users and build your expert profile.

Solutions on the web

via Oracle Community by user10648285, 1 year ago
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
via Oracle Community by 745071, 1 year ago
oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT DECODE(ASO_QUOTES.RESOURCE_ID, null, sales.name, sales1.name) sales_rep_name, aso_quotes.quote_name, aso_quotes.contract_id, aso_quotes.quote_number
via Oracle Community by 745071, 1 year ago
oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT DECODE(ASO_QUOTES.RESOURCE_ID, null, sales.name, sales1.name) sales_rep_name, aso_quotes.quote_name, aso_quotes.contract_id, aso_quotes.quote_number
via Oracle Community by Dan Cretu, 1 year ago
oracle.jbo.InvalidParamException: JBO-25006: Invalid parameter value 2 for rangeIndex passed to method ViewRowSetIteratorImpl.insertRowAtRangeIndex. Explanation: index beyond end of row set
via Oracle Community by 884536, 1 year ago
oracle.jbo.InvalidParamException: JBO-25006: Invalid parameter value 2 for rangeIndex passed to method ViewRowSetIteratorImpl.insertRowAtRangeIndex. Explanation: index beyond end of row set
via Oracle Community by 610323, 1 year ago
oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: /* Formatted on 2009/07/24 10:39 (Formatter Plus v4.8.0) */ SELECT pen.prtt_enrt_rslt_id, pcs.enrt_ctfn_typ_cd, hl1.meaning certification_type
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

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, 1 year ago

Write tip

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