Email and Print an FSG Report on a Networked Printer

Once you have requested an FSG report using “Program – Run Financial Statement Generator”, you can print it on a networked printer (that is set up to print Oracle reports), and view the output on your computer screen.

Objective:
At the end of this lesson, you will be able to view your report on your computer screen, e-mail a report notification automatically and print your department statement at your networked printer.

NOTE: If there is a printer in your department that you would like to print Oracle reports on, call the ITS Help Desk at ext. 5-4357.

Directions: Print an FSG Report

• Click on the “Options” button within the “Upon Completion” section.

NOTE: Refer to the Appendix Tip #4, to find out how to schedule a report in the “At these Times…” section.

• Click on the LOV field located to the right of the “Name” field in the “Upon Completion” screen.

• Enter the name of the person and click on the “Find” button.

Select the person’s name and click on the “OK” button.

• Click once within the “Printer” field to position your cursor in the “Printer” field.
• Click on the LOV field to the right of the “Printer” field. The Printers screen appears.

• In order to reduce the list of printers, type “prcto%” in the ‘Find” field and click the “Find” button. The printer “prcto01_app” is the second one on the list. Click on it to select it. Click on the “OK” button.

• In the “Copies” field, enter the number of copies you would like to print.
• Click on the “OK” button.

• Click on the “Submit” button. (Remember, since we left a “0” in the “Copies” field of the Options screen, we won’t actually be printing our report).

• Click on the “Refresh Data” button.

NOTE 1: The “Cancel” and “Hold” buttons are only active when a request has not yet completed.
NOTE 2: Another way to refresh the data on your “Requests” screen is to hold down the Control key and press the F11 key.
NOTE 3: In this example notice Request ID 2530466 “Phase” Completed “Status” Warning. This will always occur if the report you ran has no data. In this case, view your output and check the parameters you entered. Submit a new report with the correct parameters.

• Select your second request id and click on the “View Output” button.

• Click on the maximize box in the new browser window to maximize the window.

• Click on the close box in the browser window to close the window.

• Click on the “Submit a New Request” button.

• Click on the “OK” button.

• Click on the “Copy” Button.

• Find the report you want to copy

• Place your cursor in the “Parameters” field and make necessary changes

Example of changes:

• Click in the “Period” field.
• Click on the LOV field to the right of the “Period” field.
• Select “NOV-07” and click the “OK” button.
• Click on the “OK” button in the “Parameters” field.
• Submit the report for printing.

NOTE: To view prior requests from the Navigator screen click on the “View” menu and select “Requests”. A “Find Requests” screen will open giving you the option to specify which request id you want to find or if you want to find all of your requests simply click the “OK” button.

NOTE: You can also change the order your requests display in the “Requests” screen by using the “Order By” field in the “Find Requests” screen. You can put them in order by Request ID, Name or by Requesting Start Date.

The following screen shows the list of Request ID numbers in descending order

Summary of Steps to Print an FSG Report from a Networked Printer

1. In the “Submit Request” screen click on the “Options” button.
2. To send an e-mail notification place your cursor in the “Name” field within the “Notify the following People:” section on the “Upon Completion” screen.
   • Click on the LOV field to the right of the “Name” field.
   • Type the employee’s last name and a percent sign in the “Find” field.
   • Click on the “Find” button.
   • Select the employee’s name from the reduced list of values.
   • Click on the “OK” button.
   • Repeat for as many employees that you want to e-mail.
3. To select a printer and number of copies place your cursor in the “Printer” field within the “Print the Output To:” section on the “Upon Completion” screen.
   • Click on the LOV field to the right of the “Printer” field.
   • If you know the printer’s name, type it in the “Find” field (or part of it with a percent sign).
   • Click on the “Find” button.
   • Select the printer’s name from the reduced list of values.
   • Click on the “OK” button.
   • The cursor will automatically tab to the “Copies” field. Enter the number of copies you want to print.
   • Repeat for as many printers as you need.
4. Click on the “OK” button. The Submit Requests screen reappears.
5. Click on the “Submit” button.
6. The “Requests” screen automatically opens with your request id highlighted in blue.
7. If the phase of your job is pending or running it will be highlighted in green until it is completed. If your job errors out it will be highlighted in red.
8. Follow along the row in which your request id appears to view its phase and status in the print queue. You must also check the request id for the “Financial Statement Generator” which is a second request generated by the first. This is the request that will create your report.
9. When the phase and status are “Completed” and “Normal” for the two jobs you can view the report online. Select the second request id and click on the “View Output” button.
10. To make your output screen larger click the maximize button in the upper right hand corner.
11. Use the scroll bar to scroll down and view the other pages in your report.
12. Close your output screen by clicking on the close box in the upper right corner.
13. You can submit a new request from the “Requests” screen by clicking on the “Submit a New Request” button. The “Submit a New Request” screen will open.
14. By clicking the “OK” button you will be taken to the “Submit Request” screen where you can create a new request or copy a previous request by clicking on the “Copy” button.
15. When you copy a previous request you can change the parameters (period, segment override, etc.) by clicking in the “Parameters” field. The parameters screen will open, allowing you to change the parameter values.
16. To view requests directly from the Navigator window click on the “View” menu and select “Requests”.
17. The “Find Requests” screen will open. From there you can enter a specific request id to find, or change the order in which your requests display. Click the “OK” button to go to the “Requests” screen.