Which Oracle Integration (OIC) XPath function can be used to retrieve data from an OIC Lookup within the Map Editor?

The lookupValue function is the specific Oracle XPath extension function used within the Oracle Integration (OIC) Mapper to retrieve a value from a pre-configured lookup table (also known as a Domain Value Map or DVM). This function allows for dynamic data enrichment by mapping a source value to a corresponding target value defined in the lookup. The function typically requires parameters such as the lookup location, source column, source value, target column, and a default value to return if no match is found.

A. get-value-from-lookup is not a valid or recognized XPath function within the Oracle Integration Mapper's function library.

B. getLookup is not a standard function provided in the OIC Mapper for accessing lookup values.

C. get-content-as-string is not the correct function for lookups. A similar function, ora:getContentAsString, exists but is used for reading the content of attachments, not for querying DVMs.

1. Oracle Official Documentation (Oracle Integration 3): The lookupValue function is explicitly listed and described in the official guide for Oracle Integration.

Source: Oracle Help Center

"Using Integrations in Oracle Integration 3"

Chapter: "Map Data"

Section: "Oracle XPath Functions".

Details: The documentation specifies the function signature as oraext:lookupValue(dvmLocation

sourceColumn

sourceValue

targetColumn

defaultValue) and describes its purpose: "Looks up a value in a previously-created and populated lookup table."

2. Oracle Official Documentation (Oracle Integration Generation 2): The function is also documented for the previous generation of OIC

confirming its long-standing use.

Source: Oracle Help Center

"Using Integrations in Oracle Integration Generation 2"

Chapter: "Mapping Data"

Section: "Oracle XPath Functions".

Details: This guide provides the same function definition and syntax

demonstrating its core role in data mapping across OIC versions. The description confirms it is the designated function for this task.