OIC Integration with Logistics Cloud: Things to Know and Best Practices

February 28, 2019 | 5 minute read
Shreenidhi Raghuram
Consulting Solutions Architect
Text Size 100%:

Introduction

In this blog we will see some common issues that could be faced, the recommended fixes and best practices when integrating with Oracle Logistics Cloud using Oracle Integration Cloud (OIC).

Oracle Logistics Cloud comprises of these below components

  • Oracle Transportation Management Cloud(OTM)
  • Oracle Warehouse Management Cloud (WMS)

This blog discusses issues encountered during a customer engagement using pre-built integrations. However, the principles of this blog are relevant even when designing and activating custom OIC integrations with Oracle Logistics Cloud.

Below is a glossary of terms upfront for easy reference

Glossary

OTM Oracle Transportation Management Cloud(OTM) from Logistics Cloud

WMS Oracle Warehouse Management Cloud (WMS) from Logistics Cloud

SCM Oracle Supply Chain Management Cloud

OM Order Management from Oracle SCM Cloud

 

OIC to OTM - Interface issue when integrating with OTM

An issue was encountered after activation of OM-OTM pre-built integration. This pre-built integration integrates between Order Management- OM (from Oracle SCM Cloud) and OTM using Integration Cloud.

Pre-built flow information

Application Type Application Connector
Source Application OM SCM Adapter
Target Application OTM Logistics Adapter

 

We wont go into the details of the integration itself. Refer to this Support note for details on the OM-OTM pre-built integration Sample Integration with OTM/GTM using ICS (Doc ID 2209248.1)

Issue

During testing of the flow it was seen that OIC monitoring shows successful transmission from OM to OTM and also a successful callback but a transaction was not created on OTM. However, the callback response from OTM shows "Null TransmissionBody" in the message as shown below

 
 Null TransmissionBody
 

Resolution

For OTM 6.4x, Transmission Service does not work when the OTM WSDL url is used in the logistics adapter connection. An offline TransmissionService wsdl has been made available which addresses this issue for 6.4x. It can be accessed from the below support note Transmission Service WSDL with Inline Schemas (Doc ID 2294108.1)

Use the wsdl file provided in the support note when configuring the logistics adapter connection instead of the online wsdl url. Download the offline wsdl provided above for the specific OTM version and update it with the actual OTM host url and port. Use it as the source when creating Logistics cloud connection, as shown below

This will resolve the above issue and ensure that the OIC flow invokes the proper Transmission service on OTM

 

WMS to OIC - Cipher compatibility

The issue was encountered during runtime in the OCWMSRECEIPTCONFIRMATION of the WMS- ERP pre-built integrations This integration is used to propagate receipt confirmations from WMS to Oracle ERP Cloud.

Pre-built flow information

Application Type Application Connector
Trigger Application WMS Rest Adapter
Target Application ERP ERP Adapter

 

Refer to this support note for details on the WMS - ERP integrations using Integration Cloud Sample Integration Between Oracle Warehouse Management Cloud (release 9.0.0) and Oracle ERP/SCM Cloud (Doc ID 2404671.1)

The integration flow is exposed as rest API to be invoked from WMS. The endpoint url looks as below https://OIC-URL/ic/api/integration/v1/flows/rest/OCWMSRECEIPTCONFIRMATI/1.0/receipt_confirm

Issue

After activation of the flow, request timeout error is observed from WMS to OIC. As a result the Receipt Confirmation message is received at OIC. The same request when submitted using a REST client like soapui or postman was able to invoke the endpoint and an OIC instance was created This pointed to the issue being at the network between WMS and ICS.

Cause

On further analysis it was found that the ciphers supported by WMS and Integration cloud did not match.

OIC is frontended by LBaaS and supports the following ciphers

TLS_ECDHE_RSA_WITH_AES_256_CBC_SHA
TLS_ECDHE_RSA_WITH_AES_128_CBC_SHA256
TLS_ECDHE_RSA_WITH_AES_128_CBC_SHA
TLS_RSA_WITH_AES_256_CBC_SHA256
TLS_RSA_WITH_AES_256_CBC_SHA
TLS_RSA_WITH_AES_128_CBC_SHA256
TLS_RSA_WITH_AES_128_CBC_SHA

