E1:ORCH JSON Parser from FDA or C in Order to Use B98ORCH to send array input into a Orchestration (Doc ID 2570941.1)

Last updated on DECEMBER 27, 2022

Applies to:

Goal

Customer needs the ability to use B98ORCH Business Function to be able to send an array to an orchestration

Business Case:

Need to combine multiple lots into one bundle. This can vary from 1 to 12 different lots being tied to one bundle. Since B98ORCH only has 20 inputs and we need the lot number as well as weight, we cannot use the 20 inputs limit. Ideally, we could generate JSON based on input. With the ability to put in an array. This is more of a custom business case. Below is a more basic canned JDE case.

A second case we are looking into currently is more canned JDE. We are thinking of automating some of our order entry process. This two would require array input for each order line. In this case, it would be similar to the JSON below also.

The following would be the layout of JSON required. The array could be much longer depending on the number of inputs:

{
  "inputs" : [ {
  "name" : "NotArrayName1",
  "value" : "NotArrayVal1"
  }, {
  "name" : "NotArrayName2",
  "value" : "NotArrayVal2"
  }, {
  "name" : "NotArrayName3",
  "value" : "NotArrayVal3"
  }, {
  "name" : "NotArrayName4",
  "value" : "NotArrayVal4"
  }, {
  "name" : "NotArrayName5",
  "value" : "NotArrayVal5"
  }, {
  "name" : "NotArrayName6",
  "value" : "NotArrayVal6"
  }, {
  "name" : "NotArrayName7",
  "value" : "NotArrayVal7"
  }, {
  "name" : "NotArrayName8",
  "value" : "NotArrayVal8"
  }, {
  "name" : "NotArrayName9",
  "value" : "NotArrayVal9"
  } ],
  "detailInputs" : [ {
  "name" : "Array",
  "repeatingInputs" : [ {
  "inputs" : [ {
  "name" : "ArrayName1-1",
  "value" : "ArrayVal1-1"
  }, {
  "name" : "ArrayName1-2",
  "value" : "ArrayVal1-2"
  }, {
  "name" : "ArrayName1-3",
  "value" : "ArrayVal1-3"
  }, {
  "name" : "ArrayName1-4",
  "value" : "ArrayVal1-4"
  }, {
  "name" : "ArrayName1-5",
  "value" : "ArrayVal1-5"
  }, {
  "name" : "ArrayName1-6",
  "value" : "ArrayVal1-6"
  } ]
  }, {
  "inputs" : [ {
  "name" : "ArrayName2-1",
  "value" : "ArrayVal2-1"
  }, {
  "name" : "ArrayName2-2",
  "value" : "ArrayVal2-2"
  }, {
  "name" : "ArrayName2-3",
  "value" : "ArrayVal2-3"
  }, {
  "name" : "ArrayName2-4",
  "value" : "ArrayVal2-4"
  }, {
  "name" : "ArrayName2-5",
  "value" : "ArrayVal2-5"
  }, {
  "name" : "ArrayName2-6",
  "value" : "ArrayVal2-6"
  } ]
  } ]
  } ]
}
 

Solution

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