Browser version script Skip Headers

Oracle Quality Implementation Guide
Release 12.1
Part Number E13679-04
Go to next page
Next

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