To run the Social Security Affiliation Report:The Oracle HR Social Security Affiliation reports comply with the Social Security agencies requirement to deliver employee status changes on a timely basis.
The Oracle HRMS supports the following Social Security Affiliation reports for reporting employment changes:
Transaction Type 02: Worker separation notification (for terminations)
Transaction Type 07: Social Security Affiliation report for reporting employee salary
Transaction Type 08: Worker Social Security enrollment notification (for new hires)
For employment changes, you must notify the Social Security agencies within 5 days of the employment status change. For changes to fixed salaries, you must notify the Social Security agencies within 5 days of the salary change. For changes in variable salaries, you must submit your report every other month, within the first 5 days of the month.
The Social Security Affiliation Report collects all worker employment and salary changes that were archived by the Social Security Archiver, and it produces the following output files:
Exceptions file for person records
Summary PDF report
Exceptions file for salary modification transactions
Audit file for salary modification transactions
Magtape file for salary modification transactions (Transaction Type 07)
Exceptions file for separation transactions
Audit file for separation transactions
Magtape file for separation transaction (Transaction Type 02)
Exceptions file for hire transactions
Audit file for hire transactions
Magtape file for hire transactions (Transaction Type 08)
See: Social Security Affiliation Reports
Perform the following steps to report an employment or salary change:
To run the Social Security Affiliation Report:Once the Social Security Archiver process finishes running, run the Social Security Affiliation Report to generate DISPMAG-formatted files for submission to the Social Security Institution. This concurrent program generates the Social Security Affiliation Report for hire and separation transactions. The reports are generated in the layout specified by the DISPMAG format. It uses data archived by the archiver process. It is therefore, mandatory to run the archiver process before running the affiliation report. The report picks up all the archived transactions that have not been reported earlier.
The affiliation report interlocks all the archive records that are reported on the file. This ensures that you cannot alter the archived data after it has been reported on an affiliation report. You have to rollback an affiliation report before you can make changes to the underlying archived data.
The Social Security Affiliation Report locks the Social Security Archiver process.
Select Social Security Affiliation Report in the Request Name field.
Click in the Parameters field if the Parameters window does not automatically open.
Select the legal employer. You can view all the legal employers under the business group. You can submit the process for a legal employer, so that the report generated includes information of all the GREs under that legal employer.
Select the transmitter GRE. The transmitter GRE represents multiple GREs, allowing you to submit one report for all members. If you do not select a transmitter GRE, then the process runs for all the GREs under the legal employer selected in the previous step.
Note: If you select a transmitter GRE that has not been archived by the Social Security Archiver, the reports you generate here will be empty.
Click OK and then Submit.
The Social Security Affiliation Report produces 11 output files and stores them in the $APPLCSF/out directory. The information displayed in output files will be in order of the 'Employer SS ID'.
Click View Output to view these reports.
Oracle HRMS displays an HTML page with links to each of the reports.
These reports use the following naming convention:
AFFLXAAA11111mmddyyhhmiss_##_P.eft
If the process is submitted for Legal Employer:
X represents L
AAA represents first three characters of Legal Employer name
11111 represent first five characters of Legal Employers organization ID
If the process is submitted for a Transmitter GRE:
X represents G
AAA represents first three characters of Transmitter GRE name
11111 represent first five characters of Transmitter GREs organization ID
mmddyyhhmmss represents the month, day, year, hour, minute, and second you generated this report.
## represents the report number:
Exceptions file for person records
Summary PDF report
Exceptions file for salary modification transactions
Audit file for salary modification transactions
Magtape file for salary modification transactions (Transaction Type 07)
Exceptions file for separation transactions
Audit file for separation transactions
Magtape file for separation transaction (Transaction Type 02)
Exceptions file for hire transactions
Audit file for hire transactions
Magtape file for hire transactions (Transaction Type 08)
To view exception errors:Missing data for the following fields causes the record to be written to the exception reports (reports 1, 3, 6, and 9):
Employer Social Security ID
Employee Social Security Check Digit
Paternal Last Name
Employee First or Second Name
IMSS Waybill Number
Hire Date (for hires only)
Worker Type
Salary Type
IDW (Integrated Daily Wage)
Reduced Working-week indicator
Separation Date (for separations only)
Leaving Reason (for separations only)
Effective Date of Transaction
If your Social Security Affiliation Report fails, you can view the exception error reports to determine why.
The exception report files are CSV formatted files and are viewable through any spreadsheet.
To view the output files:Navigate to the Payroll Process Results window.
Query the Social Security Affiliation Report.
Click Output.
Select a file to view from the list of values.
A new window (File Viewer) opens in your web browser, with a list of the output files.
On the File Viewer window, select a file from the "Files Available" section.
This file displays in the "Download File" section.
Select the link in the "Download File" section to view the contents of the file.
To retry the Social Security Affiliation Report:When you run the Social Security Affiliation report, it interlocks the specified employee and salary records to prevent anyone from altering them. To make changes to the archived data, or reproduce a lost output magnetic file, you must first rollback the Affiliation report.
Perform a retry operation whenever you have data corrections to make that affect fewer than 10 employees. For changes that affect 10 or more employees, you must perform a rollback operation.
Mark assignments for retry in the Employee Assignment Process window. You can also run this process for an assignment set but not for a dynamic assignment set. If there are no employees in the GRE, you cannot perform a retry. You retry the employment changes reports from the Submit Requests window.
Note: If you have already run the Social Security Affiliation Report, you must first roll it back before you can retry the Social Security Archiver.
To retry the Social Security Affiliation Report:
In the Name field, select Retry Payroll Process.
Click in the Parameters field if the parameters window does not automatically appear.
Select the payroll process you want to retry.
Click OK and then Submit.
To roll back the Social Security Affiliation Report:Perform a rollback operation whenever you have data corrections/changes that affect 10 or more employees.
Note: If you have already run the Social Security Affiliation Report, you must first roll it back before you can roll back the Social Security Archiver process.
To roll back Social Security Affiliation report:
In the Name field, select Rollback MX Social Security Process.
Click in the Parameters field if the parameters window does not automatically appear.
Select the payroll process you want to roll back.
Click OK and then Submit.