#737 OIC - CPQ Integration

Here is a short introduction to the OIC CPQ adapter.

As a pre-requisite, I suggest you read the Oracle CPQ Cloud - Service descriptions
It is available here

Now back to the OIC CPQ adapter -

A short introduction from the adapter docs - available here

-----------------------------------------
The Oracle Configure, Price, and Quote (CPQ) Cloud Adapter enables you to create
an integration with an Oracle CPQ application.

The Oracle CPQ Cloud Adapter enables you to convert sales opportunities into revenue
by automating the quoting and sales order process with guided selling, dynamic
pricing, and a workflow approval process.

Oracle CPQ cloud extends sales automation to include the creation of an optimal
quote, which enables sales personnel to configure and price complex products; select
the best options, promotions, and deal terms; and include upsell and renewals, all using
automated workflows.

The main use case for Oracle CPQ Cloud is as the trigger (source) in an integration in
which Oracle Sales Cloud is the invoke (target). This adapter replicates the point-to-point
integration that exists today between Oracle CPQ Cloud and Oracle Sales Cloud.

Oracle CPQ Cloud is the trigger (source) of the record application. A synchronize
process is triggered as you update and save data in Oracle CPQ Cloud, but it can also
be configured by the administrator of the application. The Oracle CPQ Cloud Adapter
can also be configured as the invoke (target) in an integration.

Prebuilt integration flows with Oracle CPQ Cloud and Oracle Sales Cloud for quote
creation, opportunity import, and quote update are also provided from the Oracle Marketplace.
--------------------------------------------------------------------------------------------------------------------

Pre-requisites

One must obtain the CPQ SOAP wsdl from CPQ itself - so login and click on Admin.

Select version 2.0

Ensure you are in the Commerce tab -

Just append ?wsdl to the url shown.

Use the wsdl and your CPQ credentials in defining the CPQ Connection in OIC -

OIC CPQ adapter also supports REST -

You simple add /rest/version/metadata-catalog to your base CPQ URL

The doc mentions v3 and above.

I found my CPQ is on v8. To do so, I clicked on Admin and then

I then checked out the version number -

Using CPQ SOAP Connection as an Integration Trigger

The input is a Transaction object from CPQ.

Again, from the docs -

This object is from the CPQ commerce process. This is the business object that
you receive from the Oracle CPQ application as a request document to start this integration flow. 
This business object is automatically selected based on the content of the WSDL
file you specified when creating the Oracle CPQ connection.

Response is pre-set.

The Transaction is as follows -

Note: you cannot use the CPQ REST Connection as a trigger.

Using CPQ SOAP Connection as an Integration Invoke

Use the CPQ REST Connection as an Invoke

CPQ REST api doc here

#736 OIC SOA Suite Adapter available as feature flag

The feature flag is called -
oic.cloudadapter.adapters.soaadapter

This can be activated on your OIC environment via an SR.

example to follow.
Just downloading the latest and greatest SOA Suite version 12.2.1.4.
from here

That was quick - SOA Suite Quick Start downloaded and configured/started within 30 minutes.

#735 OIC October release new features

Check them out here

#734 Fusion ERP Batch Imports with OIC

Simple scenario here -

I have an FBDI compliant AP Invoices file in a folder on my ftp server
OIC leverages the ftp adapter, reads the file and inovkes the import to ERP
OIC receives the callback from ERP on job completion.


FBDI - File Based Data Import.
Fusion ERP provides FBDI templates for AP Invoices, Suppliers, GL etc.
Fusion users can upload such files via -

Here is an example of such a file -

I generate a zip from this as follows -

Note: I also needed to add the above .properties file to the zip.

Check out Jack Desai's excellent blog post for more info on this.
As Jack says -

The property file submitted with importBulkData operation includes the job definition and package names as well as the job parameters of the object being imported. You must generate and add the Job Properties File as part of the data ZIP file.

So how do we implement the import in OIC?

Simple, leverage the ftp adapter to read the AP file and then Fusion ERP adapter -

Now to a test...

Note the process id returned by Fusion ERP - 1615742.

I validate in ERP -

Now to the callback integration...

Again, I am leveraging the ERP adapter - this time as trigger.

Here is what I see in Fusion ERP after running an Import -

The trigger payload is as follows -

Note the Transfer, Load and Import steps above. Also the Upload to UCM.

