OIC Integration: defining and using constants by Jan Kettenis
Oracle Integration Cloud does not have native support for constants, but it is easy to set this up. This post discusses how. For integrations there are two ways to define constants in the Oracle Integration Cloud:
Lookups are initially meant to support mapping of values from one domain to another. For example, one domain has country code using two letters (“NL”) whereas another domain uses three letters (“NLD”). The lookup can then be used to “translate” the value from one to the other (“NL” <-> “NLD”). The same feature can also be used to support configurable constants by providing a list of name-value pairs. For example, in the following SMColor lookup two different name-value pairs have been stored, “YELLOW” with value “yellow”, and “BLUE” with value “blue”:
In an integration you can use this lookup to get the value by name using an XPath lookup function. As I will show hereafter, there are two different XPath expressions, each being used in a different context.
Variables are set in an Integration using the Assign activity. You can define a variable with a specific name and a value. You can also use a combination of the two. In the following example you see the variable “red” being defined with value “red” and the variable “blue” is initiated using an XPath expression that on its turn gets the value from the lookup name-value pair with name “BLUE”: Read the complete article here.
For regular information on Oracle PaaS become a member in the PaaS (Integration & Process) Partner Community please register here.