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