Automating End to End Bulk Export from Oracle ERP Cloud using Oracle Integration (Part 1- ERP Cloud Callback) by Kishore Katta

image
Background

What are the main methods available for Outbound Integrations within Oracle ERP Cloud?

Oracle ERP Cloud has provided a very useful functionality which empowers business enterprises to extract financials data from Oracle Cloud ERP and integrate it with on-premise systems, legacy systems and other Cloud Applications.

One very common business scenario in an enterprise is to generate extracts of financials data like Journals, Payables Invoices, Payments, Receivable Invoices etc for legacy or third-party partner systems. Let’s see the Outbound mechanisms and the purpose of each of them based on the volume of data that needs to be sent to downstream applications

BIP Extract

Designed to extract incremental data for scenarios ex:

–Get the list of invoices that has been approved since last execution

–Extract payment data since last execution to update downstream or upstream applications to reflect payments 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.

clip_image003 Blog clip_image005 Twitter clip_image004 LinkedIn image[7][2][2][2] Facebook clip_image002[8][4][2][2][2] Wiki

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

OIC – Syncing Netsuite customers and contacts with Eloqua by Niall Commiskey

image

Introduction

What follows is a simple example of syncing Netsuite Customers/Primary Contacts with Eloqua Accounts/Contacts

I create a new customer in Netsuite – Commiskey Botanicals with Joe Strummer as a contact. I run the integration – and validate in Eloqua – So how did I do this?
An raibh sé draíochta? – you may well ask, but no, no magic, just OIC. So back to the integration. I began by creating a Saved Search in Netsuite – think of this like SQL for dummies – you pick the business object you’re interested in, join with other related objects and then you’re finished; you have the data you require. 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.

clip_image003 Blog clip_image005 Twitter clip_image004 LinkedIn image[7][2][2][2] Facebook clip_image002[8][4][2][2][2] Wiki

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

Integration b/w Oracle Engagement Cloud, Oracle CPQ & Oracle EBS by Atul Kumar

image

We have been getting a lot of queries from our Oracle Integration Cloud OIC trainees on Use case how to create an integration so that opportunity can be converted into a quote and then into order.

In this blog, I am going to show step by step process on how to use Oracle Integration cloud OIC to integrate Oracle Sales Cloud, Oracle CPQ (Configure, Price, Quote), and Oracle E-Business Suite so that data is synchronized in real-time.

If you are starting to learn Oracle Integration Cloud OIC we have a perfect training for you where you will learn to Provisioning OIC | Connectors/Adapters | REST & SOAP APIs | Customer Case Study | Security | Monitoring Integration.

Use Case

1. Opportunity Comes through Oracle Engagement Cloud and sent to Oracle CPQ Cloud.
2. Opportunity is received and converted into a quote through Oracle CPQ Cloud and sent to Oracle E-Business Suite.
3. Then the quote is converted into Order in Oracle E-Business Suite.
4. When the integration is completed the data should be synchronized in real-time between Oracle Engagement cloud (Sales Cloud), Oracle CPQ (Configure, Price, Quote), and Oracle E-Business Suite.

It is necessary that the systems to utilize one set of data and automatically transfer data between systems, this requires the systems to be integrated so that data could flow between them in a bidirectional manner.

For this scenario, we are choosing Oracle Integration cloud OIC as it offers bidirectional data synchronization. Oracle Integration will be used for bidirectional data synchronization between Oracle Engagement cloud (Sales Cloud), Oracle CPQ Cloud, and Oracle E-Business Suite.

What Is Oracle Integration Cloud (OIC)?

Oracle Integration Cloud (OIC) is a cloud-based integration application designed to perform integrations between SaaS to SaaS SaaS to On-Premise and vice versa. 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.

clip_image003 Blog clip_image005 Twitter clip_image004 LinkedIn image[7][2][2][2] Facebook clip_image002[8][4][2][2][2] Wiki

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

Integration Properties by Samir Sahu

image

How to externalize properties using Integration Properties in OIC?

Have you tried to use the integration to read the files from FTP and wondered if there was a way to externalize the FTP location outside the integration? Or create an integration that sends out notification and wanted to externalize the recipient of the email as a property to be passed as a parameter to the integration? We have heard from our customers on the need for an easy way to externalize properties from the integration and be able to modify the values without editing the integration.

Changing hard-coded parameter values in the integration canvas can be a time-consuming task as

        i) Integrations needs to be edited

        ii) Familiarity with the integration and the design tool in order to update the appropriate action and property.

Also, there are use cases where an integration is developed by a one user and run by different users. The user running it might not have privileges to edit the integration making it difficult to change the parameter values.

We have introduced a new feature that allows the integration developer to define properties which are exposed and can be modified outside of the integration designer. Integration developers can define properties of their choosing, providing them with meaningful names and default values, and then use them throughout the integration in the rich set of available actions. Although property values are not modifiable using integration actions, what makes them extremely useful is that the default value can be overridden outside of the design tool prior to running the integration. This feature is available for both – App Driven and Scheduled Orchestration styles. 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.

