E1: 07: SUI Reporting for California Has a No Record Count in the PDF/ .txt Export File (R078300/R078305) (Doc ID 2921549.1)

Last updated on JANUARY 17, 2023

Applies to:

Symptoms

1. After applying the ESU associated to Bug 30164716 - CHANGING PROCESSING OPTION GLOSSARIES AND DATA SEQUENCING ON THE R89078305, the export R89078305 California's SUI text file is not showing a correct record when running quarter 1 or 3. Quarter 2 is fine. 

2. The two other reports called have errant header records populated on the detail output.

Reports:
R078305 / R89078305 / XJDE0001     (Report ending in 05 indicates the state of California SUI report.)
R078305C1 / R89078305 / XJDE0001
R078305S / R89078305D / XJDE0001

Steps to Duplicate:
Test 1
1. Go to State Specific SUI Report(s) Through State Unemployment Report Setup (P074001R).
2. Pre-Requisite: The processing options on each of the SUI reports is specific to that state.
3. Verify that the appropriate values are entered in the processing options before running the report. (ie - correct quarter and year).
4. Select the State Specific SUI report for the state being processed. Two reports are shown, one for the state PDF and the other for the file file creation. The last two numbers of the reports indicate the state.
5. Check the PDF and/or the .txt export for the record count on the CA SUI report.

Test 2
1. Run the CA SUI report and call the additional reports R078305C1 and R078305S.
2. Review the output and note there should be one header record and many detail lines.
3. The results show many detail lines with header records dispersed throughout the report in an errant manner.

Cause

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