Mirror of Oracle documentation

Converted for search and offline reading. Authoritative source: Oracle. Diagrams and some complex tables are simplified — check the PDF when in doubt.

4 BI Publisher Reports

This chapter describes the steps to view the Merchandising Business Intelligence (BI) Publisher reports by accessing Reports from the task bar in Merchandising.

1. Depending on the report, you can use prompts to select report parameters.

  • Some prompts allow you to filter the report contents and limit the information in the report. For example, you can filter on department or item to filter the content of the Stock Order Pick List report.

  • Some reports require a parameter, such as a letter of credit ID.

  • Some reports require no parameters, and no prompts are displayed.

  • Select values as needed from the list for the prompts displayed.

2. Select the report output you may want to view.

  • HTML (default, Web page format)

  • PDF (Adobe Acrobat Portable Document Format)

  • RTF (Rich Text Format, used by Microsoft Word and other programs)

  • Excel (Microsoft Excel format)

  • PowerPoint (Microsoft PowerPoint format)

  • CSV (comma-separated values file)

  • Data (XML)

3. Click View . The report is displayed in Oracle BI Publisher.

  • (If you select another output format, you have the option to save the report. You can also open the report with another program, such as Microsoft Excel).

4. Close the browser window when you have finished viewing, printing, or saving the report.

Daily Purge Report

A regularly scheduled batch program deletes records that you have marked for deletion for certain entities in Merchandising, such as items. These entities typically have a large number of dependencies and therefore require more extensive validation to determine if they can be deleted. Some records may not be able to be deleted based on these dependencies and issues found when deleting records are displayed in this report, based on the DAILY_PURGE_ERROR_LOG.

To view the daily purge report, from the task bar, select Reports > Daily Purge . The Daily Purge Report appears.

1. From the Tasks menu, select Reports > Daily Purge . The Daily Purge Report window appears.

4-1


In this guide