Oracle Logo
Identifier Logo
August PaaS Newsletter Banner
August 2021 Edition Oracle Integration & Process Partner Community Newsletter

Grow the Oracle Cloud business and connect, extend & innovate Oracle SaaS solutions.
Dear PaaS Partner Community
Congratulations to your success and thanks for the great collaboration in the last fiscal year. To accelerate growth, here are the summarized steps to success:

• Watch the on-demand launch webcasts to connect, innovate & extend SaaS and connect & shift workload to the Oracle Cloud Platform.
• Attend an integration or digital assistant hands-on training to become a certified expert.
• Access the sales kits including customer presentation in ppt format.
• Join the Integration and Developer partner community.

It’s summer and time for the August 2021 Oracle Integration Update. Join our September 16th webcast for details & please subscribe to the quarterly customer newsletter.

Thanks to the community for sharing all these integration articles: Authenticating Oracle Integration flows using OAuth token from 3rd party provider & Oracle HCM Cloud – Payroll Sync with the Oracle Integration Cloud & Oracle Integration Message Packs and Pricing & Connecting securely from Oracle Integration to Autonomous database using network access list & Improving the performance of Oracle Integration flows that use REST calls & Using REST APIs to manage Connections in OIC & Oracle Integration Cloud (OIC) & octet-stream MIME-type & Use Oracle Integration to connect E-Business Suite with SOA to Financials Cloud & Logging Analytics for OIC & OIC and Logging Analytics - steps towards fleet management & OIC Monitoring and Logging Analytics - more steps towards Fleet Management & OIC Monitoring and Logging Analytics - adding Business Data to Dashboards & Enable Business Events for Payables Business Events/Payments in Oracle Fusion Finance Cloud & Business Identifiers in Oracle Integration & OIC: How to perform FBDI GL File Upload & Database Xpath-extension Functions in SOA 12.

In the process & innovation section Jan discusses how Granular Should My Microprocesses Be?
Many documents require an approval process, use Oracle Integration to Add Attachments to a Process Instance.
Jürgen Kress
For a short summary of our monthly key information watch the PaaS Partner Updates on YouTube & the August edition highlights, the on-demand launch webcasts and the Integration & Digital Assistant sales kits.
In this month’s community webcast Michael Meiner will present how to connect and extend your applications and systems using pre-builts from Oracle Integration. Please join the Partner Community Webcast August 31st 2021. On-demand webcast recordings are available at the Oracle Video Hub.
Want to publish your best practice article & news in the next community newsletter? Please feel free to send it via Twitter @soaCommunity #PaaSCommunity.

Keep safe!
Jürgen Kress
PaaS Partner Adoption
Oracle HQ
Tel. +49 89 1430 1479
E-Mail: juergen.kress@oracle.com
Blog LinkedIn Twitter
Table Of Contents
Community Announcements

SaaS Partner Banner
Connect, Innovate & Extend SaaS Partner Launch Webcast
Watch our Launch Webcast
Want to increase the Oracle Cloud business? Create new service offerings for Oracle SaaS solution based on the Oracle Cloud Platform?

Watch this webcast with Suhas Uliyar, Vice President Oracle Product Management.

SaaS solutions like HCM, CX and ERP Cloud need to be integrated and customized:
Oracle Integration connects SaaS solutions with out of the box adapters.
Oracle Digital Assistant innovates SaaS solutions with pre-build chatbots.
Oracle Process and Visual Builder extends SaaS solutions with customized UIs and workflows.
Speaker: Suhas Uliyar Vice President Product Management Digital Assistant, AI & Integration Oracle HQ.
Oracle Cloud Platform Banner
Oracle Cloud Platform Partner Launch Webcast On-Demand
Want to increase your Oracle Cloud Platform business? Want to create new service offerings and solutions for the Cloud? Watch this webcast with Martijn Vlek, Vice President Integration and Security EMEA!

