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