In Oracle Integration Cloud (OIC), a “lookup” typically refers to a feature or component that allows you to store and retrieve key-value pairs or reference data within your integration flows. We us Lookup tables to map values between different systems, enrich data, or perform data transformations. We can define one lookup and use it in multiple integrations. Lookups in Oracle OIC can also be stored multiple values (columns) against a key. Refer to link for more details. Here’s a step by step overview of how we can create lookup and use it in integration.
Create Lookups in Oracle OIC
In OIC, we can create lookup tables within the Oracle Integration web console. Navigate to the “Integrations” section, select your integration, and then look for the “Lookups” option. We will create a Person Lookup and use it to derive person name against ID key value.
Define Structure and Enter Data
We can define the structure of lookup table by specifying the key and value columns. The key is typically used to search for a specific value, and the value is the data you want to retrieve. We will name key column as Person ID and value as Person Name. We can enter data manually on this same screen or use import feature to load via excel file.
Using Lookups in Integrations
We can use lookup operations to retrieve values based on specified keys in integration. Let us create an APP Driven REST integration and take Personid as a parameter as shown below
Your response payload should look like this
Now we will use lookupValue operations to map personid and retrieve person name in design canvas
Now that our simple lookup integration is ready, let’s activate and test it.
Lookups Additional Operations
OIC provides some additional operations for lookups other than create and import. These operations may include export lookup values or even delete a lookup as shown below. Before deletion, please ensure lookup is not used in any integration.
