Step-by-Step Guide to Use Oracle EBS Application to Retrieve Employee Information

Let's create an example to open the Human Resource, Vision Enterprises Form of Oracle EBS application and search an employe with the last name damin in the Find People window. Select an employee named Damin Gaur from the view-list displayed and then retrieve the employee number from the People window.

 

Next, we open the Navigator window and navigate to the Human > View > Work Assignment function. Open the Work Assignment window, enter the retrieved employee number, and then automatically fill the full name of the employee. As the output of the automated steps, view all the actions happening on the Oracle EBS Form automatically. At the completion of the workflow the Assignment History of Damin Gaur gets displayed and the Organization name is retrieved.

 

NOTE:

You must Close Environment and then Reset Environment every time you want to Test Run a process workflow, else, error is received or the test run fails.

 

1. In the Admin menu, add a WebApps application.
2. In the Application Properties panel:
   • Enter the Login URL of the Oracle EBS Form, Human Resource, Vision Enterprises. To retrieve the Form URL:
     1. Navigate to Human Resource, Vision Enterprises Form.
     2. Right click, and then click Properties
   • Enter the Search URL of the Oracle EBS Form. It must be same as the Login URL.
   • Enter a Display Name, OracleEBSDemo. You can enter any name of your choice.
     
     

      

   • In the Misc Java section, select the Has Java Components check box.
   • In the Misc Java section, select the type of environment in the Environment Type list.
     
     

      

3. Click the (Save Properties) icon to save the application. The Oracle EBS application is configured.
4. Create a new Process.
5. In the Canvas Tools pane click Process Components to view the associated activities.
6. Drag the Application activity and drop on to the Flowchart designer on the Canvas. The validation error symbol disappears when required inputs are provided.
7. In the Application Type list, select WebApps.
8. In the Select An Application list, select the configured host application, OracleEBSDemo.
   
   

    

9. Click the  (Settings) icon to launch the WEB MODE to capture the steps of logging to the Oracle EBS application. The configured Oracle EBS application appears.
10. Click the (Play) icon and then click the User ID field. The Field Properties panel of the Web Mode of the web application appears. The fields that are mandatory are highlighted with red box.
    
    

     

11. In the Action list, select Set Value.
12. In the Input Source, select UserId.
13. Enter a Display Name and then click the  (Save) icon to configure the details captured. The saved details start appearing in the Saved tab of Field Properties bar.
14. Click the (Play) icon and then click the Password field. The Field Properties panel of the Web Mode of the web application appears. The fields that are mandatory are highlighted with red box.
15. In the Action list, select Set Attribute.
16. In the Input Source, select Password.
17. Enter a Display Name and then click the   (Save) icon to configure the details captured. The saved details start appearing in the Saved tab of Field Properties bar.
18. Click the  (Play) icon and then click the Login button. The Field Properties panel of the Web Mode of the web application appears. The fields that are mandatory are highlighted with red box.
19. In the Action list, select Click.
20. Enter a Display Name and then click the (Save) icon to configure the details captured. The saved details start appearing in the Saved tab of Field Properties bar.
21. Click the (Save configured field and return to studio) icon to save the field that you configured and return to the Studio menu. The login steps are captured.
22. In the Menu bar of the Studio menu, click Test Run drop down, and then click Setup Environment to setup and launch the configured application using the Automation Studio.
23. Double click the Application activity and add the Application Host activity inside the Application activity.
24. In the Application Host activity, select Oracle EBS from the drop down list.

 

 

25. Click the (Settings) icon of the Application Host activity to attach the plug in based on the type of selected host application. A dialog box appears where you can define configurations related to the attached plug in.

 

 

26. In the Attach Behavior list of the Basics category, select Contains.
26. In the Window Title field, enter Oracle Applications – AUTOSC. Other default settings remain same. Close the dialog box to save the plug in configurations.
26. Double click to open the Application Host activity block.
    We have demonstrated Set Text, Get Text, Click, Select Listview item by index and Activate Window operations, that can be performed on the configured Oracle EBS form. You can configure other operations in the similar way depending on your business requirement.

Set Text

1. Click ADD to add the Application Control activity.

 

 

2. Click the (Field Configuration) icon of the of the Application Control activity, and then bring the Oracle EBS application window in focus.
3. Hover over the Full Name field . The area that you can capture gets highlighted with a blue box.

 

 

4. Click the highlighted area to extract the Id of the UI element. A dialog box appears where you can configure the details related to the captured UI element. The Id of the component and the window name are auto filled. The fields that are mandatory are highlighted with red box.

 

 

