#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!

 

 

#1063 OIC 25.04 New Features - Decisions in Projects

Decisions, previously only available in Process Automation, can now be created within the context of an OIC Project.

Naturally, this also includes the ability to invoke a Decision from an integration - 

Let's try this out with the following simple scenario - apply a discount to an order, based on product ordered.

The logic is banal - 

• product iBike - 10% discount
• product iCar - 15% discount

First step is to define the input data, in my case, the product ordered - 

I define the input, i.e. product as type Text. 

I now add a Decision Table - this is where I will define the discount rule -

I join the input to the decision table - 

Now to editing the decision table - 

As you can see, I've added 3 rules, covering all of my products.

I can now test the rule - 

Let's test with iCar - 

Excellent! Now we have created our first decision in a project. The final step within Decisions is to create a service, exposing this decision - 

I'll address the missing rule later. 

Activate the Decision - then open the order processing integration -