Error While Applying Global Payroll Rule Package: "ORA-00904: "ALLOW_BGN_END_TIME": invalid identifier"
(Doc ID 3066097.1)
Last updated on JANUARY 10, 2025
Applies to:
PeopleSoft Enterprise HCM Absence Management - Version 9.2 to 9.2 [Release 9]Information in this document applies to any platform.
Symptoms
The following error occurs while applying a rule package for the Global Payroll country extensions, such as Argentina or Mexico, while upgrading the HCM application to Image 50.
The error is captured in Steps "Apply GPCE Argentina Non-Rule Package" or "Apply GPCE Mexico Non-Rule Package" in the Change Assistant.
SQL error. Function: CreateSQL
Error Position: 3633
Return: 904 - ORA-00904: "ALLOW_BGN_END_TIME": invalid identifier
Statement: insert into ps_gp_abs_ss (country, pin_take_num, effdt, eff_status, unit_type, leave_hist_ind, request_ind, calc_end_dt, excl_holidays, excl_non_work, disp_user_fields, abs_user_fld1_lbl, abs_user_fld2_lbl, abs_user_fld3_lbl, abs_user_fld4_lbl, abs_user_fld5_lbl, abs_user_fld6_lbl, abs_user_fld7_lbl, abs_user_fld8_lbl, abs_user_fld9_lbl, abs_user_fld10_lbl, abs_user_fld11_lbl, abs_user_fld12_lbl, abs_user_fld13_lbl, abs_user_fld14_lbl, abs_user_fld15_lbl, abs_user_fld16_lbl, required_config1, required_config2, required_config3, required_config4, required_config5, required_config6, required_config7, required_config8, required_config9, required_config10, required_config11, required_config12, required_config13, required_config14, required_config15, required_config16, abs_uf1_seq_num, abs_uf2_seq_num, abs_uf3_seq_num, abs_uf4_seq_num, abs_uf5_seq_num, abs_uf6_seq_num, abs_uf7_seq_num, abs_uf8_seq_num, abs_uf9_seq_num, abs_uf10_seq_num, abs_uf11_seq_num, abs_uf12_seq_num, abs_uf13_seq_num, abs_uf14_seq_num, abs_uf15_seq_num, abs_uf16_seq_num, display_order, rqst_allowed_by, request_as, override_flg, disp_curr_bal, curr_bal_accum, bal_accum_disp_opt, display_reason, reason_required, allow_partial_days, partial_days_optn, fcst_ind, fcst_req_submit, fcst_req_approval, fcst_req_sbmt_role, fcst_req_appr_role, fcst_message, submit_with_warn, submit_with_error, warn_submt_by_role, err_submt_by_role, ......calc_end_dt, excl_holidays, excl_non_work, disp_user_fields, abs_user_fld1_lbl, abs_user_fld2_lbl, abs_user_fld3_lbl, abs_user_fld4_lbl, abs_user_fld5_lbl, abs_user_fld6_lbl, abs_user_fld7_lbl, abs_user_fld8_lbl, abs_user_fld9_lbl, abs_user_fld10_lbl, abs_user_fld11_lbl, abs_user_fld12_lbl, abs_user_fld13_lbl, abs_user_fld14_lbl, abs_user_fld15_lbl, abs_user_fld16_lbl, required_config1, required_config2, required_config3, required_config4, required_config5, required_config6, required_config7, required_config8, required_config9, required_config10, required_config11, required_config12, required_config13, required_config14, required_config15, required_config16, abs_uf1_seq_num, abs_uf2_seq_num, abs_uf3_seq_num, abs_uf4_seq_num, abs_uf5_seq_num, abs_uf6_seq_num, abs_uf7_seq_num, abs_uf8_seq_num, abs_uf9_seq_num, abs_uf10_seq_num, abs_uf11_seq_num, abs_uf12_seq_num, abs_uf13_seq_num, abs_uf14_seq_num, abs_uf15_seq_num, abs_uf16_seq_num, display_order, rqst_allowed_by, request_as, override_flg, disp_curr_bal, curr_bal_accum, bal_accum_disp_opt, display_reason, reason_required, allow_partial_days, partial_days_optn, fcst_ind, fcst_req_submit, fcst_req_approval, fcst_req_sbmt_role, fcst_req_appr_role, fcst_message, submit_with_warn, submit_with_error, warn_submt_by_role, err_submt_by_role, calc_duration, end_dt_duratn_rule, eoawprcs_id, eoawdefn_id, cancel_option, start_end_hol_rule, start_end_off_rule, display_orig_bgn_d, abs_tl_entry_ind, allow_time_entry, allow_ea_entry, allow_eodi_entry, hga_cancel_prcs_id, hga_cancel_defn_id, hga_can_req_as, hga_can_allow_by, hga_can_override, hga_cancel_optn, hga_disp_can_rsn, hga_appr_for_pnd, hga_can_rsn_req, hga_emp_auth_req, hga_ovrd_emp_auth, ALLOW_BGN_END_TIME FROM PS_GP_NRP_ASS_AD WHERE COUNTRY='MEX' AND EFFDT=TO_DATE('2019-01-01','YYYY-MM-DD') AND GP_PKG_ID = 'MX31530240'
Error Position: 3633
Return: 904 - ORA-00904: "ALLOW_BGN_END_TIME": invalid identifier
Statement: insert into ps_gp_abs_ss (country, pin_take_num, effdt, eff_status, unit_type, leave_hist_ind, request_ind, calc_end_dt, excl_holidays, excl_non_work, disp_user_fields, abs_user_fld1_lbl, abs_user_fld2_lbl, abs_user_fld3_lbl, abs_user_fld4_lbl, abs_user_fld5_lbl, abs_user_fld6_lbl, abs_user_fld7_lbl, abs_user_fld8_lbl, abs_user_fld9_lbl, abs_user_fld10_lbl, abs_user_fld11_lbl, abs_user_fld12_lbl, abs_user_fld13_lbl, abs_user_fld14_lbl, abs_user_fld15_lbl, abs_user_fld16_lbl, required_config1, required_config2, required_config3, required_config4, required_config5, required_config6, required_config7, required_config8, required_config9, required_config10, required_config11, required_config12, required_config13, required_config14, required_config15, required_config16, abs_uf1_seq_num, abs_uf2_seq_num, abs_uf3_seq_num, abs_uf4_seq_num, abs_uf5_seq_num, abs_uf6_seq_num, abs_uf7_seq_num, abs_uf8_seq_num, abs_uf9_seq_num, abs_uf10_seq_num, abs_uf11_seq_num, abs_uf12_seq_num, abs_uf13_seq_num, abs_uf14_seq_num, abs_uf15_seq_num, abs_uf16_seq_num, display_order, rqst_allowed_by, request_as, override_flg, disp_curr_bal, curr_bal_accum, bal_accum_disp_opt, display_reason, reason_required, allow_partial_days, partial_days_optn, fcst_ind, fcst_req_submit, fcst_req_approval, fcst_req_sbmt_role, fcst_req_appr_role, fcst_message, submit_with_warn, submit_with_error, warn_submt_by_role, err_submt_by_role, ......calc_end_dt, excl_holidays, excl_non_work, disp_user_fields, abs_user_fld1_lbl, abs_user_fld2_lbl, abs_user_fld3_lbl, abs_user_fld4_lbl, abs_user_fld5_lbl, abs_user_fld6_lbl, abs_user_fld7_lbl, abs_user_fld8_lbl, abs_user_fld9_lbl, abs_user_fld10_lbl, abs_user_fld11_lbl, abs_user_fld12_lbl, abs_user_fld13_lbl, abs_user_fld14_lbl, abs_user_fld15_lbl, abs_user_fld16_lbl, required_config1, required_config2, required_config3, required_config4, required_config5, required_config6, required_config7, required_config8, required_config9, required_config10, required_config11, required_config12, required_config13, required_config14, required_config15, required_config16, abs_uf1_seq_num, abs_uf2_seq_num, abs_uf3_seq_num, abs_uf4_seq_num, abs_uf5_seq_num, abs_uf6_seq_num, abs_uf7_seq_num, abs_uf8_seq_num, abs_uf9_seq_num, abs_uf10_seq_num, abs_uf11_seq_num, abs_uf12_seq_num, abs_uf13_seq_num, abs_uf14_seq_num, abs_uf15_seq_num, abs_uf16_seq_num, display_order, rqst_allowed_by, request_as, override_flg, disp_curr_bal, curr_bal_accum, bal_accum_disp_opt, display_reason, reason_required, allow_partial_days, partial_days_optn, fcst_ind, fcst_req_submit, fcst_req_approval, fcst_req_sbmt_role, fcst_req_appr_role, fcst_message, submit_with_warn, submit_with_error, warn_submt_by_role, err_submt_by_role, calc_duration, end_dt_duratn_rule, eoawprcs_id, eoawdefn_id, cancel_option, start_end_hol_rule, start_end_off_rule, display_orig_bgn_d, abs_tl_entry_ind, allow_time_entry, allow_ea_entry, allow_eodi_entry, hga_cancel_prcs_id, hga_cancel_defn_id, hga_can_req_as, hga_can_allow_by, hga_can_override, hga_cancel_optn, hga_disp_can_rsn, hga_appr_for_pnd, hga_can_rsn_req, hga_emp_auth_req, hga_ovrd_emp_auth, ALLOW_BGN_END_TIME FROM PS_GP_NRP_ASS_AD WHERE COUNTRY='MEX' AND EFFDT=TO_DATE('2019-01-01','YYYY-MM-DD') AND GP_PKG_ID = 'MX31530240'
The issue can be reproduced at will with the following steps:
1. Upgrading the HCM Application to Image 50
2. Run steps such as "Apply GPCE Argentina Non-Rule Package" or "Apply GPCE Mexico Non-Rule Package" in Change Assistant
3. Notice that the steps are failing in error
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
| Symptoms |
| Cause |
| Solution |
| References |