About This Recipe

This recipe uses the artificial intelligence capabilities of OCI Document Understanding to automatically extract and process information from invoices received as PDF file attachments in Microsoft Office 365 Outlook and create corresponding invoices in Oracle ERP Cloud.

To use the recipe, you must install the recipe and configure the connection and other resources within it. The main integration flow runs on a schedule. It fetches invoice PDF files that are received as attachments from a Microsoft Office 365 Outlook inbox and then encodes the PDF files to base64 in Oracle Integration. Subsequently, it invokes the child integration. The child integration flow sends the base64 encoded files to OCI Document Understanding. Using the artificial intelligence capabilities of OCI Document Understanding, key value data is extracted from the files and the results are stored in JSON format. Finally, corresponding invoices are created in Oracle ERP Cloud via REST API calls.

Note that to successfully run this recipe, the input PDF files that you receive in Outlook have to be in a certain format. You can download the following file for reference: Sample file.

System and Access Requirements

  • Oracle Integration, 3

  • OCI Document Understanding

  • Oracle ERP Cloud

  • An account on Oracle ERP Cloud with the Administrator role

  • Microsoft Azure

  • An account on Microsoft Azure with the Administrator role