Fusion Global Payroll: Duplicate Columns within Payroll Batch Loader (PBL) Task/Task Action Combo for U.S. Regional Data (Doc ID 1996615.1)

Last updated on APRIL 06, 2015

Applies to:

Oracle Fusion Global Payroll - Version 11.1.9.2.0 to 11.1.9.2.0 [Release 1.0]
Oracle Fusion Global Payroll Cloud Service - Version 11.1.9.2.0 to 11.1.9.2.0 [Release 1.0]
Information in this document applies to any platform.

Symptoms

When loading state specific regional data for the employee withholding certificate via payroll batch loader, many of the states have duplicate columns in the spreadsheet
AR, DC, GA, IA, IN, KY, LA, MA, MD, ME, MO, MS, NC, NY, OH, PA, VA, WI, WV
AL is OK

The issue can be reproduced at will with the following steps:
1. Navigator>Payroll>Administration
2. Click the Batch Loader task
3. Click the Download button
4. On the Opening DesktopGenericBatchLoader.xlsx pop-up, select to Open with Microsoft Office Excel and click the OK button
5. On the Login pop-up, click Yes, to Do you want to connect?
6. Login in using your Fusion log in credentials
7. On the Batch Header Sheet, in the Search Results region, enter a Batch Name and select the applicable Legislative Data Group (usually line 15 on the spreadsheet)
8. Click the Save button
9. On the Upload Options, select the desired option and click the OK button
10. Double-click the Batch Name
11. Click to navigate to the Batch Content Sheet
12. On the Batch Content Sheet, click the Add button
13. In the Task Name search field, enter Regional and click the Search button.
14. Highlight the following record:
Task Action: US Employee WithHolding Regional Card
Task Action Name: Select the state specific record
15. Click the Ok button
16. Double-click the Task Action Name on the Batch Content Sheet. This will invoke the fields to be used to upload the data
Review for duplicate columns



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