WMS running on Oracle Cloud Infrastructure supports the below list of ciphers

openssl ciphers

ECDHERSAAES256GCMSHA384:ECDHEECDSAAES256GCMSHA384:ECDHERSAAES256SHA384:ECDHEECDSAAES256SHA384:ECDHERSAAES256SHA:ECDHEECDSAAES256SHA:DHEDSSAES256GCMSHA384:DHERSAAES256GCMSHA384:DHERSAAES256SHA256:DHEDSSAES256SHA256:DHERSAAES256SHA:DHEDSSAES256SHA:DHERSACAMELLIA256SHA:DHEDSSCAMELLIA256SHA:ECDHRSAAES256GCMSHA384:ECDHECDSAAES256GCMSHA384:ECDHRSAAES256SHA384:ECDHECDSAAES256SHA384:ECDHRSAAES256SHA:ECDHECDSAAES256SHA:AES256GCMSHA384:AES256SHA256:AES256SHA:CAMELLIA256SHA:PSKAES256CBCSHA:ECDHERSAAES128GCMSHA256:ECDHEECDSAAES128GCMSHA256:ECDHERSAAES128SHA256:ECDHEECDSAAES128SHA256:ECDHERSAAES128SHA:ECDHEECDSAAES128SHA:DHEDSSAES128GCMSHA256:DHERSAAES128GCMSHA256:DHERSAAES128SHA256:DHEDSSAES128SHA256:DHERSAAES128SHA:DHEDSSAES128SHA:DHERSASEEDSHA:DHEDSSSEEDSHA:DHERSACAMELLIA128SHA:DHEDSSCAMELLIA128SHA:ECDHRSAAES128GCMSHA256:ECDHECDSAAES128GCMSHA256:ECDHRSAAES128SHA256:ECDHECDSAAES128SHA256:ECDHRSAAES128SHA:ECDHECDSAAES128SHA:AES128GCMSHA256:AES128SHA256:AES128SHA:SEEDSHA:CAMELLIA128SHA:PSKAES128CBCSHA:ECDHERSADESCBC3SHA:ECDHEECDSADESCBC3SHA:EDHRSADESCBC3SHA:EDHDSSDESCBC3SHA:ECDHRSADESCBC3SHA:ECDHECDSADESCBC3SHA:DESCBC3SHA:IDEACBCSHA:PSK3DESEDECBCSHA:KRB5IDEACBCSHA:KRB5DESCBC3SHA:KRB5IDEACBCMD5:KRB5DESCBC3MD5:ECDHERSARC4SHA:ECDHEECDSARC4SHA:ECDHRSARC4SHA:ECDHECDSARC4SHA:RC4SHA:RC4MD5:PSKRC4SHA:KRB5RC4SHA:KRB5RC4_MD5

Resolution

An SSL negotiation policy was created in OIC Load Balancer and matching ciphers with WMS were added to the policy.

Refer - Creating policies for Load Balancer

For example the below 2 ciphers compatible with WMS can be enabled on the OIC Load Balancer

TLSECDHERSAWITHAES128GCMSHA256
TLSECDHERSAWITHAES256GCMSHA384

Note - Creating a SSL negotiation policy overrides the default cipher set.

Creating a SSL negotiation policy overrides the default cipher set.

So make sure to add the earlier set of default ciphers also to the SSL negotiation policy before enabling it.

The SSL connectivity was restored after adding WMS matching ciphers to OIC LBaaS instance Note - Depending on the type of Integration cloud used, customers may need to open an Oracle Support SR for this resolution

 

OIC to WMS - Network Packet Mismatch

The issue was encountered during runtime when executing the "OCWMS Receipt Advice from ERP" (OCWMSRECEIPTADVICE). This is part of WMS-ERP pre-built integrations and is used to send PO details from ERP to WMS.

Pre-built flow information

Application Type Application Connector
Trigger Application ERP ERP Adapter
Target Application WMS Rest Adapter

 