#733 Fusion ERP Batch Extracts with OIC part II

Just some more background info -

I used the following connections to Fusion ERP in the previous post.

Both of these are used in the Callback Integration -
The first, for onJobCompletion, i.e. the integration trigger.
The second, to pick up the report from UCM.

The first connection is based on the following wsdl -

The second connection is based on the following Fusion ERP wsdl -

https://yourOIC/fscmService/ErpIntegrationService?wsdl

The ErpIntegrationService provides external operations for ERP integration scenarios to execute end-to-end inbound and outbound data flows. It also tracks the status of inbound and outbound data processes.

Documentation of the above here

#732 Fusion ERP Batch Extracts with OIC

Simple example and background explanation here.
Caveat to begin with - I am not a Fusion ERP expert, but I do like understanding how things work.

So what is a batch extract?
Essentially a scheduled process (ESS- Enterprise Scheduler) that runs a report in ERP e.g.
Extract payment data since last execution to update downstream or upstream applications to reflect payments.

So two components here - the scheduled process and the report to be run, according to that schedule.

Where can I monitor the execution of these scheduled processes in Fusion ERP?

Here is a job I ran earlier, triggered by an OIC integration
(we will look at the integration in detail later) -

Payables Transactions Extract or sliocht idirbhearta iníoctha, as we are wont to say in Ireland.

However, there are many more of them -

A scheduled process might have parameters that you can set to control which records are included or how they're affected. For example, a process updates only the records that are effective within the date range that you define.

So where are these ESS processes or jobs defined?

Search for Manage Enterprise Scheduler Job Definitions -

As you can see from the above, I then searched for Payables Transactions Extract -

The job is of type - BI Publisher. That means there is a BI Report defined already.

Here are the BI Report details -

So net, net is you begin with a BI Report, either one of those delivered with ERP or a custom report of your own. You then call this from an ESS job.

I have a simple example which covers the whole lifecycle -

The interaction is as follows -

1. OIC Trigger integration: Trigger the job to execute the report.

The job payload will also specify a callback url - which enables a 2nd integration to be called once the job has run successfully and the result is in UCM.

2. Fusion ERP: The report executes

3. Fusion ERP: Result is written to UCM

4. Fusion ERP: Callback Integration is triggered

5. OIC: Result is picked up from UCM and sent to destination.

OIC Integration triggering BI Report run

initiateExtract: Here we will leverage the Fusion ERP exportBulkData operation. This submits an ESS job to start the BIP report processor and eventually uploads the report output to UCM. The supported output formats are XML and CSV. Callback and notification are also supported.

The Request Payload - 

The parameter list refers to the PaymentsTransactionsExtract: Parameters screenshot above.

Here is a sample input for the parameter list -

92,/oracle/apps/ess/financials/commonModules/shared/common/outbound;PayablesTransactionsExtract,BIPREPORT,FULL_EXTRACT,#NULL,300000046987012,#NULL,#NULL,#NULL,#NULL,#NULL,12-18,N,N,300000046975971,#NULL,#NULL,#NULL,FULL_EXTRACT,#NULL,#NULL,#NULL,PayablesTransactionsExtract,#NULL

jobOptions will be set to ExtractFileType=ALL

notificationCode is set to 30

callbackURL is set to 
nn/ic/ws/integration/v1/flows/soap/DEMO_ERP_BULK_EXTRAC_CBK/1.0/'

this points to my callback integration, more about that later.


The Response will be the requestId of the submitted ESS job.

I execute the integration and view progress in ERP - Scheduled Processes -

I check the response received from the initiateExtract call -

Note the requestId returned - 1615660.

OIC Callback Integration - picking up result from UCM

This integration picks up the extract result from UCM.

Remember, we have passed the url to this integration as a parameter in the invoke of exportBulkData 

Let's look at the individual steps -

bulkExtractCallback:

The trigger is based on a SOAP connection, which itself is based on the following wsdl -

As you can see, the request contains the following -

 "requestId", "state", "resultMessage"

Note: requestId = 1615660.

downloadFile: leverages a SOAP connection, based on the Fusion ERP wsdl

The operation selected is getDocumentsForFilePrefix.

Details can be found here -

prefix is set to “ESS_” + //requestId

makes sense!

account is set to fin$/payables$/export$

comments is set to "processedby=" , //requestId  

The Response is as follows - (this is from a different run )

The file is written to my ftp server -