Fall 2008 NWOUG Conference Abstracts

Abstract Summaries


Track B - Applications Track from the Membership


Keith Lim of IBERDROLA RENEWABLES
How to modify the "PO Output for Communication report"
This report is generated and attached to the PO when it is approved. The document can also be included in the PO Approval form. This seeded report is in XSLFO format and is unusable for most companies since it does not have the necessary data or layout. This presentation will show how to get around this problem.

Joli Bock and Denise Mattice from Tektronix
Virtual Trader Accounting Engine at Tektronix, Inc."
"Are you doing manual journal entries due to limitations in the Oracle Account Generator and Auto Accounting? Are processes being done manually because standard Oracle interfaces do not provide sufficient information for them to be automated? Do you need I.T. support every time there is an accounting business model change? Virtual Trader is a configuration driven, rules based accounting engine. Come hear how Tektronix uses Virtual Trader to overcome many of these business hurdles. "

David McDougald of Maxtek
Implementing Automated Engineering Change Orders (ECO)
On Monday, May 5, 2008, Maxtek Components Corporation (a Tektronix Company) implemented automated Engineering Change Orders (ECO), including approval workflows for items, bills of materials, routings, and drawing changes. Until now, Engineering Change Orders requests and approvals have been carried out with paper and signatures gathered in sequential fashion. With this implementation, change orders will be entered electronically, and all approvers will be simultaneously notified. The new process is expected to eliminate lost or misplaced change order requests and greatly reduce time to gather approval signatures.

David Avery from Tektronix (this presentation has also been accepted for OpenWorld 2008)
"How is a Manager Going to Cope?"
"60,000 Items, ATO?s & options, 12 Currencies, 13 countries, 13 different USD prices, 3 difference EUR prices, 40.2 million lines of pricing, 6.2 million active lines, 185 different core prices lists requiring periodic maintenance, 42,097 discounts associated with 13,985 price lists! How is a manager going to cope? Come and find out how Tektronix, with the use of ORACLE Advance Pricing was able to accomplish all of this and reduce headcount by over 50%."

Track A - Technical Track from Members


Dan Morgan, PSOUG
"New 11g Partitioning Options"
"Oracle has added many valuable new partitioning options in the 11g database including partitioning by virtual column, partitioning by reference, interval partitioning and system partitioning plus a number of new options for composite partitioning that can greatly improve performance. This session, live in SQL *Plus will demonstrate many of these new capabilities. "

Eddie Awad, NWOUG BOD Member from KLC
Use these simple tips to quickly find answers to your Oracle related questions and keep your Oracle skills up-to-date
Explore many useful online Oracle resources that you may not "know about. Use different search techniques, tips and tricks to help" you find answers quickly and accurately. Learn how to use RSS and web2.0 resources to stay up to date with the latest Oracle news, products and people. And more fun stuff...

Track C - Vendor (other than Oracle)


Srini Subramanian from inspirage
Zero to ASCP: How Small Companies can benefit from Oracle Advanced Supply Chain Planning
Many companies continue to use Oracle MRP; which has not been enhanced since the late 1990?s and provides only basic planning capabilities. The Oracle ASCP application has been continually enhanced during the last 10 years to solve real world problems that face most companies. Many smaller companies have limited IT staffs / budgets and have chosen to continue to utilize traditional MRP capabilities. This presentation will outline the ease of an ASCP upgrade and the capabilities that can be implemented with no re-engineering effort. We will also outline the industry specific capabilities that enable Oracle Advanced Supply Chain Planning to help companies improve their supply chain responsiveness and realize tremendous return on investment.

"Jamie Kraus Brocchini from NaviSite, Inc. "
"Is R12 as difficult to deploy as the initial release of R11i? ""Certainly not"" reply customers who have done it. That?s why Oracle R12 implementations are occurring in record time.ÿ Hear firsthand from one such customer, Xsigo Systems in San Jose, CA about their experience as the first R12 implementation in the Americas. With the help of NaviSite?s implementation and application management expertise, Xsigo implemented over 30 Oracle E-Business Suite applications including CRM, ERP, self-service as well as Agile's PLM in just over three months. ÿR12 offers many improvements over R11 from the user interface to features and functionality such as Multi-Org, TCA Vendors, SubLedger Accounting, Tax Engine, Territory Assignment, etc. ÿNaviSite is an Oracle Certified Advantage Partner with deep experience using Oracle Accelerators to help customers achieve a fast ROI on their R12 implementations. "


Glenn Gesell from OSI Consulting
Customer Data Management: Reaching a Single Source of Truth
"Customer information is the lifeblood of any organization, but obtaining and maintaining it is an increasingly complex task due to the expanding channels for customer interaction and large volumes of information to be managed. This discussion will illustrate how Oracle Applications can be used to capture, cleanse, distribute and analyze customer data stored within the E-Business Suite, or across many disconnected systems."


Jibe Consulting - Submission 1
Title: Streamline and Save with Oracle Strategic Procurement
"Abstract:ÿ Are you needing to manage more and more complex purchases with fewer and fewer resources? ÿDo you want to transform your tactical buying function into a strategic, high value, purchasing process? In this session you will learn how you can reduce your spend on Goods and Services through Spend Analysis, Online Sourcing and Category Management.ÿ See how you canÿ automate your Procure-to-Pay process while maintaining controls and enforcing policy compliance.ÿ The journey begins with one step, and it begins here, with Oracle?s Strategic Procurement Suite. Join Jibe Consulting and OHSU in the second of a 2-part NWOUG series on how OHSU?s Procurement Department has provided strategic value to the Organization it serves.ÿ This session will recap OHSU?s assessment of their Procurement processes and systems and the resulting short and long term strategy they are currently executing on.ÿ Also, you will learn where OHSU is in the process of their Oracle Strategic Procurement journey; the benefits they have achieved to date; and plans for the next steps in their journey."


