WorkDay Tutorial-ACTIVITY – sheet with child data to manage Lang

 Business Case: Now that you generated the Manage Languages spreadsheet, you've been asked to populate it with the data below for Chad Anderson and Anthony Rizzo. Once populated, launch the integration system using your spreadsheet and verify the results. You may need to run the Integration IDs report to help you find the correct reference ID values.

Employee

Language Skill

Proficiency

Ability

Assessed On

Assessed By

Chad Anderson

French

Intermediate

Overall

2/1/2014

Logan McNeil

 

Russian

Fluent

Speaking

2/1/2014

Logan McNeil

Anthony Rizzo

Spanish

Beginner

Speaking

4/1/2014

Logan McNeil


TASK 1: FIND THE REFERENCE ID TYPE VALUES 

Run Integration IDs Report 

1.       Type Int IDs into the Search box and hit the search button 

2.       Click the Integration IDs report link

3.       For Business Object, search for Language and choose the Language Ability Type, Language Proficiency, and Language Skill Business Objects then run the report. 

Make a note of the Reference ID values you will be required to populate into the spreadsheet. 


TASK 2: POPULATE THE EXCEL SPREADSHEET 

1.       Click on the Overview tab and select Automatic Processing for the Manage Language Business Process


2.    Click on the Manage Languages tab and populate the following information:





TASK 3:        LAUNCH THE EIB AND UPLOAD THE SPREADSHEET ATTACHMENT 

1.       Search for the string WICT EIB Manage 

2.       Use the related action icon next to the WICT EIB Manage Language Integration System to select the Integration > Launch / Schedule task 


3.       Click OK to Run Now 

4.       For the Integration Attachment field Value on the far right, click on the  icon

5.       Click on Create > Create Integration Attachment 

6.       Click the Attach button 

7.       Locate your file (Manage Language.xml) and select it

8.       When the upload completes,  click OK 

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

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

11.   Click OK and Refresh until process is complete  (Do not close) 

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

13.   Once transferred to the View Background Process report – validate success


You should also view the Business Processes Loaded tab


TASK 4: FINAL VALIDATION

              1.       Search for the string Anderson 

2.       Use the related action off of Chad Anderson's Employee Object navigate to Talent > View Skills and Experience, and then choose the Languages tab. 

3.       Repeat the steps for Rizzo