Payroll Archive Process Errors: APP-PAY-06881: Error ORA-20001: Error in pay_us_action_arch.process_actions (Doc ID 1117717.1)

Last updated on JUNE 03, 2015

Applies to:

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

Symptoms

Changing from bi-weekly to semi-monthly payroll. When processing Payroll Archive, employees receive 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

 

Further logging detail shows:

CALL INTO FF_WRAPPER_PKG2
Setting PAY_TYPE=10 per_formula_functions.set_text 5
Setting ACCRUAL_FREQ=Day per_formula_functions.set_text 5
Setting ACCRUAL_START=19-08-2008 per_formula_functions.set_date 5
XXXX_FF_PKG.XXXX_CALCULATE_PAYROLL_PERIODS 5
Setting PAYROLL_YEAR_NUMBER_OF_PERIODS=24 per_formula_functions.set_nu5
XXXX_FF_PKG.XXXX_CALCULATE_PAYROLL_PERIODS 10
Setting PAYROLL_YEAR_FIRST_VALID_DATE=01-07-2010 per_formula_functions5
XXXX_FF_PKG.XXXX_CALCULATE_PAYROLL_PERIODS 15
per_formula_functions.get_date 1
PAYROLL_YEAR_FIRST_VALID_DATE=01-JUL-10 per_formula_functions.get_date5
Setting PAYROLL_YEAR_SD=01-07-2010 per_formula_functions.set_date 5
per_utility_functions.Get_Payroll_Period 5
Setting PAYROLL_PERIOD_START_DATE=01-07-2010 per_formula_functions.set5
Setting PAYROLL_PERIOD_END_DATE=07-07-2010 per_formula_functions.set_d5
Setting PAYROLL_PERIOD_NUMBER=14 per_formula_functions.set_number 5
per_utility_functions.Get_Payroll_Period 15
per_formula_functions.get_date 1
PAYROLL_PERIOD_START_DATE=01-JUL-10 per_formula_functions.get_date 5
per_formula_functions.get_date 1
PAYROLL_PERIOD_END_DATE=07-JUL-10 per_formula_functions.get_date 5
per_utility_functions.Get_Payroll_Period 5
Payroll Period not found per_utility_functions.Get_Payroll_Period 10 <==== payroll period not found!
per_formula_functions.raise_error 10

 

Changes

New payroll set up for semi-monthly payroll

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