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