Lookups In Oracle Integration Cloud


Lookups In Oracle Integration Cloud

In Oracle Integration Cloud (OIC), Lookups are used to store and manage key-value pairs or reference data that can be used within integrations and mappings. Lookups provide a convenient way to store and retrieve static data or configuration information that is needed in your integration flows. Here are the key aspects of using Lookups in Oracle Integration Cloud:

  1. Creating a Lookup:
    • To create a Lookup in Oracle Integration Cloud, you can access the Oracle Integration Cloud Console and navigate to the Integration section.
    • Under the “Integration” section, select “Lookups” and then click the “Create” button to create a new Lookup.
  1. Defining Lookup Entries:
    • Each Lookup consists of one or more entries, where each entry contains a key-value pair.
    • You can define Lookup entries manually by specifying a key and its associated value.
    • Additionally, you can import Lookup data from an external source, such as a CSV file, to populate the entries.
  1. Using Lookups in Integrations:
    • Lookups can be used within your integration flows to retrieve values based on keys.
    • In mapping expressions or conditional statements, you can reference a Lookup to retrieve the corresponding value.
    • This is particularly useful for scenarios where you need to map values between systems or apply business logic based on reference data.
  1. Dynamic Lookups:
    • In some cases, you may need to perform dynamic Lookups where the key is determined at runtime based on data within the integration.
    • Oracle Integration Cloud allows you to use expressions to construct dynamic keys and perform Lookups accordingly.
  1. Versioning and Revisions:
    • Lookups support versioning, which means you can create different versions of a Lookup as your reference data evolves.
    • This helps in maintaining historical Lookup data while making updates for future use.
  1. Security and Access Control:
    • You can control who has access to view and modify Lookups by configuring security policies and access control within Oracle Integration Cloud.
  1. Testing Lookups:
    • During development and testing, you can use the “Test Lookup” feature in Oracle Integration Cloud to verify that Lookups return the expected values.
  1. Lookups in Orchestrations:
    • Lookups can also be used within Orchestrations in Oracle Integration Cloud to retrieve reference data and make decisions based on that data.
  1. Monitoring and Logging:


    • You can monitor Lookup activity and log Lookup-related events to track how Lookups are being used within your integration flows.

Oracle Integration Cloud (OIC) Training Demo Day 1

You can find more information about Oracle Integration Cloud Service in this Oracle Docs Link



Unogeeks is the No.1 Training Institute for OIC. Anyone Disagree? Please drop in a comment

Please check our Oracle Integration Cloud Training Details here OIC Training

You can check out our other latest blogs on Oracle Integration Cloud in this OIC Blogs

💬 Follow & Connect with us:


For Training inquiries:

Call/Whatsapp: +91 73960 33555

Mail us at: info@unogeeks.com

Our Website ➜ https://unogeeks.com

Follow us:

Instagram: https://www.instagram.com/unogeeks

Facebook: https://www.facebook.com/UnogeeksSoftwareTrainingInstitute

Twitter: https://twitter.com/unogeeks


Leave a Reply

Your email address will not be published. Required fields are marked *