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 775215, 1 year ago
oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: 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 user539616, 1 year ago
oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: 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 797277, 1 year ago
oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT bp.vendor_site_id, (bp.vendor_site_code || ' - ' || ps.ADDRESS_LINE1 || DECODE (ps.ADDRESS_LINE1,NULL,NULL,', ') || ps.ADDRESS_LINE2 || DECODE
via Oracle Community by Veejay, 1 year ago
oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT * FROM (SELECT StructureEO.ID, StructureEO.NAME, StructureEO.PARENT_ID, StructureEO.PARENT_OBJ_TYPE, StructureEO.ARTICLE_ID
via Oracle Community by 452203, 1 year ago
oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: Select Header_id,Line_id from oe_order_lines_all where header_id = NVL(:1,1134)
via Oracle Community by 543071, 1 year ago
oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: select EmpEO.EMPNO, EmpEO.ENAME, EmpEO.JOB, EmpEO.DEPTNO from EMP EmpEO
oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT * FROM (select decode(fnd_profile.value('BEN_DISPLAY_EMPLOYEE_NAME'),'FN',ppf.full_name, ppf.first_name||' '|| ppf.last_name) full_name,
hr_person_type_usage_info.get_user_person_type(ppf.effective_end_date, ppf.person_id) person_type,
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,
ppf.start_date, ppf.original_date_of_hire,
decode(paf.period_of_service_id, null, pop.date_start, pos.date_start) date_start,
decode(paf.period_of_service_id, null, pop.actual_termination_date, pos.actual_termination_date) actual_termination_date,
Decode(paf.assignment_type,
'C', hr_general.decode_lookup('HR_CWK_TERMINATION_REASONS', pop.termination_reason),
hr_general.decode_lookup('LEAV_REAS', pos.leaving_reason)
) leaving_reason,
paf.effective_start_date,
hr_util_misc_ss.getObjectName('JOB', paf.job_id, ppf.business_group_id, jtl.name) job, paf.job_id,
orgtl.name organization, orgtl.organization_id,
bgtl.name business_group, bgtl.organization_id business_group_id,
lvl.location_code,
hr_util_misc_ss.getObjectName('GRADE', paf.grade_id, ppf.business_group_id, gtl.name) grade, paf.supervisor_id, ppf.person_id, paf.assignment_id, paf.primary_flag, paf.assignment_number,
ppf.employee_number,
ppf.npw_number cwk_number,
nvl(paf.effective_start_date, ppf.effective_start_date) Asg_start_date,
decode(nvl(paf.effective_end_date, ppf.effective_end_date), to_date('31/12/4712','DD/MM/RRRR'), null, nvl(paf.effective_end_date, ppf.effective_end_date) ) Asg_end_date,
hr_general.decode_lookup('YES_NO', paf.primary_flag) Prim_Flag,
lvl.derived_locale,
v.vendor_name Supplier,
paf.VENDOR_ASSIGNMENT_NUMBER Supplier_id_assignment,
paf.VENDOR_EMPLOYEE_NUMBER Supplier_id_worker,
Decode(paf.assignment_type,
'C', hr_general.decode_lookup('HR_CWK_TERMINATION_REASONS', pop.termination_reason),
hr_general.decode_lookup('LEAV_REAS', pos.leaving_reason)
)term_reason,
decode(ppf.rehire_recommendation, 'N', null, hr_general.decode_lookup('YES_NO', ppf.rehire_recommendation)) rehire,
ast.user_status assignment_status,
decode(paf.period_of_service_id, null, pop.date_start, pos.date_start) latest_hire_date,
hr_util_misc_ss.getObjectName('POSITION', paf.position_id, ppf.business_group_id, ptl.name) position,
ppf.REHIRE_REASON,
paf.supervisor_assignment_id,
null Work_Phone,
null Position_Id,
null Disc_Title,
'Y' Manager_Enabled,
null Payroll,
null Normal_Hours,
'Y1' details_enabled,
ppf.email_address,
org_info.org_information9 LegislationCode
from per_assignments_f2 paf, per_assignment_status_types_tl ast,
per_people_f ppf,
hr_all_organization_units_tl orgtl, hr_all_organization_units_tl bgtl,
per_jobs_tl jtl, hr_all_positions_f_tl ptl, hr_locations_all_vl lvl, po_vendors v,
per_grades_tl gtl, per_periods_of_service pos, per_periods_of_placement pop, hr_organization_information org_info
where trunc(sysdate) between paf.effective_start_date and paf.effective_end_date
and trunc(sysdate) between ppf.effective_start_date and ppf.effective_end_date
and (ppf.current_employee_flag = 'Y' or ppf.current_npw_flag = 'Y')
and paf.primary_flag = decode(:0 ,'Y', paf.primary_flag, 'Y')
and paf.assignment_type in ('E','C')
and paf.person_id = ppf.person_id
and paf.vendor_id = v.vendor_id(+)
and paf.assignment_status_type_id = ast.assignment_status_type_id
and ast.language = userenv('LANG')
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.job_id = jtl.job_id(+)
and jtl.language(+) = userenv('LANG')
and paf.position_id = ptl.position_id(+)
and ptl.language(+) = userenv('LANG')
and paf.organization_id = orgtl.organization_id
and orgtl.language = userenv('LANG')
and ppf.business_group_id = bgtl.organization_id
and bgtl.language = userenv('LANG')
and paf.location_id = lvl.location_id(+)
and paf.grade_id = gtl.grade_id(+)
and gtl.language(+) = userenv('LANG')
and org_info.organization_id = ppf.business_group_id
and org_information_context = 'Business Group Information') QRSLT WHERE (:1 = SUPERVISOR_ID)AND (:2 = SUPERVISOR_ASSIGNMENT_ID or hr_general2.supervisor_assignments_in_use = 'FALSE' ) ORDER BY FULL_NAME	at oracle.apps.fnd.framework.OAException.wrapperException(OAException.java:888)	at oracle.apps.fnd.framework.webui.OAPageErrorHandler.prepareException(OAPageErrorHandler.java:1145)	at oracle.apps.fnd.framework.webui.OAPageBean.renderDocument(OAPageBean.java:2898)	at oracle.apps.fnd.framework.webui.OAPageBean.renderDocument(OAPageBean.java:2700)