Running Campus Solutions Reports


Concept


Steps:

  1. For this example, you will be using the Academic Requirement Group report.

     

    Begin by navigating to the run control parameters page. 

     

    Click the Academic Advisement link.

    Step 1
  2. Click the Academic Requirement Group link.

    Step 2
  3. You can run this report/process by searching for an existing Run Control ID or you can add a new value. Creating a Run Control ID that is relevant to the report may help you remember it for future use.

    Step 3
  4. Use the Run Control search page, in this example, the Academic Requirement Group run control search page, to enter a Run Control ID.

     

    A Run Control ID is an identifier that, when paired with your User ID, uniquely identifies the process you are running.

     

    The Run Control ID allows for important parameters to be available for a process when the process runs. This ensures that when a process runs in the background it does not have to prompt you for any additional values. All parameters are stored within the system and associated with Run Control IDs and User IDs.

    Step 4
  5. By creating your own Run Control ID, you can save it and all of the assigned parameters so that you can easily access this report again in the future.

     

    For this example, assume that your name is Quinn and you want to create a Run Control ID using your name.

     

    Click the Add a New Value tab.

    Step 5
  6. Enter the desired information into the Run Control ID field. Enter

     a valid value
     e.g.
     "Quinn"
    .

    Step 6
  7. Add the new value and access the run control parameters page, for this example the Advisement Group Summary page.

     

    Click the Add button.

    Step 7
  8. Use the run control parameters page, for this example the Advisement Group Summary page, enter the request parameters. These parameters will be used to define the processing rules and data to be included when the report/process is run.

    Step 8
  9. Run control pages and their parameters will vary depending on the report that you are running. For example, other reports might have fields where you specify instructor name, campus, and to/from date values before running the report.

    Step 9
  10. Enter parameters for generating an Academic Group Summary report for the undergraduate liberal arts group.

     

    Click in the Academic Career field.

    Step 10
  11. Enter the desired information into the Academic Career field. Enter

     a valid value
     e.g.
     "UGRD"
    .

    Step 11
  12. Click in the Academic Program field.

    Step 12
  13. Enter the desired information into the Academic Program field. Enter

     a valid value
     e.g.
     "LAU"
    .

    Step 13
  14. Click the Honor Blank Values option.

    Step 14
  15. Access the Process Scheduler Request page to begin to run the process.

     

    Click the Run button.

    Step 15
  16. Use the Process Scheduler Request page to enter, update, or view general process parameters, such as server name and process output format.

    Step 16
  17. You must select a Server Name to identify the server on which to run the process.

     

    If you use the same Run Control ID for subsequent processes, the server name that you used last will default in this field.

     

    Click the Server Name list.

    Step 17
  18. Click the PSNT list item.

    Step 18
  19. Use the Recurrence field to specify the recurring time intervals for a process request to run. For instance, if you need to run a process every week day at 6 PM. that resolves all the transactions managed by your website, you could select the run recurrence definition of M-F at 6 PM. to schedule this process to run at the appropriate time.

    Step 19
  20. Use the Time Zone field to select the time zone in which the process will run. For example, you might be in Eastern Standard Time (EST) and schedule a process to run in Pacific Standard Time (PST).

    Step 20
  21. Use the Run Date field to view or specify the date when you want the process to run. This gives you the ability to set a report to run on a future date.

    Step 21
  22. Use the Run Time field to view or specify the time you want the process to run. This gives you the ability to set a report to run at a future time.

    Step 22
  23. Use the Reset to Current Date/Time button to set the Run Date and Run Time to the present date and time.

    Step 23
  24. The Description field helps to uniquely identify a process. You should be familiar enough with the processes that you run as part of your daily tasks to identify them by this description.

    Step 24
  25. The Process Name field displays the name of the process as it appears in the definition.

    Step 25
  26. The Process Type field displays the type of process, such as SQR, Crystal, and so on.

    Step 26
  27. Use the Type field to select the type of output that you want the process to produce.

     

    The four output Types are:

    File: This enables you to write the output to a file that will appear in the Output Destination.

    Printer: You can enter a custom printer location if you have the appropriate security access.

    Email: You can enter the destination information to send to a particular email recipient(s) Note that Email is available only for SQR, PS/nVision, and Crystal.

    Web: Sends all output of the process to the report repository, including log and trace files.

    Step 27
  28. Use the Format field to define the output format for the report. The values are dependent upon the Process Type that you select. For example, the default format for Web is PDF, and the default for Crystal and PS/nVision is HTML.

    Step 28
  29. Accept the values you entered and navigate back to the run control page, for this example, the Advisement Group Summary run control page.

     

    Click the OK button.

    Step 29
  30. Notice that your report has been assigned a Process Instance number. This indicates that the process has been submitted to Process Scheduler.

     

    It is a good idea to make a note of the Process Instance number for process monitoring.

    Step 30
  31. After the process is submitted to Process Scheduler, use the Process Instance number and Process Monitor to monitor the process status.

     

    You can use Process Monitor to:

    • Check the status of your submitted process requests.

    • Cancel process requests that have been initiated or are currently processing.

    • Hold process requests that are queued, and queue process requests you have put on hold.

    Step 31
  32. Access the Process List page, which is the first page of Process Monitor.

     

    Click the Process Monitor link.

    Step 32
  33. Use the Process List page to view the status of submitted process requests.

    Step 33
  34. Use the fields in the View Process Request For section to display specific processes based on the criteria entered in these fields.

    Step 34
  35. Use the User ID field to view the processes submitted by a user ID. Usually, you view your own user ID.

     

    Leave this field blank to view all of the processes that you are authorized to view.

    Step 35
  36. Use the Server field to view processes that are run on a particular server.

    Step 36
  37. Use the Run Status field to view processes by a specific status, such as Completed or Error.

     

    Leave the field blank view to all processes regardless of Run Status.

    Step 37
  38. Use the Type field to view only processes of a specific type such as Application Engine, Crystal, COBOL, SQR, or Application Engine processes.

     

    Leave the field blank to view all processes regardless of Type.

    Step 38
  39. Use the Name field to view all processes for a specific process name.

     

    Leave the field blank to view all processes regardless of Name.

    Step 39
  40. Use the Distribution Status field to view processes by distribution status, such as Posted or Error.

     

    Leave the field blank to view all processes regardless of Distribution Status.

    Step 40
  41. Use the Last fields to specify an interval of time by which to limit the process requests that appear in the list.

     

    Enter a custom numerical value in the field, and then select a unit type: Days, Hours, or Minutes.

    Step 41
  42. Use the Instance fields if you want to display results for a range of process instance numbers.

     

    Leave the fields blank to view all processes run that day, regardless of Process Instance number.

    Step 42
  43. The process Instance number helps you identify the process that you submitted, which is the process whose status you want to check.

    Step 43
  44. The current status of this report is Queued. The report is finished running when it has a status of Success.

    Step 44
  45. Knowing the status of your job helps you to see where it is in the queue or identify a problem if the process has an error.

    Step 45
  46. You must click Refresh to update the Run Status for your process. 

     

    How detailed a report is dictates how long it takes to obtain a status of Success. The report for this example is not long, so you will click Refresh only once to update the Run Status.

     

    You can continue with other work while your report is running in the background; there is no need to watch and wait.  However, if you want to monitor the progress, can click Refresh as often as you want.

     

    Click the Refresh button.

    Step 46
  47. The process is finished when the Run Status is Success.

    Step 47
  48. Access the Process Detail page.

     

    Click the Details link.

    Step 48
  49. Use the Process Detail page to view such details as request parameters and message logs.

    Step 49
  50. The Process group box contains general information to help you identify the process request.  This is a display-only group, showing basic descriptive information about the process.

    Step 50
  51. The Run group box shows specific run information, such as the Run Control ID and the run Location.

     

    If the process runs on the server, the server name appears in the Server field and any run recurrence that you have selected appears in the Recurrence field.

    Step 51
  52. The Update Process group box displays the actions you can take for this field depend on your user authorizations and the current status of the request.

     

    If you are authorized, you have the following options for your request: Hold, Queue, Cancel, Delete, or Restart.

    Step 52
  53. The Actions group box contains links to other pages that provide additional details about the process parameters.

    Step 53
  54. Click the Parameters link to view additional information about the process parameters, such as runtime definition variables, the path and program used to run the process, the location of the completed output, and additional information about the process status.

    Step 54
  55. Click the Message Log link to view messages that are inserted into the message log by the program that is running.

    Step 55
  56. The Batch Timings link is only available for process requests with a process type of Application Engine.

     

    The Batch Timings report contains a set of statistics that system administrators can use to tune the system to gain better performance. This report relates specifically to PeopleSoft Application Engine program performance.

    Step 56
  57. When you click the View Log/Trace link, a new browser window opens, displaying links that enable you to view the message log and trace file in a browser.

     

    The View Log/Trace link appears on the Process Detail page when at least one of the following conditions is met:

    • The output destination for the process request is Web, and the report and log files were successfully posted to the Report Repository by the Distribution Agent.

    • The process has a run status of Successful.

    • The process request ran from a PeopleSoft Process Scheduler Server Agent that was set up using the Server Definition page with a distribution node.

    Step 57
  58. Click the OK button.

    Step 58
  59. Now that your report has finished running, you are ready to use Report Manager to view your report.

     

    Return to the run control page, in this example, the Advisement Group Summary run control page.

     

    Click the Go back to Academic Requirement Group link.

    Step 59
  60. Report Manager is like your own personal "in box" of reports and process output. It provides a secured means to view report content, check the posting status of your output, and see content detail messages.

    Step 60
  61. Access the List page, which is the first page of the Report Manager component.

     

    Click the Report Manager link.

    Step 61
  62. Use the List page to view a list of reports from multiple databases to which you have access. Unlike the Administration page, the List page lists reports when both of the following events occur.

     

    First, the Distribution Agent has successfully posted the report to the report repository. Once the report has posted, the Distribution Agent publishes a message to have an entry added to the report folder table for the new report.

     

    Second, the local message node has subscribed to the message that was sent by the Distribution Agent by adding an entry for the report in the report folder table.

    Step 62
  63. Use the Explorer page to see a hierarchical view of folders and reports. Unlike the Administration page, the Explorer page lists reports when both of the following events occur.

     

    First, the Distribution Agent has successfully posted the report to the report repository. Once the report has posted, the Distribution Agent publishes a message to have an entry added to the report folder table for the new report.

     

    Second, the local message node has subscribed to the message that was sent by the Distribution Agent by adding an entry for the report in the report folder table.

    Step 63
  64. Use the Administration page you to view the report, view details about the report, and delete unwanted reports from the system. New reports that have been scheduled or are in the process of being posted to the report repository are viewed only through the Administration page.

    Step 64
  65. Use the Archives page to view reports that have been archived.

    Step 65
  66. For this exercise, you need to navigate to the Administration page to view the report.

     

    Click the Administration tab.

    Step 66
  67. The reports are listed in the Report List section of the page. You can sort the list by clicking the headings in the columns.

    Step 67
  68. The Group Advisement Summary report with your instance number, is at the top of the list, and the status is Posted.

    Step 68
  69. In Report Manager, there are several status possibilities. Knowing what they mean will help you to understand the progress of your job without having to check the Process Monitor.

    Step 69
  70. Because the status of your report is Posted, you can access the Report Detail page to view your report.

     

    Click the Details link.

    Step 70
  71. The link for the report contains the process name followed by the process instance number.  Access the report.

     

    Click the SRGRPADV_713.PDF link.

    Step 71
  72. The system opens a new browser window to display the report. (You might need to expand the browser window to view a report).

     

    Review the report, in this example the Advisement Requirement Group Summary Report

     

    You can print the report by using the browser's print button.

    Step 72
  73. After viewing the report, return to the Report Detail page in the original browser window.

     

    Click the Close button.

    Step 73
  74. Continue clicking to return to the Report Manager component.

     

    Click the OK button.

    Step 74
  75. If you are authorized to delete a report, the Select check box is active. This enables you to select the report and then click the Delete button to remove the report from the list.

     

    Note that you must be assigned the ReportDistAdmin (Report Manager administrator) or ReportSuperUser (super user) role in PeopleSoft Security to be able to delete a report in Report Manager.

     

    For this example, you do not have this authorization and you do not need to delete a report.

    Step 75

You have successfully set parameters to run a report, submitted the request to Process Scheduler, viewed the process status using Process Monitor, and viewed the report using Report Manager.

Table of Contents  Start Topic