Cypress Semiconductor Cypress Semiconductor Corporation designs develops manufactures

Cypress Semiconductor • Cypress Semiconductor Corporation designs, develops, manufactures and markets a broad line of high -performance digital and mixed-signal integrated circuits for a range of markets, including data communications, telecommunications, computing, consumer and instrumentation systems. Peg Pongpairoj, Sr. Business Systems Analyst supporting global procurement • 1/29/2022 1

Oracle Products • Current Oracle Products/Release versions • Applications R 11. 5. 7 (U. S. sites) PO, Inv, i. Procurement, AP, GL, FA, AR, Projects, i. Expenses • Procurement, Inventory, i. Procurement are on Family Pack version G; • AP-Minipack G, AR Minipack H; GL-Minipack F, FA Minipack I • Noetix View is for Oracle 11. 5. 7 not 11. 0. 3 • Applications R 11. 0. 3 (Philippines) • PO, Inv, BOM, MRP, AP, GL, FA • Recent upgrade 11. 5. 9 upgrade Family Pack I in Q 1 2004 1/29/2022 2

Purchasing Reports • Standard reports include: • Spend • Cost Savings • Cycle time • PO Activity/Volume • Open Pos • Reports are posted on the department’s intranet and sent directly to distribution lists • Adhoc reports both for purchasing staff and internal customers 1/29/2022 3

Reporting products & infrastructure • Noetix View - Noetix. Views transforms Oracle Applications data into business information. It organizes Oracle data in folders or views that are readily usable and easily accessible to users. Noetix View provides the basis from which Noetix Web query and Brio pull live data. • Noetix Web Query • Brio 1/29/2022 4

Reporting tools • Currently approx. 90% of departmental reports are created via Brio and Noetix. • For reporting and data dissemination, three tools are used: 1. Brio - Complex, multi-dimensional queries; used mainly to build most standard reports 2. Noetix - simple queries, used mainly to build adhoc reports 3. Excel - all queries/data are posted in excel. 1/29/2022 5

Brio 6. 0 • Data extracting/query tool, third party-product • Connects directly to production database • Used for 90% of weekly, monthly and quarterly reports • Complex, multi-dimensional queries; used mainly to build most standard reports • Security and setup done by IT • Available both for Oracle 11 i and 11. 0. 3 (all Cypress sites) • Users - 4 BSAs, one buyer 1/29/2022 6

Brio Pros & Cons Pros - allows complicated query with multiple tables - good processing time against live database - user setup is easy - does not require SQL Cons - not a user friendly tool - requires some data modeling background 1/29/2022 7

Brio • 1/29/2022 8

Brio • 1/29/2022 9

Noetix Web Query • Data extracting tool, third party-product • Connects directly to production database • Web-based tool • Used to create simple ad-hoc query • Data exportable to excel web query • Not available for 11. 0. 3 (CML site) • Users - 3 BSAs, finance group 1/29/2022 10

Noetix Web Query. Pros & Cons Pros - good performance against live database - does not require data modeling background - all reports convertible to Excel web query Cons - 1/29/2022 More user friendly Does not allow multiple-table query 11

Noetix • 1/29/2022 12

Noetix • 1/29/2022 13

Noetix • 1/29/2022 14

Excel • Primary data reporting/dissemination tools • Widely used/accepted by users • 100% of Brio/Noetix queries converted to Excel 1/29/2022 15

Next steps • Automate report generating through scheduling • Noetix/web query training for end users 1/29/2022 16