5. In the Action list, select Set Text.
5. In the Text field, enter damin and select the Is Default Value. You can enter any employee name that you want to search.
5. In the Display Name, enter Name. You can enter any name of your choice to be displayed.
5. Close the dialog box.  The Save Confirmation message box appears.
5. Click YES  to save the entered details.
5. In the Properties pane of the added Application Control activity, set the Wait After time as 3000 as the next screen takes time to load.
   Follow below steps to configure the subsequent steps of the automation process workflow example.

Click

1. Click ADD to add the Application Control activity.
2. Click the (Field Configuration) icon of the of the Application Control activity, and then bring the Oracle EBS application window in focus.

 

 

3. Hover over the Find field, and the click the button. A dialog box appears.

 

 

4. In the Action list, select Click.
4. In the Display Name, enter Click to find the employee. You can enter any name of your choice to be displayed.
4. Close the dialog box.  The Save Confirmation message box appears.
4. Click YES  to save the entered details.
4. In the Properties pane of the added Application Control activity, set the Wait After time as 3000 as the next screen takes time to load.
   Follow below steps to configure the subsequent steps of the automation process workflow example.

Select Listview item by index

1. Click ADD to add the Application Control activity.
2. Click the (Field Configuration) icon of the of the Application Control activity, and then bring the Oracle EBS application window in focus.

 

 

3. Hover over the list view, and the click the highlighted area. A dialog box appears.

 

 

4. In the Action list, select Select Listview item by index.
4. In the Index field, enter 1 to select the second data available in the list.
4. In the Display Name, enter Select relevant employee. You can enter any name of your choice to be displayed.
4. Close the dialog box.  The Save Confirmation message box appears.
4. Click YES  to save the entered details.
4. Click ADD to add the Application Control activity.
4. Click the (Field Configuration) icon of the of the Application Control activity, and then bring the Oracle EBS application window in focus.

 

 

11. Hover over the OK field, and the click the button. A dialog box appears.

 

 

12. In the Action list, select Click.
12. In the Display Name, enter Click Ok. You can enter any name of your choice to be displayed.
12. Close the dialog box.  The Save Confirmation message box appears.
12. Click YES  to save the entered details.
12. In the Properties pane of the added Application Control activity, set the Wait After time as 3000 as the next screen takes time to load.
    Follow below steps to configure the subsequent steps of the automation process workflow example.

Get Text

1. Click ADD to add the Application Control activity.
2. Click the (Field Configuration) icon of the of the Application Control activity, and then bring the Oracle EBS application window in focus.

 

 

3. Hover over the Identification field, and the click the field containing the employee Id. A dialog box appears.

 

 

4. In the Action list, select Get Text.
4. In the Display Name field, enter EmployeeId. You can enter any name of your choice to be displayed.
4. In the Variable Name field, enter EmployeeId. The variable gets created and the extracted data gets stored in this variable. You can define a relevant parameter in the Parameter bar and select the same from the Variable Name list.
4. Close the dialog box.  The Save Confirmation message box appears.
4. Click YES  to save the entered details.
4. In the Properties pane of the added Application Control activity, set the Wait After time as 3000 as the next screen takes time to load.
   Follow below steps to configure the subsequent steps of the automation process workflow example.

Activate Window

1. Click ADD to add the Application Control activity.
2. Click the (Field Configuration) icon of the of the Application Control activity, and then bring the Oracle EBS application window in focus.

 

 

3. Hover over the Navigator, and the click the window to bring it in focus. A dialog box appears.

 

 

4. In the Action list, select Activate window.
4. In the Display Name field, enter Bring in focus. You can enter any name of your choice to be displayed.
4. Close the dialog box.  The Save Confirmation message box appears.
4. Click YES  to save the entered details.
4. In the Properties pane of the added Application Control activity, set the Wait After time as 3000 as the next screen takes time to load.
   Follow below steps to configure the subsequent steps of the automation process workflow example.

 

Select Navigate Item By Index

1. Click ADD to add the Application Control activity.
2. Click the (Field Configuration) icon of the of the Application Control activity , and then bring the Oracle EBS application window in focus.

 

 

3. Hover over the Navigator window and click the pane where View function is available to extract the Id of that pane. A dialog box appears.

 

 

4. In the Action list, select Select Navigator Item By Index.
4. In the Index field, enter 7. The index of the View function is 7.
4. In the Display Name, enter Select Payroll. You can enter any name of your choice.
4. Close the dialog box.  The Save Confirmation message box appears.
4. Click YES  to save the entered details.
4. Click ADD to add the Application Control activity.
4. Click the (Field Configuration) icon of the of the Application Control activity, and then bring the Oracle EBS application window in focus.

 

 

11. Hover over the Expand button and then click the highlighted area. The dialog box appears.

 

 