Watch the webcast with Martijn Vlek, Vice President Oracle EMEA!
Content:
• Cloud Platform update
• Sales Plays & Cheat Sheets
• Customer presentations & demos & free trials
• Partner resources & support

Speaker: Martijn Vlek,
Vice President Integration and Security EMEA
Partner Community Webcast Banner
Connect and Extend your Applications and Systems
PaaS Partner Community Webcast August 31st 2021
Learn how to leverage adapters and accelerators to grow your business. We will cover the latest innovations in prebuilt adapters, including:
• Key features in new and existing application adapters
• Special highlight: new adapters offered by Advantco, an Oracle partner
• Accelerators and recipes available in Oracle Integration
• How partners can leverage and promote pre-built integrations

Speaker: Michael Meiner
Schedule: August 31st 2021 16:30-17:30 CET (Berlin time)

For details please visit the registration page here.
Take the opportunity to watch our community webcasts on-demand:
How to connect your B2B ecosystem using Oracle Integration
Connect, Innovate & Extend SaaS Partner Launch
Oracle Cloud Platform Partner Launch Webcast on-demand
Oracle Visual Builder What’s New
Accelerate your chatbot projects with Oracle Digital Assistant Templates
Identity Propagation call from Integration Cloud to Oracle SaaS Applications
Connect Opera with Oracle SaaS
Extreme Scalability and Enhanced Resilience for OIC
SOA Modernization
Cloud Native and Serverless SaaS Extensions
How Process Workflow can extend the role of Integration
Innovate Service Cloud with Chatbots
• Integration Update & New Features
Chatbot Design best practices for Conversational UX
Cloud Platform KickOff Webcast 2020
NetSuite Integration
Integration Insight
Innovate HCM with Chatbots
ERP Integration with Application Adapters
HCM Integration with Application Adapters
Extend SaaS with Visual Builder Cloud Service
Integration Adapters
Integrate SaaS

For the latest information please visit Community Website (Community membership required).
Partner YouTube Banner
Cloud Platform Partner YouTube Update August 2021
The August video includes three topics:
 
• Launch Webcasts on-demand
• Sales kits
• Integration adapter Webcast

For regular updates please subscribe to our YouTube channel here. Thanks for your likes and sharing the video on YouTube and LinkedIn. For the latest integration & process information, please join the PaaS community.
SaaS Bootcamp Banner
Integrate SaaS Hands-on Bootcamps Webtraining
Do you want to find out why Gartner named Oracle as a Leader in Magic Quadrant for three years in row? Are you able to innovate quickly in the new digital world? Are you looking for ways to integrate systems and data faster using a modern cloud integration platform?
Free Oracle Cloud platforms 30 days cloud trial are available here. Your Oracle partner manager can extend this trails.

For SaaS trials please visit https://demo.oracle.com . For support please contact the OPN Team.

Attend the Oracle Integration Bootcamp, a three days hands-on training for Oracle partners.

Oracle Product Management is pleased to invite Oracle Partners to attend a 3-days hands-on workshop on how to integrate with ERP & HCM applications using Oracle Integration Cloud.

This Invite-Only hands-on workshop will be delivered at No-Fee to Partners. It will consist of presentations, demos, and hands-on labs.

Oracle Integration Cloud (OIC) offers Integration, Process Automation and Visual design capabilities that help business analysts and IT specialists to automate end to end business processes across departments.

Oracle Integration Cloud offers a simple recipe to be successful in this application integration and process automation journey: Build, Integrate and Engage.

Schedule:
On-demand training
US & Canada August 10th, 12th & 17th 2021
India August 24th, 26th & September 3rd 2021
South America September 8th, 9th, 10th 2021
Oracle Implementation Banner

Oracle Implementation Certifications


