iSetup: The Saviour who Saved 2000 hrs in our Financial Project

1. 10314 iSetup- The Saviour who Saved 2000 hrs. in our Project Involving Financials for 352 Operating Units 25-April-2018 Vicky Adwani Manager Hitachi Consulting

2. Introduction Vicky Adwani Manager

3. Table of Contents • About the Client and Project • Business Case/Requirement • Why iSetup? • iSetup Solution-Key Features (with worked example) • Hints and Tips • What to watch out for ? • Advantages • Savings • Appendix

4. About the Client and Project

5. About the Client • Ministry of Singapore Client • Founded in 1960 • Manages 410 schools in Singapore • 33000 Education officers • Annual Education budget- 12.9billion SGD in 2017

6. About the Project • Application Footprint • EBS 12.2.6 implementation Financials Hyperion P&B Oracle BI Fixed Deposit (Custom) 5

7. About the Project Enterprise Structure Business Group HR Ledger GL Legal Entity Operating unit 1 Operating unit 2 Operating unit 3 Operating unit 352 AP, AR AP,AR AP,AR AP,AR • HR=Human Resources • AP=Accounts Payables • GL=General Ledger • AR=Accounts Receivables

8. Business case/Requirement

9. Business Case/Requirement Configure AP and AR for 352 OU’s in UAT environment School 1 School 3 School 2 School 352 OU 3 OU 352 OU 1 OU 2 AR AP AR AP AR AP AP AR • UAT=User Acceptance Testing • OU=Operating Unit • AP=Accounts Payables • AR=Accounts Receivables

10. Why iSetup?

11. Why iSetup? • Possible Solutions • Data Loader- Tool which picks up data from excel in desired format and creates config in system. • Manual- Manual entry • iSetup- Spreadsheet load option. Migration and Reporting tool.

12. Why did we chose iSetup?

13. iSetup Solution-Key Features (with worked example)

14. iSetup Solution Key Features • Introduction • Data Migration and Reporting tool • Move setup data (Complete or partial) across instances or copy data within the same instance • Generate Reports on setup data

15. iSetup Solution Key Features • Product Coverage-Over 250 different setups in R12

16. iSetup Solution Key Features • High Level Solution Configure Extract Populate Load Validate

17. iSetup Solution Key Features • Register instance

18. iSetup Solution Key Features • Selection Sets- Template

19. iSetup Solution Key Features • Selection Sets- Parameters/Configs.

20. iSetup Solution Key Features • Selection Sets- Filters

21. iSetup Solution KeyFeatures • Extract

22. iSetup Solution Key Features • Download Zip Extract

23. iSetup Solution Key Features • Zip Extract Structure Actual setup data

24. iSetup Solution Key Features • Downloaded XML Extract- Receivables System Options sample file

25. iSetup Solution Key Features • Open XML Extract in excel

26. iSetup Solution Key Features • Spreadsheet version of XML file type

27. iSetup Solution Key Features • Populate data for other Operating units in spreadsheet

28. iSetup Solution Key Features • Create XML data file from worksheet data

29. iSetup Solution Key Features • Save the file as XML

30. iSetup Solution Key Features • Ensure Header and Trailer match with original XML downloaded

31. iSetup Solution Key Features • Zip the extract

32. iSetup Solution Key Features • Upload the extract

33. iSetup Solution Key Features • Extract Uploaded

34. iSetup Solution Key Features • Load Extract

35. iSetup Solution Key Features • Load Extract 31

36. iSetup Solution Key Features • Enable Deployment Report/Update Records

37. iSetup Solution Key Features • Load Completed

38. iSetup Solution Key Features • Record Count successfully loaded

39. iSetup Solution Key Features • Log file/Deployment report

40. iSetup Solution Key Features • Validate the data loaded- Generate Extract

41. iSetup Solution Key Features • Extract Generated

42. iSetup Solution Key Features • Use Extract to submit Report

43. iSetup Solution Key Features • Report output

44. iSetup Solution Key Features • Validate System options created

45. iSetup Solution Key Features • Dependencies • Majority of errors would come because of dependencies problem • Trying to load a child record prior to loading a parent record Operating Units Load Order Dependencies Payables Financial Options Receivables System Options

46. Hints and Tips

47. Hints and Tips • Create Custom Selection sets when required parameters/configs. not available out of box • Load Deposit Transaction types after Invoice transaction type load completion (Dependency) • Take Technical help to convert excel file into XML type if a setup has multiple layers of data (E.g.- Receipt Class> Receipt Method> Bank Accounts assignments) • Ensure mandatory patches as mentioned in Doc Id 1480802.1 are applied

48. Hints and Tips • Do not modify the column names in the downloaded extract • Do not alter sequence of columns in the downloaded extract • Do not change the name of the downloaded extract file • Can be used to update config. records also. Attributes update allowed only if updateable from front end • Solution can provide massive value addition in projects where voluminous setups is required to be configured • Extract and load one setup at a time

49. What to watch out for?

50. What to watch out for • Ensure parent setup is loaded before loading a child setup • Some of the basic configs. not available out of the box (E.g.- Cross Validation rules, Account Alias, EBTAX, etc.) • Error Messages in the log file and deployment report are too technical • Receivables Auto Accounting load was successful after application of patch as mentioned in Doc ID 2215618.1