Build an AI-Powered Financial Management Interface for a Multicloud Environment

Introduction

Mergers, acquisitions, or choosing best-of-breed technologies can result in diverse technology portfolios, often across more than one cloud provider. Oracle Multicloud can help. For example, the infrastructure and AI services of one cloud can pair with a SaaS application hosted on another.

In this demo, an AI-powered chat interface works across Google Gemini AI, Oracle Database on Google Cloud, and Oracle Fusion Cloud Financials on Oracle Cloud Infrastructure (OCI). Steps covered include the following:

• Data extracted from Oracle Fusion Financials on OCI, using REST APIs
• Tabulated JSON data stored in Oracle Database on Google Cloud
• Embeddings, created by Gemini, added to the database
• A simple prompt interface created using Streamlit

For the chat interface, prompt input is converted into embeddings, followed by a similarity search in Oracle Database on Google Cloud. Relevant data is then processed by Gemini models to generate a contextual response from the financial application’s data.

Demo

Prerequisites and setup

1. Oracle Cloud account—sign-up page
2. Google Cloud account—sign-up page
3. Google Gemini—documentation
4. Streamlit—documentation

Additional resources

• Product page: Oracle Database@Google Cloud
• Documentation: Oracle Database@Google Cloud
• Product page: Oracle Fusion Financials