Enablement and certification are key to cloud success.
At the Oracle Competence Center and Online Learning Library partners can attend free on-line classes and certifications. In addition we offer the latest implementation exams ($245 or free vouchers) for:
Oracle Application Integration Cloud Platform 2020 Sales Specialist
Oracle Integration Cloud 2022 Solution Engineer Specialist
Oracle Cloud Platform Application Integration 2021 Specialist | 1Z0-1042-21
Oracle Cloud Platform Digital Assistant 2020 Specialist | 1Z0-1071-20
SOA Modernization Overview
Integration Section
August 2021 Oracle Integration Update
By: Antony Reynolds:


It is time for the August quarterly update to Oracle Integration. With Summer in full swing, Lilly, the Oracle integration mascot, is pleased to share all our new features and improvements. Note that testing is still underway for these features and, although unlikely, it is possible that some will not meet our quality standard and be deferred to a later release.

Announcements & Update Windows

Currently tenant administrators get notified of OIC Gen 2 updates via notifications in the OCI console. OIC Gen 2 administrators can also see the same update notice in the OIC console, so watch out for the date of your update.

Remember, you can also mark your Gen 2 instance for update in either the first or second update window, as explained in Choose Your Update Window. If you previously tagged your instance, then there is no need to tag it again. If it is not yet tagged for window 1, then the deadline for tagging for August was 14 July but you can still add it for the November release. Tags added after July 14 will take effect for the November release.

An Artificially Intelligent Assistant

This release continues to expand the artificial intelligence capabilities within Oracle Integration by debuting a new digital assistant named Oracle Assistant. Use Oracle Assistant to learn how to get started with Oracle Integration, find answers to your questions, and more. Give it a try, and let us know what you think!

To learn more about how Oracle Assistant was developed see this great video
.

Prebuilt Connectivity Enhancements

As usual there are enhancements to existing adapters as well as important new adapters.

New Third Party Adapters

Two new adapters for popular applications are released this quarter:

• SAP S/4 Hana Adapter
• Zendesk Adapter

Enhanced Adapters

Exciting updates to a number of third-party adapters:

• OData support in SuccessFactors Adapter
• Platform Event support in Salesforce Adapter
• JQL support in Jira Adapter
• Custom Objects are now supported in Bulk Export in Marketo Adapter

Recipes Update

Lots of new recipes, many of them dealing with customer experience (CX) applications.

Note that these recipes may not ship at exactly the same time as the August update. check the OIC home page for these recipes.
Read the complete article here.


Authenticating Oracle Integration flows using OAuth token from 3rd party provider
By: Prakash Masand


As Oracle Integration customers look to embrace the multi-cloud strategy, they will have cross-cloud business applications & processes. In the context of a realistic business solution, customers will end up having a business requirement to integrate the business applications and services across multiple cloud providers. As an example, let's say the customer has a business application running on a non-Oracle Cloud provider like Microsoft Azure. This business application now has a requirement to fetch the information from the
Oracle Cloud applications.

In normal circumstances, one would acquire the token from the Oracle Identity Cloud Service, to fetch the information from Oracle Cloud applications. However, in a multi-cloud vendor solution, this will cause additional complexity of handling multiple tokens lifetime, additional security risk, etc. In such a scenario how good it would be if one can fetch information or I may say integrate with cross-cloud vendor applications using OAuth token in hand. This is exactly the topic of my blog i.e. how one can invoke the Oracle Integration flow using the 3rd party OAuth providers.

I will expound on the same example I portrayed earlier as a sample use case for the blog, we will see how one can use the OAuth token obtained from Microsoft Azure AD to invoke the Oracle Integration flow.

Let's now talk about the highlevel solution, we will be leveraging a couple of Oracle Cloud Infrastructure services viz. Oracle API Gateway and Oracle Functions. At an outset, we will use the OCI API gateway to be the front end of our Oracle Integration flow.

Oracle API Gateway supports using the authorizer function as an extra logic layer for authenticating the APIs. This is exactly what we want i.e. we would like to build logic to validate the OAuth token received from callee and exchange it with the required token from the Oracle Identity Cloud Service for invoking the OIC flow. Let us now visualize the solution flow graphically:

