Oracle Cost Management Features and Workarounds OAUG Cost

Oracle Cost Management Features and Workarounds OAUG Cost SIG Meeting February 15, 2011 Douglas Volz Consulting doug@volzconsulting. com Slide

Agenda § Welcome to Our Session! § 2011 Schedule - to December 2011 § Introduce the OAUG Cost SIG Website • • Home page Membership Minutes Other stuff § Costing Little Known Features and Workarounds Slide 2

OAUG Cost SIG Schedule to December 2011 § March 15, 2011 – A/P Accruals for R 12 § April 19, 2011 – Different ways to use cost elements, sub-elements, cost allocation methods § May 17, 2011 - Tracing a sale of inventory through Oracle to see the cost and A/R and sales side, what processes have to be run to do costing, create accounting, COGS recognition, etc. § June 21, 2011 – Receiving as it relates to Inventory (& maybe WIP too …) § July - August 2011 – Summer Break § September 20, 2011 – To be determined § October 18, 2011 - Segregation of Duties, goals, purpose, how to work with the SOD people § November 15, 2011 - Standard vs. average vs. layer costing / periodic costing § December 2011 – Holiday Break Slide 3

OAUG Cost SIG Web Pages – Home Page (http: //costmgmt. oaug. org/) Slide 4

OAUG Cost SIG Web Pages – previous events Slide 5

OAUG Cost SIG Web Pages – resources Slide 6

OAUG Cost SIG Web Pages – membership (http: //costmgmt. oaug. org/Membership. php? page=Membership) Slide 7

OAUG Cost SIG Web Pages – board, bylaws, about Slide 8

OAUG Cost SIG Web Pages – Minutes (http: //www. volzconsulting. com/oaugcostsig. html) Slide 9

Tips and Tricks Introduction – Do You Ever Feel Like This? Slide 10

Introduction p This presentation is for both Release 11 i & 12 p The objective is to find out about better ways to use Oracle Cost Management for your everyday work p Get suggestions on standard features you may not be using Slide 11

Agenda p Get suggestions on features or setup changes that may help you: § Cost cut-off date § Cost type setup § Currency formatting / extended decimal precision § Custom mass edits § Data verification audits § Defaults for job close and standard cost update § Item cost mass load tools § Printing for standard text reports § Quantity decimal formatting on cost reports § Material overhead defaults § Material overhead absorption rules § Transaction Value Historical Summary Report Slide 12

Cost Cut-Off Date Slide 13

Cost Cut-Off Date § The Inventory & WIP Cost Processors will not cost transactions as of the cost cut-off date § Typically used at month-end and year-end • Helps with overlapping inventory accounting periods § Use it with your annual cost rollup and standard cost revaluation (standard costing) § Use it to stop costing to allow you to enter your new year Avg. Rates cost type information (average costing) Slide 14

Cost Type Controls § Multi-Org § Allow Updates § Snapshot Bills § Previous Level Rollup Options Slide 15

Cost Type Controls – Alternate BOMs for Costing Slide 16

Currency Controls & Decimal Formatting Slide 17

Custom Mass Edits § What do you do if you want something different? Slide 18

Custom Mass Edits – CST_MASS_EDITS § Oracle Cost Management has an open architecture so you can create your own custom mass edits § Common ones include: • • Last PO Price Multi-org A/P average Changing material overheads across multiple inventory orgs Really, anything multi-org … § Mass edits are stored procedures, registered in CST_MASS_EDITS • MASS_EDIT_ID • MASS_EDIT_NAME • DESCRIPTION • USER_DEFINED • CONCURRENT_PROGRAM • PROCEDURE_NAME • INVENTORY_FLAG • DISABLE_DATE Slide 19

Data verification audits p For BOM, Engineering & MRP Slide 20

Data verification audits p Use to find invalid information, BOM Audit examples: § § § Costed items not assigned to the costing category set Costed items with no frozen costs Bills that are buy items Bills with no components Components with zero usage quantity Slide 21

Defaults for Job Close - Form p No defaults for job status form / can close your shop floor down Slide 22

Defaults for Job Close – SRS Launch p Latest Release 12 SRS Launch does has a default status (but defaults to “Exclude Jobs with Pending Trans: No”) Slide 23

Defaults for Job Close SRS – How to Change p Change your defaults in the Concurrent Program Definition (Sysadmin or Application Developer resp. ) Slide 24

Defaults for Standard Cost Update p Defaults to All Items – you may wish to change this Slide 25

Item Cost Mass Load Tools p What you really want to do is: § Download your item costs into Excel § Upload new costs into a pending cost type from Excel p Choices? § Dataloader § Customizations (self-build) § Commercial products • More 4 Apps – Item Cost Wizard, Transactions Wizard (Avg Cost Update) • Chain. Sys – app. Load suite of tools Slide 26

Printing/Reporting Good News for Latest R 12 Versions (XML Reports) p Latest Release 12 has XML reports, lots and lots of them p But not where you expect them Slide 27

Good News for Latest R 12 Versions (XML Reports) p Latest Release 12 has XML reports, lots and lots of them (But not where you expect them) Slide 28

In the Meantime - How do You Print Off the Text-Based Reports? p Per Meta. Link ID 297522. 1, in the Oracle EBS Applications, the seed data provided for the print style definition is for a DEC LN 03 printer p For some reason the Sysadmins and implementation partners don’t seem to “get it” p Common problems: § Poor pagination § Wrapped lines § Unusable output Slide 29

In the Meantime - How do You Print Off the Text-Based Reports? p Macro for MS Word (thanks for Ashley Herrott, Celgene Corporation, for sharing) Slide 30

In the Meantime - How do You Print Off the Text-Based Reports? p Paste the following into your new MS Word Macro Sub Oracle() ' ' Oracle Macro ' Macro recorded 3/1/2006 by Zak ' Selection. Whole. Story With Active. Document. Page. Setup. Line. Numbering. Active = False. Orientation = wd. Orient. Landscape. Top. Margin = Inches. To. Points(0. 5). Bottom. Margin = Inches. To. Points(0. 5). Left. Margin = Inches. To. Points(0. 5). Right. Margin = Inches. To. Points(0. 5). Gutter = Inches. To. Points(0). Header. Distance = Inches. To. Points(0. 5). Footer. Distance = Inches. To. Points(0. 5). Page. Width = Inches. To. Points(11). Page. Height = Inches. To. Points(8. 5). First. Page. Tray = wd. Printer. Default. Bin. Other. Pages. Tray = wd. Printer. Default. Bin. Section. Start = wd. Section. New. Page. Odd. And. Even. Pages. Header. Footer = False. Different. First. Page. Header. Footer = False. Vertical. Alignment = wd. Align. Vertical. Top. Suppress. Endnotes = False. Mirror. Margins = False. Two. Pages. One = False. Gutter. Pos = wd. Gutter. Pos. Left End With Selection. Font. Name = "Courier New" Selection. Font. Size = 6. 5 End Sub Slide 31

In the Meantime - How do You Print Off the Text-Based Reports? p Save to your template and customize your menu: Slide 32

In the Meantime - How do You Print Off the Text-Based Reports? p Now save as a command: p And drag to your favorite toolbar: (You can even assign an icon to your new command): Slide 33

What About Decimal Precision for Quantities? § There is a common profile which affects all inventory, BOM and WIP reports and how the quantity precision is reported § You can set this profile by person § INV: Dynamic Precision Option for Quantity on Reports Slide 34

Material Overhead Defaults Slide 35

Material Overhead Absorption Rules Slide 36

Transaction Value Historical Summary Report Slide 37

Summary § As true with most ERP solutions, there are little-known features which can really be helpful § We have looked at many of them, for more, go to the OAUG Cost SIG minutes for May 2008 § If you have tips you would like to share let us know Slide 38

Acknowledgements § You, the OAUG Cost SIG, thanks for sharing § Partners in crime at my clients over the years Slide 39

Douglas Volz (doug@volzconsulting. com) Professional Background Doug Volz is a Senior Architect and Advisor for Oracle Application projects, with a particular interest in Cost and Project 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, Switzerland Germany. Doug leads the OAUG Cost 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. ) Ø Celgene Corporation (US, Switzerland) Ø NTL (UK, now Virgin Media) Ø TCI International (US) Ø Onninen AS (Norway) Slide 40

Thank You for Your Attendance and Participation Slide 41