Case Study
Helping a manufacturer modernize with APEX
Forms Modernization & Extending Oracle EBS
The Overview
Services: Oracle APEX Development
Solutions: Legacy Modernization, EBS Extension
Industry: Retail
Groupe Novatech designs and manufactures innovative architectural products such as entrance doors, door glass, patio doors, windows, and more. Its products are distributed internationally for residential and commercial uses.
Novatech has 15 factories across Canada, the United States, and France and employs over 1000 people.
The Challenge
The company undertook a modernization of its IT systems. This included upgrading its primary enterprise software, Oracle E-Business Suite (EBS), which was still running on a version dating back to the early 2000s. Novatech also wished to eliminate several opportunistic applications outside EBS that had cropped up over the years.
“Satellite applications”
Novatech had also accumulated a series of ad-hoc “satellite applications” developed outside EBS, either because the system could not accommodate some business processes or because they were too difficult to incorporate.
Although built in good faith by end-users trying to fix their business problems, these Excel and Access applications presented unnecessary risks:
- Security risks. Files outside an ERP system can easily be shared or altered.
- Data integrity risks. These multiple files also represent “competing” sources of information, contrary to the good practice of having a single data source.
- Costs. Such as the cost of correcting errors, either in production, in erroneous orders, duplicates, etc.
Furthermore, Novatech’s IT department had become responsible for the upkeep and repair of these files. Therefore, it was time to get rid of them.
Outdated Oracle Forms applications
In addition, during the update of E-Business Suite, some of the personalizations developed in Oracle Forms were found to be no longer a good fit for the new version as they had been developed with a different data model.
In summary, Novatech needed to update EBS and migrate the data and functionality from Excel, Access, and the outdated Forms applications into the new E-Business Suite environment.
The Solution
Forms application migration to APEX
During Novatech’s update of EBS, its IT team cut their development time in half by replacing unsuitable Forms applications with Oracle APEX instead of rebuilding them from scratch for the new version of EBS.
There are still standard EBS Forms applications remaining in Novatech’s ecosystem, but these were purposely left intact as they function very well and require no personalization.
External applications
As for the external applications, Novatech looked for an experienced partner who could help them through the work. Already aware of APEX’s capabilities, Novatech searched for an experienced Oracle APEX partner and reached out to Insum.
One of the required migrations was a collection of approximately three hundred customer price lists in Excel with different filters, generally updated every year. Thus, Novatech wanted to do away with manual updates and the risks of human error during the lists’ approvals and renewals. They wished to transfer the data to the Oracle database and access it through APEX applications from within E-Business Suite.
Novatech worked with Insum to build the required applications and convert the needed data to a new APEX environment. Insum also provided knowledge transfer to the Novatech team who were then able to further develop and maintain the system on their own.
Why APEX was chosen
- The scarcity of expert resources in Oracle Forms development
- The much faster development cycle
- APEX applications can be deployed to mobile devices
- Excel or Access application replacements can’t be integrated into Oracle menus and navigation. Data and access would not have been centralized nor secured.
- Unlike Forms, Excel, or Access, APEX provides end-users with a seamless connection to the EBS environment. So seamless, in fact, that they can’t tell the difference. This is primarily thanks to the Insum-developed integration tool called Handshake for EBS.
The Results
The use of Oracle APEX to replace ad hoc and Oracle Forms applications and extending EBS has proven to be pivotal in addressing Novatech’s business needs.
Through its intuitive UI and interactive reporting tools, APEX has provided the company with better exposure to E-Business Suite data, enabling management to react more quickly to increase the efficiency of the production environment.
APEX has also helped spark an accelerated evolution of business processes. IT has noted a renewed enthusiasm among end-users for their applications, which has, in turn, generated more requests for other enhancements to the E-Business Suite system. As a result, the IT department is now prioritizing requests instead of using its energy to encourage users to adopt new features. Other projects with APEX are planned.
“The fact that Oracle fully supports APEX and its team is easily reachable and responsive when software issues arise has reinforced our confidence in APEX.”
–Mick Morin, Director of IT, Novatech.
Work with Us
We appreciate your interest in learning more about Insum.
We want to learn about how we can work with you.
Do you have any questions or need more info?
Fill out this form, and a member of our
team will connect with you. Let's talk!
Some of our other case studies
Enhancing Laboratory Solutions with Oracle APEX and OCI
Learn more about how Agilab, a leader in laboratory informatics, leveraged Oracle APEX and Oracle Cloud Infrastructure (OCI) to deliver a scalable SaaS platform. Learn how innovative development, secure cloud infrastructure, and tailored solutions transformed pharmaceutical R&D operations.
Transforming Shipping Operations with Oracle APEX at Nidec Leroy-Somer
Discover how a leading manufacturer improved its shipping operations by integrating Oracle APEX with Oracle E-Business Suite, reducing processing time and increasing efficiency with a modern, real-time shipping interface.
Modernizing ERP for Construction with Oracle APEX and OCI
Discover how CGSI modernized its ERP solution, iXbat, for construction and public works using Oracle APEX and OCI. Improved scalability, security, and efficiency with rapid development and real-time analytics.
AP Automation with Oracle APEX and Document Understanding
Trailcon Leasing, a top transportation company in Canada, struggled with inefficient and error-prone manual invoice processing. Insum implemented an Oracle AI-powered solution to automate invoice parsing, reducing processing time from 30 minutes to 5 minutes. This automation improved accuracy and operational efficiency, allowing Trailcon’s finance team to focus on strategic tasks.
Banking on a Customer Application
Discover how an international banking group improved operational efficiency, reduced customer duplication errors, and enhanced data security through a custom Oracle APEX application integrated with Oracle EBS.
Creating a Supplier Portal with Oracle APEX
Learn how Insum replaced an inefficient and cumbersome Excel spreadsheet and implemented an Oracle APEX-based Supplier Portal that revolutionized data handling, increasing efficiency and accuracy for a global electronics manufacturer.