As you can see from above, here the process starts with the user/business application acquiring the OAuth token from Microsoft Azure AD, once acquired it invokes the endpoint exposed through Oracle API Gateway. Oracle API Gateway will be invoking the custom authorizer Oracle Function (based on configuration) and then invokes the real backend endpoint i.e. Oracle Integration flow.

Let us now dive into the details of implementing the above process/flow, for the sake of simplicity I am going to divide the above process into three steps viz. 1) Oracle Integration/IDCS configuration 2) Oracle Function custom authorizer implementation 3) Oracle API Gateway configuration. Read the complete article here.


Oracle HCM Cloud – Payroll Sync with the Oracle Integration Cloud
By: Daniel Teixeira

The most common use case I come across with Oracle HCM Cloud is Payroll Integration. Most organizations use 3rd party Payroll providers. Many of those have multiple payroll providers if they operate in multiple countries. This means that there are several different requirements for each of those providers.

With the Oracle Integration Cloud, we can provide and automate framework to manage the Integration with all Payroll providers and with ERP also (the bigger end to end process also touches ERP)

This post will show a sample implementation of this.

Create HCM Extract

First things first – We need to define a HCM Extract. This is the extract that contains all the required data to be sent to the Payroll providers. This is definitely not the job of the integration developer/architect, but we need to have this in place.
There are some options on how to do this:

1: One extract for all payrolls – OIC will do the proper mapping for each payroll.

2: Multiple extracts, one for each payroll – OIC will do minimum mapping. Read the complete article here.


Oracle Integration Message Packs and Pricing
By: Ankur Jain


Oracle Integration billing depends on the Message Pack you provide while provisioning the Oracle Integration instance. The minimum Message Pack for Oracle Integration is one. The maximum number of Message Pack depends on the Licensed Type you choose while creating the Oracle Integration instance.

Oracle Integration offers two types of licenses you need to choose from and accordingly set the maximum number of message packs. The following figure shows the type of license and max threshold.

Oracle Integration license and max threshold

Pricing is based on the number of Message Pack/hour as shown in the following figure:
Oracle Integration pricing

Refer to the document for the latest pricing. Few pricing examples are given as per the following tables: Read the complete article here.


Connecting securely from Oracle Integration to Autonomous database using network access list.
By: Shreenidhi Raghuram

Introduction

Many integration use cases require the use of Autonomous database (ADB) as the parking lot datastore with Oracle Integration.

Oracle Integration provides various options to connect to ADB. The Oracle integration documentation table below summarizes these options.

* Cloud Database Connectivity Support

Options

In summary,

• Connecting to ADB dedicated instances (ADB-D) and ADB shared private endpoint DB requires an OIC connectivity agent.

• Connecting to ADB Shared infrastructure (ADB-S) database uses JDBC over SSL and provides direct connectivity using wallet.

Note that this mode does not require the connectivity agent to be deployed. Oracle integration connects using JDBC over SSL directly to the ADB-S public endpoint in this case.

Use case


Certain organizations' security requirements or use cases may mandate that the database network traffic should only traverse through a private endpoint within a VCN. These use cases undoubtedly will need to use the ADB dedicated or ADB shared private endpoint databases. Oracle integration requires the connectivity agent to be deployed in the ADB VCN for these modes. Read the complete article here.


Improving the performance of Oracle Integration flows that use REST calls

By: Nick Montoya

Oracle Integration connects disparate SaaS and on-premises applications to help businesses move faster. This interaction between Oracle Integration Cloud (OIC) and Oracle SaaS (or on-premise) applications needs to be carefully designed and planned for performance and scalability. Overloaded integration flows may run within acceptable timeframes during design phase. They may even pass User Acceptance Testing especially if testers are just going through functional testing. However, when testing for performance and scalability, problems may arise. It is imperative to design solutions that would meet expected peak volumes at runtime. This blog will provide some helpful pointers that you could use to make your solutions achieve better performance and scalability.

