CASE STUDY

Oracle OCI Generative AI Services: Enabling Natural Language Querying for Oracle eBusiness Suite

Introduction

Patch Solutions – PatchPay service, provides HRMS & Payroll as a service based on Oracle Fusion HCM Cloud, Oracle eBusiness Suite applications and Oracle Database 23ai. By combining the capabilities of Oracle Payroll and Oracle eBusiness Suite, PatchPay offers an end-to-end enterprise class HCM & payroll solution. The Oracle eBusiness Suite applications, hosted and managed by Patch Solutions, are provided as a subscription service with advanced AI-powered analytics capabilities.

BSC – a long term partner and service provider to Patch Solutions, provides the cloud managed services and technical expertise to keep PatchPay available and secure 24x7x365, including comprehensive AI service integration and natural language processing capabilities.

Company Overview

Patch Solutions are a leading provider for Oracle HCM and Payroll consulting, support and managed services. Patch Solutions are based in Sydney, Australia and service customers globally. As a provider of mission-critical payroll and HR services, delivering intuitive data access and advanced analytics capabilities are essential to maintaining competitive advantage and customer satisfaction.

BSC provides consulting, support and hosting services for the Oracle technology stack. BSC provide the private cloud platform and management services for the PatchPay solution, including comprehensive AI service integration and natural language processing architecture. BSC are based in Sydney, Australia and service customers globally.

Challenge/Problem

Following the successful deployment of PatchPay on Oracle Cloud Infrastructure, Patch Solutions identified several critical challenges in delivering advanced analytics capabilities that meet modern user expectations:

Natural Language Interface Requirements

  • Customer demand for conversational interfaces that allow business users to query Oracle eBusiness Suite data using plain English.
  • Need to eliminate the technical barrier between business users and their Oracle eBusiness Suite data without requiring SQL expertise.
  • Growing expectation for AI-powered analytics that can understand context and provide intelligent responses to business questions.

Complex Oracle eBusiness Suite Data Access

  • Oracle eBusiness Suite’s rich but complex data structures required significant technical knowledge to navigate effectively.
  • Limited ability for end users to perform exploratory data analysis or ask follow-up questions dynamically.

Solution

Patch Solutions and BSC implemented Oracle’s natural language query solution for Oracle eBusiness Suite leveraging Oracle Select AI and OCI Generative AI services. This innovative approach transforms how business users interact with their Oracle eBusiness Suite data by enabling them to ask questions in plain English:

Oracle Select AI and OCI Generative AI Integration

Oracle Autonomous Database’s Select AI feature works in conjunction with OCI Generative AI services to translate natural language questions into accurate SQL queries that can be executed against Oracle eBusiness Suite data.

  • Deployed Oracle Autonomous Database with Select AI capability as the core natural language processing engine for the eBusiness Suite solution.
  • Integrated OCI Generative AI services to provide the large language model capabilities needed for understanding business terminology and generating contextually appropriate SQL queries.
  • Configured AI profiles for different business domains (such as People, Manufacturing, Logistics, etc.) to ensure more accurate query generation based on the specific area being questioned.
  • Implemented secure separation between the AI query generation process and the actual data execution to maintain enterprise security standards.

Benefits

The implementation of Oracle OCI Generative AI services has fundamentally transformed how PatchPay customers interact with their Oracle eBusiness Suite applications:

Revolutionary User Experience

  • Business users can now query complex Oracle eBusiness Suite data using natural language questions like “Show me overtime trends for the Sydney office last quarter.”
  • Eliminated the learning curve typically associated with Oracle eBusiness Suite reporting and analytics tools.
  • Enabled conversational analytics that allow users to drill down into data with follow-up questions and contextual exploration.

Enhanced Oracle eBusiness Suite Accessibility

  • Democratized access to Oracle eBusiness Suite insights by removing technical barriers for business users.
  • Accelerated time-to-insight for critical business decisions by providing immediate responses to analytical questions.
  • Extended the value of Oracle eBusiness Suite investments by making data more accessible across the organisation.

Operational Excellence

  • Reduced Oracle eBusiness Suite custom report development time by approximately 90% through natural language querying.
  • Minimised IT support overhead for Oracle eBusiness Suite reporting requests and user training requirements.
  • Improved data accuracy through AI-powered validation of natural language queries against Oracle eBusiness Suite data structures.

Advanced AI-Powered Insights

  • AI services provide intelligent suggestions for follow-up questions based on Oracle eBusiness Suite data patterns and user behavior.
  • Automated identification of data trends and anomalies in Oracle eBusiness Suite applications that might be missed through traditional reporting.
  • Enhanced decision-making through AI-generated insights and recommendations based on Oracle eBusiness Suite historical data.

Scalable Cloud Architecture

  • Oracle OCI Generative AI services automatically scale to handle varying query volumes across multiple Oracle eBusiness Suite environments.
  • Reduced infrastructure costs through efficient cloud resource utilisation and on-demand AI processing capabilities.
  • Future-proof architecture that can incorporate new AI capabilities as Oracle continues to enhance OCI Generative AI services.

Customer Quotes

“Oracle OCI Generative AI services have revolutionised how our customers interact with their Oracle eBusiness Suite applications. Business users can now have natural conversations with their data, asking questions like ‘What employees had the highest training costs this year?’ and getting immediate, contextual answers. This has completely transformed the user experience of Oracle eBusiness Suite from a technical system to an intelligent business partner.” – John Sale, Patch Solutions

“The integration of Oracle OCI Generative AI with Oracle eBusiness Suite has eliminated the traditional barriers between our users and their data. Our customers can now leverage the full power of their Oracle eBusiness Suite investments through simple conversations. Questions like ‘Compare our payroll expenses across all locations for Q3’ that used to require custom reports and technical expertise can now be answered instantly through natural language.” – Mark Burgess, BSC