City council Oracle megaproject got a code red – and they went live anyway
(2023/10/04)
- Reference: 1696410911
- News link: https://www.theregister.co.uk/2023/10/04/birmingham_city_council_oracle_project/
- Source link:
Massive local authority Birmingham City Council went live with new Oracle Fusion ERP software in April last year, knowing the system was likely to fail.
Since the introduction of the replacement for an ageing SAP financial management system, the council cannot close its books and file financial reports. The escalating costs of the project — which have risen from £20 million ($24 million) to an estimated £100 million ($121 million) — [1]have contributed to the council effectively becoming bankrupt las month .
According to a 12-page public interest report from auditors Grant Thornton, the Oracle system implementation was rated as "red" before going live and "included a significant number of items requiring a solution."
[2]
"The finance system had several adaptations that did not subsequently operate effectively. As such, the system is not able to fully meet the financial reporting needs of the Council including finance, human resources, and schools," the auditor said.
[3]
[4]
The Oracle implementation "significantly impacted" the Council's ability to function, Grant Thornton added, while numerous workarounds and manual interventions were needed to operate the system.
The problems implementing the new ERP system meant the council couldn't create an "outturn position" [financial forecast] for 2022/23 or a set of financial statements for the same year. Neither can it provide an up-to-date financial position for the current year, 2023/24.
[5]
"This has impacted on payments to suppliers and also on financial reporting for schools and other organisations that use the Council's financial services," the report said.
Grant Thornton also highlighted concerns over security and governance. The auditors said "some IT security systems were not implemented and there is an inadequate segregation of duties in the system."
From 2019, the council had planned to implement Oracle out-of-the-box and change its processes to fit the system. However, [6]a report earlier this year said council's officers began to change this approach and customize Oracle.
[7]
"This shift in emphasis (from adoption to adaptation) has severely impacted upon the council's ability to properly implement the Oracle system."
In its [8]most recent plans , the council said it would work with Oracle Consulting and go back to its "out of the box Oracle vision."
Insiders have told The Register that the functionality provided by the heavily modified SAP system — which began life in 1999 — could not be fulfilled by Oracle out-of-the-box. Either technical or manual adaption was necessary, they said.
Grant Thornton said it was "considering whether all of the basic foundations for the Oracle re-implementation design phase are in place."
"We are also looking at whether the emerging proposals for the Oracle re-implementation have properly considered all the options and whether they have a good enough understanding of the costs/implications," it added.
[9]Techies at Europe's biggest council have 8 weeks to pull finance reports from Oracle system
[10]Oracle at Europe's largest council didn't foresee bankruptcy
[11]Local governments aren't businesses – so why are they force-fed business software?
[12]Europe's biggest city council faces £100M bill in Oracle ERP project disaster
In a joint statement, the council's leader John Cotton and deputy leader Sharon Thompson said: "The council's political and administrative leadership accept the recommendations from the external auditor, which comprehensively set out the challenges facing the council… They also highlight the need for us to examine how we work more effectively and collaboratively to build a better Birmingham.
"We are determined to harness the resources of the council to work together on preparing an action plan to tackle the significant challenges we face and want to assure our communities, businesses, and staff, that we will take the decisive actions required," the statement said.
Oracle declined to comment. ®
Get our [13]Tech Resources
[1] https://www.theregister.com/2023/09/05/birmingham_city_council_oracle/
[2] https://pubads.g.doubleclick.net/gampad/jump?co=1&iu=/6978/reg_software/databases&sz=300x50%7C300x100%7C300x250%7C300x251%7C300x252%7C300x600%7C300x601&tile=2&c=2ZR03wq01oI2j3EisgoSMoQAAABA&t=ct%3Dns%26unitnum%3D2%26raptor%3Dcondor%26pos%3Dtop%26test%3D0
[3] https://pubads.g.doubleclick.net/gampad/jump?co=1&iu=/6978/reg_software/databases&sz=300x50%7C300x100%7C300x250%7C300x251%7C300x252%7C300x600%7C300x601&tile=4&c=44ZR03wq01oI2j3EisgoSMoQAAABA&t=ct%3Dns%26unitnum%3D4%26raptor%3Dfalcon%26pos%3Dmid%26test%3D0
[4] https://pubads.g.doubleclick.net/gampad/jump?co=1&iu=/6978/reg_software/databases&sz=300x50%7C300x100%7C300x250%7C300x251%7C300x252%7C300x600%7C300x601&tile=3&c=33ZR03wq01oI2j3EisgoSMoQAAABA&t=ct%3Dns%26unitnum%3D3%26raptor%3Deagle%26pos%3Dmid%26test%3D0
[5] https://pubads.g.doubleclick.net/gampad/jump?co=1&iu=/6978/reg_software/databases&sz=300x50%7C300x100%7C300x250%7C300x251%7C300x252%7C300x600%7C300x601&tile=4&c=44ZR03wq01oI2j3EisgoSMoQAAABA&t=ct%3Dns%26unitnum%3D4%26raptor%3Dfalcon%26pos%3Dmid%26test%3D0
[6] https://www.theregister.com/2023/06/29/birmingham_city_council_running_parallel/
[7] https://pubads.g.doubleclick.net/gampad/jump?co=1&iu=/6978/reg_software/databases&sz=300x50%7C300x100%7C300x250%7C300x251%7C300x252%7C300x600%7C300x601&tile=3&c=33ZR03wq01oI2j3EisgoSMoQAAABA&t=ct%3Dns%26unitnum%3D3%26raptor%3Deagle%26pos%3Dmid%26test%3D0
[8] https://birmingham.cmis.uk.com/birmingham/Document.ashx?czJKcaeAi5tUFL1DTL2UE4zNRBcoShgo=qJbRwIrsTQSWSooXWJdZvx9Cnajf22NDbJMFZI07HyFu2mK8MwXO%2fA%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
[9] https://www.theregister.com/2023/10/02/birmingham_city_council_oracle/
[10] https://www.theregister.com/2023/09/18/birmingham_city_council_oracle/
[11] https://www.theregister.com/2023/09/11/opinion_piece/
[12] https://www.theregister.com/2023/05/25/europes_biggest_council_faces_100m_erp_bill/
[13] https://whitepapers.theregister.com/
Since the introduction of the replacement for an ageing SAP financial management system, the council cannot close its books and file financial reports. The escalating costs of the project — which have risen from £20 million ($24 million) to an estimated £100 million ($121 million) — [1]have contributed to the council effectively becoming bankrupt las month .
According to a 12-page public interest report from auditors Grant Thornton, the Oracle system implementation was rated as "red" before going live and "included a significant number of items requiring a solution."
[2]
"The finance system had several adaptations that did not subsequently operate effectively. As such, the system is not able to fully meet the financial reporting needs of the Council including finance, human resources, and schools," the auditor said.
[3]
[4]
The Oracle implementation "significantly impacted" the Council's ability to function, Grant Thornton added, while numerous workarounds and manual interventions were needed to operate the system.
The problems implementing the new ERP system meant the council couldn't create an "outturn position" [financial forecast] for 2022/23 or a set of financial statements for the same year. Neither can it provide an up-to-date financial position for the current year, 2023/24.
[5]
"This has impacted on payments to suppliers and also on financial reporting for schools and other organisations that use the Council's financial services," the report said.
Grant Thornton also highlighted concerns over security and governance. The auditors said "some IT security systems were not implemented and there is an inadequate segregation of duties in the system."
From 2019, the council had planned to implement Oracle out-of-the-box and change its processes to fit the system. However, [6]a report earlier this year said council's officers began to change this approach and customize Oracle.
[7]
"This shift in emphasis (from adoption to adaptation) has severely impacted upon the council's ability to properly implement the Oracle system."
In its [8]most recent plans , the council said it would work with Oracle Consulting and go back to its "out of the box Oracle vision."
Insiders have told The Register that the functionality provided by the heavily modified SAP system — which began life in 1999 — could not be fulfilled by Oracle out-of-the-box. Either technical or manual adaption was necessary, they said.
Grant Thornton said it was "considering whether all of the basic foundations for the Oracle re-implementation design phase are in place."
"We are also looking at whether the emerging proposals for the Oracle re-implementation have properly considered all the options and whether they have a good enough understanding of the costs/implications," it added.
[9]Techies at Europe's biggest council have 8 weeks to pull finance reports from Oracle system
[10]Oracle at Europe's largest council didn't foresee bankruptcy
[11]Local governments aren't businesses – so why are they force-fed business software?
[12]Europe's biggest city council faces £100M bill in Oracle ERP project disaster
In a joint statement, the council's leader John Cotton and deputy leader Sharon Thompson said: "The council's political and administrative leadership accept the recommendations from the external auditor, which comprehensively set out the challenges facing the council… They also highlight the need for us to examine how we work more effectively and collaboratively to build a better Birmingham.
"We are determined to harness the resources of the council to work together on preparing an action plan to tackle the significant challenges we face and want to assure our communities, businesses, and staff, that we will take the decisive actions required," the statement said.
Oracle declined to comment. ®
Get our [13]Tech Resources
[1] https://www.theregister.com/2023/09/05/birmingham_city_council_oracle/
[2] https://pubads.g.doubleclick.net/gampad/jump?co=1&iu=/6978/reg_software/databases&sz=300x50%7C300x100%7C300x250%7C300x251%7C300x252%7C300x600%7C300x601&tile=2&c=2ZR03wq01oI2j3EisgoSMoQAAABA&t=ct%3Dns%26unitnum%3D2%26raptor%3Dcondor%26pos%3Dtop%26test%3D0
[3] https://pubads.g.doubleclick.net/gampad/jump?co=1&iu=/6978/reg_software/databases&sz=300x50%7C300x100%7C300x250%7C300x251%7C300x252%7C300x600%7C300x601&tile=4&c=44ZR03wq01oI2j3EisgoSMoQAAABA&t=ct%3Dns%26unitnum%3D4%26raptor%3Dfalcon%26pos%3Dmid%26test%3D0
[4] https://pubads.g.doubleclick.net/gampad/jump?co=1&iu=/6978/reg_software/databases&sz=300x50%7C300x100%7C300x250%7C300x251%7C300x252%7C300x600%7C300x601&tile=3&c=33ZR03wq01oI2j3EisgoSMoQAAABA&t=ct%3Dns%26unitnum%3D3%26raptor%3Deagle%26pos%3Dmid%26test%3D0
[5] https://pubads.g.doubleclick.net/gampad/jump?co=1&iu=/6978/reg_software/databases&sz=300x50%7C300x100%7C300x250%7C300x251%7C300x252%7C300x600%7C300x601&tile=4&c=44ZR03wq01oI2j3EisgoSMoQAAABA&t=ct%3Dns%26unitnum%3D4%26raptor%3Dfalcon%26pos%3Dmid%26test%3D0
[6] https://www.theregister.com/2023/06/29/birmingham_city_council_running_parallel/
[7] https://pubads.g.doubleclick.net/gampad/jump?co=1&iu=/6978/reg_software/databases&sz=300x50%7C300x100%7C300x250%7C300x251%7C300x252%7C300x600%7C300x601&tile=3&c=33ZR03wq01oI2j3EisgoSMoQAAABA&t=ct%3Dns%26unitnum%3D3%26raptor%3Deagle%26pos%3Dmid%26test%3D0
[8] https://birmingham.cmis.uk.com/birmingham/Document.ashx?czJKcaeAi5tUFL1DTL2UE4zNRBcoShgo=qJbRwIrsTQSWSooXWJdZvx9Cnajf22NDbJMFZI07HyFu2mK8MwXO%2fA%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
[9] https://www.theregister.com/2023/10/02/birmingham_city_council_oracle/
[10] https://www.theregister.com/2023/09/18/birmingham_city_council_oracle/
[11] https://www.theregister.com/2023/09/11/opinion_piece/
[12] https://www.theregister.com/2023/05/25/europes_biggest_council_faces_100m_erp_bill/
[13] https://whitepapers.theregister.com/
A drop in the ocean
Anonymous Coward
Looking at how much Birmingham have frittered on noisy, slow trams and the wider messing up of Brum city centre, I suspect the Oracle overspend is not really significant.
Oracle declined to comment.
But they will be sending the lawyers because Oracle has not been paid since the system refuses to pay bills sent through the new system. The city being bankrupt is no excuse and Oracle is eyeing replacement payment in other currencies, such as all the land and buildings of the city centre. In the meantime, a statement from Oracle counsel was received to say: "The radius of Oracleham city ownership will extend for every day we are not properly compensated.".
The city of Birming Oracleham declined to comment.