Payroll Archive Process Error: ORA-20001: Error at step 15 in pay_ac_action_arch.get_xfr_elements (Doc ID 1590780.1)

Last updated on OCTOBER 09, 2013

Applies to:

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


Some employees are erroring in the Payroll Archive process. 

Payroll Archive Error

Error ORA-20001: Error at step 15 in pay_ac_action_arch.get_xfr_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 h


The same employees are getting a different error when attempting to display their SOEs.

SOE Error

ORA-20101: Error in pay_us_soe_balances_pkg.populate_state_balance - ORA-20001: Assertion failure detected at location get_new_latest_bal_value:1.
Cause: an internal error has occurred at location get_new_latest_bal_value:1.
Action: please contact your Oracle customer representative.
ORA-06512: at "APPS.PAY_US_SOE_BALANCES_PKG", line 2118

FRM-40735: KEY-EXEQRY trigger raised unhandled exception ORA-20101.

My Oracle Support <Note 1550131.1> states for the SOE error to request a datafix solution by creating a service request and reference document number 1550131.1


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