The Office of Personnel Management (OPM) requires agencies to submit retirement data about their employees to process retirements for Federal employees in a timely and accurate manner. OPM has detailed data reporting requirements for the Electronic Retirement Record (ERR) Data Feed. Oracle Federal HR provides the 'Retirement Data Report' to accomplish the reporting needs of the Guide to Human Resources Reporting (GHRR).

Important: This report is unique to OPM requirements as both HR and Payroll data must be submitted in the same file. As US Federal HR customers do not process with integrated payroll functionality, the extract files reflect only the HR Data. The Payroll provided segments must be merged with this report format at the sending site. The customers' payroll system is responsible for taking the HR Data provided, adding the Payroll data and then submitting the final transmission to OPM.

You must run the Retirement Data Report program first in a 'Preview Mode'. The Preview Mode enables HR users to review the data for accuracy and completeness. Once the HR user completes this review, the program can be submitted in a 'Final Mode', which creates the data file that is then sent to payroll for merging and final transmittal to OPM. Reports created are in XML format. The HR User can view the reports as a text file when opened from the View Log.

Use the Request Submit window.

   To run the Retirement Data Report:

1. In the Name field, select Retirement Data Report.

2. Click the Parameters field to open the Parameters window. Enter the required parameters:

   • File Name: Name that you want to assign to the output file

   • Business group: Business group for which you want to run the report.

   • Agency Code

   • Sub Element

   • Additional Agencies or sub Element

   • HR Data Provider Code

   • Report Start Date

   • Report End Date

   • Processing Mode: Run the Retirement Data Report program first in a 'Preview Mode'.

3. Click OK to accept the Parameters and close the window.

4. Click Submit to generate the report.

5. To locate the path of the ASCII and XML files, in the View Requests window, select the row for the report and click View Log. The report generates an ASCII and an XML file. You can submit the resulting ASCII output to the OPM.