Identify Peak Volume Profile and test downstream systems.

When designing an Oracle Integration solution for Performance and Scalability, it is very important to identify the peak-hour and peak-day volume. Knowing how many integrations will be running at peak hour will not only help you size your Production OIC environment accordingly, but also, it will help in the testing of your downstream (from OIC point of view) systems.

Testing of downstream systems with expected volumes early in the implementation cycle will help you validate a scalable implementation and/or identify performance bottlenecks in your design.

If these outbound calls take longer than a few seconds, then there is plenty of design work to do. Longer synchronous calls to outbound systems may cause OIC to wait for these calls to finish and it may block other processes from running in OIC. Therefore, end users may experience longer response times. Read the complete article here.



Using REST APIs to manage Connections in OIC

By: Pranav Davar

In cases, when we have many connections created on the OIC instance, it becomes hard to manage connections using the OIC console. Also, to achieve automation, manually going and updating each and every connection is never a feasible task. OIC provides various REST APIs to fetch connection details, update connection properties and delete connections. With the help of these APIs, we can overcome such scenarios.

In this blog, we will be discussing how to use various OIC connections REST APIs. A postman collection in the public workspace, which contains some of the use cases for this and can be forked, updated, and used accordingly.

Below are various REST APIs, that are covered in this blog:

1. Retrieve Connections
2. Retrieve a Connection
3. Update a Connection
4. Test a Connection
5. Refresh Metadata for a Connection
6. Delete a Connection

In this blog, we will be using Postman to test and run various APIs. Below is the link to the Postman collection, which will be helpful to try and test different REST APIs.

Authentication for REST APIs

To invoke OIC connections REST APIs, BASIC AUTH can be used to authenticate and authorize calls. The user whose credentials are used to call these APIs must have access to edit the connection.
OAuth can also be used to authenticate to REST APIs. In this blog, we will be using Basic Auth to authenticate/authorize API calls. Read the complete article here.



Oracle Integration Cloud (OIC) & octet-stream MIME-type
By: Amy Simpson-Grange


I was recently working on an integration in Oracle Integration Cloud (OIC) which leveraged APIs exposed from Oracle HCM. I needed to retrieve details from the REST endpoint in the image below. The overall solution would take this REST response and write the data to an XML file to be consumed by another system.

REST Endpoint
Response headers: Content-Type =
application/octet-stream

As you can see in the REST response headers above, the content-type of the response is application/octet-stream. This response type has been supported by the Oracle Integration REST adapter for a couple of years now and is configurable in the trigger request and response allowing the possibility to both invoke REST integrations using binary content and return binary content in a REST response.

What is application/octet-stream MIME attachments?

Effectively, a MIME attachment with the content type “application/octet-stream” is a binary file. Usually, the MIME attachment is an application file or document that may be opened in specific applications. For example, a spreadsheet .xlsx file would open in Microsoft Excel, a .docx file would open in Microsoft Word or an .exe file would indicate a Windows or DOS executable program. However, the application/octet-stream MIME type is used for unknown binary files anFd is in fact the default binary file. File contents will be preserved in binary but it requires the processor to understand and determine the specific file type (e.g, from a filename extension).

Using application/octet-stream in OIC

This feature can be used by selecting the “Raw” option within the invoke Request/Response page when configuring the REST adapter. Read the complete article here.

Use Oracle Integration to connect E-Business Suite with SOA to Financials Cloud

Most deployments of Oracle E-Business Suite are integrated with other commercial or bespoke applications so companies can run their processes with agility. Oracle software-oriented architecture (SOA) Suite is a popular choice to provide integration to EBS for its broad connectivity options and EBS Adapter capabilities.

