Payroll Archive Process Is Shows Completed On View Requests Page But, Is In Error On All Employees With APP-PAY-06881: Error ORA-20001: Error in pay_us_action_arch.process_actions ORA-20001: Database item requires context DATE_EARNED to be set (Doc ID 2148686.1)

Last updated on JUNE 10, 2016

Applies to:

Oracle HRMS (US) - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

On : 12.1.3 version, External Process Archive/Paysl

When attempting to run Payroll Archive for over 1400 employees
the following error occurs for all employees.

ERROR
-----------------------
 HR_6881_HRPROC_ORA_ERR
SQLERRMC ORA-20001: Error in pay_us_action_arch.process_actions
ORA-06512: at "APPS.PAY_ARCHIVE", line 1207
ORA-06512: at line 3

SQL_NO 1108
TABLE_NAME pay_archive.process_employee
APP-PAY-06881: Error ORA-20001: Error in pay_us_action_arch.process_actions
ORA-06512: at "APPS.PAY_ARCHIVE", line 1207
ORA-06512: at line 3
has occurred in table pay_archive.process_employee at location 1108

Cause: an oracle error has occurred. The failure was reported on table pay_archive.process_employee at location 1108 with the error text ORA-20001: Error in pay_us_action_arch.process_actions
ORA-06512: at "APPS.PAY_ARCHIVE", line 1207
ORA-06512: at line 3

PYUPIP shows

PYUPIP shows

lpay_emp_action_arch.get_employee_other_info 10
p_run_action_id = 81859640
p_assignment_id = 2466
p_organization_id = 214
p_business_group_id = 122
p_curr_pymt_eff_date = 26-MAY-16
p_tax_unit_id = 141
pay_emp_action_arch.get_employee_other_info 20
Opened for Business Group:Payslip Info                                    <<<<
pay_emp_action_arch.get_employee_other_info                          <<<<
lv_info_type BALANCE
ln_element_type_id
ln_input_value_id
ln_balance_type_id 10535214
ln_balance_dimension_id151
lv_message
lv_display_name HS Personal Leave Hours
pay_emp_action_arch.get_employee_other_info 210
pay_emp_action_arch.get_employee_other_info 220
ln_balance_type_id10535214
lv_name BALANCE
lv_value_type GRE_YTD
ln_defined_balance_id 20339004
p_ppp_source_action_id
ln_run_action_id 81859638
pay_balance_pkg.set_context 10
p_context_name : TAX_UNIT_ID
p_context_value : 141
pay_balance_pkg.get_value - ACTION MODE 1
def_bal_id = 20339004
asg_action_id = 81859638
pay_balance_pkg.set_context 10
p_context_name : ASSIGNMENT_ACTION_ID
p_context_value : 81859638
pay_balance_pkg.load_defbal_cache :p_defined_balance_id:20339004 10
pay_balance_pkg.load_defbal_cache:ASSIGNMENT_ACTION_ID 20
pay_balance_pkg.load_defbal_cache:TAX_UNIT_ID 20
pay_balance_pkg.load_defbal_cache 30
Entering: pay_monitor_balance_retrieval.monitor_balance_retrieval 10
pay_monitor_balance_retrieval.monitor_balance_retrieval 40
Leaving: pay_monitor_balance_retrieval.monitor_balance_retrieval 50
Entering: pay_balance_pkg.get_rb_value 5
pay_balance_pkg.load_defbal_cache 30
pay_balance_pkg.get_rb_value 20
pay_balance_pkg.get_rb_value l_balance_value: 35
Leaving: pay_balance_pkg.get_rb_value 45
Entering: pay_balance_pkg.get_rr_value 5
pay_balance_pkg.load_defbal_cache 30
Entering: pay_balance_pkg.get_rr_value 10
Entering pay_balance_pkg.get_run_bal 10
Entering pay_balance_pkg.get_run_bal 15
pay_balance_pkg.run_rr_route 1
pay_balance_pkg.run_rr_route 10
Error in pay_us_action_arch.process_actions-ORA-20001: Database item requires context DATE_EARNED to be set
Error at step 21 in pay_us_action_arch.action_archive_data-ORA-20001: Error in pay_us_action_arch.process_actions
pay_core_utils.pop_message


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. run Payroll Archive

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms