Why Upgrade to Release 12 WIIFM Cost and

Why Upgrade to Release 12? WIIFM? Cost and Related Improvements Douglas Volz Consulting doug@volzconsulting. com Sharon Widmer Independent Consulting s_widmer@comcast. net

Agenda p R 12 Cost Related Features § § § § § MOAC – Multi-Org Access Control Subledger Accounting Re-Designed A/P Accruals COGS Recognition Cost-Related BOM Features Period Close Drilldown As-of Dates for Inventory Valuation Reconciliation Challenges Cost Rollup Changes Slide 2

R 12 Multi-Org Access Control p Mostly affects “operating unit” level functions p Allows you to access information across multiple operating units without changing responsibilities p Set up a security profile listing the operating units to access p Run Security List Maintenance concurrent program p Assign the security profile using the MO: Security Profile Slide 3

R 12 Multi-Org Access Control Slide 4

SLA: Primary and Secondary Ledgers p Primary and Secondary Ledgers § In Release 12 Subledger Accounting replaced Global AX § Primary to secondary ledger mapping is much better Slide 5

Oracle Discrete Costing SLA enhancements: Flexible variance account recognition for: § Invoice price and purchase variances § Average cost adjustment § Standard cost adjustment § Manufacturing variances § Account aliases § Freight charges § Most other inventory, manufacturing and related account entries Slide 6

SLA Setup and Process Overview JOURNAL ENTRY SETUPS PROCESS Enter Transaction(s) Define/copy and modify account derivation rules Cost Manager Define/copy and modify journal line types Create Accounting* Define/copy and modify descriptions Transfer Journal Entries to GL *Run ‘Create Accounting – Cost Management’ concurrent request for accounting all transactions from the Cost Management – SLA responsibility. Receiving Accounting can be generated in the Purchasing responsibilities using the ‘Create Accounting – Receiving’ concurrent request. These requests have an option to transfer the entries created to General Ledger. A separate process is also available. Slide 7

Subledger Accounting p SLA for product line accounting, variance recognition Accounting Configurations Subledger Journal Entries Transactions GL Journal Entries and Balances Accounting Program Subledger Balances Accounting Events Journal Entry Setup SLA Cost Management Slide 8

Subledger Accounting p SLA Basic Architecture Enter Transaction(s) Cost Manager One Common Accounting Subledger Table Same Cost Transaction Accounting Tables Create Accounting SLA Accounting Tables G/L Tables XLA_EVENTS Transaction Accounting Tables GL_LEDGERS XLA_AE_HEADERS GL_ INTERFACE GL_JE_BATCHES XLA_AE_LINES GL_JE_HEADERS XLA_DISTRIBUTION _LINKS GL_JE_LINES Slide 9

Subledger Accounting and Inquiries Tools menu options (View Accounting and View Accounting Events) launch SLA UI pages (HTML) which display the information regarding the accounting event with the transaction and its corresponding accounting Clicking on distributions button shows the default accounting from MTL_TRANSACTION_ACCOUNTS Slide 10

Subledger Accounting and Inquiries - View Accounting details for the Miscellaneous receipt transaction in the SLA UI (launched from the Tools menu) Accounting is created for all ledgers associated with the primary ledger (Vision Operations (USA)) Slide 11

COGS Recognition p In R 12 all customer shipment entries go to deferred COGS p Revenue and COGS are explicitly matched • AR: “Autoinvoice” & “Revenue Recognition Master Program” • CST: “Inventory Cost Processor” or “Record Order Management” • CST: “Collect Revenue Recognition Information” • CST: Then “Generate COGS Recognition Events” p New Accounting Entries to clear deferred COGS p Use the COGS Revenue and COGS Matching Report Slide 12

COGS Recognition – Accounting Entries p New Accounting Entries to clear deferred COGS Inventory 1. Customer Shipment 10 Deferred COGS 10 10 2. COGS Recognition p Use the COGS Revenue and COGS Matching Report Slide 13 “True” COGS 10

New Deferred COGS Account Slide 14

COGS Recognition (Continued) p Dependencies • This new feature introduces a dependency in the Receivables and Costing period close processes • Costing will process COGS recognition events in a closed inventory period until the Receivables period status is set to CLOSED • You have to run Create Accounting after you have closed your inventory orgs Having to remember to run COGS Recognition Processes followed by Create Accounting may create confusion at month-end Slide 15

Related BOM Features p Fixed Component Usage Support: Support for lot-based materials that have a fixed usage regardless of the job size for discrete WIP jobs, OSFM lot-based jobs and Flow Manufacturing p Component Yield Support: Flexibility to control the value of component yield factors at WIP job level. The transaction logic now considers pre-yield BOM quantity per assembly rather than the quantity inflated by shrinkage. Slide 16

Period Close Diagnostics p Forms Drilldown • Using the same Inventory Accounting Periods form you can drilldown to associated forms to view the problem transactions p New workflow to notify of failing transactions p Period Close Pending Transactions Report • Report for the transactions holding up the inventory accounting period Slide 17

A/P Accruals p Perpetual A/P Accruals are Completely Rewritten • Monthly load into summary tables • Excellent detail and summary reporting (same report/different templates) • A/P Accrual write-offs go to your G/L • Works right out of the box! p Period End Accruals: • Calculate Accrual Balances at PO Distribution Level • Period-end accrual entries stored in a separate accounting table and automatically reversed in the new month • Uninvoiced Receipts Report and Period-End Accruals use same underlying code / same results Slide 18