Jibe Consulting - Submission 2
"Title:ÿ R12 Upgrade Considerations, Awareness, and Readiness"
"Abstract:ÿ Whether your plans to upgrade are eminent, or tentatively planned for 2009, eventually you will be upgrading.ÿ What are your major concerns and what do you need to consider for your upgrade from both a business process and technology perspective?ÿ How will your existing EBS applications be impacted?ÿ What tech stack upgrades are mandatory, which ones are important for your organization?ÿ Is Oracle?s OBIEE and BI Enterprise Performance Management (EPM) applications an important component of your overall upgrade strategy?ÿ Do you want to use the upgrade as an opportunity to implement new modules or extend your existing modules?ÿ This presentation will provide an overview of the impacts of an R12 upgrade on your organization from both a functional and technical perspective."


Impac Consulting - Submission 1
"Title: Regulatory Inspections andÿeAM by Terry Hughes, Principal Consultant"
"Abstract: Regulatory inspections can be a significant component of maintaining assets.ÿ By way of an example, this presentation depicts the use of eAM in an underground coal mine collecting inspection data through setup and usage of quality plans. Using the Work Order completion transactions for the quality plans provides a simple interface for thorough and accurate data collection.ÿ "


Impac Consulting - Submission 2
"Ttitle: Roadmap to OBIEE by Randy McAllister, Principal Consultant"
"Abstract: Join Randy McAllister for his in-depth presentation, ""Roadmap To OBIEE"". Randy's insightful and informative presentation provides extensive coverage of:
Oracle Reports - an E-Business Reporting foundation that utilizes standard and custom reports.
"XML Publisher - Create customer-ready PDF documents, such as financial statements, marketing materials, contracts, invoices, and purchase orders. "
Oracle BI System & Discoverer - a decision support solution integrated with Oracle Applications.
"Daily Business Intelligence (DBI) - a reporting and analysis framework that provides relevant, accurate, and timely information through dashboards and drill-down reports. "
"Oracle Portal - Publish Oracle Reports, Discover workbooks, worksheets & gauges, as well as enabling access to content for your customers. "
WEB ADI - bringing Oracle E-Business Suite functionality to a spreadsheet.
"Report Manager - a centralized report distribution system for point-in-time reports, accessible by Oracle Applications user using any Web browser. "


"Malcolm Colton of WireCache, VP Marketing"
"Title: ""I've Tuned My Database. Now What?"""
"Abstract: You have to carefully tune your database, but eventually you start hitting diminishing returns. Or perhaps your database is running in a virtualized environment where you can't create the precise tuning that you need. Is there any choice other than a forklift upgrade? Learn about an appliance that will allow you to support double the number of users, with far better response times. It costs far less than a server upgrade, is completely invisible to your applications and the database, and requires no tuning or administration."


"Global Software, Inc; Amy Collier Marketing "
Title: Leveraging Next Generation Spreadsheet Technology: Enhancing your Oracle? application with Microsoft? Excel-based Automation Tools
"Abstract: Global Software, Inc. is the number one worldwide provider of spreadsheet automation tools to the Oracle? customer community. The inability to gain access to dynamic data within spreadsheets can be debilitating to even the most efficiently run organization. Companies rely on spreadsheets as a key tool in their operational process and financial analysis, therefore, time lost in creating inefficient cumbersome spreadsheets results in lost productivity, lost revenue, lost customers and lost opportunities. Global Software will provide proven processes and best practices to assist companies in leveraging next generation spreadsheet technology to improve productivity and automate Oracle? spreadsheet environments."
"Oracle? users will learn a variety of concepts and best practices within the Excel environment that will enhance the overall Oracle? experience. Through Global?s spreadsheet automation solutions for Oracle? E-Business suite departmental expenses can be retrieved for a dynamic period, year-to-date, life-to-date and the quarter in seconds. With its? familiar Excel interface and ease of use, this revolutionary system will enable the Northwest Oracle? members to Automate in '08."


Stefanie R. Uhl of The GL Company
"Title: ""Accountants Gone Wild!!"""
"ÿAbstract: ?Why is there so much effort in Finance and IT removing data from Oracle E-Business Suite tables into separate data warehouses or into spreadsheets? What improvements in the efficiency of your month end could be achieved if you could do your data troubleshooting, analysis and reporting directly, and in real-time, against the EBS tables? Would the perfect solution be to relieve IT from this burden and empower the end users in Finance to do for themselves? This is the premise of the ?Accounting Intelligence? concept and The GL Company?s Inquiry Suite solution. Take the chains off your Finance users. Minimize those rogue databases, spreadsheets and pivot tables. Get home before dark at month end."


Track D - Oracle Track (5 presentations in total; 3 apps and 2 technology)
Oracle Key Note Presentation by Tom Kyte
"Managing change is the largest challenge for all of us. Constant change is the norm--not the exception. This session explores how to more easily manage changes to applications, requirements, and versions in an Oracle environment. This session looks at the old, the new, and the coming features of Oracle Database that enable change to be introduced as safely as possible into your environment."


Oracle Applications Track Subject Areas - confirmed with Cortny of Oracle week of 7/9
Enterprise Performance Management Overview
"Agile - Product Lifecycle Management (Michael Caveney is the speaker)
EBS R12 - specific functional area such as supply chain or order mgmt


Oracle Technology Subject Areas - confirmed with Jane Smit of Oracle week of 7/14
Fusion Middleware
Business Intelligence