You can download and upload edited spread sheets in XML format, CSV format and HR Tables using APIs and the data pump.

To upload and download spread sheets using APIs:

First, open the applicable function from the Configuration Workbench menu or click the Test icon on the People Data Function and Layout page and do the following:

1. Set the Do You Want to Upload Data as a Batch Process field to NO.

2. Select the applicable Source Business Group.

3. Select the applicable Target Business Group.

4. Set Do you want to Search option to Yes to filter information that you want to download in the spreadsheet. Otherwise, set to NO to download all records in the spreadsheet

5. If you have set the option in step 6 to YES, then select the applicable parameters on the Person Search page.

6. Click Launch the Spreadsheet.

   To upload spread sheets to data tables using the data pump:

1. Set the Do You Want to Upload Data as a Batch Process field to Yes.

2. Set Run Data Pump to No to load the data from spreadsheet to Data Pump tables

3. Provide a Batch Prefix.

4. Select the applicable Source Business Group.

5. Select the applicable Target Business Group.

6. Set Do you want to Search option to Yes to filter information that you want to download in the spreadsheet. Otherwise, set to NO to download all records in the spreadsheet

7. Click Continue

8. If you have set the option in step 6 to YES, then select the applicable parameters on the Person Search page.

9. Click Launch the Spreadsheet.

   To run the data pump:

1. Set the Do You Want to Upload Data as a Batch Process field to Yes

2. Set Run Data Pump Flag to Yes

3. Select the applicable Target Business Group.

4. Select the Batch Name from the list

5. Click Process Batch Lines

   For information on Data Pump, see: Oracle HRMS Data Pump

   To upload spreadsheets in XML and CSV format:

1. Browse and select the applicable XML or CSV data.

2. Select the applicable Target Business Group.

3. Click Launch Spreadsheet to upload the data.