Multiple Worksite Report (MWR) .mf File Format is not in the Correct Format

(Doc ID 2156380.1)

Last updated on APRIL 10, 2017

Applies to:

Oracle HRMS (US) - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

The Multiple Worksite Report .mf file has been rejected by the Bureau of Labor Statistics (BLS). The .mf file currently produces all records in one single line, but the BLS requires each record to be on a separate line.

Excerpt from the BLS Electronic Data Reporting brochure:

Chapter 3:
• Each CES and MWR file format begins with the 17 common data elements and are 350 characters long;…
• For each program (CES or MWR), the employer should generate a data record in the standardized flat file format for each establishment…


Link to the BLS brochure: http://www.bls.gov/cew/cewedr00.pdf


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Run Multiple Worksite Report for State Periodic Wage Listing Enhanced (SPWL)
2. Submit .mf file to Bureau of Labor Stats (BLS)


Cause

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