2.9.1_Simulation - Running Query Reports

Navigation: Main Menu > Reporting Tools > Query > Query Manager

Purpose: Use this simulation to practice running a query report.

Steps:

1. Enter the desired information into the Find an Existing Query begins with field. Enter

    a valid value
    e.g.
    "BH_SCM_RQS_NO_POS_TEN_DYS_MORE"
   .
   Step 1

2. Click the Search button.

   Step 2

3. Click the Schedule link.

   Step 3

4. The Run Control ID is a personal name you choose to give a query. This is different from the Description you will need to complete on the next screen.

    

   Enter the desired information into the Run Control ID field. Enter

    a valid value
    e.g.
    "PERSONAL_DESCRIPT"
   .
   Step 4

5. Click the Add button.

   Step 5

6. The Description is a required field that is a personal description of the query contents.

    

   Enter the desired information into the Description field. Enter

    a valid value
    e.g.
    "Reqs without POs"
   .
   Step 6

7. Click the OK button.

   Step 7

8. Click Main Menu to go to the Process Monitor.

   Step 8

9. Click the PeopleTools menu.

   Step 9

10. Click the Process Scheduler menu.

    Step 10

11. Click the Process Monitor menu.

    Step 11

12. Click the Details link.

    Step 12

13. Click the View Log/Trace link.

    Step 13

14. To open the query in Excel, click the desired file in the list. 

     

    A separate browser window will open to direct you to Excel.

    Step 14

Congratulations! You have run a query report.

Your final learning activity in this course is the Course Quiz.

After clicking finish below, go to the course outline, select Course Quiz and click the Start button to begin. When you finish answering all questions your score displays. Exit the course after completing the course quiz.

Table of Contents  Start Topic