Reconciliation Improvements in R 12 Inventory Reconciliation § Inventory Value Reports have an “as of date” • • Inventory Value Report Receiving Value Report Intransit Value Report All Inventories Value Report Slide 19

Reconciliation Challenges in R 12 Subledger Accounting and Inventory Reconciliation § Which accounts represent inventory and WIP valuation? Release 12 dropped the valuation accounts on most inventory reports § Dropped Reports (use: R 12 Open Account Balance Listing and Account Analysis report ) • Receiving Value by Destination Account Report • Subinventory Account Value Report • and the Cost Group Account Value Report have been dropped Slide 20

Reconciliation Challenges in R 12 (Continued): Material and WIP Distribution Inquiries and Reports § Release 12 Mat’l and WIP distribution inquiries & reports do not reflect the SLA results § SLA Journal Reports do not show operational information § Release 12 records the Material accounting and WIP accounting entries by cost element – rendering the old 11 i inquiries and reports more difficult to use, especially for Standard Costing. Release 12 forces Standard Costing to record WIP & Material entries by Cost Element / you can summarize in SLA but you don’t have the same detail reporting in SLA Slide 21

Basic Table Structure for SLA Enter Transaction(s) Accounting Processor Module Specific Transaction Accounting Tables One Common Accounting Subledger Table Receiving Material WIP Create Accounting SLA Accounting Tables G/L Tables XLA_EVENTS Transaction Accounting Tables GL_LEDGERS XLA_AE_HEADERS GL_ INTERFACE GL_JE_BATCHES XLA_AE_LINES GL_JE_HEADERS XLA_DISTRIBUTION _LINKS GL_JE_LINES Slide 22

Cost Rollup Changes § The Supply Chain Cost Rollup and Cost Rollup have been combined Slide 23

Cost Rollup Changes Slide 24

Summary § Subledger Accounting solves many account classification issues § Yet Subledger Accounting causes additional reconciliation headaches • Yet one more interface and batch job • More levels of indirection: multiple accounting tables • Which accounting table to tell your auditors and how to explain to them it is different? • Must run Cost Management Subledger Period Close Exceptions Report (by ledger –but you can use Ledger Sets) Slide 25

Summary (continued) § COGS Recognition works well, just have to get used to entries hitting after you close the inventory accounting periods § New period close diagnostics § Inventory reconciliation issues are improved and also hindered in Release 12 • • Inventory value reports have as “as of date” But most inventory value reports have no valuation accounts Still only single warehouse Period Close Reconciliation Report not multi-org (consider custom reports from the period close snapshot table cst_period_close_summary) Slide 26

Acknowledgements § Oracle Cost Development § Partners in crime at our clients Slide 27

Sharon Widmer (s_widmer@comcast. net) Professional Background. With over 25 years total work experience, Sharon Widmer is an accomplished Oracle Functional Consultant and Accounting Manager, specializing in manufacturing and distribution companies. She has 14 years experience implementing Oracle Applications, and over 10 years in Accounting for Manufacturing and Distribution companies. Sharon has helped clients with Oracle implementations (Release 11. 0. 3 through Release 12. 1) and process reengineering for Inventory Control and Accounting. Industries she has worked in include High Tech, Building Construction & Industrial Products, Telecommunications, and Life Sciences. In a recent consulting role Sharon helped a Chip Test Equipment manufacturer and their Cost Management team get to the next level. As a SME for Inventory Control and Cost Accounting, she helped them achieve significant process redesign and Oracle configuration changes, which resulted in more accurate Inventory Control and a streamlined, faster Cost Month End Close. Core Expertise Experience p p Clients Served: Ø Form Factor Ø Stryker Endoscopy Ø Qualcomm Ø USG Ø Toshiba America Business Systems Ø Amkor Technology Ø JDS Uniphase Data Conversion – Data Cleansing Standard Costing Manufacturing Processes Ø Cost Management Ø Inventory Ø Warehouse Management Ø WIP Ø Bills of Material Slide 28

Douglas Volz (doug@volzconsulting. com) Professional Background Doug Volz is a Senior Architect and Advisor for Oracle Application projects, with a particular interest in Project and Cost Management. He has 30 years accumulated experience, including 5 years in Oracle Development (co-designing Oracle Cost Management) and 12 years in industry in Cost and Accounting Management positions. His Manufacturing and Cost systems experience covers project management, software design/development, delivery and consulting services, for both Oracle Corporation, and multiple international consulting firms. Prior to his systems career, Mr. Volz also held numerous management accounting positions for telecommunications, defense, and electronics companies. In his consulting roles, Doug has served over 100 clients. Many of these were multi-org, multi-currency with global footprints. Countries include US, Mexico, UK, Netherlands, Belgium, Taiwan, P. R. O. C. , Norway, Japan, Italy and Germany. Doug leads the Cost Sub-Committee, for the OAUG Discrete Manufacturing Special Interest Group. He also advises and participates on the Oracle Customer Advisory Board for Fusion Costing. Core Expertise Experience p Multi-organization, Multi-currency ERP Implementations p Project Management and Senior Project Advisor p Core manufacturing processes 4 Cost Management 4 Inventory 4 Bills of Material 4 WIP p Systems Integration and Data Conversions p Sample of clients served: Ø Beckman Coulter (US) Ø Matsushita (UK, Mexico) Ø NTL (now Virgin Media) Ø Logitech (US, Taiwan, P. R. C. ) Ø Matsushita (UK, Mexico) Ø NTL (now Virgin Media) Ø TCI International (US) Ø Onninen AS (Norway) Slide 29

Thanks for allowing us to discuss these topics with you! Slide 30