February 8, 2020

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 :

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





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.



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.

                     

1 comment:

If you have any doubts, Please let me know.