Setting Parameters

TMS populates some parameter fields with default values. After the first time the report is executed, the parameters entered when you last ran the report become the default values. You can save your parameters for future use. See Retrieving a Parameter Set.

The column of boxes on the right indicates if you can enter a wildcard (%) to search for a valid value for the field. If a box is selected, you can use wildcards.

Fields displayed in red are mandatory; you must enter a value in them.

For more information, see:

• General Parameters
  
• Job-Specific Parameters
  
• Scheduling Parameters
  

General Parameters

Many reports include, under General Parameters:

• Output: Select a format. Options include PDF, RTF, XML, HTML, and XLS.

• Display Parameters: Select Yes to display the values of the report-specific parameters in the report output.

Job-Specific Parameters

Many reports or batch jobs have parameters that are unique to the report, and that you can use to customize the report output to suit your needs more closely.

If there are job-specific parameters for your report or batch job, they appear under the Job Specific heading in the Report Submission window.

Report Template: It is a job-specific parameter in many reports. If your company has created a custom template, it appears in the list of values. The Oracle Template is the default template. See Customizing Report Templates. for information on creating and setting up templates.

Scheduling Parameters

Some jobs have parameters that allow you to schedule the job to run in the future:

• Frequency. To schedule a single job execution, leave this field blank. To schedule execution on a regular basis, select one of the following from the list: Hourly, Daily, Weekly, Monthly or Every. If you choose Every, you can define the interval at which you want the job to run. Two additional fields appear:

  • Frequency Length. Enter the interval you want to have pass between job executions. For example, if you want the job to run every week, enter 1 here and enter Week in the Unit field below. A list of values is available; press F9.

  • Unit. From the list select one of the following: Hour(s), Day(s), Week(s), or Month(s). A list of values is available; press F9.

• Clock. From the list, select one of the following: Midnight, Noon, Now. Enter the time of day you want the job to run.

• Date. From the list, select one of the following: Today, Tomorrow, Monday…Sunday.

• Report Server Name. The system displays the name of the report server that last ran the report. You can use the same one or enter a different one. If you are running the report or other job for the first time, you may need to click in the line below to make the other parameters appear.

You must then select Job, then choose Submit or click the Submit icon.