Creating and managing lookup in Oracle Integration Cloud

[@toddhensley880]

I see you can either enter a domain name a column or pick an adapter. How does the usage change if you pick an adapter?

[@TechSupper]

You can choose either one. Doesn't matter.

[@maheedharatmakuru3120]

Hi ankur, In SOA DVM we have a concept of QUALIFIER to get a value based on 2 or more keys,Do we have any option like that here? Or Do u know any way to implement it?

[@TechSupper]

Try this www.techsupper.com/2020/03/extract-data-based-on-multiple-columns-from-lookup-in-oic.html

[@maheedharatmakuru3120]

@@TechSupper thanks Ankur....you are really helping a lot for beginners like us.

[@TechSupper]

You're welcome

[@papayyasastrychalla1872]

lookup codedes are case sensitive. I entered UP and if I give up in the end point to test it will give default value message country code not found. How to fix this please share. duplicate lookup codes have been entered by mistake. CN for China, CN for Canada. when i passed this in the end point It gave me the internal server error How to fix this, please share.

[@TechSupper]

Hi Sastry, Solution of first problem: Assign the request parameter in input variable and use upper-case function which will convert the value in upper case and fetch the data from lookup accordingly. Solution of second problem: Make sure entries are unique

[@luisortiz2184]

thanks great video...

[@TechSupper]

Thanks

[@adinarayanakelli6812]

Sir nice all vedieos send to me .........

[@TechSupper]

Thank you

[@adinarayanakelli6812]

Sir u wil have telgram chanel

[@TechSupper]

You can join this chat.whatsapp.com/Fwxuj5AApnq0Jg8SQeMNRb