Skip to Main Content
Oracle Integration 3 - Automate Invoice Processing with OCI Document Understanding

About This Workshop

Youtube Video

About This Workshop
This tutorial will cover the following steps:

1. Ingesting Invoice PDF Documents: We'll start by ingesting invoice PDF documents into the workflow. This will be done by the stakeholder uploading the document by launching a processing application web form.

2. Extracting Invoice Data with OCI Document AI Service: Next, the workflow leverages OCI's Document AI Service to extract key information from the invoice PDFs, such as invoice number, date, total amount, line items, and vendor details. This AI Services document control leverages advanced machine learning models to understand the structure and layout of documents, enabling accurate data extraction.

3. Validating Extracted Invoice Data: After extracting the invoice data, we'll implement a validation process to ensure the integrity and completeness of the extracted information. This could involve checking for missing or inconsistent data

4. Triggering OIC Integration flow for saving the Invoices: If the extracted invoice data is deemed valid during the validation process, we'll trigger an OIC Integration flow. This Integration flow will initiate a series of actions to save the invoice in the database. We will OIC Event system to publish the Invoice details.

5. Storing Valid Invoice Data in a Database: A subscriber Integration flow will transform and persist the invoice details in a database for further processing or integration with other systems, such as accounting or enterprise resource planning (ERP) systems. For this Live lab we will consider the invoice records to be stored in a database. However, the design pattern can easily be extended to create another seamless subscriber integration flow and create an invoice record in ERP cloud.

Throughout the Live Lab, we'll explore the usage of OCI AI services- Document Understanding form control and extend the use case to invoke an integration flow to persist the invoice record in DB. We will also explore OPA Analytics to identify the process trends, and errors, and understand how long processes take to complete and why.

By the end of this Live Lab, you'll have a comprehensive understanding of how to build an end-to-end invoice processing Integration using OCI AI Services, ensuring accurate data extraction, validation, and storage, while streamlining the processing of valid invoices through automated workflows.

Workshop Info

2 hours, 45 minutes
  • Introduction
  • OCI Tenancy Creation
  • Database Setup
  • Oracle Process Automation Setup
  • Develop OPA Workflow
  • Develop OIC Integration (publish/subscribe) flows
  • Activation and Testing (Test Valid and Invalid invoices)
  • Explore OPA Analytics
  • Conclusion
  • Access to an Oracle Integration & OPA instance
  • Understanding of basic OIC concepts like integrations and connections
  • Basic understanding of OCI AI Document understanding
  • Basic understanding of Oracle Process Automation workflows

Other Workshops you might like