Print:
Print this page

Share:
Send to friend

Ministry of Finance France Success Story

 

Live on Oracle – Anubex IDMS to Oracle migration solution delivered at DGCP

Background

The NDL system was created in the early 1980’s and significant development investments have been put into this core DGCP system over the past 25 years. NDL stands for «Nouvelle Dépense Locale» or in English «New Local Spending» and is a system that is highly important for the daily operations of DGCP and for the ministry in general. By choosing Anubex to migrate it’s IDMS based application the DGCP has opened up an easy access to it’s data and maintains the value of the NDL application itself by reassuring it’s continued well functioning in the new modern environment. It has also disposed of the non-strategic IDMS platform in a rapid manner.

The Ministère des Finances, de I’industrie et de l’Economie (Minéfi) is responsible for the economy, budget and the industry of France. It is one of the largest public organisations of France with a staff of 185,000 civil servants. DGCP, the public treasury of France, is one of the organisations of the Minefi with the responsibility over five main activity areas, namely:

  • Recovery of state income

  • Control and execution of public spending

  • Production of budget and accounting information

  • Expertise and financial advise

  • Management of public money

The DGCP includes a decentralised network of in total about 57,000 staff spread over more than 3,000 offices. 205.6 billion Euros of public income were recovered in 2005 and 176.4 billion Euros were paid to creditors of the local communities and 459.9 billion Euros were paid to state creditors that year.

The NDL application is one of the core systems that enables the functioning of the DGCP operations including the management of these transactions. NDL handles the processing and data collection of all public expenditure throughout France. The users of the system are the ‘Ordonnateurs’ which are regional and departmental chief administrative officers as well as the accountants of the French public treasury.

These Ordonnateurs, are ministry-exterior institutions with the authority to prescribe, schedule and execute the payments and receipts. The accountants are charged with receiving and transmitting the funds and with controlling and describing the operations carried out.

In practical terms: The Ordonnateurs create expenditure entries in NDL on a daily basis and the system is updated by nightly batch jobs. The accountants can access the NDL database but cannot modify any of the data directly in the system. Every night there is a transfer of updates to other systems interfaced to NDL. The accountants control and verify the correctness of the expenditure entries and validates these.

So in summary NDL is the principal application used by the Ordonnateurs and the public accountants for the execution of their work with the local spending at a decentralised level. NDL unites the totality of the actors involved in the execution of local spending in one single shared system. The system includes a large amount of interfaces to various Minefi applications such as the Finance, the Regulations, the Budget and the Accounting systems of the ministry.

It is in other words a core application of significant importance not only to DGCP but for the totality of the ministry. The NDL business analysts and some of the programmers are based in Paris, other NDL programmers are located in Clermont-Ferrand and Bordeaux. The system is operated from two IT Operations Centres, one in Tours and the other one in Bordeaux.

The Story

When the DGCP started investigating solutions to migrate the NDL system they were faced with many challenges that were listed down as key aspects in the public tender they published.

The context of the tender was the migration of the NDL IDMS application to an Oracle RDBMS while continuing to use the CASE tool repositories built in Pacbase for application maintenance. The migrated application should remain on the IBM mainframe environment but now with a relational architecture utilising Oracle.

Some main challenges described in the public tender was:

  • To enable that the developers would be able to continue maintaining the application after migration. In fact the development and maintenance environment should remain Pacbase
  • The impact of the migration should not degrade the performance or disturb the operations of the NDL users in any way
  • Avoidance of any end user re-training whatsoever
  • Data migration and going live with 26 databases in one year

Madame Grosman, the Minefi project leader that managed the request for tender put a strong focus on certain key project prerequisites. With regard to the tender she comments that one of her key concerns was that “ We certainly wanted to avoid the hassle of retraining our approximately 14,000 users across France”. So one of the main requirements in the tender should be that the migrated system could be put into production without any user retraining. Also, she continues, “To rewrite the 3.4 million lines of z/OS COBOL would cost a significant amount of money and the timeframe required for a rewrite exercise would be too long for us to focus on”.

Anubex won the tender process against some of the main players in the IT industry. The project started soon thereafter. The first project step in