Business Identifiers in Oracle Integration by Ankur Jain

A Business identifier in Oracle Integration helps you to track the messages from the monitoring dashboard quickly and easily.

Without enabling the Business identifiers, you can not activate the integrations.

Max 3 business identifiers can be assigned during the design time. One is primary and the other two are secondary.

To understand how to enable Business Identifiers and how to use them to track the runtime integration, read the complete article here

PaaS Partner Community

For regular information on Oracle PaaS become a member in the PaaS (Integration & Process) Partner Community please register here.

Blog Twitter LinkedIn Facebook Wiki

Technorati Tags: SOA Community,Oracle SOA,Oracle BPM,OPN,Jürgen Kress

Oracle Integration Update Webcast September 2021 on-demand

Watch to get the latest updates and innovations on Oracle Integration release. Our Oracle Integration Product Manager Team will present new features, product roadmaps, discuss upcoming innovations and provide guidelines to help you adopt these quickly within your organization. Topics include:

• Welcome & announcements

• August release update Oracle Integration

• ERP / SCM Integration Best Practices from the A-Team

• Questions & Answers

Watch the on-demand webcast here and subscribe to the newsletter here.

PaaS Partner Community

For regular information on Oracle PaaS become a member in the PaaS (Integration & Process) Partner Community please register here.

Blog Twitter LinkedIn Facebook Wiki

Technorati Tags: SOA Community,Oracle SOA,Oracle BPM,OPN,Jürgen Kress

OIC & Blue Prism part 2 by Niall Commiskey

This post goes into a bit more detail, especially on the Blue Prism side. The use case today is that of updating an excel sheet – Here’s mine – today we are doing employee assessments and we will leverage Blue Prism to automatically assign performance values, based on the employee rating. Apologies to any Liam Mellows fans out there.

The employees have been rated – the performance fields just need to be updated. Our digital worker will take care of this.

The OIC process will invoke Blue Prism, passing the name of the excel sheet to be processed.

The Blue Prism process is as follows –

Thanks to the following page for the instructions on how to create the above.

The logic is simple enough –

• Open workbook – Open the excel sheet

• Get Collection – here we copy the workbook contents to the Employees collection

• Loop over each employee entry

  • Update each employee performance field based on their rating

• Write Data – update the Excel sheet

• Save Data – Save Excel Sheet

• Close Workbook – Close Excel Sheet

The process leverages the Blue Prism VBO(Visual Business Object) for Excel. This VBO is pre-seeded in the product. Think of this as an Excel adapter, providing us with functionality such as open close, write, save etc.

You see on the left a Data Item – Workbook Name. This is the variable which holds the name of the excel sheet to be processed. Read the complete article here.

PaaS Partner Community

For regular information on Oracle PaaS become a member in the PaaS (Integration & Process) Partner Community please register here.

Blog Twitter LinkedIn Facebook Wiki

Technorati Tags: SOA Community,Oracle SOA,Oracle BPM,OPN,Jürgen Kress

OIC and Blue Prism RPA by Niall Commiskey

I downloaded the BluePrism trial this morning, along with a set of 10 beginner labs they make available online.

Blue Prism Design Time

The focus of this post is not on how to design automations with Blue Prism; the 10 labs do a great job of that. The focus here is on how to invoke such from OIC.

I will use the following process as an example – this is actually Lab4  Blue Prism offers a rich set of process design actions –

Some of these have been used to add robustness to the process model, very important for mission critical automations.

The process shown above is very simple – it opens the Blue Prism website in InternetExplorer and searches for a specific topic – e.g. Coca Cola

So it is doing the following, from an automation perspective –

1. open the page in IE

2. enter data – the search string – in the search box

3. press the search button.

I test this within the Blue Prism Design Studio and it works fine. The search value – Coca Cola – is hard coded, as you can see in the Data Items block above.