Refer to this support note for details on the WMS- ERP integrations using Integration Cloud Sample Integration Between Oracle Warehouse Management Cloud (release 9.0.0) and Oracle ERP/SCM Cloud (Doc ID 2404671.1)

Issue

After the required setups are completed and after Receipt Advice event is generated from ERP, it was observed that the event does not reach WMS.

OIC endpoint used by the ERP to trigger the flow is of the form https://OIC-URL/ic/api/integration/v1/flows/rest/OCWMSRECEIPTCONFIRMATI/1.0/receipt_confirm

The WMS url that OIC REST adapter uses to POST the PO is of the form https://WMSURL/wms/api/initstage_interface

On further troubleshooting it was seen that the final payload destined for WMS could be successfully posted using a REST client like Postman. But the invocation from OIC to WMS is seen to generate the following error in the OIC Diagnostic logs

Error

Fault Details :

http://www.w3.org/Protocols/rfc2616/rfc2616-sec10.html#sec10.5.1Internal Server Error500<![CDATA[https://tb4.wms.ocs.oraclecloud.com/WMS_URL/wms/api/init_stage_interface/]]><![CDATA[CASDK-0041: An error occurred even before the REST endpoint could be invoked.[[java.net.SocketException: Connection reset]]]]>
:Application Error
 java.net.SocketException: Connection reset

It was seen from OIC instance monitoring that this step takes 2 minutes and then times out with Connection Reset error. A curl test from OIC VM to WMS endpoint confirmed the same behavior.

$ curl -X POST 
https://WMS_URL/wms/api/init_stage_interface/ 
-u 'user:password' 
-H 'Content-Type: application/x-www-form-urlencoded' 
-d 'actual payload taken from ICS diagnostic logs after payload tracing'

curl: (56) SSL read: errno -5961

Curl command failed with SSL error (shown above) after waiting for 2 mins.

This error occurs an MTU mismatch between OIC and WMS

Resolution

Check for the MTU size configured on eth0 interface in the OIC VM. This can be done using "ifconfig -a" relevant output of the command is shown below

$ ifconfig -a
eth0 Link encap:Ethernet HWaddr 02:33:39:8C:C0:41
...
UP BROADCAST RUNNING MULTICAST MTU:8900 Metric:1
RX packets:2584221 errors:0 dropped:0 overruns:0 frame:0
TX packets:3034685 errors:0 dropped:0 overruns:0 carrier:0
collisions:0 txqueuelen:1000
RX bytes:1881219361 (1.7 GiB) TX bytes:1887746542 (1.7 GiB)

The recommended value is 1500 as per oracle documentation for OCI to OCI-Classic communications.

Refer to https://docs.oracle.com/en/cloud/paas/api-platform-cloud/apfki/index.html#APFKI-GUID-F3E50E1E-DEAB-4773-969F-B6AB2CEF9DD5

Follow the instructions in the doc to change the MTU value to 1500.

After this change, the OCWMSRECEIPTADVICE REST API call is received with payload at WMS and completes as expected. Note: Depending on the type of Integration cloud used, customers may need to open an Oracle Support SR for this resolution

Common References

  • PreBuilt Integration - Sample Integration with OTM/GTM using ICS (Doc ID 2209248.1) PreBuilt Integration - Sample Integration Between Oracle Warehouse Management Cloud (release 9.0.0) and Oracle ERP/SCM Cloud (Doc ID 2404671.1)
  • Creating Policies for Load Balancer - here

Shreenidhi Raghuram

Consulting Solutions Architect

As a member of Cloud Solution Architects A-Team, my area of work involves SaaS, PaaS4SaaS and IaaS. My work focuses on Solution architecture involving Fusion Supply Chain Management (SCM), Integration, Extensions, High Availability, Security, Infrastructure, Hybrid Cloud and Networking aspects of Oracle cloud solutions.


Previous Post

Using Expression Language (EL) in Page Composer to Mask Data based on a Custom Role

Dereck DE ALMEIDA | 3 min read

Next Post


Integrating Oracle Integration Cloud Integration with UIPath

Siming Mu | 6 min read