WorkDay Tutorial-ACTIVITY – Populating customized spreadsheets

 Business Case: Now that you generated the spreadsheet, you've been asked to populate it with the Bonus Payment data below, launch the integration system and verify the results.

TASK 1:       REVIEW REPORT 

1.       Search the tenant for a report called WDINST EIB Sales & Marketing Payments. 

2.       Run the report and review the output. You will use this report to locate the necessary reference IDs and to validate the data loaded by your integration system.

 

TASK 2:  POPULATE THE EXCEL SPREADSHEET 

1.       Open the Request_Bonus_Payment.xml file created and saved in the previous activity 

2.       On the Overview tab, select automatic processing for the BP (Request Bonus Payment)


3.       Enter the information below into the correct columns on the Request Bonus Payment Tab. Some of the values are accessible from a report that is provided for you called WDINST EIB Sales & Marketing Payments:


TASK 3:        LAUNCH THE INTEGRATION 

1.       After the spreadsheet is populated, search for 'WICT EIB' in your tenant and select WICT EIB 

Load Bonuses for Sales & Marketing. Don’t forget to select the Integrations category. 

2.       On the related actions menu, navigate to Integration > Launch/Schedule 

3.       Leave the default value "Run Now" and click OK 

4.       In the Integration Attachment Value prompt,  select Create > Create Integration 

Attachment 

5.       Click Attach and navigate to your saved spreadsheet 

6.       Once the upload completes, then click OK 

7.       Select Specify Value for Validate Only Load and check the box 

8.       Select Specify Value for Add Errors to Attachment and check the box

9.       Click OK and wait for process to complete  (Do not Close)

10.   If completed successfully, re-run the integration without Validate Only selected. Re-use the same integration attachment created above.

11.   Run the WDINST EIB Sales & Marketing Payments  report to verify the results.