OIC Basics – Using the Mapper Code Window

….or how to ‘Map the Source XML Element NAME and VALUES to Targets’.

I thought that we’d share a tip regarding using the ‘Code’ facility in OIC to build more complex XSLT in mapper actions.

We had a requirement to create a scheduled OIC integration that would get some exchange rate values from an external provider using an API, and to transform those values into rows of data for a CSV input file which would then be loaded in Oracle ERP Cloud using the ‘Import and Calculate Daily Rates’ FDBI loader.

The API that we were using to obtain the exchange rates data created output XML data like this:

<response-wrapper xmlns="https://someAPI/exchangerates/types">

But we needed to create some CSV file input like this for the ‘Import and Calculate Daily Rates’ FDBI loader …


In this short video we look at the normal mapper, code page for the mapper and the test page that helped us work through the solution.

Until next time…

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s