#1064 OIC 25.04 New Features - AI Doc Understanding & SELECT AI support

The OIC 25.04 release introduces a new native action for OCI AI Document Understanding -

This makes it very easy to implement scenarios, such as the following - every day, at 5pm, read invoices from our ftp server /inbox directory, extract the salient data and process accordingly.

First stop is my demo invoice - 

Let's test the powers of AI Document Understanding on this - 

Looks good! Now to OIC...

I copy my invoice to my local ftp server - 

Here is my OIC project with my scheduled integration, DailyBatch -

The integration is as follows - also check out the configuration of the Document Understanding native action

Now to the mapping - essentially, I download the document via the ftp connection, this gives me the file reference. I then use the mapping function encodeReferenceToBase64 and map to the target - 

I then activate and run the integration -

Excellent! Here's a screenshot of the Document Understanding response -

Summa

This is the first native action for OCI AI services to appear in the integration design palette.

As you can see, there are other such AI services, so expect more such native actions to appear in future releases!

SELECT AI support in the ATP Adapter

First step is to look at enabling SELECT AI on your ATP instance - 

Btw. my ATP user is RENATEC and I am using Cohere as my AI engine.

GRANT execute on DBMS_CLOUD_AI to RENATEC

BEGIN  

    DBMS_NETWORK_ACL_ADMIN.APPEND_HOST_ACE(

         host => 'api.cohere.ai',

         ace  => xs$ace_type(privilege_list => xs$name_list('http'),

                             principal_name => 'RENATEC',

                             principal_type => xs_acl.ptype_db)

   );

END;

/

EXEC DBMS_CLOUD.CREATE_CREDENTIAL(credential_name   => 'COHERE_CRED', username => 'COHERE', password => 'yourCohereAPIKey');

BEGIN

  DBMS_CLOUD_AI.CREATE_PROFILE(

  profile_name   => 'Cohere',

  attributes     =>'{"provider": "cohere",

"credential_name": "COHERE_CRED",

"object_list": [{"owner": "RENATEC", "name": "orders"},

  {"owner": "RENATEC", "name": "countries"}]

       }',

status     => 'enabled',  

          description     => 'AI profile to use Cohere for SQL translation'

     );

END;

/

Note the object_list above - here I am defining which tables can be used in respect of AI generation of SQL. 

EXEC DBMS_CLOUD_AI.set_profile('COHERE');

I now test this in ATP - I want to generate SQL to select all Irish customers from my orders table.

Now to OIC, where I have an integration that invokes ATP via an ATP connection. Here is the configuration -

Summa Summarum

These are really 2 excellent AI driven features in OIC 25.04, and there are many more to come!