FC 109/27 |
Hundred and Ninth Session |
Rome, 9 – 13 May 2005 |
Progress Report on Administrative Information Systems |
1. This report provides information to the Finance Committee on progress made with the Administrative Information Systems between February 2004 and January 2005, and plans for the period February 2005 – January 2006.
2. During the period from February 2004 to January 2005, the main areas of work covered were as set out below:
Development of interface monitoring reports. The review of interface processes, identification of current controls and specification of monitoring reports has been completed for all interfaces included within the scope of the review. Standard reports on interface activity are now prepared on a monthly basis which provide positive assurance on this activity.
Preparation and publication of the Corporate Accounting Manual. A review has been made of the existing financial procedures referred to in the Manual Sections and a preliminary assessment of the relevance and applicability of each has been undertaken. Procedural documentation for the Accounts Receivable and other groups has been prepared and has been published on the AFF intranet site.
Further developments in the Data Warehouse. Reporting functions were expanded to include information sourced from the Accounts Receivable and Human Resources sub-systems.
Split Assessment Reporting. Work was undertaken on the development of new reports to support corporate and budget holder requirements for the monitoring of Regular Programme resources.
Improved use of standard functionality in purchasing business processes. A number of system changes have been specified and developed in order to make better use of existing Oracle Financials release 11i functionality. This has included the development of new reporting and data analysis functionality for both Oracle Purchasing and Oracle Fixed Assets.
Oracle Financials Upgrade Project. The upgrade of Oracle Financials is a prerequisite for the successful implementation of the HRMS project. This is because, in order to benefit from the substantial improvements that have been made in later versions, the Oracle HRMS application will be introduced on a version that is higher than the current version of Oracle Financials in place at FAO. As an integrated suite of applications it is necessary that all elements operate on the same version. The requirement for this project was agreed in the October 2004 meeting of the Oracle Project Management Committee.
It is estimated that the project will require a minimum of eight months preparation based on previous similar projects. Project mobilization activities to release core project team staff members from their current duties were completed by the end of February 2005 to allow the main project activities to start.
3. The main focus of work for the period February 2005 to January 2006 will be on the implementation of the Oracle Financials Upgrade Project which is estimated to require a minimum of eight months preparation. The project activities which will be completed during this period are divided into 3 phases:
4. Work will also continue in the following areas:
5. The cost of work undertaken in relation to Oracle Financials is being funded wholly from arrears:
Actual |
Forecast | |||
Year |
2003 |
2004 |
2005 |
Total |
RP Allotment |
0 |
0 |
0 |
0 |
Arrears Allotment |
$ 216K |
$1 169K |
$1 967K |
$3 352K |
6. In addition, funding requirements for the Oracle Financials Upgrade project are estimated to be US$1 550 000 and the most likely funding source is to advance funds from the FAO HRMS Project (please see paragraph 24).
7. During the period of the Oracle Financials upgrade project, system development will be frozen to ensure that significant changes are not implemented in the production system while the new system is undergoing testing. This will limit the scope of other system developments which can be completed during the upgrade and throughout the remaining period of the HRMS implementation. It will nevertheless be necessary to accommodate those developments that are recognized to be high priority in their own right such as the Field Accounting System Replacement Project.
8. The budgeted amount for the FAS Replacement Project is US$675 000, which is approximately one third of the US$1.8 million spent in 1998 on the existing field accounting system. The Organization will look for a flexible solution that will allow additional functionalities to be potentially added in the future. However, the initial functionality envisaged by this project will be limited to financial and budget management aspects of the FAOR office.
9. The project to replace the Field Accounting System is funded from arrears. Given the scope of the business requirements and that the project has only recently started, it will not be possible to fully deliver the arrears funded portion of the project by the end of the 2004-2005 biennium. The freeze on system development due to the Oracle Financials Upgrade will also have a potential impact on the ability to fully deliver the other administrative information systems projects funded under the arrears heading (“Unbudgeted Cost of Consolidating Oracle Financials”) by the end of the 2004-2005 biennium. It is proposed that any unspent balance on these projects be therefore carried forward into 2006 within the Capital Expenditure Facility.
10. All of the planned outputs presented to the Finance Committee at its 107th Session in May 2004 have been achieved:
11. While not explicitly foreseen in the plan, the MTP 2006-11 and PIR 2002-03 documents were produced using new technology which will streamline the related document production, translation and publishing workflows.
12. The planning of the coming months is of considerable importance since the PIRES arrears funding will be exhausted in September 2005. Thus, in the absence of additional resources, PIRES must be brought to a sustainable state of development within the next year.
13. The workplan which has been endorsed by the Project’s Inter-departmental Working Group (IDWG) comprises two types of workstreams: (1) those representing specific systems development objectives under PBE control and (2) those associated with integration points with other corporate systems and processes, with priority given to rationalizing the applications.
14. Within this framework, the following outputs will be completed during 2005:
15. The resources envelope for the PIRES project has not changed significantly since the earlier reports to the Finance Committee, and spending is proceeding according to plan.
Actual |
Forecast | |||
Year |
2003 |
2004 |
2005 |
Total |
RP Allotment |
$ 588K |
$ 437K |
$ 418K |
$ 1 443K |
Arrears Allotment |
$ 96K |
$ 381K |
$ 345K |
$ 822K |
16. As noted earlier the arrears funding for PIRES will be exhausted within 2005 and, therefore, the workplan for 2005 focuses on bringing the system to a sustainable state of development, with as many of the Project's objectives achieved as possible by the end of this year.
17. To ensure the existence of in-house skills, a training programme for the two PBE technical staff is being implemented based on the PIRES technical architecture. The various integration points noted above are likely to require additional effort, particularly in the context of the HRMS project, and longer term staffing requirements for maintaining PIRES will be determined in the PWB 2006-07.
18. There has been good progress against the workplans for the period February 2004 – January 2005. Documentation of current Human Resources business processes has been completed and review of proposals for business process improvements is almost complete.
19. A study covering the current and future Human Resource Management Model has been initiated in December 2004 and is planned to be completed in April 2005. The new Management Model will seek to extend HR coverage and improve overall HR service delivery whilst reducing costs. One of the objectives of the study is to estimate benefits and savings resulting from the HRMS implementation.
20. The main activity being executed in the October 2004 – March 2005 period is Gap Analysis, the mapping of FAO new business processes to the Oracle ERP standard functionality, in order to identify basic configuration and gaps in functionality. The project is slightly behind schedule due to difficulties in recruitment of high level technical resources, but the 2004 expenditures have been less than forecasted. It is therefore expected to absorb this delay within the current financial and time plans.
21. Once the above Gap Analysis project phase is complete, and the new HR Service Delivery Model defined, the project will move into its next phase, the Conference Room Pilot, where a system prototype will be demonstrated and discussed with the users over the period April – September 2005. In the second half of 2005, the development activities will also start. The project completion date is the end of 2006.
22. The project will also provide input to the Oracle Financials upgrade, and finalise the design of the integration between the PIRES and HRMS systems, specifically in the areas of post management, staff costing, performance management and HR planning.
23. It was reported to the Finance Committee in May 2004 that the cost estimate for the project totalled US$19 000 000, with a shortfall of US$5 021 000. In light of the fact that the Gap Analysis is not yet complete at the time of preparing this report, and that the gap analysis outcome is the basis for a more accurate cost prediction, a new cost estimate will be provided to the Committee in the September 2005 session. This will include an estimate of the benefits (including cost savings) that the project will deliver.
24. As reported in paragraph 20, the 2004 expenditures were lower than forecasted. The anticipated expenditure of arrears funding allotted for this project has been re-phased across years 2004, 2005 and 2006, and funds allocated to Oracle Financials upgrade as indicated in section I. The new resource allocation is summarised in the table below.
Actual | Estimate | ||||
Year |
2002-03 |
2004 |
2005 |
2006 |
Total |
Original arrears phasing (May 2004 report) |
$ 286K |
$ 4 689K |
$ 6 104K |
$ 2 900K |
$ 13 979K |
Revised arrears phasing |
$ 286K |
$ 3 660K |
$ 6 843K |
$ 1 640K |
$ 13 979K |
Financials upgrade |
$ 1 550K |
25. This will require a carry-forward of the unspent balance of arrears funding, estimated at US$1 640 000, into 2006. The project has been included in the Capital Budgeting proposal endorsed by the Finance Committee in May 2004.
26. Actions are in progress to examine areas for cost reduction. Some reductions have been achieved whilst others are under investigation:
27. Difficulties have been experienced in recruiting high level technical resources since market rates exceed maximum FAO consultant honorarium ceilings. Measures to address this problem have been taken.
28. Availability of divisional resources has been limited by other programme priorities. Stakeholder divisions have had their budgets severely cut in the 2004-2005 biennium and this has created delays in the project activities that have so far been absorbed. A risk exists, however, if new budget cuts are made that the delays in responding to project requests will start to affect project timeline and costs.
_____________________
1 As at 31 December 2004, the STP rate for the bank accounts used to process Accounts Payable payments all exceeded 90% compared to a SWIFT industry benchmark of 76%.