E1:05: EEO-1 Report Data File UBE (R89058515) Does Not Create a .CSV File (Doc ID 3001350.1)

Last updated on JANUARY 31, 2024

Applies to:

Symptoms

EEO-1 Report Data File UBE (R89058515) Does Not Create a .CSV File. The file is in TXT format with 1319 positions per record which is acceptable for upload but harder to work with.

The CSV format is requested. CSV would have a comma between each field and would be easier to work with to verify data and correct errors before the final upload

Below are the customer's concerns about this issue:

1. In the past the client has printed the report and then manually entered the values in the government website.
2. EEO-1 Report (R058515) prints the report.
3. EEO-1 Report (R058515) PDF shows the Number of Employees by 10 Job Categories in a Given Address Location.
4. The EEO-1 Report Data File UBE (R89058515) takes the data from the Report and puts it in a text file with no “TXT” extension and with no commas between data fields.
5. When viewed in Notepad with Word Wrap on, it looks like multiple lines of text.
6. When viewed in Textpad with no Word Wrap it is one unbroken string of text. Either way it is difficult to compare with the PDF report.
7. The customer is concerned about uploading the file on the government website because they have to submit the file by location and they have 36 locations they have to upload.
8. They are afraid of the data being rejected and being unable to verify the data they are sending is accurate.
9. They are going to try uploading for the first time in April 2224 and they don’t know how to test it on the government website before submitting the final data.

BUSINESS IMPACT:

The customer has 36 locations to upload and is concerned about the difficulties of working with a file with one long unbroken string of text if they have to identify and correct errors if the file is rejected.

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.