FOI Request - IT Systems
Request 101002954926
1. What Applications and versions are you running and what was the value of the contracts for:
• a. Finance?
• b. HR?
• c. Payroll?
• d. Projects?
• e. Business Intelligence Software Tools?
2. Are you planning a IT system upgrade in the next 12-18 months?
3. How many Full Time Employees do you have (excluding employees at Schools)?
4. Which Enterprise Resource Planning (ERP) or Finance system do you currently use?
a. What is the value & expiry date of your current contract/licence? What are the extension options?
5. How many Finance system users do you have?
6. How many Purchasing system users do you have?
7. Which Supply Chain Management (SCM) System do you currently use?
a. What is the value & expiry date of your current contract/licence? What are the extension options?
8. Which Enterprise Performance Management (EPM), Scenario Planning or Strategic Modelling system do you currently use?
9. What is the value & expiry date of your current contract/licence? What are the extension options?
10. Which Human Capital Management (HCM) or HR system do you currently use?
a. What is the value & expiry date of your current contract/licence? What are the extension options?
11. How many HR system users do you have?
12. Do you have a Digital Transformation Strategy?
13. What parts of your Digital Transformation Strategy are you looking to implement in the next 12-18 months?
14. Do you have any plans to migrate to a fully integrated, fully cloud based back-office system in the next two years
15. Do you have an Oracle support partner for applications? If so who?
What kind of support is included in the contract (functional/technical/etc.?)
When does it expire?
16. Are you running any Oracle Databases?
If so, what versions are you currently running?
What applications are being run on these Databases?
Are you planning another Database upgrade in the next 12-18 months?
17. Do you have an Oracle support partner for Databases? If so who?
What is the per annum value of the database support contract?
When does it expire?
Where are the databases held? Hosted, onsite/offsite?
If not, how many in-house DBAs do you have?
18. Where do you advertise any Oracle procurement opportunities?
Who is responsible for looking after the contract for the Oracle estate?
Who is responsible for looking after the licenses for the Oracle estate?
When does this contract renew?
Do you work with off-shore partners?
19. Have you considered using a Software As A Service solution and not yet moved to one? Do you currently work with any partners in this space?
20. At what level are decisions are made around procuring software and services such as video conferencing?
21. We request for you to provide contact details of all chief decision makers regarding your technology through your organisation?
Response 26-01-22
1. What Applications and versions are you running and what was the value of the contracts for:
• a. Finance? e5.5 FMS / Cognos 11.2
• b. HR? iTrent 10.40.02
• c. Payroll? iTrent 10.40.02
• d. Projects? Pentana
• e. Business Intelligence Software Tools? Business Objects - SAP BI 4.2 used by iTrent, CareFirst, iWorld, Servitor and Talis.
2. Are you planning a IT system upgrade in the next 12-18 months? Of the systems above we are looking to upgrade FMS in the next 12-18 months.
3. How many Full Time Employees do you have (excluding employees at Schools)? 1405
4. Which Enterprise Resource Planning (ERP) or Finance system do you currently use? We don’t use an ERP but use Advanced e5 for accounting and financial management.
a. What is the value & expiry date of your current contract/licence? What are the extension options? This information falls under Section 25 of the Freedom of Information (Scotland) Act 2002 - Information otherwise accessible. This information can be found here:- http://www.moray.gov.uk/downloads/file101332.pdf
5. How many Finance system users do you have? 716 users
6. How many Purchasing system users do you have? 368 users
7. Which Supply Chain Management (SCM) System do you currently use? We are not aware of a system that fits that description.
a. What is the value & expiry date of your current contract/licence? What are the extension options? This information falls under Section 25 of the Freedom of Information (Scotland) Act 2002 - Information otherwise accessible. This information can be found here:- http://www.moray.gov.uk/downloads/file101332.pdf
8. Which Enterprise Performance Management (EPM), Scenario Planning or Strategic Modelling system do you currently use? We are not aware of a system that fits that description.
9. What is the value & expiry date of your current contract/licence? What are the extension options? We are not aware of a system that fits that description.
10. Which Human Capital Management (HCM) or HR system do you currently use? See answer to 1 above
a. What is the value & expiry date of your current contract/licence? What are the extension options? This information falls under Section 25 of the Freedom of Information (Scotland) Act 2002 - Information otherwise accessible. This information can be found here:- http://www.moray.gov.uk/downloads/file101332.pdf
11. How many HR system users do you have? It is a combined HR/Payroll system. There are 20 system users for the combined system
12. Do you have a Digital Transformation Strategy? Yes
13. What parts of your Digital Transformation Strategy are you looking to implement in the next 12-18 months?
Moray Council's transformation approach is contained within the corporate plan, digital transformation strategy and Improvement and Modernisation Plans. Links to these are as follows:
Link to Moray Council Corporate Plan: http://www.moray.gov.uk/moray_standard/page_41074.html
Link to Improvement Modernisation Programme (IMP) 12/12/2018:
- https://moray.cmis.uk.com/moray/Document.ashx?czJKcaeAi5tUFL1DTL2UE4zNRBcoShgo=h4QKqU%2bCWy%2bhWzhaC5TgkwjRuKeaMHBzbcOrOI3YoKgxUHMnKryrjQ%3d%3d&rUzwRPf%2bZ3zd4E7Ikn8Lyw%3d%3d=pwRE6AGJFLDNlh225F5QMaQWCtPHwdhUfCZ%2fLUQzgA2uL5jNRG4jdQ%3d%3d&mCTIbCubSFfXsDGW9IXnlg%3d%3d=hFflUdN3100%3d&kCx1AnS9%2fpWZQ40DXFvdEw%3d%3d=hFflUdN3100%3d&uJovDxwdjMPoYv%2bAJvYtyA%3d%3d=ctNJFf55vVA%3d&FgPlIEJYlotS%2bYGoBi5olA%3d%3d=NHdURQburHA%3d&d9Qjj0ag1Pd993jsyOJqFvmyB7X0CSQK=ctNJFf55vVA%3d&WGewmoAfeNR9xqBux0r1Q8Za60lavYmz=ctNJFf55vVA%3d&WGewmoAfeNQ16B2MHuCpMRKZMwaG1PaO=ctNJFf55vVA%3d
Link to IMP Update – 14/01/2020:
https://moray.cmis.uk.com/moray/Document.ashx?czJKcaeAi5tUFL1DTL2UE4zNRBcoShgo=rDPYo%2f6uWInp3wND6LRHjO5IL%2fnF51YngM340PcCePniRYSMMV7Cow%3d%3d&rUzwRPf%2bZ3zd4E7Ikn8Lyw%3d%3d=pwRE6AGJFLDNlh225F5QMaQWCtPHwdhUfCZ%2fLUQzgA2uL5jNRG4jdQ%3d%3d&mCTIbCubSFfXsDGW9IXnlg%3d%3d=hFflUdN3100%3d&kCx1AnS9%2fpWZQ40DXFvdEw%3d%3d=hFflUdN3100%3d&uJovDxwdjMPoYv%2bAJvYtyA%3d%3d=ctNJFf55vVA%3d&FgPlIEJYlotS%2bYGoBi5olA%3d%3d=NHdURQburHA%3d&d9Qjj0ag1Pd993jsyOJqFvmyB7X0CSQK=ctNJFf55vVA%3d&WGewmoAfeNR9xqBux0r1Q8Za60lavYmz=ctNJFf55vVA%3d&WGewmoAfeNQ16B2MHuCpMRKZMwaG1PaO=ctNJFf55vVA%3d
14. Do you have any plans to migrate to a fully integrated, fully cloud based back-office system in the next two years No
15. Do you have an Oracle support partner for applications? If so who? Application Specific
What kind of support is included in the contract (functional/technical/etc.?) When does it expire? Various
16. Are you running any Oracle Databases? Yes
If so, what versions are you currently running? Various 11g (CareFirst), 12c (FMS), 19c (housing)
What applications are being run on these Databases? Various e5 FMS, iWorld Housing, CareFirst, IDOX, Servitor.
Are you planning another Database upgrade in the next 12-18 months? As required
17. Do you have an Oracle support partner for Databases? If so who? Application Specific
What is the per annum value of the database support contract? Included with application support
When does it expire? This information falls under Section 25 of the Freedom of Information (Scotland) Act 2002 - Information otherwise accessible. This information can be found here:- http://www.moray.gov.uk/downloads/file101332.pdf
Where are the databases held? Hosted, onsite/offsite? Various on-site
If not, how many in-house DBAs do you have? 2
18. Where do you advertise any Oracle procurement opportunities? https://www.publiccontractsscotland.gov.uk/
Who is responsible for looking after the contract for the Oracle estate? ICT Information Systems Manager
Who is responsible for looking after the licenses for the Oracle estate? ICT Information Systems Manager
When does this contract renew? Various
Do you work with off-shore partners? No
19. Have you considered using a Software As A Service solution and not yet moved to one? Yes Do you currently work with any partners in this space? Yes
20. At what level are decisions are made around procuring software and services such as video conferencing? Information Systems Manager / Infrastructure Manager
21. We request for you to provide contact details of all chief decision makers regarding your technology through your organisation? This information falls under Section 25 of the Freedom of Information (Scotland) Act 2002 - Information otherwise accessible. Please see document located here: http://www.moray.gov.uk/downloads/file135050.pdf. Please note, where job titles have been marked 'N/A', this is because the post does not exist within the Moray Council structure.