Creating Journal Entries in Netsuite via OIC by Niall Commiskey

My first real foray into the magical world of bookkeeping. What is a journal entry?

Apparently journal entries are used to record business transactions. And remember the books must always balance – so here’s an example for a sales entry – I sell my Hare of the Dog T-Shirt on credit, so I need to debit accounts receivable and credit sales. Ask your accountant, if you need to know more.

Net, net, I can create a Journal Entry in Netsuite, via the OIC Netsuite adapter. Again, I am not a Netsuite or bookkeeping expert, so my first step is to create a Journal Entry in Netsuite itself and then look at the xml version. 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

How to Configure the New Oracle Integration Cloud (OIC) Streams Adapter by John Graves

Introduction

I’m writing this blog because some of the existing documentation is a bit confusing and I initially struggled to get the new OIC Streams Adapter configured.

Connector Parameters

There are not many things to setup for the connector, but let me explain each one in detail:

Bootstrap Servers

If you search around, you’ll find lots of different examples of how this should look.  Some use "cell-1" prefix, some show "console" prefix and others. For The OIC Streams Adapter, this should be in the form:

streaming.us-ashburn-1.oci.oraclecloud.com:9092

where the "us-ashburn-1" is replaced with your region (e.g. us-ashburn-1,us-phoenix-1, etc).  This can be found in the URL when you login to the OCI console. The rest should be the same and the port should be 9092.

SASL Username

This part can be confusing.  The docs often speak of an ID, but not meaning OCID.  Let me try to make it clear here.  It is made up of three parts: 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

Zero loss of service, smoothly migration from Salesforce to Oracle Apps CX with Oracle Integration Cloud Salesforce Adapter plus helper technology tools such as an Autonomous Database, Data Integration and Object Storage by Javier Mugueta

One of the big challenges regarding migrations is operational risk when moving from the old solution to the new one. Oracle Cloud provides technologies and tools that help reduce the risk to almost zero by leveraging patterns that allow the coexistence of both solutions during the migration phase, giving the alternative to deploy Oracle CX in tracks that can go live sequentially avoiding a big bang approach which typically sounds scaring.

Salesforce Adapter

Oracle Integration Cloud (OIC) provides Salesforce Adapter, an bidirectional integration component that can be used for synchronisation between Salesforce and Oracle CX during the migration project, helping in the roll out of the different modules in CX by maintaining objects created in one side replicted in the other or vice versa.

With the adapter, we can catch CRUD operations events in both sides, creating/updating/deleting the corresponding entities as long as data is created in SalesForce or Oracle. 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

Update Lookups in Oracle Integration Cloud by Ankur Jain

Update lookups in Oracle Integration Cloud are one of the most common requirements and this has been asked in multiple forums on how to update lookup hence the article is written.

Integration doesn’t have inbuilt functions to update lookup values at runtime. To solve this, OIC offers a REST API to update lookup as per need. The REST API details:

PUT: /ic/api/integration/v1/lookups/{lookupname}

Request Payload: 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

Extending OOTB OIC Recipe – Extract New Hire Info by Kishore Katta

Background

In the previous blog we have seen how to Install and Run a Recipe – Extract New Hire Info from Oracle HCM Cloud. Extract definition is created and executed in HCM Cloud as a pre-requisite for the OOTB Recipe to work. In this blog we will create an Integration Flow in OIC to extend and automate the whole process of executing the Extract instead of having it done manually from HCM Cloud. Also, there has been incredible uptake of cloud storage buckets which provides a simple, low cost mechanism to store both structured and unstructured data. Data Archiving is one of the key use cases for extracts. We will store the extracts in an OCI Storage bucket as part of the Integration Flow. 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

Replace Existing Connection with New Connection in OIC Integration by Amit Kumar Suman

New update in OIC allow us to replace any connection used in an integration with another connection of same Type and Role. Earlier if you want to replace any existing connection of an integration for that you had to delete the existing connection and then configure a new connection in place of that. This action affect the downstream flow and you had to reconfigure most of the thing. It was totally a REWORK.

How this new update can help you ?

One case scenario – suppose you want to change the connection name of a connection that you have used in your integration. You can achieve this using this new feature ‘ #Replace ‘. Just replace the older connection with new connection having new name. It will not affect your downstream flow. NO REWORK:)

Steps Overview to replace older connection with new connection from an 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

Install and Run Oracle Integration Recipe – Extract New Hire Info from HCM Cloud by Kishore Katta

Accelerators and recipes are a great way to kick-start on building your integrations. Accelerators are run-ready business integrations or technical patterns you can configure and activate. Recipes are starter templates that give you a head start. Some of the recipes exist today as separate downloads via Oracle Marketplace and other repositories. Oracle-built recipes are harvested and they are made available as part of Oracle Integration instances. OIC new Home Page brings these right to your doorstep!

For instance if we need to automate HCM Cloud extract and push it to an SFTP server there is a Recipe for that. As part of this blog series we will see how to customize the OOTB Recipe and modify the Integration Flow. 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 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. 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.

Blog Twitter LinkedIn Facebook Wiki

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