Oracle by Example brandingBuilding a Workflow in the Workflow Studio

section 0Before You Begin

This 50-minute OBE shows you how to create a new workflow process, and design for approve and reject cases in the Workflow Studio.

Time to Complete

50 minutes.

Background

Starting with Tools Release 9.2.6.4, you can create a new workflow process in the Workflow Studio. The Workflow Studio is a web-based user interface that you can launch from the Orchestrator Studio. This enhancement removes the dependency on the Object Management Workbench to create a new workflow process.

Note: The ability to create a workflow process by using OMW is still available.

Scenario

For this OBE, consider a scenario in which you want to create a new workflow process where a request is made to increase the credit limit for a customer. After the request is submitted, the workflow sends a message to the supervisor for approval. The supervisor approves the request first, the originator receives a message. The originator sends the request again, the supervisor rejects it, and the originator receives a notification.

Prerequisites

  • Orchestrator Studio 9.2.7 or later deployed in a JD Edwards EnterpriseOne test environment.

section 1Importing an Orchestration

In this task you will import an orchestration.

  1. Download and save in your system the Send_Reject_Message.zip file containing the orchestration that notifies the originator if their request is rejected by the supervisor.
  2. Sign in to the JD Edwards EnterpriseOne Orchestrator Studio.
  3. Click the Tools menu and select Import/Export from the drop-down list.
  4. Importing or Export Menu
    Import or Export Menu
  5. Upload the shared compressed file and check Select All check box and then click Submit.
    Upload the Compressed File
    Upload the Compressed File
  6. Click the Back button on the top menu bar to return to the Orchestrator Studio.

section 2Creating a New Workflow Process

In this task you will create a new workflow process in the Orchestrator Studio.

  1. Click the Workflows icon to open the Workflow Studio.
  2. Accessing Workflows from Orchestrator Studio
    Accessing Workflows from the Orchestrator Studio
  3. Click New to create a new workflow.
  4. Complete the below fields:
    Name: CRED_HOL
    Description: Adjust Credit Limit

section 3Defining Key and Additional Data Structures

A JD Edwards EnterpriseOne workflow process requires these two data structures:

  • Key: A key data structure contains the data items that make an instance of a process unique, similar to how the primary key in a table is the unique index in a table.
  • Additional: An additional data structure contains all the other data that the process and any task within the process, need to complete the process flow.
  1. Click the Key Data Structure icon and enter D03B0159B in the Key Data field.
  2. Key Data Structure Selection
    Key Data Structure Selection
  3. Click the Additional Data Structure icon and enter D03B0159C in the Additional Data field.
  4. Adding Action Message task
    Additional Data Structure Selection
  5. Click Save to continue.

section 4Adding Tasks and Transitions to the Workflow Process

