Case Study

Banking on a Customer Application

Oracle E-business Suite and APEX

The Overview

Services: Oracle APEX Development

Solutions:  EBS Extension, Custom Application, UX/UI

Industry: Financial Services

This international banking group is a powerhouse in the financial sector, being one of the largest in Europe and a global leader. It offers various banking and insurance services tailored to enterprises, housing, and territorial collectives. With a strong emphasis on innovation and customer satisfaction, the group continually seeks to improve its operations and service delivery. As part of its commitment to excellence, the group has invested heavily in technology to streamline processes, enhance security, and provide top-notch service.

The Challenge

The need for modernization and efficiency in their customer data management processes led them to seek a solution that would not only improve operational efficiency but also ensure data accuracy and security. The transition to a more digital and automated approach was essential to maintaining their competitive edge in a rapidly evolving financial landscape.

The group faced several challenges that needed addressing to enhance operational efficiency and data accuracy:

  • Increase Efficiency: Boost the productivity of accounts receivable clerks by allowing bulk import from Excel spreadsheets.
  • Improve Customer Creation Process: Streamline the process for creating new customer accounts and reduce duplicate entries before entering the ERP.
  • Ensure Security: Maintain robust security between Oracle E-Business Suite (EBS) and Oracle APEX.

The Solution

Insum designed, developed, and deployed a custom Oracle APEX application fully integrated with EBS tailored to the Customer’s needs. The solution featured:

  • Search and Creation Screens: User-friendly interfaces for searching and creating customer profiles.
  • Approval Process Visualization: Clear and concise visual representation of the customer creation approval process.
  • Secure Sign-On Mechanism: Implemented via Insum’s Handshake for EBS, ensuring seamless integration and security between EBS and APEX.

The Technology Used

The Insum Handshake for EBS is a robust integration solution that bridges Oracle E-Business Suite and Oracle APEX, maintaining the EBS context within APEX. This tool accelerates APEX development within the EBS environment, adhering strictly to EBS development standards and drawing from Insum’s extensive project experience.

The Results

The implementation of the APEX application led to significant improvements:

  • More Efficient Workload Sharing: Enhanced distribution of tasks among accounts receivable clerks.
  • Reduced Duplicate Data: Streamlined processes for create new acccounts
  • Customized Approval Workflow: An approval workflow tailored to the organization’s needs, operating outside EBS.
  • Full EBS and APEX Integration: Ensured seamless operation and data consistency across systems.

Insum_casestudy_cloud_graphique

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

Trailcon Leasing – Automating Invoice Processing with AI and Oracle APEX

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.

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.

Moving Air Transat to the Cloud

Air Transat collaborated with Insum to transition its critical scheduling application to Oracle Cloud, addressing server inefficiency and high replacement costs. This move enhanced performance and achieved significant savings.

Revitalizing Legacy Systems: A Cemetery’s Journey to Modernization

In a significant digital transformation, Insum collaborated with one of North America’s largest cemeteries to overhaul a 20-year-old system, replacing cumbersome manual processes with an integrated, user-friendly platform. The solution included a customer portal for online access to gravesite information, advanced reporting tools, and seamless integrations across departments.

Oracle APEX Makes Waves at Valley Water

How Insum helped Santa Clara Valley Water develop key applications to help it serve its 2 million residents and better manage its water resource system.

Modernizing Oracle Forms Applications with Technip Energies

Partnering with Talan, Insum helped Technip Energies modernize its Oracle Forms material management applications.