When you move your applications to the cloud, there are more opportunities to modernize and integrate with other cloud services and SaaS applications. Oracle Integration takes integration and connectivity capabilities beyond yet reusing what is developed and running on SOA Suite.

This architecture presents the end state of moving an EBS instance to OCI along with the integration built with SOA Suite in a secure setup and the components needed to connect Oracle Integration with SOA Suite and EBS. This architecture also shows integration with Oracle Financials Cloud.

Architecture

This architecture shows the deployment of Oracle E-Business Suite in a single availability domain inside a single Oracle Cloud Infrastructure region, along with existing integrations built using Oracle SOA Suite. Oracle Integration connects to SOA using the Integration connectivity agent to provide reuse of integrations built with SOA and connectivity to other SaaS applications and cloud technologies.

The architecture includes two compartments, both of which have Cloud Guard enabled to provide maximum security based on Oracle's security best practices. In addition, the compartment where the database system and the autonomous database private endpoint are deployed is a security zone compartment.

Each compartment contains a virtual cloud network (VCN), which are connected through a local peering gateway, allowing network traffic between the two. Components are in different subnets and fault domains to provide high availability. The databases are accessed only through the bastion host and the application virtual machines (VMs) are accessed through the load balancers.

The database and the application instances that are deployed in their private subnets on OCI are backed up to OCI Object Storage by using a service gateway. A service gateway provides access to Object Storage without traversing the internet. You can use the automatic and on-demand database backups feature to back up applications and the database.

Use a network address translation (NAT) gateway to enable outbound connection from the application instances in the private subnets to the Internet to download patches and apply operating system and application updates. With a NAT gateway, the hosts in private subnet can initiate connections to the Internet and receive responses, but don't receive inbound connections initiated from the internet. Read the complete article here.



Logging Analytics for OIC
By: Niall Commiskey

With OIC on OCI we get a plethora of monitoring capabilities; we also have the ability to analyze logs and naturally push data to other analytics services such as Oracle Analytics Cloud. All of us are, hopefully, very familiar with the OOTB monitoring features of OIC. This post goes a little deeper to see what's on offer at OCI level. This post discusses the OIC Metrics available at OCI service level. It also looks at the OCI Logging Analytics service and the value-add it provides. So let's get going!

The above dashboard is a simple and basic example of what one can do with OIC logs in OCI Logging Analytics service.

There are 2 sources for the data shown above - let's call them default and custom. Part 2 of my recent post discusses the former. You can check out the post here.

So now to Logging Analytics - here is the main menu.
Read the complete article here.


OIC and Logging Analytics - steps towards fleet management By: Niall Commiskey

This post covers the scenario of aggregating the logs of OIC instances from different regions within the one tenancy. In my case, OIC1 is in UK South(London) and OIC2 is in US West(Phoenix). So how best to approach this?

We've seen in a previous post how easy it is to push the OIC Activity Stream logs to OCI Logging Service. That is the starting point for us.

So back to our use-case - this is the high level flow - OIC1 London Activity Stream Logs to OCI Logging – Read the complete article here.


OIC Monitoring and Logging Analytics - steps towards Fleet Management
By: Niall Commiskey

The previous post mentioned 2 OIC instances in two different regions. A typical fleet management requirement would be to check whether both OIC instances are up and running. Here's where OCI APM - Application Performance Management can help.

It contains a feature called Synthetic Monitoring - The APM docs tells us that Synthetic Monitoring helps in simulating a path in the application that a user would normally take, and ensure that the user can transition through the different web pages in the path smoothly. This helps to recognize application performance issues before the end user experiences it. I created 2 simple ping-style integrations, one in my London and one in my Phoenix OIC instance. These can then be called by APM – Read the complete article here.


OIC Monitoring and Logging Analytics - adding Business Data to Dashboards
By: Niall Commiskey

Integration Insight is THE solution for business user facing Dashboards on top of your integrations and processes. However, you can also surface business / payload data in Logging analytics. The example below is again based on the OIC Activity Stream logs.