For a new workflow process, the Start and End tasks are present in the diagram workspace by default. You must add other tasks between the Start and End tasks. To complete the CRED_HOL workflow, you will add one Business Function task, one Action Message task, two Transitions, one Info Message task, and one Orchestration task.

  1. Drag and drop an Action Message task between the START and END tasks.
  2. Drag and Drop
                      Action Message Task
    Drag and Drop Action Message Task
  3. Enter APPROVE in the Task Name field and Approve Request in the Description field.
  4. Adding Action Message task
    Adding Action Message Task
  5. Click the Edit icon to configure the Action Message task.
  6. In the Message Editor window, select Address Book from the drop-down list in the To Recipient field.
  7. Enter mnSendToAddress_AN8Rin the Address Book Number field and select mnSendToAddress_AN8R under Additional Data – D03B0159C from the drop-down list.
  8. Enter Request to increase credit limit in the Subject Literal field.
  9. Enter P98806 in the Shortcut field.
  10. Select W98806A from the Form drop-down list.
  11. Toggle on the Input for the second parameter and in the Mapping drop-down, under System Values select Current Workflow Task.
  12. Enter LM1234 in Message and provide the below inputs:
    &1 = mnCustomerNumber_AN8
    &2 = szCustomerName_ALPH
    &3 = mnOldCreditLimit_ACL
    &4 = mnNewCreditLimit_AG
    &5 = jdDateUpdated_UPMJ
    &6 = szOriginatorName_ALP1
  13. Configuring Action Message task
    Configuring Action Message Task
  14. Close the Message Editor window and click Save.

    Now, you will add an Orchestration task to the workflow. The orchestration sends a formatted message just to demonstrate the functionalities. The orchestration can do a lot of things, and a lot of features are supported in the message, including rich formatted message, attachments, action links and so on.
  15. Move the END task to the right side of the diagram workspace. Drag and drop an Orchestration task between the APPROVE and END tasks.
  16. Enter REJECTED in the Task Name field and Send Reject Message in the Description field.
  17. Click the Edit icon to configure the Orchestration task.
  18. In the Orchestration Editor window, click the Search icon to search and select Send a Reject Message.
  19. Configuring Orchestration task
    Configuring Orchestration Task
  20. Map the below inputs and close the Orchestration Editor window.
    originator = mnOriginatorNumber_ANO
    newLimit = mnNewCreditLimit_AG
    customerName = szCustomerName_ALPH
  21. Orchestration Editor
    Orchestration Editor Window
  22. Move the Orchestration task down and click Save.
  23. Workflow with Orchestration Task
    Workflow with Orchestration Task
  24. Drag and drop a Business Function task between the APPROVE and END tasks.
  25. Workflow with Business Function task
    Workflow with Business Function Task
  26. Enter UPDATE in the Task Name field and Update Credit Limit in the Description field.
  27. Click the Edit icon to configure the Business Function task.
  28. Enter N03B0159 in field Function Object Name.
  29. Toggle on the Input mapping for all the parameters and map the below inputs.
    mnCustomerNumber = mnCustomerNumber_AN8
    mnNewCreditLimit = mnNewCreditLimit_AG
    szCompany_CO = szCompany_CO
  30. Business Function Editor Window
    Business Function Editor Window
  31. Close the Business Function Editor window.
  32. Drag and drop an Info Message task next to the Business Function task.
  33. Enter APPROVED in the Task Name field and Send the approval message in the Description field.
  34. Workflow with Info Message Task
    Workflow with Info Message Task
  35. Click the Edit icon to configure the Info Message task.
  36. In the Message Editor window, select Address Book from the drop-down list in the To Recipient field.
  37. Enter mnOriginatorNumber_ANO in the Address Book Number field and select mnOriginatorNumber_ANO under Additional Data – D03B0159C from the drop-down list.
  38. Enter Credit Limit Has Been Approved in the Subject Literal field.
  39. Define Message with the below values:
    Message = LM1235
    &1 = mnCustomerNumber_AN8
    &2 = szCustomerName_ALPH
    &3 = mnNewCreditLimit_AG
  40. Info Message Editor Window
    Info Message Editor Window
  41. Close the Message Editor window.
  42. Hover over the Info Message task and click the arrow and drag it to connect to the END task.
  43. Connecting Info Message and
                      End Tasks
    Connecting Info Message and End Tasks
    Connecting Info Message and
                      End Tasks
    Connecting Info Message and End Tasks
  44. Right-click the link between APPROVE and UPDATE tasks. Select Add and Attach Transition Condition from the context menu.
  45. Add and Attach Transition
                      Condition
    Add and Attach Transition Condition
  46. In the Edit Condition window, complete the below fields:
    Task name = IFAPPROVED
    Description = if the request is approved
  47. Adding Transition in the
                      Workflow
    Adding Transition in the Workflow
  48. Click the Additional Data Structure icon in the right pane and select cApprovalActionCode from the list to define the Left Operand. The system automatically populates is equal to in the Compare Operator.
  49. Click the Literal icon and enter A for Right Operand and click OK.
  50. Edit Condition Window for
                      IFAPPROVED
    Edit Condition Window for IFAPPROVED
  51. Review the condition and close the Edit Condition window.

    In step 8, we selected the general workflow approval application P98806, which updates cApprovalActionCode with either "A" or "R" for the workflow instance. Therefore, to use the generic workflow approval application P98806, it is required that Data Dictionary item APPRACT is included in the data structure of the workflow and the values in the conditions are either "A" or "R".
  52. Click the Manage Transition Condition icon on the left and click the Add icon.
  53. In the Edit Condition window, complete the below fields:
    Task Name = IFREJECTED
    Description = The request is rejected
  54. Click the Additional Data Structure icon in the right pane and select cApprovalActionCode from the list to define the Left Operand. The system automatically populates is equal to in the Compare Operator.
  55. Click the Literal icon and enter R for Right Operand and click OK.
  56. Edit Condition Window for
                      IFREJECTED
    Edit Condition Window for IFREJECTED
  57. Review the condition and close the Edit Condition window.
  58. Click the Diagram icon to return to the diagram workspace.
  59. Hover over the link between the APPROVE and REJECTED tasks. Right-click and select Select and Attach Transition Condition from the context menu.
  60. Select and Attach
                      Transition Condition
    Select and Attach Transition Condition
  61. Click IFREJECTRED condition in the selection window.
  62. Click Save.
  63. Click Manage and then click Validate. The system displays the message, “Validate Successful.”
  64. Validating the Workflow
                      Process
    Validating the Workflow Process
  65. Click Manage and then click Release Reservation. The system displays the message, “Release Reservation Successful.”
  66. Click Manage and then click Activate.
  67. Completed Workflow Process
    Completed Workflow Process

