Use Lookups in Variable Assignments

You can create variable assignments that use lookups in the Expression Builder. You must have already created the lookup.

Create a lookup in Oracle Integration. See Manage Lookups.

For this example, a lookup named ZIP_CITY_DVM is created to map the ZIP codes (using a SOAP Adapter) and the city names (using a domain name).

Create an orchestration into which a SOAP Adapter is added as the trigger.
Drag the Assign icon to the plus sign for the SOAP Adapter in the integration canvas.
Enter an assignment name and optional description when prompted by the Assignments dialog, then click OK.
Enter a name for the assignment in the Name field, then click the Expression Builder icon at the far right.
In the Expression Builder, expand Functions, then Oracle Integration.
Drag the lookupValue function to the Expression field.

This starts the Build Lookup Function wizard.
Select the lookup table, and click Next. For this example, the lookup created in Step 1 (ZIP_CITY_DVM) is selected.
Select the source and target columns. For example, select to pass the city to the ZIP code.

Description of the illustration ics_lookups_source_target.png
Complete the remaining pages of the wizard, then click Done.
In the Source tree, select the element to map. For this example, ZIP is dragged on top of srcValue in the Expression field.
Click Close.

The completed variable assignment is displayed.
Click Exit Assignments.
In the orchestrated integration, click the mapper icon, then click the Edit icon.
Assign the variable you created to the city target element, then click Save.

Description of the illustration ics_lookups_source_target3.png
Click Close.