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

Oracle Community | 775215 | 6 years ago
  1. 0

    Seeded Page is erroring out in JDeveloper

    Oracle Community | 1 decade ago | Adarsh Kumar
    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
  2. 0

    not all variables bound while running seeded HierarchyPG from Jdev

    Oracle Community | 6 years ago | 775215
    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
  3. 0

    customizing the oaf page

    Oracle Community | 5 years ago | user539616
    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
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    java.sql.SQLException: Missing IN or OUT parameter at index:: 1 - OA Framework

    developer-works.com | 1 year ago
    oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT e.template_id, p.template_name FROM gecm_otst_enable_templates e, gecm_otst_prompts_tl p WHERE e.template_id = p.template_id AND org_id = :1 AND LANGUAGE = :2 UNION SELECT t.template_id, p.template_name FROM gecm_otst_prompts_tl p, gecm_otst_addr_templates t WHERE t.template_id = p.template_id AND t.org_id = -1 AND p.LANGUAGE = :2 AND NOT EXISTS(SELECT e.template_id, p.template_name FROM gecm_otst_enable_templates e, gecm_otst_prompts_tl p WHERE e.template_id = p.template_id AND org_id = :1 AND LANGUAGE = :2)
  6. 0

    db:: 3.24::RAC service is in Unknown state with CHECK TIMED OUT dj

    hivmr.com | 7 months ago
    oracle.apps.fnd.framework.OAException: java.lang.IndexOutOfBoundsException: index:5 size:5

    1 unregistered visitors
    Not finding the right solution?
    Take a tour to get the most out of Samebug.

    Tired of useless tips?

    Automated exception search integrated into your IDE

    Root Cause Analysis

    1. 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()
    2. oracle.apps.fnd
      OAPageBean.renderDocument
      1. oracle.apps.fnd.framework.OAException.wrapperException(OAException.java:888)
      2. oracle.apps.fnd.framework.webui.OAPageErrorHandler.prepareException(OAPageErrorHandler.java:1145)
      3. oracle.apps.fnd.framework.webui.OAPageBean.renderDocument(OAPageBean.java:2898)
      4. oracle.apps.fnd.framework.webui.OAPageBean.renderDocument(OAPageBean.java:2700)
      4 frames