Oracle Quality Implementation Guide

Skip Headers

Title and Copyright Information

Send Us Your Comments

Preface

Nonconformance and Disposition Solution

Overview of the Nonconformance and Dispositions Solution

Nonconformance and Dispositions Solution

Solution Templates

Implementation Considerations

Implementing Nonconformance and Disposition Solution

Implementation Roadmap

Implementation Checklist

Setting Up

Overview of Setting Up

Step 1 - Choose a configuration (mandatory)

Step 2 - Copy from Template Collection Plans (mandatory)

Step 3 - Update of Sequence prefix and suffix (mandatory)

Step 4 - Update of values for seeded collection elements (optional)

Step 5 - Update of menu entry to point to the correct plan (mandatory)

Step 6 - Modify Collection Plan Details and Plan Element Prompts (optional)

Step 7 - Update 'Execute a SQL script' Text (conditionally mandatory)

Step 8 - Set Up Collection Plan Security (optional)

Step 9 - Add user defined elements to the plans (optional)

Step 10 - Link user defined plans to the system (optional)

Step 11 - Link Corrective Action system to Nonconformance and Disposition system (optional)

Step 12 - Link the Transactional Collection Plan to the Nonconformance and Disposition system (optional)

Step 13 - De-link Collection Plans from the Nonconformance and Disposition system (optional)

Step 14 - Organize the Plan Elements into Folders (optional)

Step 15 - Set Up Profile Options (optional)

Step 16 - Setup within other modules (conditionally mandatory)

Considerations Prior to Implementation

Maintaining a Reference Copy of Collection Plans (optional)

Nonconformance Lifecycle

Overview of Procedures

Process Flow Chart

Process Steps

Logging Nonconformances using MSCA and Oracle Warehouse Management

Overview of Logging Nonconformances

Process Steps

Setting Up

Logging Nonconformances

Disposition Lifecycle

Overview of Disposition Lifecycle

Process Flow Chart

Process Steps

Reporting

Overview of Reporting

Quality Results Report Writer

Oracle Discoverer

Tailoring Your Solution

Overview of Tailoring Solutions

Workflow Configuration

Using Oracle Approval Management

Tailoring E-mail Notifications

Tips and Techniques

Corrective Action Solution

Overview of the Corrective Action Solution

Overview of Solution Templates

Solution Templates

Implementation Roadmap

Overview of Implementation Roadmap

Implementation Considerations

Prerequisites

Corrective Action Request Types

Corrective Action Request Sources

Captured Data

Valid Values

Corrective Action Identification

Corrective Action Data Privileges

Corrective Action Process

Implementation Checklist

Setting Up

Overview of Setting Up

Step 1 - Choose a configuration (mandatory)

Step 2 - Copy from template Collection Plans (mandatory)

Step 3 - Update of Sequence prefix and suffix (mandatory)

Step 4 - Update of values for seeded collection elements (optional)

Step 5 - Update of menu entry to point to the correct plan (mandatory)

Step 6 - Modify Collection Plan Details and Plan Element Prompts (optional)

Step 7 - Add user defined elements to the plans (optional)

Step 8 - Link user defined plans to the system (optional)

Step 9 - Organize the plan elements into folders (optional)

Step 10 - Set Up Profile Options (optional)

Step 11 - Setup within other modules (conditionally mandatory)

Step 12 - Set Up Collection Plan Security

Step 13 - Set Up Collection Element Security

Considerations Prior to Implementation

Implementation

Implementing Corrective Action Solutions

Processing Corrective Action from an Audit

Processing Corrective Action Generated from a Nonconformance

Processing Corrective Action for a Supplier

Processing Corrective Action from a Customer Complaint

Reporting

Generating Reports on Corrective Action Information

Quality Results Report Writer

Oracle Discoverer

Tailoring Your Solution

Overview of Tailoring Solutions

Workflow Configuration

Using Oracle Approval Management

Tailoring E-mail Notifications

Tips and Techniques

Field Security

Derive User Information using Assign-a-Value

Lookup Feature Using SQL Validation Strings

Dependent List of Values

Custom Reports

Audits Solution

Overview of Audits Solution

Audits Solution

Solution Templates

Implementation Considerations

Overview of Implementation Considerations

Prerequisites

Types of Audits

Audits Solution Implementation Tasks

Valid Values

Audits Identification

Audits Solution Data Privileges

Implementation Roadmap

Implementation Check List

Setting Up

Overview of Setting Up

Setup Prerequisites

Setting up Audits Solution

Set Up Steps

Implementation

Overview of Implementation

Process Steps

Audits Solution Process

Reporting

Reporting Overview

Tailoring Your Solution

Overview of Tailoring Your Solutions

Workflow Configuration

Tailoring E-mail Notifications

Tips and Techniques

Nonconformance and Disposition Seeded Template Collection Plan Structure

Overview of Seeded Plan Structure

Nonconformance and Disposition Seeded Template Collection Plan Details

Overview of Seeded Template Collection Plan Details

Template Supplier Nonconformance Record Plan

Template Nonconformance Master Plan

Template Maintenance Nonconformance Record Plan

Template Nonconformance Detail Plan

Template WIP Component Segregation

Template Inventory Segregation

Template Disposition Header Plan

Template Disposition Detail Plan

Template In-Process related Disposition Action and Result

Template Inventory related Disposition Action and Result

Sample Code

Sample PL/SQL Code for finding Approver using Oracle Workflow

Sample Code for Custom SQL*Plus Report

Stand-alone Collection Plan for Nonconformances Entered via Mobile Applications and Warehouse Management

Overview of Stand-alone Collection Plan

Collection Elements for Automated Disposition Action Processing

Overview of Collection Elements for Automated Disposition Action Processing

Nonconformance and Disposition Seeded Workflows Notifications

Seeded Workflow Notifications

Corrective Action Seeded Template Collection Plan Structure

Corrective Action Parent-Child Collection Plan Structure

Corrective Action Seeded Template Collection Plan Details

Overview of Corrective Action Seeded Template Plan Details

Template Corrective Action Request

Template Corrective Action Request Review

Template CAR Actions Implementation

Template ECO Submission

Template Supplier Corrective Action Response

Template Quality Service CAR

Corrective Action Sample Code

Sample Code for Custom SQL*Plus Report

Corrective Action Solution Seeded Workflow Notifications

Seeded Workflow Notifications

Audits Seeded Template Collection Plan Structure

Structure of Seeded Template Collection Plan

Audits Seeded Template Plan Details

Overview of Seeded Template Plans

Template Audit Master Plan

Template Audit Master History Plan

Template Audit Findings Plan

Template Audit Findings History Plan

Template Audit Question and Response Plan

Template Audit Question and Response History Plan

Template Audit Question Bank Plan

Audits Seeded Workflow Notifications

Seeded Workflow Notifications

Windows and Navigation Paths

Windows and Navigation Paths

Index

Oracle Quality Implementation Guide

Contents

Nonconformance and Disposition Solution

Corrective Action Solution

Audits Solution