Reporting

Reporting Overview

Reports on Corrective Action information can be created using the following tools:

• Quality Results Report Writer - Generate reports on a single collection plan (Corrective Action Request or Corrective Action Implementation)

• Oracle Discoverer - Generate reports that analyze data across multiple plans and providing an enterprise view of corrective action requests across multiple organizations.

Quality Results Report Writer

The Oracle Quality Results Report Writer is used to build simple reports on Audits, based on a single collection plan. Following is a list of some of the reports that can be generated:

• All Audits that are open and its summary details

• All audits and its results during a specific period

• Audit findings of a particular audit

• All nonconformances /major findings of an Audit

• Audit Questions from a particular Quality Standard

Oracle Discoverer

Oracle Discoverer enables you to analyze Audits throughout your enterprise. Data from application schema is organized into Folders within Discoverer. The following are steps to build folders for audits:

The following are the steps to build folders for audit analysis:

1. Open business area, Quality Data Collection Analysis, using the Admin edition of Discoverer.

2. Create Folders in this area from the following views:

   • Q_<AUDIT MASTER PLAN>_V

     Note: <AUDIT MASTER PLAN> refers to the name of your collection plan with spaces replaced by an underscore. the views are created dynamically when the collection plan is created or updated. The columns in the view correspond with the collection elements within the collection plan.

   • Q_<AUDIT MASTER HISTORY PLAN>_V

   • Q_<AUDIT FINDINGS PLAN>_V

   • Q_<AUDIT FINDINGS HISTORY PLAN>_V

   • Q_<AUDITS QUESTION AND RESPONSE PLAN>_V

   • Q_<AUDITS QUESTION AND RESPONSE HISTORY PLAN>_V

3. Create Joins for these folders:

   • One to Many

     • Q_<AUDIT MASTER PLAN>_V.AUDIT_NUMBER

   • One to Many

     • Q_<AUDIT MASTER PLAN>_V.AUDIT_NUMBER>_ Q_<AUDIT MASTER HISTORY>_V.AUDIT_NUMBER

You can perform cross-plan analysis using Oracle Discoverer User Edition. For example, reporting all Defects and Causes by Supplier and time period.

See Also Oracle Discoverer User's Guide