2 Replies Latest reply on Dec 3, 2018 2:26 PM by vikaserp

    Payroll external archiver error

    jeffb1

      Running Payroll External Archiver process (payusxfr). For nearly all employees it gives:

       

      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
      ORA-06512: at "APPS_APPLMGR.PAY_ARCHIVE", line 1234
      ORA-06512: at line 3

      Action:        Please contact your support representative.

       

      Have a Severity 1 SR with Oracle but no solutions to date. Can anyone assist?