Software utilised at the Scottish Public Pensions Agency: FOI release

FOI reference: FOI/18/01165
Date received: 18 April 2018
Date responded: 1 May 2018

Information requested

Information on databases and ERP systems used by the Scottish Public Pensions Agency.

Response

Information of Applications SPPA are running. (see below)

Applications SPPA are running for:
Finance:	Epicor & Scottish Government provided
HR:	Provided by Scottish Government
Payroll:	Altair & Web View Resource Link
Project:	MS Project
CRM:	Joomla & Drupal
Manufacturing:	None
Sourcing:	None
Invoice Scanning Tool:	None
Are you using Config Snapshot?	None
What BI Tool are you using?	None

What versions of the above are you running?	Epicor 10, Altair 7 & 8, Web View R20.
When was your last Application upgrade?	Web View R20: April 2018
	Altair: February 2018
	Ongoing upgrade to Epicor 10 for Epicor due to complete in June 2018
Are you planning another upgrade in the next 12 – 18 months?	No
Do you have an Oracle support partner for applications? If so, who?	No
Do you have an SAP support partner for applications? If so, who?	No
What kind of support is included in the contract/s (functional/technical/etc?)	Software Support for all.
What is the value of the SAP application support contract, and when does it end?	Not applicable. SPPA does not have SAP support.
What is the value of the Oracle application support contract, and when does it end?	Not applicable. SPPA has no direct Oracle application support.
When does the SAP and/or Oracle contracts expire?	Not applicable (see above).

Are you running any Oracle Databases? If so, what versions are you running?	Yes. All are on 11g R2.
Are you running any SAP Databases? If so, what versions are you running?	No
What applications are being run on these databases?	Altair & Web View
Are you planning another Database upgrade in the next 12 – 18 months?	No
Do you have an Oracle support partner for Databases? If so, who?	Standard Oracle DB Support with Oracle
Do you have an SAP support partner for Databases? If so, who?	No
What is the value of the database support contract for SAP, and when does it end?	Not applicable. SPPA does not have Database support contract with SAP.
What is the value of the Database support contract for Oracle, and when does it expire?	Supported internally
Where are the Databases held - Hosted onsite/offsite?	Onsite
If not, how many in-house DBAs do you have?		Six

Where do you advertise any Oracle and/or SAP procurement opportunities?	Public Contracts Scotland
Who is responsible for looking after the contract for the Oracle and/or SAP estate?	IT Manager
Who is responsible for looking after the licences for the Oracle and/or SAP estate?	IT Manager
How much do you pay annually for Oracle Support & Maintenance, and when does it renew?	Altair: £13,967 (January 2019)
	Web View: £17,800 (March 2019)
How much do you pay annually for SAP Support & Maintenance, and when does it renew?	Not applicable. SPPA does not have Support & Maintenance with SAP.
Do you work with off-shore partners?	No

About FOI

The Scottish Government is committed to publishing all information released in response to Freedom of Information requests. View all FOI responses at http://www.gov.scot/foi-responses