6 View and Manage Pixel-Perfect Report History

This topic describes the job history features including republishing data from history, sending the job output to new destinations, and getting error information on report jobs that didn't complete successfully.

Topics:

View Report Job History and Saved Output

The Report Job History page displays information about running and completed report jobs.

You can access the Report Job History page and then search for the report job history. You can also access this page from the context of a specific report. Use one of the following to select Report Job History.

  • Browse/Manage in the Home page.

  • Open on the global header.

Use the Report Job History page to:

  • View the status and details of running and completed report jobs.

  • Identify the critical jobs.

  • Cancel a running job.

  • Monitor a running job.

  • View job submission details.

  • Download or view the XML data produced from the report, if you selected Save Data for the report.

  • Download or view the report document, if you selected Save output.

  • Republish the report data using other formats or templates, if you selected Save Data for the report.

  • Delete report jobs from history.

View Job History for a Specific Report

If you navigate to the Report Job History page from the context of a specific report, then the jobs for that report are automatically displayed with the default filters applied.

  1. Perform one of the following:

    • From the Catalog, navigate to the report, and click Job History.

    • From the Report Viewer, navigate to the report, and click Job History.

  2. In the Report Job History page, specify the filters if required and click Search.

    Following are the default filters:

    • Report Path - Equals the path to the report from which you launched the Report Jobs History page.

    • Start Processing - Equals to or later than one week ago.

    • Owner - Equals your user ID.

    • Scope - Equals All Histories. Includes Private Job Histories and Public Job Histories.

    • Status - Equals All. Includes all the possible values for status — Success, Failed, Running, Output has error, Canceled, Cancelling, Delivery has error, Update status has error, Deleted, Scheduled, Skipped, and Suspended.

Search for Report Job History

Specify the filter criteria for searching a report job history.

  1. Enter values for the Filter criteria to search for a specific job history or group of completed report jobs.
  2. Click Search. The jobs that meet the filter criteria are displayed in the Report Job Histories table.

    You can sort the table by a particular column by clicking the column heading and selecting the up arrow or down arrow for ascending or descending.

View Details of a Job History

Use the Report Job History page to view the details of a job history.

  1. In the Report Job History page, click the Report Job Name to view a detail page for the job.
  2. To view delivery information for each output, click the expand icon next to the output name.
  3. Click Return to return to the Report Job History page.

Download Data from a Report Job

You can view the details of a report job, download the XML data, and save the file to your preferred location.

You must enable the Save Data for Republishing option when you create the job to make the data available for republishing.

  1. In the Report Job History page, click the report job name in the Report Job Histories table to view the job detail page.
  2. In the Output & Delivery section, click the XML Data download button.
  3. When prompted, select the location to save the file.

Republish from History in Report Viewer

In Report Viewer, you can use your job history to republish data.

On successful completion of the jobs that save data for republishing, you can republish data using any of the supported output formats for the layout templates included in the report. You can apply a new layout, choose a different output format, or export the report. Because you're using the data retrieved from a previous report run, you can't update the parameters.

  1. Select the report in the BI catalog.
  2. Click Open to run the report in Report Viewer.
  3. On the Actions menu, click Republish from History.
  4. In the Open dialog, select the job name and specify the output format.
    In the Job Name drop-down list, you can view only ten jobs. To view all the jobs submitted by you in the Report Job History page, click View full history for this report.
  5. Click Okay.

Republish a Report from History

You can republish a report from history.

You must enable the Save Data for Republishing option when you create the job to make the data available for republishing.

  1. In the Report Job History page, click the Report Job Name to view the job detail page.
  2. From the Output & Delivery section, click Republish. This launches the Report Viewer.
  3. From the Report Viewer you can now apply a new layout, choose a different output type or export the report. Because you're using data the retrieved from the previous report run, you can't update the parameters.
  4. To return to the Report Job History page, click the Actions menu and select Return.

Send an Output to a New Destination

You can send the output of a report to a new destination.

You must enable the Save Output option when you create the job to make the output available in the history table. The send functionality doesn't create history or save the delivery status. It simply sends the output to the destination selected.
  1. In the Report Job History page, click the Report Job Name to view the job detail page.
  2. In the Output & Delivery section, locate the output that you want to send to a new destination, and click Send.
  3. In the Send dialog, do the following:
    1. Select the delivery type.
    2. Click Add Destination.
    3. Enter the appropriate fields for your delivery type.
  4. After you finish adding the destinations, click Submit.

Monitor Running Jobs

You can monitor the stages of the report processing when a job is in running status.

  1. In the Report Job History page, hover over the Running status indicator in the Report Job Histories table.
    The status displays with the instance ID of the cluster instance handling the processing.
  2. To check the latest status, refresh the page. The status doesn't automatically update while you're viewing the page.

Process Stages of Jobs

This topic lists the processing stages of a job.

Processing Stage Substages

Job Processor

Sending to Job Queue

In job queue

In job processor

Job processor completed

Job processor caused exception

Data Fetching

Fetching XML Data

XML Data Fetched

Before calling data model pre-trigger

After calling data model pre-trigger

Before calling data model post-trigger

After calling data model post-trigger

Fetching Bursting Control File (for bursting jobs only)

Fetching bursting control

XML Bursting control xml fetched

Data Processor

In data processor

Parsing control file (applies only to bursting jobs)

Control file parsed (applies only to bursting jobs)

Cutting data based on split key (applies only to bursting jobs)

Data cutting completed (applies only to bursting jobs)

Total sub-jobs (applies only to bursting jobs)

Data processor completed

Report Processor

Once the job reaches this stage, outputs can be viewed as they're completed by clicking the Report Job Name.

In report processor

Rendering report document

Report document rendering completed

Report processor completed

Error rendering report document

Delivery Processor

The valid values for <delivery> are email, fax, File, FTP, Print, WebDAV, or Document Cloud Services, depending on the destinations selected for the report.

In <delivery> processor

Delivering to <delivery> processor

Document delivered to <delivery> server

<Delivery> processor completed

Cancel a Running Job

You can cancel a running job.

  1. In the Report Job History page, click anywhere within the table row for the report job to select it (except the job name link).
    You can select multiple jobs by pressing Ctrl + Shift and clicking the additional rows. Deselect a row by clicking it again. You can only cancel a job that has the status, Running.
  2. Click the Cancel Running Jobs icon at the top of the table.
  3. Click OK in the confirmation message.

Get Error and Warning Information for Reports

If a report job fails or completes with warnings, you can view the error and warning information.

  • In the Report Job History page, hover over the error or warning status indicator in the results table

    The job details page also displays error and warning.

    For more complete diagnostic information on errors or warnings, you can view the diagnostic log files for the job in Oracle Fusion Middleware Control.

Delete a Job History

You can delete a job history.

  1. In the Report Job History page, click anywhere within the table row for the report job to select it (except the job name link).

    You can select multiple rows.

  2. Click the Delete icon at the top of the table.
  3. Click OK on the Confirmation dialog.