Now we do suggest turning off logging for your production integrations, however, there may be reasons for logging, such as for compliance purposes e.g. I need to prove when order nr 123 was processed. The OIC LOG action will still write to the OIC Activity Stream, even when flow logging has not been enabled.

Here is my simple order processing integration - Read the complete article here.


Enable Business Events for Payables Business Events/Payments in Oracle Fusion Finance Cloud
By: Deb Mukherjee

For Expenses / Financial Common Module / GL / Receivable / Revenue Management Business events are enabled using Rest API , but for Payables and Payments there is a facility to do it from Front end.

Go to Setup and Maintenance > Find Manage Administrator Profile Values > Search Enable Business Events

Toggle this value from NO to YES :-

Roles needed:

• Application Implementation Consultant
• Financial Administrator

Oracle OIC ERP Adapter Supported Events list Check Subscription like below: https:///soa-infra/PublicEvent/subscriptions. Now it shows empty subscription. We will check the same again once the process is over.


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.


OIC: How to perform FBDI GL File Upload

By: Deb Mukherjee

That FBDI file upload was kind of Straight forward.

However now we will see how to load a FBDI file where the Process expect some Extra Parameters.
Example: The Import Journal process.

The best way to do this is to Generate the FBDI file manually and then load it in Oracle Fusion.
Followed by that we can try automating the process.

Highlights of Manual Upload

Now Go to TOOLS > JOURNALS > TASKS > Manage Journals and locate any existing period.
Click and open any Journal to get an idea of it.
Now we can download the template file and generate the sample data file to load.
The template file for Journal Import can be downloaded from here


Database Xpath-extension Functions in SOA 12
By: Pranav Davar


In SOA, we can connect with databases using a database jca adapter and configuring the data source and connection factory in the WebLogic server. Sometimes, we may want to query the database directly within the BPEL component or XSLT without configuring a database jca adapter. For such use cases, we can take leverage of database functions that can be used within BPEL Assign Activity or XSLT transformations.

We have 3 different database functions available, that can be used in different use cases.

1. oraeext:sequence-next-val()
2. oraext:lookup-table()
3. oraext:query-database()


1. oraext:sequence-next-val()



Syntax:

oraext:sequence-next-val(sequence as string, dataSource as string)
sequence: Specify the sequence available in the database for which the next value needs to be extracted.
dataSource: Specify the Data source JNDI name as configured in WebLogic server or JDBC string in the format jdbc:oracle:thin:username/password@host:port:sid.
Note: Only oracle thin driver is supported if used as JDBC string.

This function is used when we want to fetch the next value of defined sequence in the database. It can be used in cases where we want each request to adhere with a particular sequence id which can be used to identify each unique record where using a db adapter might create overhead and extra transformation. This function is basically an alternative to the below SQL statement. Read the complete article here.
Business Process Management & Innovation Section

How Granular Should My Microprocesses Be?
By: Jan Kettenis

As with all modularization principles, finding the right granularity is not always trivial and the more important. Some of us have seen complete projects fail because of getting this wrong. The Microprocess Architecture is no exception to this rule and in the following I discuss this topic, hoping to guide you in getting it right.

As explained in the article introducing the Microprocess Architecture the rationale for applying it consists of a combination of reducing impact when implementing new features and bug fixes, ease applying them to an already deployed business process, supporting parallel development and few others. Said differently and in one word: agility.

To correct the mistake made in the introducing article of not defining what a microprocess stands for:

A microprocess is a subprocess of a larger business process, where the subprocess spans the execution of one or more activities to reach a business significant state change of the business process, and which can be developed and deployed as a stand-alone component.

This definition implies that the scope of a microprocess has business visibility. However, as such that does not yet clarify the right granularity. Too course-grained and there is a risk of not delivering on the core value of agility, too fine-grained and you risk issues with performance and scalability.

