The Forestry Commission is the British governmental department responsible for the protection and expansion of Britain’s forests and woodlands. The commission manages woodlands in Scotland, England, and Wales.
The Forestry Commission uses a Web-based service built on Oracle Database to administer forestry-related grant applications―from initial application through final grant payment. Applicants submit 2,500 grant applications per year, which include relevant maps presenting spatial details. The grant approval processes for Scotland, England, and Wales are slightly different, and the system accommodates these differences.
The software is updated quarterly, as well as when needed to accommodate ad hoc changes. The Forestry Commission carries out, thorough regression testing prior to each release, a process that was done manually and took up to two weeks to complete for each update. To accelerate this process, The Forestry Commission implemented Oracle Functional Testing, part of the Oracle Application Testing Suite. By automating regular testing with Oracle Functional Testing, regression testing time has been reduced by 80% to just two days per full regression test pack run.
“Oracle Functional testing has enabled us to run more regression tests, more often, resulting in improved functionality, reliability and time savings,” said Rab Beck, systems test manager, Forestry Commission.
Scientific Computers Ltd (SCL) has a long history of working with Oracle Application Testing Suite and is Oracle’s leading partner in Oracle Application Testing Suite within the United Kingdom.
The Forestry Commission engaged with SCL to assist with the implementation of Oracle Functional Testing. End-to-end grant processing is complex and involves many steps, such as the inclusion of spatial information and ensuring that data is in the correct state to move to the next step. SCL helped The Forestry Commission to split the automated tests into smaller, more manageable scripts that run from the master script. SCL also worked with The Forestry Commission to overcome some complicated issues related to digitizing GIS maps on the Welsh system.