Case Study
Custom Regulatory Information Application for a Pharmaceutical Provider
APEX Development
The Overview
Services: Oracle APEX Development
Solutions: Custom Application, Product Information Management Integration
Technology: Autonomous Database
Industry: Pharmaceutical
Our client is a world leader in pharmaceutical technologies and services for the healthcare industry. It is present in 80 countries with approximately 67,000 employees and serves more than 3.7 million customers and patients
The Challenge
The pharmaceutical industry is highly regulated, and our client must document its products’ regulatory information to ensure compliance. It must manage the submission of the regulatory dossiers (regulatory events), as well as track detailed product information.
They had initially purchased a tool from the pharmaceutical market in order to create and maintain this information, but it did not meet their needs. They were looking for a new solution that could provide full lifecycle management with a centralized, global view of product details, documents and submissions, and that could support collaboration and meet compliance requirements.
The timeline was tight and they needed the new system to be completed and in place within 4 months.
Needs
Oracle took note of our client’s challenges and contacted its long-time partner Insum. Together they presented an offer that would:
- Recover, clean, and migrate existing data to the new platform
- Ensure data integrity
- Reduce data entry through a more straightforward process
- Provide the end-user with a highly intuitive interface
- Reduce overall costs.
- Offer great flexibility in configuration
- Be better suited to their present needs while being easily scalable if needed.
Oracle, aware of Insum’s APEX expertise, knew it would build the application to the highest standards and within budget while respecting the client’s tight timelines.
The Approach
Given the project’s tight timeline, Insum opted for an agile approach, thoroughly integrating our client into the process. There were 2-3 meetings a week with project stakeholders, and regular deployments with demos roughly every 3 weeks. The frequency of these Insum/client meetings ensured there were no surprises.
Meetings almost always included developers, the tech lead analyst, and client users to eliminate any knowledge gaps that could slow the process down.
The client’s team also conducted work sessions on its own to ensure unified feedback and requests.
To ensure smooth adoption of the new application and of the Oracle Autonomous Database, knowledge transfer sessions were jointly conducted by both Insum and Oracle.
Agile methodology
- Regular meetings
- Frequent deployments
- Knowledge transfer
The Technology Used
This solution included Oracle’s fully managed Autonomous Database (Autonomous Transaction Processing), and Oracle Application Express (APEX), the Oracle Database’s Rapid Application Development platform.
Oracle’s Autonomous Database, which hosts the APEX application, was deployed within a day and a half, and work on the APEX application began immediately thereafter.
The Autonomous Database is an optimal solution, ensuring a high level of data security for the client’s sensitive information, while also minimizing maintenance efforts thanks to its self-driving, self-securing, and self-repairing capabilities.
The Results
Our client now works with:
- An application that’s fully adapted to their needs: secure, simple, very interactive, and performant, with no duplicate data entry.
- Zero application licensing costs as APEX application and user costs are already part of the Oracle Database license.
- A fully scalable and fully managed-by Oracle infrastructure that can easily be adjusted to the size of the application as well as other workloads that the client has planned for it.
“Thanks to Insum’s professionalism and technical knowledge, we have now a database that precisely answers our needs. The development of the tool went perfectly well: rapid development through an agile mode, favorable working hours with the time difference between our country and Canada, very good coordination, and communication between our teams, and very open-minded and nice people!”
– Anne-Sophie – Director, Regulatory Affairs, pharmaceutical provider
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.
