Case Study

Banking on a Customer Application

Oracle E-business Suite and APEX

The Overview

Services: Oracle APEX Development

Solutions:  Oracle EBS/Oracle APEX Integration, EBS Extension, Custom Application

Technology: Handshake for Oracle EBS

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

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.

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.