Monday 28 May 2018

Oracle ICS : Import ERP Cloud certificates


One of the pre-requisites to implement callback from ERP cloud to Oracle ICS is importing the ERP cloud certificates into ICS to authenticate SAML assertion from Oracle ERP cloud.

First we will cover how to retrieve the certificates:

1. The ERP cloud certificates can be retrieved from the Catalog Service WSDL URL.
The WSDL URL is like below:

R12: https://hostname/fndAppCoreServices/ServiceCatalogService?WSDL
R12: https://hostname/fscmService/ServiceCatalogService?WSDL

Enter the WSDL URL in your browser. Once loaded, navigate to X509Certificate element like shown below:


2. Copy each certificate string and in notepad make like below:

-----BEGIN CERTIFICATE-----
YIOUMIIDbDCCAlSgAwIBAgIGAVMkh+/kMA0GCSqGSIb3DQEBCwUAMHgxCzAJBgNVBAYTAlVTMRAwDgYDVQQIEwdNe
-----END CERTIFICATE-----

3. Save this file as erp_certificate1.cer
4. Repeat for second certificate line and save as erp_certificate2.cer

Now that we have both certificates we will import them into Oracle ICS

1. Login to Oracle ICS console
2. On the left navigation bar go to Integrations
3. Click on Settings













4. Under Settings select Certificates
















5. On upper-right corner click on Upload
6. Select Type: Message Protection Certificate. Enter a valid name and browse and upload your certificate 1

















7. Repeat for certificate 2

There done.


Helpful?? Please Comment

Happy Learning!!

Oracle ICS : Create a REST connection


Below are the steps to create REST connection in Oracle ICS to create a REST service or to call a REST service.

1. Login to ICS Console
2. On Home page, click on 'Create Connection'

















3. Click on create on upper-right corner







4. Search for REST and select













5. Enter the name - Test_REST_Conn

6.
a. Select Trigger and Invoke if you are going to call another REST URL
b. If you want create a REST integration/service using this connection then only select Trigger option (connection properties will be required to be entered)

Click on create.

7. If using option a, follow below steps or go to step 12

8. Click on 'Configure Connectivity'










9.
a. Select Connection Type: REST API Base URL
b. Connection URL: Enter/Paste the REST service URL













10. If the REST API requires authentication, ex: basic authentication, then click on the 'Configure Security'

11. Select Policy: Basic Authentication, and enter the username and password and click on OK














12. Click Save and Test your connection from the upper-right corner. If the test is successful, the connection status will be 100% and ready to use.


Helpful?? Please Comment

Happy Learning!!

OSB 12c : Dynamic Routing to Business/Proxy Service

Dynamic routing is a kind of  Content-based Routing pattern, which is used when the BusinessService/ProxyService path is required to be de...