clip_image003 Blog clip_image005 Twitter clip_image004 LinkedIn image[7][2][2][2] Facebook clip_image002[8][4][2][2][2] Wiki

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

How to use the new Import/Export feature in Oracle Integration by Steve Tindall

image

With the August 2020 release, Oracle Integration now includes a great new feature that allows you to export all the design-time meta-data from your instance into a single export file stored on OCI Block Storage. That same export file can then be imported into a different instance of Oracle Integration, effectively giving you a complete migration and/or backup capability. There are several options that can be chosen when configuring an export job depending on your intended use and we will explore those a bit later on.

I have also included a Further Reading section at the bottom of this guide that will take you to the relevant documentation for this UI and it’s underlying API’s – should you wish to automate these activities in your devops processes.

This guide will walk you through these major steps:

  1. Create a storage bucket in OCI Object Storage
  2. Create an OCI Auth Token for accessing to your storage bucket
  3. Configure your storage bucket for use in Oracle Integration
  4. Create an Export Job in Oracle Integration
  5. Create an Import Job in Oracle Integration

Create a storage bucket in OCI Object Storage

Before we get started creating export jobs, we must create a storage bucket in OCI and then configure secure access so that Oracle Integration can connect to your storage bucket. Let’s first go and create a storage bucket in OCI and then we will come back to Oracle Integration to configure and use it.

First, open your OCI console for your cloud account. Next, locate “Object Storage” in the left sidebar menu and select the sub menu “Object Storage” i.e. Object Storage à Object Storage. 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.

clip_image003 Blog clip_image005 Twitter clip_image004 LinkedIn image[7][2][2][2] Facebook clip_image002[8][4][2][2][2] Wiki

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

Top tweets PaaS Partner Community November 2020

imageNovember top tweets by PaaSCommunity

Send your tweets @soacommunity #PaaSCommunity and follow us at http://twitter.com/soacommunity. Make sure you share your content with the community!

PaaS Partner Community

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

clip_image003 Blog clip_image005 Twitter clip_image004 LinkedIn image[7][2][2][2] Facebook clip_image002[8][4][2][2][2] Wiki

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

PGP Encryption/Decryption using Stage: OIC by Ankur Jain

image

Oracle Integration Cloud Stage File action is one of the important actions that allows us to perform various operations(list, write, read, read in chunks, etc.) on a file.

Stage File is becoming stronger now as the PGP encryption & decryption features have been added.

The new feature makes it easy to configure PGP keys in Stage File. You can perform a Read/Write operation to decrypt/encrypt files up to 10 MB in size in Stage File action.

A complete video has been shooted to showcase how it works. 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.

clip_image003 Blog clip_image005 Twitter clip_image004 LinkedIn image[7][2][2][2] Facebook clip_image002[8][4][2][2][2] Wiki

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

Real Time Item Synchronization using Oracle Integration by Kishore Katta

image

Usecase

As we move critical systems to the cloud, maintaining a true Item Master at the core becomes astronomically challenging without standardized controls. Whether just starting or well into the cloud, a simplified Item Master will drive business transformation no matter what the make-up of your world. Irrespective of Consolidation or Centralized Style of implementation of Oracle Product Hub Cloud the Real Time Synchronization of Item/Attributes/Item Categories/BOM and related information with Enterprise ERP’s and Commerce ERP’s is pretty much a necessity. Look at the World of Possibilities which is true in many of the Real Customer Scenarios.

In this use case we will explore the use of Oracle Integration to subscribe to Oracle Product Hub Cloud Events and push the relevant event information to downstream systems such as E-Business suite for a typical Hybrid Deployment scenario.

a. User creates an Item in Oracle Product Hub Cloud

b. Oracle Integration subscribes to the Item event, transforms and pushes the relevant Item information to E-Business Suite 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.

clip_image003 Blog clip_image005 Twitter clip_image004 LinkedIn image[7][2][2][2] Facebook clip_image002[8][4][2][2][2] Wiki

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

New SOA Modernization Overview free online training including free certification now available!

imageAccess this training to get a SOA overview and three options to enable your customers to rapidly modernize their SOA infrastructure and connect their SaaS and mobile applications with existing on-premise systems. Attend the free on-demand webtraining here.

PaaS Partner Community

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

clip_image003 Blog clip_image005 Twitter clip_image004 LinkedIn image[7][2][2][2] Facebook clip_image002[8][4][2][2][2] Wiki

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

Oracle Implementation Certifications

imageEnablement 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. Additional we offer the latest implementation exams ($245 or free vouchers) for:

· Oracle Cloud Platform Application Integration 2020 Specialist | 1Z0-1042-20

· Oracle Cloud Platform Digital Assistant 2020 Specialist | 1Z0-1071-20

· Oracle Cloud Platform Application Development 2019 Associate I 1Z0-1043

· Oracle Cloud Platform Enterprise Analytics 2019 Associate | 1Z0-1041

· Oracle Cloud Platform Content and Experience 2019 Associate | 1Z0-1040

PaaS Partner Community

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

clip_image003 Blog clip_image005 Twitter clip_image004 LinkedIn image[7][2][2][2] Facebook clip_image002[8][4][2][2][2] Wiki

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