220 likes | 415 Views
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. Agenda.
E N D
OSFM and aManufacturing 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
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
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.
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
Upgrade to 11.5.10 from 11.0.3 Project Background - Timetable • Order Management • Inventory • Purchasing • Financials (GL/AP/AR/CM/FA) • Human Resources Develop interface engine (eFabless) Install interface engine, develop and test interfaces Replace Spreadsheet Cost Accounting with OSFM • Receiving • Inventory • OSFM 2006 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
Components – Getting Started - Tables The necessary tables for each transaction were identified
Components – Getting Started - Columns • Every required column for each table was planned. • eFabless rules were created for each (see Appendix for examples)
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)
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
Questions and Answers Presenter Contact Information Clark Stockard (408) 414-8879 clark.stockard@powerint.com Travis Cox (925) 786-1230 travis.cox@oacsi.com