Before You Begin

This 30-minute Oracle by Example (OBE) shows you how to create an orchestration that automatically generates serial numbers for multiple work orders. It shows how to use the Orchestrator Process Recorder to capture the steps you would perform manually in EnterpriseOne forms. The system saves this recording as an Orchestrator form request. You will then include this form request in an orchestration called "WOSLGEN". This Orchestration also shows how to create a data request.

Scenario

In this OBE, consider a scenario in which you manufacture large numbers of serialized items and you want to generate serial numbers for all the items. The manual process can be cumbersome and time-consuming as it requires drilling into each work order and then run the Assign Serial Numbers application to interactively generate them. This Orchestration replaces the manual process allowing for mass generation of work order serial numbers.

What Do You Need?

• Orchestrator Studio 9.2.7 or later deployed in a JD Edwards EnterpriseOne test environment with a minimum of EnterpriseOne Tools 9.2.7.
• Data for items, and branches in the database.
• Access to the Orchestrator Studio and permissions to create orchestration and service request components, which are managed as user defined objects (UDO) in EnterpriseOne.
• Access to the Process Recorder in EnterpriseOne.
• A work order for which serial number needs to created should be created.

Recording the Process for Creating a Form Request to Generate a Serial Number for Work Order

1. Open a web browser and sign in to EnterpriseOne on the web.
2. Navigate to Work With Manufacturing Work Orders (P48013) application from the Fast Path.
3. Click the Login(User Id) drop-down menu, from Personalization menu, select Record a Process.
Work Order must be created before starting the process.
4. In the Process Recorder, click Start.
5. Enter 1136920 in the Order No field.
For this OBE, the order number for the work order is 1136920.
6. Click Find.
7. Select the work order displayed.
8. Click the Row exit and select Serial Numbers.
The Work With Work Order Serial Numbers form is displayed.



9. Click the Form exit and select Revisions.
The Serial Number Revisions form is displayed.



10. Click the Form exit and click Lot/SN Generation.
11. Click OK.
12. In the Process Recorder, click Stop.
13. Complete the following fields in the Process Recorder:
• Name = WOSLGEN
• Description = Work Order Serial Number Generation.
• Product Code = 55



14. Click Save.
EnterpriseOne saves the recording as a Form Request.
15. Close Process Recorder.
16. Click the login drop-down menu(user id) and click Sign Out.
    

Creating Data Request in Orchestrator Studio

1. Sign in to the Orchestrator Studio.
2. On the Orchestrator Studio Home Page, Click the Data Requests icon.
3. Click the New button.
4. Enter Work Order Data in the Name field.
5. Enter Work Order Data Request in the Description field .
6. Enter F4801 in the Table/View Name field.
7. Click Load.
8. Enter Doc Order in the Data Set Variable Name field.
9. Type User ID in the Filter field.
10. Click filter icon.

11. Type Request Date in the Filter field.
12. Click Filter icon.

13. Select Order Number as Return Value.
14. Click Return icon to add parameters in the Return Fields and Variable Names .
15. Click Save.
16. Close the Data Request form.

Creating an Orchestration to Generate a Serial Number for Work Order

1. On the Orchestrator Studio Home page, click Form Requests icon.
2. From the list of Personal Form Requests, select WOSLGEN.
If you don’t see WOSLGEN listed, click the refresh icon.
3. In the Manage menu, select Create Orchestration,.
4. Click Design Mode.
5. Click the Add(+) button beside the Start button .
New Step Type form is displayed.
6. From the the New Step Type select Data request .
7. From the list of Personal Data Requests, select Work Order Data.
8. Click Save button.
The name defaults to WOSLGEN from the form request.

9. Click the WOSLGEN icon in the Orchestration flow and then click Transformations icon.

10. Select Doc order in the Iterate over drop-down list.


11. Map the inputs as follows:
• From the Available Values drop-down list in the Order_No row, select Doc Order.Order Number.
• From the Available Values drop-down list in Select_Row row, select Select_Row.
• From the Available Values drop-down list in P48013_Version row, select P48013_Version.

12. Click Add Inputs to Orchestration.
13. Click Save on the WOSLGEN page.

14. Click the Work Order Data icon in the Orchestration flow and click Transformations icon.

15. Map the values as follows.
• From the Available Values column in the User Id row, select User Id 1.
• From the Available Values column in the Requested Date row, select Requested Date 1.

16. Click Add Inputs to Orchestration.
17. Click Save on the WOSLGEN page.

Testing the Work Order Serial Number Generation Orchestration

1. On the Orchestration page, click Start button and click Inputs and Values.
Inputs and Values Form opens up.
2. Enter the Requested Date in the Input field and specify the Value Type in the format Date-yy/MM/dd.
3. Enter User ID as the Input field and specify the Value Type as String.

4. Click Save.
5. To test the Orchestration, click the Start icon in the orchestration flow and then click the Run Orchestration icon

6. In the input fields on the left, enter the following :
Requested Date: The requested date of the order in the format defined.
User Id: User id.


7. Click Run button.
8. The Output shows the new order number and the success message.
Expand the Inputs area on the right to clearly see the JSON input that was sent.



9. Close(x) the Run Orchestration form.
10. Click on Sign Out from the Login(User Id) drop-down menu.
11. Sign in to EnterpriseOne application.
12. Access the Work With Manufacturing Work Orders (P48013) application from the Fast Path.
13. Search for the work orders by their request date.
14. Select any work order.
15. Select Serial Numbers from Row Exit.
The serial numbers generated by orchestration will be displayed.

Want to Learn More?

• JD Edwards EnterpriseOne Tools Orchestrator Guide