section 5 Creating a Logic Extension to Start the Workflow Process

  1. Click Home to return to the Orchestrator Studio and then click the Logic Extension icon.
  2. Launching Logic Extensions
                      from Orchestrator Studio
    Launching Logic Extensions from Orchestrator Studio
  3. Click New and enter the following values:
    Name = Start Workflow
    Description = Start Workflow
  4. Click the Logic icon to access the design area.
  5. Click the + icon between the Start and End and select Workflow from the context menu.
  6. Click the search icon in Workflow field.
  7. Adding Workflow to Logic
                      Extension
    Adding Workflow to Logic Extension
  8. In the Workflow List window, enter cred_ in the Filter field and select the workflow, CRED_HOL, created in the previous task. After you select the workflow, the Key Data Structure and Additional Data Structure sections are displayed to create the mappings.
  9. Click the Edit icon for Key Data Structure section.
  10. Click the drop-down icon next to mnCustomerNumber and select Add to Data Structure.
  11. Close Workflow Parameter Mapping window.
  12. Click the Edit icon for the Additional Data Structure section.
  13. Click the drop-down list next to all the parameters, except ID 8 cApprovalActionCode, and select Add to Data Structure.
  14. Workflow Parameter Mapping
                      for Additional Data Structure
    Workflow Parameter Mapping for Additional Data Structure
  15. Close the Workflow Parameter Mapping window.
  16. Click the Data Structure icon and rename the first two inputs as the following:
    mnCustomerNumber1 = CustomerNumber
    szCustomerName2 = CustomerName
  17. Workflow Data Structure
                      Mapping
    Workflow Data Structure Mapping
  18. Click Save.

section 6Running the Workflow Process

  1. Click the Test icon for Start Workflow.
  2. Enter the input values as below:
    CustomerNumber = 3001
    CustomerName = Global Enterprises
    mnOldCreditLimit3 = 100
    mnOriginatorNumber5 = 1
    szOriginatorName6 = Financial/Distribution Company
    mnNewCreditLimit7 = 150
    mnSendToAddress8 = 1
    szCompany9 = 00000
  3. Click the Calendar icon jdDateUpdated4 to pick a date.
  4. Workflow Test
    Workflow Test
  5. Click the Test icon to start the workflow.

    Note: In this OBE, we are using user JDE’s address book number for both the originator and approver (SendToAddress). In reality, you will want to send the request to someone with the pertinent authority and the originator would be an employee who submitted the request.
  6. Sign in to JD Edwards EnterpriseOne web client.
  7. Click the Notification List icon in the navigator and then click the Launch Message Center icon to open the Message Center.
  8. Click Work Center tab and expand the queue Personal In Basket.
  9. Open message titled Request to increase credit limit.
  10. Click the Workflow Approval link in the message.
  11. On the Workflow Approval form, click OK.
  12. Expand the queue Personal In Basket. View the new message, this is a plain text message constructed by the ACCEPTED (Info Message) task.
  13. Return to the Logic Extension in Orchestrator Studio and click the Test icon to send another request.
  14. Switch back to the JD Edwards EnterpriseOne web client.
  15. Click the Refresh icon at the bottom of the Work Center tab.
  16. Expand the queue Personal In Basket and open the message titled Request to increase credit limit.
  17. Select the Reject option and click OK on the Workflow Approval form.
  18. Expand the queue Personal In Basket. View the new message in Message Center, the formatted text message is sent from REJECTED (Orchestration) task.

next stepNext Tutorial

Calling an Orchestration from a Workflow Process


more informationWant to Learn More?