E1: ORCH: Example for Parsing JSON to Set Output Variables (Data Set Variable) Using Groovy (Doc ID 2667935.1)

Last updated on OCTOBER 10, 2022

Applies to:

Goal

1.  This example has three steps in the orchestration.

1.    Data Service:  It Fetches data from F4211 and returns multiple lines based on an order number.
2.    Custom Groovy:  It parses Json result from the step1.  Convert dates from yyyyMMdd to MM/dd/yyyy format. Then, put the whole lines (array) information into output variables.
3.    Form Service Request:  It inserts multiple grid records into P42101 with correct Data format.

2.  JSON output from an External REST  that contains exchange rate info.  Then the sample groovy puts the data into data set variables.

3.  Using the "def array" and "returnMap.put("xxx", array);

Solution

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.