OAC OSFM and a Manufacturing Execution System Compatible

OAC OSFM and a Manufacturing Execution System: Compatible Partners Training Day January 17, 2007

Objectives § § Outline the mechanics of PI’s interface project Communicate the challenges encountered Discuss the solution components employed Share some tips and pitfalls Nor. Cal OAUG Training Day 2 Date: January 17, 2007

Agenda § § § § Introduction - Power Integrations Background on the Project Overview of PI Supply Chain Overview of OSFM Integration Challenges and Considerations Interface Components Lessons Learned Questions and Answers Nor. Cal OAUG Training Day 3 Date: January 17, 2007

Power Integrations Innovation in Power Conversion § Fabless Semiconductor Manufacturer § Headquartered in San Jose § Founded in 1988 § Leading supplier of high-voltage analog integrated circuits (ICs) used in power conversion. – Enable compact, lightweight power supplies that are simpler to design and manufacture, more reliable, and more energy-efficient than those made with competing technologies. – Power a vast range of consumer and industrial electronics— computers, DVD players, TV set-top boxes, cell phone chargers, home appliances, telecom networking equipment, and many others. Nor. Cal OAUG Training Day 4 Date: January 17, 2007

Project Background – Business Considerations Issues: § Camstar MESA used for tracking production only § WIP/Inv Cost – done on massive spreadsheets § Extraordinarily long and painful month end close Solution: § Implement OSFM & Inventory to manage WIP valuation – In process Sort, Assembly, Test, Tape & Reel, etc – Wafer Bank, Die Bank, Untested, etc Nor. Cal OAUG Training Day 5 Date: January 17, 2007

Project Background - Timetable Upgrade to 11. 5. 10 from 11. 0. 3 • Order Management • Inventory • Purchasing • Financials (GL/AP/AR/CM/FA) • Human Resources Develop interface engine (e. Fabless) Install interface engine, develop and test interfaces • Receiving • Inventory • OSFM Replace Spreadsheet Cost Accounting with OSFM 2006 Nor. Cal OAUG Training Day 2007 6 Date: January 17, 2007

Overview – Supply Chain Nor. Cal OAUG Training Day 7 Date: January 17, 2007

OSFM Integration Nor. Cal OAUG Training Day 8 Date: January 17, 2007

Challenges and Considerations § MESA uses single item number for multiple operations: – Wafer number for Wafer Bank, Sort, and Die Bank – FG number for Assembly, Test, and Finished Goods § Multiple Organizations with changes in inventory asset ownership § Not every transaction in MESA is necessary for Cost Accounting § Must avoid prematurely processing a “downstream” transaction for a given lot before “upstream” transaction is successfully played Nor. Cal OAUG Training Day 9 Date: January 17, 2007

Components – Getting Started - Tables d fie nti de i e r tio c sa n ra ht e nw c s ry sa s ce le b a t ea r fo ne e h T Nor. Cal OAUG Training Day 10 Date: January 17, 2007

Components – Getting Started - Columns m xa re d. fo e nn ndix a l s p ppe a w e. A e l e ab h (s t ch eac a e r or d fo f n ate m u ol e cre c ed wer r i u eq rules r ery less v • E ab • e. F Nor. Cal OAUG Training Day 11 s) e l p Date: January 17, 2007

Components – Simplified Overview Nor. Cal OAUG Training Day 12 Date: January 17, 2007

Components – Example of Transactions Nor. Cal OAUG Training Day 13 Date: January 17, 2007

Components – Example of Transactions Nor. Cal OAUG Training Day 14 Date: January 17, 2007

Lessons Learned § API user guides are not always clear for example… – Initially used rcv_lots_interface for Receiving Deliver – Learned via TAR should be mtl_transaction_lots_interface § TRM Column descriptions are not always clear for example… – Column Name = PRODUCT_CODE – TRM description = Stores the product name to identify the source transaction for the record – Mandatory = No – Discovered it is required for Receiving Delivery (RCV) Nor. Cal OAUG Training Day 15 Date: January 17, 2007

Lessons Learned § Error messages are not always accurate for example… – RCV_TP_ACCT_PERIOD_CLOSED error caused by values unrelated to accounting periods. – Transactions set to ERROR status with no error message § Mapping the right rules and data values took longer than expected. § Need to be on the latest patchset § Recognize the need to properly staff for on-going monitoring of the transactions Nor. Cal OAUG Training Day 16 Date: January 17, 2007

Questions and Answers Presenter Contact Information Clark Stockard (408) 414 -8879 clark. stockard@powerint. com Travis Cox (925) 786 -1230 travis. cox@oacsi. com Nor. Cal OAUG Training Day 17 Date: January 17, 2007

Appendix – Example of e. Fabless Rule Nor. Cal OAUG Training Day 18 Date: January 17, 2007

Appendix – Example of e. Fabless Rule Nor. Cal OAUG Training Day 19 Date: January 17, 2007

Appendix – Example of e. Fabless Rule Nor. Cal OAUG Training Day 20 Date: January 17, 2007

Appendix – Example of e. Fabless Rule Nor. Cal OAUG Training Day 21 Date: January 17, 2007

Appendix – Example of e. Fabless Rule Nor. Cal OAUG Training Day 22 Date: January 17, 2007