SOA 12c RESTAdapter : Creating a REST Binding

In Oracle SOA Suite 12c we have the much awaited REST adapter, which allows easily integrate REST into your services for XML, JSON or URL-encoded payload.

This is what you should do if you want to expose your service using a REST binding.

We will create a REST POST web-service which  will receive either XML, JSON or URL-encoded parameters and pass them to the BPEL.

Steps:

1. Create new SOA Application and Project
2. Create/Import your schema/XSD file
 If you want to create a schema from scratch, on the 'New Gallery' choose the 'XML Schema'

3. Next we drag a REST Adapter from the Components Palette into the Exposed Services column at the composite.xml, this will bring up the 'Create REST Binding' wizard



Next

4.  At the 'Operation Bindings' section, click on the 'green plus sign' and then click on  'Add operation binding', this will bring up the 'REST Operation Binding' wizard:



5. Provide an Operation Name, define your HTTP verb as POST



6. At the 'Request' tab you will see the options offered for payload: XML, JSON, URL-Encoded and No Payload. Select all except 'No Payload'

7. At the Schema URL field available, we will click on that one’s search icon and select the  'Input' element on the XSD.


8. Click on the 'Generate Sample Payload' button to create sample input payloads.

9. Repeat steps 6 and 7 for 'Response' tab.

10. Click OK to create the operation and OK again on the 'Create REST binding' wizard.

11. Create a Synchronous BPEL process, drag a BPEL component to the composite.xml screen.

12. On the creation wizard, at the Input/Output section, select our XSD element for both and uncheck 'Expose as a SOAP Service'

13. Your  composite should look like below



14. Connect your BPEL and Adapter.
15. In your BPEL add Assign activity and map Input to Output variables.
16. Save all.
17. Deploy and Test.


Helpful? Please comment.

Happy Learning!!

Oracle Fusion Application : Create Custom ESS Job to run BIP Report

In this post I will list the steps required to create a new custom ESS job to be used to run a BIP report which takes a parameter input.

Assuming that you have already created a BIP report, lets begin!

1. Login to Oracle Application Cloud
2. Navigate to Setup & Maintenance
3. In Search Task, search for 'Enterprise Scheduler Jobs for Financial and Supply Chain Management%'

4. Click on the task
5. On the Manage Job Definition Tab you will see a Action icon like below

6. Click on Action and select Create

7. On the Job Definition page above,  fill the details like below:

Display Name: Test ESS Job [a meaningful name]
Name: Test_ESS_Job [Identifier without spaces]
Path: fscmess/testjobs/ [relative folder which will be created under path /oracle/apps/ess/custom/]
Description: Custom ESS Job
Job Application Name: FscmEss
Enable submission from Enterprise Manager: Unchecked
Job Type: BIPJobType
Bursting report: Checked if you have bursting for your report else Unchecked
Class: (Auto populated)
ReportID: /Custom/Samples/Test BIP Report.xdo [path of your report on BI Catalog]
Allow multiple pending submissions: False
Enable submission from Schedule Process: Checked

8. On the parameter tab below click on Actions > Create
9. Enter the details like below

Parameter Prompt: Identifier
Data Type: String
Read Only: Unchecked
Page Element: Text Box
Default value:
Tool Tip:
Required: Checked
Do not Display: Unchecked

10. Save and Close
11. Done

To submit/run this job:

1. Navigate to Schedule Processes > Schedule New Process > Search (Test Ess Job)
2. Select
3. Enter parameter id and submit.
4. Refresh to view the status of the process.
5. Check your report output in process log.



Helpful?? Please comment

Happy Learning!!

Oracle ICS : How to use Lookups in integrations - lookupValue function

To use a lookup in your integration, ICS provides a function : lookupValue which is configured with the Build Lookup Function wizard.

You may have already created a lookup on the Lookups page.
On steps how to create a lookup you can follow the blog page: Oracle ICS : How to create Lookups

Below are the steps to access and use a lookup.

1. Build Lookup Function Wizard:
  a. Go to and open your Integration (Edit mode)
  b. Open the Expression Builder (in mapping, assign, filter and other flow actions)

   c. Expand Components   
   d. Expand Functions > ICS
   e. Drag the lookupValue function into your expression box

You can also search for 'lookupValue' in the search box for Components.

The Build Lookup Function Wizard is displayed.

2. Setting up the lookup function:
    a. From the displayed lookups select the lookup you want to use (I have used the same lookup i created earlier)

 
b.  Click on Next 

The lookupValue function requires a source and target column.
The source column refers to your source value and the function returns the value in the corresponding target column.
If not found it will return the default value(if you define one)

Basic signature:
lookupValue(dvmlocation, srcColumn, srcvalue, targetColumn, defaultValue)

   c. Click on 'Select Source Column' and select the source column
   d. Repeat for Target Column
   e. Lookup definition will then look like below:

   f. Click on Next
   g. Enter a default value example: 'No Value Found' or leave blank
   h. Click on Next

Summary is like below:

   i. Click on Done 
   j. You will see a Warning message because srcValue is not yet set
   k. Click on OK
   l. The expression is like below:

dvm:lookupValue('oramds:/apps/ICS/DVM/CountryNameLookUp.dvm','CountryCode',srcValue,'CountryName','')

  m. Remove the srcValue and map/enter the value you want to use.
  n. If hard coding, enter the value in quotes - example 'IN'

dvm:lookupValue('oramds:/apps/ICS/DVM/CountryNameLookUp.dvm','CountryCode','IN','CountryName','')

 3. Validate and Save.

When you will run your integration the lookup will fetch 'India'.


Helpful? Please Comment.

Happy Learning!!

Oracle ICS : How to create Lookups / Domain Value Map (DVM)

In Oracle ICS lookups are pretty simple and easy to configure and use.
They are also easy to migrate from one environment to another.

Below is a detailed explanation of how to create lookups in Oracle ICS.

1. Login to Integration Cloud Service domain.
2. On the home page click on the Lookups diagram

3. Click Create on the right top corner.
The create new lookup dialog is deisplayed

4. Enter a Name, an optional Description and click on Create.

5. The lookup page is displayed.
6. Click on the domain name and select Edit Domain Name to change name.

7. Enter a new name and click on OK. (Character limit is 50)

8. Similarly edit other domain name.
9. Add new domain/column by using the '+' on the right hand side.
10. Enter a value in the field below the domain name. To add more rows click on '+' on the bottom.
11. Repeat to add more domain and values to the lookup.
12. Your lookup will look like below:

13. Click Save when complete.

Helpful?? Please Comment

Happy Learning!!

SOA 12c : Export/Import ESS job from one environment to another

In the current version of SOA once you create an ESS job we have to use the below process to migrate it to another environment.


For executing the below we will have to use WSLT.

Steps:
1. Login in to your server
2. Navigate to bin: cd $SOA_HOME/common/bin
3. Run : ./wlst.sh

4. Run: connect('weblogic','password','t3://adminserver_hostname:adminserver_port');
This will connect you to the ESSserver.

5. Run: exportMetadata(application='EssNativeHostingApp', server='ess_server1', toLocation='/home/temp/EssDevExport.zip');

6.importMetadata(application='EssNativeHostingApp', server='ess_server1', fromLocation='/home/temp/EssDevExport.zip');

These steps will export the metadata of your ESS jobs and you can then import the same into another environment.

Helpful?? Please Comment.

Happy Learning!!

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!!