12. In the Action list, select Click.
12. In the Display Name, enter Expand View. You can enter any name of your choice to be displayed.
12. Close the dialog box.  The Save Confirmation message box appears.
12. Click YES  to save the entered details. Since we have to select and expand the first item, we would directly configure the action to expand the History function. If you need to select any other item, configure Select Navigator Item By Index and specify the index number accordingly.
12. In the Properties pane of the added Application Control activity, set the Wait After time as 3000 as the next screen takes time to load.
12. Click ADD to add the Application Control activity.
12. Click the (Field Configuration) icon of the of the Application Control activity, and then bring the Oracle EBS application window in focus.

 

 

19. Hover over the Expand button and then click the highlighted area. The dialog box appears.

 

 

20. In the Action list, select Click.
20. In the Display Name, enter Expand History. You can enter any name of your choice to be displayed.
20. Close the dialog box.  The Save Confirmation message box appears.
20. Click YES  to save the entered details. Since we have to select and open the first item, we would directly configure the action to open the Work Assignment window. If you need to select any other item, configure Select Navigator Item By Index and specify the index number accordingly.
20. In the Properties pane of the added Application Control activity, set the Wait After time as 3000 as the next screen takes time to load.
20. Click ADD to add the Application Control activity.
20. Click the (Field Configuration) icon of the of the Application Control activity, and then bring the Oracle EBS application window in focus.

 

 

27. Hover over the Open button and then click the highlighted area. The dialog box appears.
27. In the Action list, select Click.
27. In the Display Name, enter Click Open. You can enter any name of your choice to be displayed.

 

 

30. Close the dialog box.  The Save Confirmation message box appears.
30. In the Properties pane of the added Application Control activity, set the Wait After time as 3000 as the next screen takes time to load.
30. Click ADD to add the Application Control activity.
30. Click the (Field Configuration) icon of the of the Application Control activity, and then bring the Oracle EBS application window in focus.

 

 

34. Hover over the Number field and then click the highlighted area. The dialog box appears.

 

 

35. In the Action list, select Set Text.
35. In the Display Name, enter Set employee Id. You can enter any name of your choice to be displayed.
35. Close the dialog box.  The Save Confirmation message box appears.
35. In the Properties pane of the added Application Control activity, set the Wait After time as 3000 as the next screen takes time to load.
35. Click ADD to add the Application Control activity.
35. Click the (Field Configuration) icon of the of the Application Control activity, and then bring the Oracle EBS application window in focus.

 

 

41. Hover over the Full Name field and then click the highlighted area. The dialog box appears.

 

 

42. In the Action list, select Click.
42. In the Display Name, enter Click Verify full name. You can enter any name of your choice to be displayed.
42. Close the dialog box.  The Save Confirmation message box appears.
42. In the Properties pane of the added Application Control activity, set the Wait After time as 3000 as the next screen takes time to load.
42. Click ADD to add the Application Control activity.
42. Click the (Field Configuration) icon of the of the Application Control activity, and then bring the Oracle EBS application window in focus.

 

 

48. Hover over the Find button and then click the highlighted area. The dialog box appears.

 

 

49. In the Action list, select Click.
49. In the Display Name, enter Click Find. You can enter any name of your choice to be displayed.
49. Close the dialog box.  The Save Confirmation message box appears.
49. In the Properties pane of the added Application Control activity, set the Wait After time as 3000 as the next screen takes time to load.
49. Click ADD to add the Application Control activity.
49. Click the (Field Configuration) icon of the of the Application Control activity, and then bring the Oracle EBS application window in focus.

 

 

55. Hover over the Organization field and then click the highlighted area. The dialog box appears.

 

 

56. In the Action list, select Get Text.
56. In the Display Name, enter Click Find. You can enter any name of your choice to display to be displayed.
56. In the Variable Name field, enter GetOrgname. The variable gets created and the extracted data gets stored in this variable. You can define a relevant parameter in the Parameter bar and select the same from the Variable Name list.
56. Close the dialog box.  The Save Confirmation message box appears.
56. Click YES  to save the entered details.
56. Close the dialog box.  The Save Confirmation message box appears.
56. In the Properties pane of the added Application Control activity, set the Wait After time as 3000 as the next screen takes time to load.

To view the organization name in Automation Studio, let's add WriteLine activity. You can assign this process to a robot, if you want to execute this process outside Automation Studio.

63. Add a WriteLine activity, and in the Text field, enter GetOrgname to print the organization name that gets saved in this variable.
63. Save the process.
63. Reset and then set up the environment.
63. Perform the test run. Below is the screen shot of how the process workflow looks:

 

You can view all the actions taking place on the Oracle EBS Form automatically. On the completion of the execution of the process workflow, the Assignment History of Damin Gaur gets displayed.

 

 

The Output console of Automation Studio displays the organization name retrieved.