Oracle Quality: Defect Tracking and Vendor Return Process

1. Oracle Quality: Defect Tracking and Vendor Return Process NorCalOAUG Presented by: Rahul Sharma Kishore Bodhireddy www.ubex.com

2. Agenda • Introduction • Process Overview • Business Case • Scenario • Issues • Solution Overview • Defect Tracking • Vendor Returns • Costs/Benefits of Implementation • Conclusions

3. Ubex Corporation • Premier provider of end-to-end business solutions • 8+ years in high-tech vertical • Exclusive focus on Oracle Applications • Oracle Partner • Founded by Oracle Alumnus • Service Offerings • Implementation • Upgrade • Customizations • Maintenance • Integration • Support

4. Introduction to Oracle Quality Oracle Quality is an integrated quality management application designed to help manufacturers in their quest for zero defect. Helps achieve: • Establish quality standards for products and processes across the enterprise • Ensure product tests are performed at the right time and document all test results. • Collect information about product defects, their causes and their related dispositions • Alert appropriate personnel when products do not conform to required standards • Provides flexible reporting on all aspects of quality management • Terminologies: • Collection elements, specifications, collection plans, actions and alerts, data collection options

5. Introduction (contd.) • Client • A high-tech manufacturer, ISO 9000 certified • Business Issue • Error-prone and cumbersome defect tracking system • Disconnected and manual processes • Solution • Oracle Quality, part of Oracle Manufacturing suite

6. Process Overview

7. Scenario • Disparate Systems • Custom application for defect creation • Transactions in Oracle Applications • Shipping authorization in a third application • Batch programs to synchronize data • Disconnected and manual processes

8. Issues • Process Issues • Slow defect creation to corrective action cycle • Due to waiting times • Long wait time for work orders • Lower customer satisfaction • Parts rejected in receiving without defect creation • Multiple disposition not supported by the system • Data Issues • Missing information for defect creation • Part #, Work order #, PO #, Defect # • Data invariably out-of-sync • Duplicate data entry • Error in debit amounts • Incorrect information on shipments

9. Issues (contd.) • Security Issues • Inability to restrict field level access • Anyone with access to receiving could access PO inspection • User Interface Issues • Not very user friendly or intuitive • Inflexible list of values • Lack of up-to-date help documentation

10. Solution Options

11. Solution Overview Shipping Plans Shipping Plans Inspection Plan DMR Plan DMR Plan DMR MRB Plan MRB Plan MRB MRB Plan MRB Plan

12. Processes Supported • Receiving Inspection: Acceptance / rejection process for parts delivered by supplier. • Assembly defect tracking: Defect tracking process on the manufacturing shop floor. • Test Inspection: Defect tracking process during system testing. • Stock Inspection: Defect tracking process for parts in stock. • Disposition process • Corrective Action process • Vendor Returns: Shipping and Accounting

13. Collection Plan Overview

14. Features of Implementation • Process • Creation of DMR enforced on rejection of parts in receiving • DMR creation done by 4 different groups • DMRs dispositioned by one group • Consolidated non-conformances for disposition through parent-child plans • Enabled creation of multiple dispositions • Enforced validations on disposition and nonconformance quantities • Corrective Action and disposition handled by same plan • Integrated shipping and accounting process for RTV items • Supported domestic and international shipments • Debit memo creation automated in Oracle Inventory

15. Features of Implementation (contd.) • Data • Restricted LOV used to enforce data integrity • Automated data entry for shipping and accounting • Security • Access to collection plans restricted to select groups • Field level security enforced through setups • Unauthorized access to receiving inspection eliminated • Others • Collection plans created from existing templates (available in 11.5.9) • Template PO Inspection Plan • Template WIP Component Segregation • Defined fields as mandatory or non-mandatory • Defined fields as conditionally mandatory • Displayed fields made non-editable

16. Benefits of Implementation • Completely integrated defect tracking and vendor return processes • Real time information available • Faster defect creation to corrective action cycle • Eliminated duplicate data entry • Reduced manual debit memo creation by 50% • Minimized data entry error • Vendor debit amounts • More in sync data

17. Costs of Implementation • Infrastructure • No additional hardware and instance • Licensing • No additional licensing required for manufacturing users • Implementation • Implementation time nearly 25% below estimated • Training • Minimal

18. Conclusions • Attractive ROI • Improved productivity • Implementing Oracle Quality makes good business sense

19. Q & A For more information: www.ubex.com