Now say I want to expose this functionality as a service – I will then need to define an input variable for the search string. This can be easily defined in the Start action. Read the complete article here.

PaaS Partner Community

For regular information on Oracle PaaS become a member in the PaaS (Integration & Process) Partner Community please register here.

Blog Twitter LinkedIn Facebook Wiki

Technorati Tags: SOA Community,Oracle SOA,Oracle BPM,OPN,Jürgen Kress

OIC Scheduling for End of Month style processes – Tip #11 by Phil Wilkins

Setting up calendar schedules that aren’t simply reoccurring, such as a specific date in a month like 28th or third Friday, become more of a challenge with the OIC Scheduler. The calendar works with the ical standard set by the IETF standard 2445. If you review the standard’s section 4.3.0, this describes the reoccurrence options, whilst able, not able to address these needs.

Reoccurring on specific dates can, in theory, be set. If you review section 4.3.4, you will see a date has the potential to be defined as a comma-separated list. So multiple dates for month-end can be provided as a list. Note, this is predicated on the calendar attribute supporting date-mday (DATE). The DTSTART and DTEND attributes accept DATE with no indication that the date-mday is not supported.

Specifying the dates explicitly overcomes the problems of national holidays. The downside is that you need to know when the list needs to be extended and, in the case of OIC, the means to edit the scheduler format safely.

NOTE: we have not tested whether the OIC scheduler is compliant with the use of date-mday at the time of writing.

Complex formulas for scheduling and more manageable scheduling..

There are several options for managing reoccurring events, such as month-end, year-end accounting, payroll and expenses payments etc.

In most options, we assume that we have a simple reoccurring schedule that triggers an integration that determines whether the trigger is legitimate. This could be as simple as daily. If valid, then invoking the main integration with the business process. Read the complete article here.

PaaS Partner Community

For regular information on Oracle PaaS become a member in the PaaS (Integration & Process) Partner Community please register here.

Blog Twitter LinkedIn Facebook Wiki

Technorati Tags: SOA Community,Oracle SOA,Oracle BPM,OPN,Jürgen Kress

OIC Integration Lifecycle Using REST Endpoints by Amy Simpson-Grange

Out-of-the-box, Oracle provides a bunch of REST endpoints available to interact with your Oracle Integration Cloud (OIC) instance or the components in which you have built. In this post, we will look at how we interact with an OIC integration using the available REST endpoints throughout it’s lifecycle. This post will not cover all available endpoints and ways to utilize, but rather the key use cases and those that I think are really useful! The full list of available endpoints can be found here.

OIC supports OAuth 2.0 authentication mechanism. Before you can get started using these APIs, you will need to ensure you have the appropriate details to authenticate, retrieve a token and use in your REST calls. For information on doing this, see the Oracle Documentation.

When you call any of the Oracle Integration REST endpoints, the response header returns one of the standard HTTP status codes defined here.

I should also point out that all of this activity can also be completed manually within the OIC service console but these endpoints are specifically useful if you want to script/automate the lifecycle processes. Read the complete article here.

PaaS Partner Community

For regular information on Oracle PaaS become a member in the PaaS (Integration & Process) Partner Community please register here.

Blog Twitter LinkedIn Facebook Wiki

Technorati Tags: SOA Community,Oracle SOA,Oracle BPM,OPN,Jürgen Kress

Oracle Assistant for OIC by Niall Commiskey

The artificial intelligence capabilities of OIC have been augmented by the introduction of the Oracle Assistant for OIC. This compelling new feature of the August release is a great resource for folks new to Oracle Integration and also for those who are not so new. 

Usage is simple – here are some examples – read the complete article here.

PaaS Partner Community

For regular information on Oracle PaaS become a member in the PaaS (Integration & Process) Partner Community please register here.

Blog Twitter LinkedIn Facebook Wiki

Technorati Tags: SOA Community,Oracle SOA,Oracle BPM,OPN,Jürgen Kress