Lookups in Oracle Integration Cloud

We use lookups in the integrations to create reusable tables that map the different terms used to describe the same item across your applications. Lookups are exact same as Data Value Map(DVM) in SOA.


Lets see how to define a Lookup in OIC  with an example :

Use Case :-

Inside this blog, we see will define a lookup for Country Code & Country Name. For a specific Country Code we will assign one unique Country Name.

Country_Code	Country_Name
USA	United States of America
IS	Israel

development Steps in detail :

- Advertisement -

STEP 1 : Click at Lookups present inside Designer tab and then click CREATE 

   

               Enter the below details and click CREATE :

           *Lookup Name : CountryLookup ( you can write any meaning full name)

             Description    : write small description

         

STEP 2 : Click on Domain_Name_1 and then click Edit Domain Name

              and enter the below detail and click Ok

  

              *Domain Name : Country_Code

- Advertisement -

STEP 3 : Similarly click Domain_Name_2 and then click Edit Domain Name

              and enter the below detail and click Ok

             *Domain Name : Country_Name

             

STEP 4 : Now add the values in lookup table. Click the "+" icon and add the

             below values (as shown in below image)

             

             In Country_Code column write IN & in Country_Name write INDIA

            Similarly add two more values (as shown in below image )

         Country_Code  Column  : add  USA , IS

                Country_Name  Column  : add UNITED STATES of AMERICA , ISRAEL 

              After adding above two values click Save and then click Close.

- Advertisement -

STEP 5 : Your Lookups is ready to use in Integration. Please access the Next

             blog to know how to implement this Lookups in an Integration.