E9.2 Creating Sales Order with Configured Items Using Orchestrator

[[email protected]]

Hello JDE List Community,

I am currently facing related to the creation of sales orders using Orchestrator.

I have successfully managed to create multi-line sales orders by following the guidelines provided in a below link. However, I am now faced with a new requirement - creating sales orders with configured items.

I am unsure of the correct process and steps to follow in order to fulfill this requirement. I am hoping that someone in this knowledgeable community might be able to provide me with detailed instructions or point me towards any relevant resources that could guide me through this process.

Any help or guidance would be greatly appreciated. .

Reference Link:
Oracle Support Document 2779029.1 (E1: ORCH: How to Create Multiple Sales Orders With Multiple SO Lines By Sending a Multiple JSON Array Orchestration Input ( Object )) can be found at: https://support.oracle.com/epmos/faces/DocumentDisplay?id=2779029.1

Creating an Orchestration to Enter Sales Orders in EnterpriseOne (oracle.com)

 

[DaveWagoner]

OH WOW. I was wondering about configurator in all of this.

If I get a spare hour I'll play with the demo data in pristine, but don't hold your breath with me

 

[JasonDorough]

Tejas,
I have built an orchestration that enters configured items for a client who manufactures baseball gloves. We received Json from the online ordering portal that provided all the details for the configured item (baseball glove). Groovy was used to parse the Json to create numerous variables. These were passed to a series of XREF components that used the input variables to return the answers that were then used to create the configured item via sales order entry. To start, you should do a process recorder to capture the process of entering a configured item. You will need to know the row number for each question and if it is mandatory or is derived from previous responses. To summarize, a customer ordered a glove we received the Json containing the model, stitching type, stitching color, webbing type, webbing color, embroidery etc. Custom groovy was used to associate these qualities with the correct row number in the configured item ordering screen. These qualites were passed into XREF components to return the actual answer needed to be inputted on the appropriate row. For example, initial JSON would say WebbingColor = White. The XRef would return the value W, which matched the selection needed on the configured items entry screen. This was not an easy orchestration and I hope this makes sense and helps you figure it out.

 

[DaveWagoner]

Tejas,
I have built an orchestration that enters configured items for a client who manufactures baseball gloves. We received Json from the online ordering portal that provided all the details for the configured item (baseball glove). Groovy was used to parse the Json to create numerous variables. These were passed to a series of XREF components that used the input variables to return the answers that were then used to create the configured item via sales order entry. To start, you should do a process recorder to capture the process of entering a configured item. You will need to know the row number for each question and if it is mandatory or is derived from previous responses. To summarize, a customer ordered a glove we received the Json containing the model, stitching type, stitching color, webbing type, webbing color, embroidery etc. Custom groovy was used to associate these qualities with the correct row number in the configured item ordering screen. These qualites were passed into XREF components to return the actual answer needed to be inputted on the appropriate row. For example, initial JSON would say WebbingColor = White. The XRef would return the value W, which matched the selection needed on the configured items entry screen. This was not an easy orchestration and I hope this makes sense and helps you figure it out.

This is fascinating to hear.

Does a change in configured item segments mean a change in segment row order which necessitates a change in the orchestration/groovy? Or is that semi-dynamic?

 

[JasonDorough]

This is fascinating to hear.

Does a change in configured item segments mean a change in segment row order which necessitates a change in the orchestration/groovy? Or is that semi-dynamic?

Dave, depending on the base item selected, the amount and order of the questions could be different. After all the Xref lookups to attain the answers, we had a final groovy component to form an array that would contain the answer along with which row it was on. We had if statements in the groovy that used the item# to derive which set of questions and responses would be used.

 

[DaveWagoner]

WOW thanks. That sounds like a big lift. Good to hear it's possible