Integration Technologies - JDE1 (MOSC)

MOSC Banner

I would like to take a manipulated output form one Orchestration and pass it to another Orchestratio

edited Dec 18, 2019 4:08AM in Integration Technologies - JDE1 (MOSC) 1 commentAnswered

I have manipulated the output of a Data Request Orchestration using Groovy and added a new key/value pair : highlighted below in blue.

Groovy Script in Data Request Orchestration.....

import groovy.json.JsonSlurper;

import groovy.json.JsonBuilder;

import com.oracle.e1.common.OrchestrationAttributes;

String main(OrchestrationAttributes orchAttr, String input)

{

  def jsonIn = new JsonSlurper().parseText(input);

 

  // modify jsonIn

  def int i = 0;

  while(i<=0) {

  def map1 = jsonIn."Data Requests"[0]."Data Browser - V5541271 [One View Inventory Valuation Analysis - F41021 and F4102 joi]"[i];

   

     if (map1."ABC 1 Sls [F4102]"=="A") {

         def Date = new Date()+30;

         def newDate=Date.format("dd/MM/yyyy");

         map1."Next Count Date [F41021]a" = newDate;

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center