Oracle Quality Implementation Guide

Contents

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