My Oracle Support Banner

External Process Archive Errors in Various Packages.procedures (ie.Pay_us_action_arch.Update_federal_value, pay_ac_action_arch.populate_elements) with ORA-20001 ORA-06512 ORA-01722: INVALID NUMBER (Doc ID 339912.1)

Last updated on SEPTEMBER 01, 2017

Applies to:

Oracle HRMS (Canada) - Version 12 and later
Oracle HRMS (US) - Version 12 and later
Information in this document applies to any platform.
Concurrent Program: PAYUSXFR - External Process Archive


Symptoms

External Process Archive fails with:

HR_6881_HRPROC_ORA_ERR
SQLERRMC ORA-20001: Error in pay_us_action_arch.update_federal_values
ORA-06512: at "APPS.PAY_ARCHIVE", line 1199
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.update_federal_values
ORA-06512: at "APPS.PAY_ARCHIVE", line 1199
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.update_federal_values
ORA-06512: at "APPS.PAY_ARCHIVE", line 1199
ORA-06512: at line 3

 

OR

 

HR_6881_HRPROC_ORA_ERR
SQLERRMC ORA-20001: Error at step 15 in pay_ac_action_arch.populate_elements
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 at step 15 in pay_ac_action_arch.populate_elements
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 at step 15 in pay_ac_action_arch.populate_elements
ORA-06512: at "APPS.PAY_ARCHIVE", line 1207
ORA-06512: at line 3

 

 

With logging of GMEBFTZ on in Pay_action_Parameters (Running QP on one thread) we see the following error further down in log file:

pay_balance_pkg.get_rb_value                                            35
Leaving: pay_balance_pkg.get_rb_value                                   45
pay_ac_action_arch.populate_elements                                    120
pay_ac_action_arch.populate_elements                                    125
pay_ac_action_arch.populate_elements                                    200
Error at step 15 in pay_ac_action_arch.populate_elements-ORA-01722: invalid number     <============================
Error at step 20 in pay_ac_action_arch.get_current_elements-ORA-20001: Error at step 1
5 in pay_ac_action_arch.populate_elements
Error at step 10 in pay_ac_action_arch.first_time_process-ORA-20001: Error at step 15 in pay_ac_action_arch.populate_elements
Error in pay_us_action_arch.process_actions-ORA-20001: Error at step 15 in pay_ac_action_arch.populate_elements
Error at step 21 in pay_us_action_arch.action_archive_data-ORA-20001: Error at step 15 in pay_ac_action_arch.populate_elements

 

Run Quick Pay then Run PrePayment process successfully. Run External Process Archive which fails.

Changes

 

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
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.