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.
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 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:
Open business area, Quality Data Collection Analysis, using the Admin edition of Discoverer.
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
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