Mexico SUA Interface Extract Worker Data output file (File EFT_12) Is Incorrect If Social Security Archiver Is Run For Both Hire And Separation At Same Time

(Doc ID 1923000.1)

Last updated on DECEMBER 20, 2016

Applies to:

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


On : 12.1 HRMS RUP7 version, PAY Reports


When an employee is hired, terminated and Social Security Archiver is run for both The Hire and Separation transactions at the sametime,SUA Interface Extract Worker Data output file is reporting the incorrect employee hire date.

Expect SUA Worker Data output file (File eft_12) to show the actual Hire Date of employee

The issue can be reproduced at will with the following steps:

Bi-Week Payroll Period 7-JUL-2014 to 20-JUL-2014

1. Hire employee on 07-jul-2014
2- Separation date 20-jul-2014.
3- Run Social Security Archiver.  This produces the Employee Record, Transactions 08 (Hire) and 02 (Separation)
4- Run SUA interface extract
file 12 (worker data file) the employee’s hire date is appearing as 21-jul-2014


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