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

Oracle Community | user10648285 | 4 years ago
tip
Your exception is missing from the Samebug knowledge base.
Here are the best solutions we found on the Internet.
Click on the to mark the helpful solution and get rewards for you help.
  1. 0

    R12 issue: oracle.jbo.SQLStmtException: JBO-27122: SQL error

    Oracle Community | 4 years ago | user10648285
    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')
  2. 0

    oracle.jbo.SQLStmtException:JBO-27122:SQLerror during statement preparation

    Oracle Community | 6 years ago | 837397
    oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT * FROM (SELECT OPMTL.ORG_PAYMENT_METHOD_NAME , OPM.ORG_PAYMENT_METHOD_ID , OPM.CURRENCY_CODE , OPM.DEFINED_BALANCE_ID , PTTL.PAYMENT_TYPE_NAME , PT.TERRITORY_CODE , PT.CATEGORY , PT.PRE_VALIDATION_REQUIRED , OPM.EFFECTIVE_END_DATE , OPM.EFFECTIVE_START_DATE , USG.PAYROLL_ID , OPM.BUSINESS_GROUP_ID , PEA.ID_FLEX_NUM , FC.NAME CURRENCY_NAME, PAY_PPMV4_SS.GET_PPM_COUNTRY(OPM.ORG_PAYMENT_METHOD_ID,OPM.BUSINESS_GROUP_ID + 0) PPM_COUNTRY_CODE, PAY_PPMV4_SS.GET_PPM_COUNTRY(OPM.ORG_PAYMENT_METHOD_ID,OPM.BUSINESS_GROUP_ID + 0,'Y') TERRITORY_SHORT_NAME, PAY_PPMV4_SS.GET_BANK_FLEXCODE(OPM.ORG_PAYMENT_METHOD_ID,OPM.BUSINESS_GROUP_ID + 0) BANK_FLEX_CODE FROM PAY_ORG_PAYMENT_METHODS_F_TL OPMTL, PAY_PAYMENT_TYPES_TL PTTL, PAY_ORG_PAYMENT_METHODS_F OPM, PAY_ORG_PAY_METHOD_USAGES_F USG, PAY_PAYMENT_TYPES PT, PAY_EXTERNAL_ACCOUNTS PEA, FND_SESSIONS FF , FND_CURRENCIES_VL FC WHERE PT.PAYMENT_TYPE_ID = PTTL.PAYMENT_TYPE_ID AND PTTL.LANGUAGE = USERENV('LANG') AND OPM.ORG_PAYMENT_METHOD_ID = OPMTL.ORG_PAYMENT_METHOD_ID AND OPMTL.LANGUAGE = USERENV('LANG') AND FF.SESSION_ID = USERENV('SESSIONID') AND FF.EFFECTIVE_DATE BETWEEN OPM.EFFECTIVE_START_DATE AND OPM.EFFECTIVE_END_DATE AND FF.EFFECTIVE_DATE BETWEEN USG.EFFECTIVE_START_DATE AND USG.EFFECTIVE_END_DATE AND USG.ORG_PAYMENT_METHOD_ID = OPM.ORG_PAYMENT_METHOD_ID AND OPM.PAYMENT_TYPE_ID = PT.PAYMENT_TYPE_ID AND OPM.CURRENCY_CODE = FC.CURRENCY_CODE(+) AND OPM.EXTERNAL_ACCOUNT_ID = PEA.EXTERNAL_ACCOUNT_ID (+) AND USG.PAYROLL_ID = :1 AND OPM.BUSINESS_GROUP_ID + 0 = :2 AND :3 BETWEEN OPM.EFFECTIVE_START_DATE AND OPM.EFFECTIVE_END_DATE AND OPM.DEFINED_BALANCE_ID IS NOT NULL) QRSLT WHERE (ORG_PAYMENT_METHOD_ID IN (837,977,133,279,274,417,297,226,324,271,183,390,396,429,217,144)
  3. 0

    JBO-27022: Failed to load value at index 93 with java object of type java.l

    Oracle Community | 6 years ago | 879472
    oracle.apps.fnd.framework.OAException: oracle.jbo.AttributeLoadException: JBO-27022: Failed to load value at index 93 with java object of type java.lang.String due to java.sql.SQLException.
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Refresh picklist VO for message choice

    Oracle Community | 5 years ago | Dan Cretu
    oracle.apps.fnd.framework.OAException: oracle.jbo.InvalidParamException: JBO-25006: Invalid parameter value 2 for rangeIndex passed to method ViewRowSetIteratorImpl.insertRowAtRangeIndex. Explanation: index beyond end of row set
  6. 0

    Not a statement exception error while compiling AMImpl file

    Oracle Community | 5 years ago | 884536
    oracle.apps.fnd.framework.OAException: oracle.jbo.InvalidParamException: JBO-25006: Invalid parameter value 2 for rangeIndex passed to method ViewRowSetIteratorImpl.insertRowAtRangeIndex. Explanation: index beyond end of row set

    2 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 * 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()
    2. oracle.apps.fnd
      OAApplicationModuleImpl.invokeMethod
      1. oracle.apps.fnd.framework.OAException.wrapperException(OAException.java:912)
      2. oracle.apps.fnd.framework.OAException.wrapperException(OAException.java:886)
      3. oracle.apps.fnd.framework.OAException.wrapperInvocationTargetException(OAException.java:1009)
      4. oracle.apps.fnd.framework.server.OAUtility.invokeMethod(OAUtility.java:211)
      5. oracle.apps.fnd.framework.server.OAUtility.invokeMethod(OAUtility.java:153)
      6. oracle.apps.fnd.framework.server.OAApplicationModuleImpl.invokeMethod(OAApplicationModuleImpl.java:762)
      6 frames
    3. oracle.apps.per
      PersonAsgSummaryCO.processRequest
      1. oracle.apps.per.selfservice.mgrviews.webui.PersonAsgSummaryCO.processRequest(PersonAsgSummaryCO.java:78)
      1 frame
    4. oracle.apps.fnd
      OAPageBean.preparePage
      1. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:600)
      2. oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(OAWebBeanContainerHelper.java:252)
      3. oracle.apps.fnd.framework.webui.beans.layout.OAStackLayoutBean.processRequest(OAStackLayoutBean.java:350)
      4. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:968)
      5. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:935)
      6. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:659)
      7. oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(OAWebBeanContainerHelper.java:252)
      8. oracle.apps.fnd.framework.webui.beans.layout.OAStackLayoutBean.processRequest(OAStackLayoutBean.java:350)
      9. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:968)
      10. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:935)
      11. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:659)
      12. oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(OAWebBeanContainerHelper.java:252)
      13. oracle.apps.fnd.framework.webui.beans.layout.OAHeaderBean.processRequest(OAHeaderBean.java:391)
      14. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:968)
      15. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:935)
      16. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:659)
      17. oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(OAWebBeanContainerHelper.java:252)
      18. oracle.apps.fnd.framework.webui.beans.layout.OAStackLayoutBean.processRequest(OAStackLayoutBean.java:350)
      19. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:968)
      20. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:935)
      21. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:659)
      22. oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(OAWebBeanContainerHelper.java:252)
      23. oracle.apps.fnd.framework.webui.OAPageLayoutHelper.processRequest(OAPageLayoutHelper.java:1182)
      24. oracle.apps.fnd.framework.webui.beans.layout.OAPageLayoutBean.processRequest(OAPageLayoutBean.java:1569)
      25. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:968)
      26. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:935)
      27. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:659)
      28. oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(OAWebBeanContainerHelper.java:252)
      29. oracle.apps.fnd.framework.webui.beans.form.OAFormBean.processRequest(OAFormBean.java:385)
      30. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:968)
      31. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:935)
      32. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:659)
      33. oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(OAWebBeanContainerHelper.java:252)
      34. oracle.apps.fnd.framework.webui.beans.OABodyBean.processRequest(OABodyBean.java:353)
      35. oracle.apps.fnd.framework.webui.OAPageBean.processRequest(OAPageBean.java:2607)
      36. oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:1940)
      37. oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:543)
      38. oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:431)
      38 frames