Payroll and OTL - EBS (MOSC)

MOSC Banner

Announcements for Payroll and OTL can now be found in the Announcements - Payroll and OTL - EBS (MOSC) subcategory. Follow to be sure you don't miss a thing!

payroll exernal archiver failure (payusxfr)

edited Jan 15, 2019 2:23PM in Payroll and OTL - EBS (MOSC) 1 commentAnswered ✓

     Running the Payroll External Archiver and it is failing with:

HR_6881_HRPROC_ORA_ERR
SQLERRMC ORA-20001: Error in pay_us_action_arch.update_ytd_withheld
ORA-06512: at "APPS_APPLMGR.PAY_ARCHIVE", line 1234
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_ytd_withheld
ORA-06512: at "APPS_APPLMGR.PAY_ARCHIVE", line 1234
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_ytd_withheld

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

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

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center