So, what is the right granularity? First let me try to illustrate by example. I then capture some of the main characteristics that should give you guidance on how to apply it for your use case.

Order handling example:

An order handling process of a bank, that starts with a customer submitting an order form and ends with invoking one or more back-end systems to handle the delivery, could consist of the following micro-processes: Read the complete article here.


Use Oracle Integration to Add Attachments to a Process Instance
By:
Bogdan Eremia

The other day it came to my attention that it’s not really straightforward to add attachments to an Oracle Process Instance using the REST API.

One reason for this is that it requires multipart/mixed media type for the request body message format, and producing this kind format is not so common for JavaScript clients. The JS clients are more used to working with multipart/form-data, the de-facto standard for form-based file upload in HTML.

One way of overcoming this is to use Oracle Integration Cloud (OIC) between the JS client and Process REST API. OIC has a REST Technology Adapter that supports sending/receiving attachments in both multipart/mixed and multipart/form-data media types. The goal is to shape in OIC a REST interface that accepts multipart/form-data, to do a translation into multipart/mixed (alongside with other transformations/actions if required) and to call the Process REST API. Below are the main steps for achieving this.

1. Create a REST Connection in OIC for Process REST API.

Go to OIC Homepage > Designer > Connections to create a new connection by selecting the REST Adapter.
Read the complete article here.

My private corner – Congratulations to 1 million page views

Additional New Material for PaaS Community
  • Cloud discounts To accelerate migrations to the cloud, Oracle gives organizations moving to Oracle Cloud Infrastructure (OCI) a 25% to 33% discount on tech software support for every dollar spent on OCI. Some companies could see their Oracle Database or Oracle WebLogic Server support bill go to zero
  • Free Tier freedom Two developer teams describe how they use Oracle Always Free Services to create real-world applications—fast, without spending on cloud infrastructure. The Free Tier lets developers spin up new apps quickly with little risk before scaling up.
  • Accelerate Your Cloud Strategy: Featuring Larry Ellison On demand.
  • Oracle Live – The Future of Business with Steve Miranda
  • Renewable by 2025 Oracle is helping customers reduce their carbon footprint while leading the way toward a more sustainable future, pledging to power its global operations—both facilities and cloud—with 100% renewable energy by 2025.
Twitter SOA Banner
Top Tweets PaaS Community
Send your tweets #PaaSCommunity
Follow us on Twitter.
Training Calendar Banner
Training Calendar
For the latest trainings visit our PaaS Partner Trainings
Join the Oracle Developer Meetup groups
We launched three new local Meetup locations in Cairo, Frankfurt and Porto! Want to learn more about developing Enterprise-grade Cloud Native applications on the Oracle Cloud Platform, covering topics like Microservices Architecture, developing in Node, Python and PHP, using Low Code development tools to build Mobile apps, and much more?

Join the Oracle Developer Meetup groups if you want to follow Oracle’s solutions in this area or participate in the events and hands-on labs we organize:
  • Utrecht, Netherlands
  • Brussels, Belgium
  • Cairo, Egypt
  • Lisbon, Portugal
  • Lille, France
  • London, UK
  • Madrid, Spain
  • Istanbul,Turkey
  • Sao Paulo, Brazil
Free Trials Banner
PaaS free trial Accounts
Free Oracle Cloud Accounts 30 days cloud trial are available here. Your Oracle partner manager can extend this trails.

For SaaS trials please visit https://demo.oracle.com. For support please contact the OPN Team.
FY22 Banner
Congratulation to Niall Commiskey our Oracle Integration Product Manager for 1 million blog views. With 871 articles, the best resource for the latest OIC news and technical tips. Visit Niall’s blog here, for additional integration blogs please see here.
You write a blog? Let us know, send us a tweet at #PaaSCommunity!
Community Resources
Slack
Blog & Twitter
Workspace
Stay Connected
Facebook Linkedin Twitter Youtube
#PaaSCommunity