



Modernization of an operations management application for SNCF with Oracle APEX

Reconciling Cloud and legacy systems: a major challenge for our customer, who needed to modernize the management of its ERP operations. SQORUS supported SCNF in this transformation.

The challenge

Modernizing ERP management in the face of cloud and legacy systems

SNCF has an ERP used by 25,000 daily users, based on a 20-year database and 15 years of history. With the opening to competition, a new Cloud ERP was added to the existing system.

To make these two environments cohabit, SNCF needed suitable tools to supervise and manage the various ERP deployment operations.

The existing management tool, a complex Excel file, posed several problems:

Tool developed by employees who are no longer with us
Accessible to steering team only
Frequent saturation and file blocking
Ineffective communication between players (hundreds of e-mails sent)
Difficulty coordinating stakeholders (up to a hundred people)

Our clients

Testimonial

Patrice FRANCOIS

Head of ARCHITECTURE & IT EXPERTISE division

All these operations were originally controlled by an Excel application, a good old file that had been around for many years […]. This application had become complex. The file easily became saturated, and froze, requiring meetings to share it with users […].

Background & objective

Develop a steering application to manage technical operations

Modernization was therefore essential to simplify operations management and make them more reliable.

It was designed to meet three key challenges:

- Time: with only three people involved, the challenge was to design, test and deliver an operational solution in record time.
- Flexibility: the application had to adapt to both light maintenance (small-scale TMA) and complex, large-scale management plans.
- Rationalization: the aim was to optimize processes, centralize information and improve coordination between all players for smoother, more efficient management.

The aim of the project was to design, test and deploy in three months a solution capable of managing both one-off operations and large-scale intervention plans.

The main objective was to create a centralized, real-time control application capable of managing all technical and application operations, improving coordination between teams and reducing email exchanges for smoother, more collaborative operation.

The SQORUS solution

A collaborative solution for real-time data management

SQORUS developed an application on Oracle APEX, chosen for its compatibility with the SNCF environment and its ability to integrate data from Excel.

1. Design

2. Streamlining

3. Configuration

4. Control

5. Validation

1.drawing design

Creation of a complete tree structure integrating interdependencies between action groups and tasks.

2. Rationalization of reference systems

Creation and centralization of databases to promote reuse and consistency of information.

3. Configuration

Set up simple table-based parameterization with notions of predecessors, hierarchies and task launch conditions.

4. Control and automation :

Action tracking, automatic notifications
Continuous adjustment to actual progress

5. Validation and follow-up

Possibility of commenting, validating and revising plans at every stage to guarantee reliability and continuity of management.

The application enables :

Hierarchical structure (plans, action groups, tasks, dependencies)
Real-time monitoring of forecast and actual durations
An automatic notification system for task tracking
An overview for management teams
Optimized management of access rights
Adapting to different work rhythms
Dynamic recalculation of times according to progress

The results

Benefits of modernizing your application with APEX

The SNCF has gained in reliability and efficiency thanks to a solution that simplifies the day-to-day work of its teams and improves the operational performance deployed by the IT team at SQORUS.

The benefits :

Reduction of emails sent in line with SNCF’s CSR policy
Better stakeholder coordination
Real-time visibility of operations progress
Optimizing schedules and night-time operations
Robust application, even in the event of problems

The application has been in production for a few months now, and has already been used to pilot several operations: test interventions, change of management model, and then the last evolutionary maintenance train.

SNCF is already planning to use the system for its next strategic operations, such as blanket changeovers and the rollout of the new 2026 management model, as well as technical maintenance and application upgrades.



The SQORUS choice

Why choose SQORUS for your Oracle APEX project?

Our customer chose SQORUS for its recognized expertise and mastery of the Oracle APEX solution. Our consultants’ agile approach, combined with their understanding of business challenges, was decisive in the success of this modern web application development project.



Business expertise

With over 35 years’ experience in application development, our experts have an in-depth understanding of the challenges and opportunities presented by this technology.



Oracle Partner

Certified partner status guaranteeing up-to-date expertise and a certified team to meet your business challenges.



Personalized support

Our team works closely with yours to understand your specific needs, business objectives and vision.

Our clients

Testimonial

Patrice FRANCOIS

Head of ARCHITECTURE & IT EXPERTISE division

We worked with SQORUS to improve the solution as we went along. This has considerably reduced the number of e-mails sent, and everyone has a real-time view of what’s happening in the field.

Contact SQORUS for your APEX project

Would you like to modernize your operations management application with Oracle APEX? Transform your processes into collaborative, intuitive and secure applications, accessible in real time.

Contact SQORUS

They trust us