Abstracts and Speakers

Keynote

Colby Springer, CIO Club Corp

Keynote

Keith Morrow, CIO 7-Eleven

 

 

Collaborative Supply Management: Implementing Trading Partner Collaboration

Businesses today face a tough economy as well as closer scrutiny from investors and shareholders. As a result, most companies must justify trading partner collaboration projects with evidence of fast payback—typically within the first 12 months of implementation. To achieve a collaboration project’s ROI in a short timeframe, companies must leverage current technology investments and effectively extend business processes to trading partners across the supply network. According to Michael Hammer of the Harvard Business Review, “Streamlining cross-company processes is the next great frontier for reducing costs, enhancing quality and speeding operations. It’s where this decade’s productivity wars will be fought.” These productivity wars will be won through the ROI achieved by trading partner collaboration and collaborative execution.  Supply Chain veteran, Rich Sherman, will address trading partner collaboration and the importance of Collaborative Supply Management in today’s complex, extended supply chains. Attendees will gain insight into the key elements of supply chain collaboration, why integration and trading partner collaboration projects fail, and how to overcome barriers to collaboration. Mr. Sherman will also discuss why trading partners are leery of adopting collaborative relationship management solutions, along with recommendations on what will inspire them to adopt

Richard Sherman, ClearOrbit

Richard J. Sherman is an internationally recognized writer, researcher, and speaker on logistics, supply chain management, collaborative commerce, marketing and organizational change. He currently serves as Chief Marketing Officer at ClearOrbit, headquartered in Austin, Texas. ClearOrbit is the recognized leader in providing innovative supply chain process management applications for managing, automating, and coordinating supply chain execution activities and enterprise visibility across global distribution networks.  As a research director, he successfully launched the supply chain management advisory services for AMR Research and was a leading member of the team that founded the Supply Chain Council. Throughout his career, Mr. Sherman has held senior management positions with EXE Technologies, Syncra Systems, Numetrix, Ltd., Information Resources, Inc., Mercer Management Consulting, Digital Equipment Corporation and Unisys Corporation serving clients in retail, wholesale, manufacturing, and logistics services (warehousing & transportation).  He is a frequent contributor of articles related to eBusiness, collaborative commerce and supply chain management, and speaks at conferences, symposiums, and universities regularly.  Considered an industry visionary, he serves on the VICS CPFR Committee, the North American Leadership Team of the Supply Chain Council, the National Advisory Board to the Center for Logistics Management at the University of Nevada-Reno, and is a professional member of the Council of Logistics Management (CLM) and the Warehousing Education and Research Council (WERC).  He has served as an executive in residence at the University of Tennessee, Michigan State University, and the Ohio State University among others.  An alumnus of the University of Notre Dame for both undergraduate and graduate degrees, Mr. Sherman has attended management development programs at Michigan State University, Miami University, and the Universities of Tennessee and North Florida

Improve performance and lower costs of your Oracle Applications with Application Resource Management

Oracle Application customers including Sun Microsystems, Applied Materials and Tektronix have adopted a new best practice in their Oracle application environments called Application Resource Management (ARM).  ARM is a new class of application aware infrastructure that monitors and manages data growth in an application environment and takes action to maintain high service levels of performance and stability.  The presentation will explain how ARM works and explain why leading enterprises have adopted ARM to meet or exceed service levels in the face of consolidations, data growth and regulatory compliance business initiatives.  Each of these business initiatives has dramatic data growth implications.   The presentation will include a discussion of the traditional solutions (such as adding server and storage capacity) enterprises have used to manage their Oracle applications--and why these short term solutions ultimately fail to deliver long term results in these application environments.  Also, we will detail the requirements for selecting ARM solutions – what to look for -- as well as a roadmap for a successful implementation.   Case studies will be used to illustrate ARM practices at Sun, Applied Materials, Tektronix and others, and will include descriptions of measurable business improvements such as performance, stability, and cost savings.

Leonard Asuncion, OuterBay

Leonard spent the past 10 years with one of the largest users of Oracle Applications, United Parcel Service in logistics and business development.  In the past 2 years, Leonard has spent time educating people in the Application Data Management market and how it benefits companies that utilize Oracle, PeopleSoft and Custom   Applications. Leonard has spoken at various Oracle conferences relating to incorporating an Application Data Management strategy for upgrading to future Oracle   releases, overcoming performance issues and conveying the importance of a Life Cycle Management strategy to maintain regularatory compliance.  Leonard received both   his BS in San Jose and MBA from Golden Gate

"To Patch or Not to Patch – It’s Not a DBA Question"

In earlier releases of the Oracle Applications the area of patch application and patch application strategy was the purview of the technical support team - namely the applications DBAs.  These early patches were usually very specific in nature, target to address specific bugs or functionality in the software.  In the more recent versions of the applications, 11i in particular, the patching strategy has become much more of a business decision.  Two major reasons for this are as follows: 1) Patches are predominately being released in sets and packs that often have a much wider range of impact than the desired resolution to a given issue; and 2) The involvement of Oracle Support in any reported issue is directly proportional to the degree in which you are patched-current.  The target audience of this white paper is not only corporate technical teams, but also the functional business teams and management.  Different patching methodologies will be presented with the relative merits and risks of each, as well as the impacts on the technical and business teams.

 

Alicia Hoekstra, Solution Beacon

Alicia Hoekstra has over 18 years experience with information technology and has been working with, implementing, upgrading, and supporting the Oracle Applications, domestically and internationally, for more than 10 years.  A founder of the Applications SIG of the Dallas Oracle User Group as well as an active participant in DOUG and SCOUG, Alicia also served on the international OAUG Board of Directors for three years.  Alicia frequently speaks and writes on a number of Oracle Applications implementation and upgrade topics at local, regional, and international user group meetings and conferences.

 

Enforcing Business Rules and Security in Oracle Applications. Two Approaches

Most businesses running Oracle Applications have requirements to make changes to or restrict access to standard Application Forms.

 

First Approach: A custom table driven application to store field and block properties, which are set by the forms custom library at run time. Field and block properties are grouped as rules and these rules can be assigned to the Site, Application, Responsibilities, Users, or Profile. By using this approach you can make forms look and behave differently for different users with out modification.

 

Second Approach: A custom table driven application to store table and column properties that are enforced by simple database triggers generated by the application. Table and column properties are grouped as rules and these rules can be assigned to the Site, Application, Responsibilities, Users, or Profile. The database triggers determine if a rule exists for the current user and will return a form error message if the rule is violated. In addition to table and column properties, SQL statements can be defined to enforce most any business rule

Mike Rodgers, Orchard

Ten Ways to Annoy Your DBA

This presentation will deal with ways that developers can annoy their DBA and how to avoid some of these annoyances.  The presentation will concentrate on queries and their optimization, but will touch on some other issues as well.  The presentation is geared towards the intermediate developer who is familiar with SQL.  Specific topics will include analyzes of tables, the anti-join query (NOT IN (SELECT...)), deadlocks, and table space usage.

Michael Shreeve, Braun Consulting

Michael Shreeve is a Senior Manager within Braun Consulting's Business Intelligence business unit.  He has been both a developer that has annoyed his share of DBAs as well as being the annoyed DBA for data warehouse projects over the past seven years

Workflow Builder

Abstract in regular

Karen Brownfield, Solution Beacon

Karen Brownfield of Solution Beacon has 25+ years experience programming, installing, and managing applications used in various industries including Chemicals, Entertainment, Defense, Recruitment, and Hospitality. The past 12 years she has focused on Oracle Applications specializing in Financials and Workflow as functional specialist, programmer, team lead, and/or project manager. Karen is an active member of the international OAUG Board of Directors, serving in multiple capacities in the last 10 years, including President and Past President; and has presented many papers and training sessions at the various OAUG and user group conferences locally, regionally, and internationally. Karen can be reached by email at kbrownfield@solutionbeacon.com.

Introducing Oracle iSetup

Looking to save time, reduce risk and increase setup accuracy on your Oracle E-Business Suite Implementation project? With the release of Oracle iSetup, true setup automation is finally here.  iSetup provides you with automated setup of the Oracle E-Business Suite, enhancing the quality of your setup and increasing the efficiency of your implementation. 

 

Oracle iSetup is a new Internet-enabled application that allows you to configure Oracle E-Business Suite in a quick and cost effective manner. iSetup empowers you to quickly setup your critical business processes using an intuitive, web-based questionnaire. 

 

iSetup presents you with an easy-to-answer business questions. Once you record your responses to these questions, iSetup automatically translates your business requirements into setup options. The intelligent rule engine makes sure that your responses are mutually consistent. iSetup compliments your responses with the knowledge base of leading business practices to generate setups for the Oracle E-Business Suite. 

 

This presentation will go into the details of Oracle iSetup scope, availability, usage, future direction and customer success stories

Kirk Williams – Frontier Consulting, Inc.
Mr. Williams has spoke at several local, regional and international OAUG Conferences with Topics in Self-Service Web Applications Quality, iSetup and Oracle Hosted service providers

Outsourced Hosted Solutions – Pro’s & Con’s

This presentation will focus around current experiences with Oracle Outsourcing and other Oracle Hosted Solutions Providers.  Benefits of the Outsourced solution will be discussed along with the Business Drivers that should be considered when reviewing an Outsoucred Solution

Kirk Williams – Frontier Consulting, Inc.
Mr. Williams has spoke at several local, regional and international OAUG Conferences with Topics in Self-Service Web Applications Quality, iSetup and Oracle Hosted service providers

No more Oracle Sales Compensation? – Now give them “Incentives”! Implementing  Oracle Incentive Compensation

Oracle Sales Compensation no longer exists as of 11.5.7. This presentation will provide insights into implementation of Oracle Incentive Compensation. Changes from Oracle Sales Compensation will be discussed along with the prerequisites required for successful implementation of the new html-based module. We will also discuss the skillset required for implementation, the structure of a Compensation Plan, and additional functionality in Oracle Incentive Compensation

Gary Pearson, Torques Technology

Using the Customer Contact Center to Revolutionize Customer Service in Today's Economy

This presentation outlines Oracle's Contact Center Applications can be leveraged to improve customer loyalty and profitability

Matt Hampton, Matt Hampton is a Manager of Customer Solutions with the Dallas office of Braun Consulting, specializing in customer contact centers, and CRM implementations.  He has over seven years of implementation experience and eight plus years of business experience in contact centers  His most notable projects were with General Motors, Direct TV,  DBS Bank of Singapore, Shell, Tricon Global Industries, and New York Times.   Mr. Hampton has worked in all life cycles of these projects, and has consistently delivered project deliverables on time and on budget for his clients.  He has worked on many facets in these contact center implementations including the following:  vendor assessment, outsourcing, business strategy, business analyst, configuration/development, testing, training, knowledge transfer, and change management

Data Warehouse

With Oracle9i Database's unique performance and scalability features, customers do not need to rebuild their data warehouses from the ground up when data volumes, user demands, and analytical processing overwhelm their original systems.  This presentation looks at the manageability, performance and security features that Oracle9i provides to support the demanding needs of today's data warehouses. It puts these features into context by providing real world insights into the Oracle9i data warehouse

Michael Coleman,

Michael is a Principal Technology Sales Consultant in Oracle's Commercial Sales division.  He has been in the computer industry for 18 years with the last 7 years working for Oracle.  Michael's focus areas at Oracle are large scale systems, high availability and Data Warehousing

Collaboration Suite

Email, voicemail, meeting participation, calendaring and file sharing are critical activities of every business. They create the communication and content management infrastructure within a company. The ability to conduct business over many different communication channels holds the promise of faster and more flexible interaction with customers, partners and employees. Accepting the challenge to provide this streamlined interaction requires integrated communications systems based on a common technology infrastructure. Oracle satisfies this demand by offering integrated email, voicemail, phone, fax, scheduling, calendaring, real-time on-line meeting services and file management in a single product, Oracle Collaboration Suite.  This session will be an overview of the Oracle Collaboration Suite solution and how it provides a complete, integrated collaborative environment.

 

Jill Jennings, Oracle Corp

Jill Jennings is a Senior Sales Consultant in the Dallas area Oracle office.  She has been with Oracle for over four and a-half years, specializing in Oracle’s middle-tier technology stack, Oracle9iAS, and Oracle Collaboration Suite. Jill may be contacted through email at jill.jennings@oracle.com or her direct office number, (972) 868-3454.

ABC’s of Building Workflows

Workflow is everywhere in Release 11i.  Whether you need to customize an account generator, set the timeouts in the Oracle delivered workflows, or you want to write your own, you must know how to use the Builder Tool.  This presentation will give a brief overview of the pieces of the workflow technology and then focus on how to use Workflow Builder to create or customize workflows

Karen Brownfield, Solution Beacon

Karen Brownfield of Solution Beacon has 25+ years experience programming, installing, and managing applications used in various industries. The past 12 years she has focused on Oracle Applications specializing in Financials and Workflow as functional specialist, programmer, team lead, and/or project manager. Karen is an active member of the international OAUG Board of Directors, serving in multiple capacities in the last 10 years, including President and Past President; and has presented many papers and training sessions at the various OAUG and user group conferences locally, regionally, and internationally.

Public Sector Challenges migrating from legacy to Oracle

The institutional change management issues, administrative culture changes, and technological challenges that accompany a public school district when migrating from legacy systems can seem overwhelming. An analysis of how the Dallas Independent School District replaced its older legacy systems with Oracle Financials, HR and Payroll applications in a fifteen month implementation. A case study of a large public sector enterprise migrating from legacy systems to an industry-standard Web-enabled business model, and the view from the project manager who lived to tell the tale, with lessons learned

Lee Allen, DISD

Lee Allen is the Executive Manager for Business Services Training & Support for the Dallas Independent School District. He has been with the DISD since May 1997, and has also overseen the district’s Technology Services division.  Mr. Allen was the project manager for the district’s 15-month migration from legacy financial and human resources systems to Oracle Web-based applications.  Mr. Allen worked in the Santa Fe Public Schools from 1987-1997

Database Resource Manager: Another Tool in the DBA's Arsenal

The main goal of the Database Resource Manager is to give the Oracle DBA more control over priority of jobs CPU usage thus better managing the server. The Oracle Database Resource Manager includes a scheduling mechanism that keeps track of CPU time consumption and performs scheduling decisions at fixed time-intervals. It also contains a mechanism to control the number of concurrently active sessions. Once all active session slots are filled, subsequent sessions attempting execution will be queued and let into the system as other active sessions finish their work.  The Resource Manager also allows the administrator to set scheduling policies based on the predicted execution time of a query (e.g. only run very long queries in a low priority group or not at all). The presentation will review the use of the Resource manager and present a short case study.

Mike Towery, KnightWorks Consulting

Mike has over 18 years data processing experience in all phases of system development on a wide range of hardware, operating systems, and enterprise wide databases. He has installed and maintained numerous Oracle databases as well as performed DBA activities for those databases. He has been responsible for SQL/PL-SQL and database tuning, backup and recovery for multiple Oracle databases and hardware environments. He has led the performance testing for a number of Oracle's largest and most challenging application implementations. His teaching experience at Southern Methodist University enables me to clearly communicate Oracle concepts. In addition, Mike has his own consulting company, KnightWorks Consulting, through which he performs Oracle DBA services.

Using 11i Delivery Regions and Zones features to Schedule and Release Sales Orders

Review the new features in 11i Order Management for defining Delivery Regions and Zones with associated Intransit Times.  Demonstrate the use of the intransit times to calculate Schedule Dates for sales order lines to control the release of sales order lines for picking

April Stooksberry, Independent Consultant, CPA

April Stooksberry's Education includes a Bachelor and a Master of Science in Accounting and Information Systems from University of North Texas.  Practical business experience includes cost analysis, budget preparation and analysis, domestic and international financial reporting, retail sales and management, asset accounting and management, inventory accounting and management, and customer service.  This business experience is coupled with over 15 years of experience in systems analysis, design, testing, and implementation of custom and packaged applications including over 10 years of experience in Oracle application implementation projects.

Financials Family Pack D-A Preview of New Functionality coming in 11.5.9

A preview of Release 11.5.9 for Financials via Family Pack D. Family Pack D contains much of the functionality that will be provided in Release 11.5.9 of the Financial Applications. The presentation will cover the Functionality as advertised, as well as many of the "gotchas" and challenges encountered at an actual site (early adopter) as part of their go live.

Mark Clark, o2Works

Mark Clark has thirteen years of experience with Oracle Applications, having started his career at Oracle Corporation in their consulting services practice. He participated in and led implementations and upgrades throughout North America, and on behalf of multinational interests overseas. Additionally he has taught classes for Oracle University throughout their US Education centers. He has been involved with founding and co-founding two nationally focused consulting practices that specialize exclusively in Oracle Applications. Mark recently joined the international OAUG Board of Directors in addition to his active leadership as the president of the South Central Oracle Users Group, and as a founder and Board Member of the North Central OAUG. He frequently speaks and writes on a number of Oracle Applications implementation and upgrade topics at local, regional, and international user group meetings and conferences. Mark can be reached by email at mclark@o2works.com or by phone at 214.616.9605.

RAC Demo

This session demonstrates Oracle 9i Real Application Cluster (RAC) solutions on HP’s Itanium2 servers. The focus is on a single hardware solution based on HP platforms as small as the rx2600 server up to the Superdome with Itanium2 processors. A brief discussion of how HP is able to boot the Itanium2 platforms to multiple operating systems is provided.   The presentation/demonstration focuses on the characteristics of RedHat Linux cluster solutions.  It starts with two rx2600 servers with shared storage in a powered-down state and goes through all of the procedures required to bring it to an operational RedHat Linux cluster. Oracle 9i RAC is then added to demonstrate the availability, scalability and manageability of a RAC database in a Linux cluster. This includes fail-over and parallelized scalability queries. A brief discussion of RAC functionality is provided to understand how this database technology takes advantage of HP’s cluster solutions

Steve Gonzalez, HP

Steve is a Senior Solutions Architect in Hewlett-Packard's Central Region BCS Regional Support Group. He has been in the computer industry for over 29 years with the last 18 at HP in support of UNIX and high-performance platforms.  Steve's current responsibilities include focus on HP's AlphaServer and Itanium2 product families and the UNIX operating systems that run on those platforms.  Steve has developed numerous white papers and training classes for implementation of HP cluster technologies for TruCluster, HP-UX ServiceGuard and RedHat Linux clusters

Corporate Governance: Sarbanes - Oxley Act of 2002 and Oracle Corporation

How is the Sarbanes - Oxley Act of 2002 going to impact corporate America? Should corporations take a pro-active or re-active stance to compliance of the Act? What parts of the companies are most likely to be impacted and how? What are the requirements of the Act and how can applications and technology aid in the compliance with the Act? What are the consequences for not complying?  What approach are the large audit and consulting firms taking to alleviate corporate risk pertaining to the Act? What are the anticipated costs for companies to become compliant with the Act?  How can Oracle applications and technology aid companies in their compliance with the Act?   The presentation will provide you with a high level familiarization of what the Act entails and possible solutions for complying with it. Examples of how companies are utilizing Oracle application and technology solutions in a effort to fully comply with the Act will be covered

Ted Sherrill, Oracle Corp

The presentation will be given by Ted Sherrill a Oracle Principal Sales Consultant with a BBA in Accounting and a MBA in Information Systems.  Ted has over seven years as a Oracle employee covering technology and application solutions.  Ted also has worked in public accounting and served as a accountant and IT specialist for a multi-national corporation

Supply Chain

With increasingly unique and unpredictable customer demands for innovation, speed, quality, and service, all supply chain participants are rapidly adopting new e-business practices to succeed in an increasingly competitive environment. These practices allow companies to lower costs, increase velocity, and drive new business enabling them to survive and thrive.  Oracle enables companies to leverage new e-business best practices to automate all processes within a company and to collaboratively extend automation across the supply chain.  This session will review the current Oracle Supply Chain footprint with a focus on how companies can lower costs and drive efficiencies with Oracle Applications

Amy Descombaz, Oracle Corp

Amy Descombaz is a Senior Sales Consultant at Oracle.  She has been with Oracle for over three years focusing on Supply Chain Applications and supports the West Commercial Sales team.  Before joining Oracle, Amy was a Sales Consultant for a mid-market ERP company and was a Manufacturing Engineer at Texas Instruments.  Her responsibilities at TI included program management of outsourced manufacturing

New Features of Oracle’s Development Environment

This presentation will explore the latest features and upcoming strategy for Oracle’s Internet Development Suite.  The discussion and demonstrations will focus on Oracle Designer, Oracle SCM, Oracle Forms and Oracle JDeveloper

Cindy Haley, Oracle Corp

Cindy Haley is a Principal Sales Consultant in the Dallas Oracle office.  She has been with Oracle for fourteen years, specializing in custom development with Oracle’s development environment.  Cindy may be contacted at cindy.haley@oracle.com or (972)401.5705.

Dial “M” for Mobile - De-mystifying the use of Oracle’s Mobile Supply Chain Application

This presentation will reveal the in’s and out’s of implementing Oracle’s Mobile Supply Chain Application.   The discussion is based on an 11.5.7 implementation completed in the last year.  Areas covered will be:  Reasons for implementing MSCA; The hardware required to implement the application; The Creation of Bar Code Labels; Performing Remote Transactions; Tips for Implementing MSCA

Sandi Briggs, Torque Technology

Ms. Sandra H. Briggs is an Experienced Consultant for Torque Technologies with 9 years of industry experience and 14 years of consulting experience. She has recently implemented Oracle’s MSCA, Inventory, BOM, WIP in an 11.5.7 environment.  Other Oracle experience has been with the Advanced Planning System and the Warehouse Management System.  She has over six years of other ERP experience and four years of Supply Chain Planning and eCommerce experience.  She has worked with companies in commercial, aerospace, process, and discrete industries to improve their use of business systems in a production environment. Her primary focus has been on scheduling, inventory, production control, and engineering data management functions. Her project roles include: project manager, functional team lead, education and training specialist, implementation support, business analyst, documentation developer, and software selection support

Collaborative Procurement: A quantum leap in supply chain efficiency

Oracle 11i Internet Procurement suite of applications has provided an unprecedented opportunity to take costs and time out of your procurement cycle and give you a competitive advantage. To reap the benefits, you need to look at the procurement process in a whole new light. This presentation will discuss how two companies justified the investment in iProcurement and reaped the benefits by successfully implementing the applications. Procurement executives, professionals and application Super Users from Manufacturing, Distribution and Service companies will benefit from this presentation.

Raj Wagle, Solix Systems

Raj Wagle has been an Oracle Applications consultant for the past four years. He has performed numerous 11i e-business suite implementations in manufacturing, distribution and procurement areas. For the prior 14 years, Raj worked for EDS in various capacities – as a Business Development Manager, Management Consultant and ERP Systems Project Manager, and assisted numerous large and mid-size companies worldwide to improve internal operations and supply chain efficiencies. Raj’s academic background is in mechanical engineering, management information systems and business management. He is presently a Senior Manager – Oracle Practice at Solix Technologies.  

Oracle Applications and Linux: The Truth Behind the Hype

Linux is starting to garner a lot of attention lately as a low-cost platform for business applications.  But is it ready for Oracle 11i Applications?  Does it live up to the hype?  What are the key considerations for moving to Linux?  This presentation attempts to go beyond the hype surrounding Linux and provide an accurate high-level picture of how Linux is affecting the Oracle Applications world and who can take advantage of the cost-savings associated with Linux.  A case study involving a current Oracle 11.5.8 Applications demonstration instance on Redhat Advanced Server 2.1 is explored, showing what was saved and gained by moving from a Dell/Windows environment to a Dell/Redhat Linux environment.

 

This presentation is primarily for key IT stakeholders in an Oracle Applications environment, including System Administrators, Database Administrators, and IT managers who are interested to learn more about Linux and how it fits into the current Oracle Applications marketplace

Russ Johnson, Braun Consulting

Russ Johnson is a Senior Consultant with Braun Consulting, responsible for performing Oracle Applications DBA and developer skills on 11i E-Business Suite implementations.  Russ has been involved with 5 11i implementations and is the 11i Applications DBA for the instance used in the case study

The Internals of “Internal Orders”

This presentation will provide an overview of the Internal Order Process Flow, the strategic business decisions for implementing internal orders, key set up considerations and impact, manual and auto creations of internal orders and customization considerations.  The topic will be based on a recent release 11.5.7 implementation.

Pearletta Ullrich, CPIM, Torque Technology

Ms. Pearletta Ullrich, is a consultant for Torque Technology with 21 years of industry experience and 6 years of Oracle consulting experience. This includes 10 years of experience in the manufacturing industry.  She has implemented Inventory, Master Scheduling/MRP, Supply Chain Planning, Purchasing, Bill of Materials/Engineering, Work in Process, and Workflow.  She has completed five implementations on Oracle Applications release 11i.  Ms Ullrich has her Certification in Production and Inventory Management (CPIM) from APICS.

SQL – DBA’s Best Friend

In this presentation, techniques utilizing SQL scripts and the Oracle RDBMS data dictionary to support dba needs will be presented.  Selected scripts will be used to function as templates for presenting types of script structures.   Sample scripts demonstrate how to create scripts that  generate secondary scripts to build database objects, alter objects, analyze objects, identify potential database problems or support normal dba maintenance activities.  Utilization of PL/SQL functions in SQL scripts will also be discussed and demonstrated.

Lee Millikin, Consultant

Dr. Lee Millikin first began using query languages in 1980 to maintain IMS hierarchical   databases.  First as an Oracle Principal Instructor, then as an active consultant and contractor offering DBA services, he has utilized SQL*Plus and the data dictionary to develop a large library of SQL scripts to support dba needs.  In addition to scripts to support dba activities, Dr. Millikin has worked with numerous developers to tune as well as create SQL scripts to meet complicated data mining needs

11i HR/Payroll/Benefits Strategies after Financials

The Oracle HRMS product family has vaulted into the role as HRMS industry leader over PeopleSoft and SAP based on new functionality in Release 11i.  Many Oracle Financials customers are maximizing their Oracle 11i E-Business Suite investment and implementing the Oracle HRMS product suite and thus saving, on average, 25% annually by eliminating inefficient “best of breed” solutions.  We will discuss shared data between Oracle HRMS and Financials, critical implementation factors, and realistic project expectations unique to the HRMS suite.  We will address new functionality in 11i HRMS, such as Oracle Benefits (Standard and Advanced) and Self Service HR

Ken Conway, BOSS Corporation

Ken Conway is Executive Vice President at BOSS Corporation and leads a team exclusively dedicated to Oracle HRMS (HR, Payroll, Advanced Benefits, etc.) solutions throughout North America and Europe.  Ken has worked with Oracle HRMS implementations for over 8 years in both management and hands-on roles including several of the first successful implementations that went into production in the United States

FSG’s Made Simple

This presentation will demonstrate the fundamental elements necessary in developing and deploying standard FSG’s.  These fundamental basics include definition of row sets, column sets and reports. In addition advanced topics will be covered that include: consolidated reports, creating reports using different levels or details, changing column sets to break out reports, using segment overrides, using row sets for departments, utilizing % of Rows and % Columns and using statistical accounts.

Ronda Ellis & Karen Brownfield, Solution Beacon

Ronda Ellis of Solution Beacon has over 20+ years of business and accounting knowledge that encompasses several different industries that include: Real Estate and Banking, Retail, Hospitality, manufacturing and Services.  Ronda holds a Bachelor’s degree from Dallas Baptist University.  She has presented at numerous local, regional and national conferences.  Ronda has spent the last 9 years utilizing and implementing Oracle Applications.  The modules include: AR, AP, FA, GL, CE, INV, PO, PA, and Sales Compensation.   Ronda currently serves on the South Central Oracle Applications User Group board as Chair.  In addition, Ronda serves as the Vice-Chair and OAUG representative for the South Central Oracle User Group, as well as the President of the Fort Worth Oracle User Group.  Ronda has participated in various project roles that include: Project Manager, Project Lead, and module lead.  Ronda can be reached by email at rellis@solutionbeacon.com.  Karen Brownfield of Solution Beacon has 25+ years experience programming, installing, and managing applications used in various industries including Chemicals, Entertainment, Defense, Recruitment, and Hospitality. The past 12 years she has focused on Oracle Applications specializing in Financials and Workflow as functional specialist, programmer, team lead, and/or project manager. Karen is an active member of the international OAUG Board of Directors, serving in multiple capacities in the last 10 years, including President and Past President; and has presented many papers and training sessions at the various OAUG and user group conferences locally, regionally, and internationally. Karen can be reached by email at kbrownfield@solutionbeacon.com.

Increasing Shipping EfficiencyThrough Device and Application Integration

Efficient order fulfillment is critical to managing supply chain costs and customer service levels.  Learn how SkinCeuticals teamed with ClearOrbit to seamlessly combine handheld RF scanners, fixed station POS scanners, weigh scales, bar code printers, laser jet printers and freight rating systems to streamline their shipping process within Oracle 11i.

Tarek Omar, Rob Harris - SkinCeuticals; Dan Kubala - ClearOrbit,

As the manufacturer of the original topical vitamin-C formulations, SkinCeuticals, Inc. is the pioneer in the field of anti-oxidant research.  SkinCeuticals products are sold through the world’s leading dermatologists, plastic surgeons, obstetricians, gynecologists, day spas and salons.  SkinCeuticals is located in Dallas, Texas, USA and has distribution in all 50 United States, and in 16 countries worldwide.  Tarek Omar is a graduate of Southern Methodist University with a degree in Finance and Real Estate.  Tarek joined SkinCeuticals, Inc. shortly after it was founded in 1994.  He has worked in just about every area of the organization, including Operations, Accounting, sales reporting and compensation, and Information Technology.  His extensive knowledge of SkinCeuticals core business processes, along with his technical expertise, contributed to his team’s successful implementation of Oracle11i.  SkinCeuticals was able to successfully implement 18 Oracle modules in 78 days, while internally managing all technical aspects of the implementation.  Tarek is currently involved in leveraging the technological resources in place at SkinCeuticals, Inc. in effort to provide his company with the most efficient and effective ERP/CRM system available.   Rob Harrison is a graduate of Southern Methodist University with a bachelor of science in Engineering Management and Information Systems. While attending SMU, Rob participated in SkinCeuticals Summer Internship program, where he assisted in the implementation of Oracle 11i. Upon graduation Rob joined the SkinCeuticals team full time, an has been focused primarily on leveraging SkinCeuticals Oracle environment, and seeking increased efficiency throughout their supply chain.  Dan Kubala is ClearOrbit’s Director of Product Marketing, overseeing product marketing and market research initiatives. Previously, Kubala was Vice President of Marketing at Tanknology, responsible for marketing and business development for technology-based environmental services.  Prior to that Kubala was Technology Marketing Manager at the IC2 Institute, managing business strategy and market analysis for high-tech firms employing federal R&D in commercial applications. Kubala has also worked in product management and supply chain management positions in the consumer products industry.  His technical background comes through experience as project leader on a software development team at Image Sciences Incorporated and as a consultant to IBM. He holds a BA in Mathematics from the University of Dallas and an MBA from the University of Texas at Austin.

WMS Implementation Success

Oracle Warehouse Management (WMS) is a powerful and capable software solution for manufacturers and distributors that is looked upon by many as a key component in Oracle’s 11i E-Business Suite. This session focuses on the knowledge resources, methodology and challenges to assure success with Oracle WMS. The ClearOrbit team will further detail the complexities and technical challenges they overcame in their latest WMS implementation at Zachry Construction – a privately held construction company headquartered in San Antonio, Texas with more than 10,000 employees and world-wide material management needs. We encourage everyone with an interest in warehouse management systems and mobile user automation projects to attend.

Dusty Knight, Cleatius Copeland – ClearOrbit

Dusty Knight is currently a Project Manager responsible for managing large-scale supply chain execution projects for ClearOrbit.  Dusty was the Project Manager for ClearOrbit's implementation of Oracle Warehouse Management (WMS) at Zachry Construction Corporation.  Dusty has over 9 years in operations consulting experience, and was been responsible for developing several implementation methodologies including methodologies for WMS implementations, ClearOrbit Gemini Series implementations, and project management.  Cleatius Copeland is currently Director of Professional Services for ClearOrbit, responsible for overall customer satisfaction.  He has been with ClearOrbit 2 ½ years and has spent 8 years leading Professional Services organizations in the Supply Chain Execution and ERP marketplace.  Prior to this experience, he spent 20 years in Distribution and Manufacturing operations, primarily in the High Tech and Packaging industries.

Using Business Intelligence with Oracle’s E-Business Suite

Along with the different modules in Oracle's E-Business Suite, some analysis of the data can and will need to be done with other Oracle DW/BI software and/or Oracle partner/third party tools.  An introduction into what Business Intelligence is and is not will be presented, along with an overview of the major players in this market space.  After helping the audience understand the reason behind using these tools, the next focus will be on how and when to use them.  Each attendee will learn the advantages and disadvantages of the products under Oracle's Business Intelligence umbrella.  After going through many OFA and OSA implementations, I will offer some very practical guidelines on using OFA and OSA, including some areas to consider if you may be migrating to or considering EPB (OFA/OSA replacement) in 2004.  We will then contrast and compare these two modules to the use of 9iAS Discoverer, BIS (11.5.7 and below), DBI (11.5.8 and above), and the other intelligence modules.  Part of this comparison will include a discussion of the underlying architecture that BI uses in Oracle Applications EDW (11.5.8 and above), Jaros Analytics (11.0.3 and 11i), and DecisionPoint Analytics (10.7, 11.03., and 11i).    Finally, each attendee will receive a briefing in a proven methodology that assesses your readiness and resources to implement a Business Intelligence Solution

David Fuston – FMT Systems

David Fuston has managed multiple projects involving Oracle E-Business Suite 11i, Data Warehousing, Data Marts, Data Transformation, Online Analytical Processing, and Business Intelligence utilizing Oracle RDBMS and Express MDBMS technologies since 1992.  He has been an active beta tester in programs for Oracle Applications 11i, Oracle Sales Analyzer, Oracle Financial Analyzer, Discoverer, and 9iAS.   As an author and presenter of multiple basic and intermediate level technical papers, he has been a speaker at International Oracle User Group (IOUG), Oracle OpenWorld, Oracle Applications User Group (OAUG), and Oracle AppsWorld conferences.  Currently, he is serving as the vice-president of the BI/DW SIG of OAUG.

Oracle BIS and Enterprise Data Warehouse

Are you confused by all the Oracle Intelligence buzzwords?  B.I.S., E.D.W., Discoverer, P.M.F., - What does it all mean?  Oracle E-Business Suite customers are now bombarded by 178 products that make up the Oracle E-Business Suite.  One of the most confusing areas is Business Intelligence.  There are a number of parts, all with a different acronym and some with the same name!  Bring clarity to the situation.  Learn how the Business Intelligence puzzle fits together to satisfy all you company’s reporting needs

Nick Roppolo –  Braun Consulting

Mr. Roppolo is a Manager in Braun Consulting's enterprise Applications practice, with over six years of experience providing supply chain solutions including iProcurement and iSupplier Portal implementations.  Nick’s experience includes functional and technical Oracle purchasing experience with multiple clients

Centralizing Data Access

Finding it challenging to get meaningful data from Oracle Applications and other data sources?  Learn how to simplify access to the information stored in your Oracle Apps database and how to accelerate the delivery of your business intelligence strategy while enhancing your current investment in business intelligence technology including query and reporting tools, dashboards and portals, and ETL tools.

Eric Nelson - Noetix Corporation

Eric Nelson is a Senior Sales Consultant for Noetix Corporation with over 20 years of information technology experience.  His background includes extensive work in the areas of Data Warehouse design and implementation, Business Intelligence, and Analytical Applications.

Making Discoverer Easy to Use for Financial Analysis across the Enterprise

Abstract:  The audience will learn how to maximize the user experience with Discoverer by deploying proper underlying infrastructure. This presentation will review alternative approaches and identify cost effective ways to accomplish the recommended approach.  It will include a Discoverer demo.

Executive Summary: Discoverer is a very powerful tool for analysis yet many Discoverer users have trouble getting the information they need. Developing an EUL to simplify access to the data in Oracle Applications helps but is not the whole answer. An additional layer between Oracle and Discoverer is needed to greatly simplify reporting and analysis.

If set up right, Discoverer is so easy to use that most business users can get the data they need for complex analysis without much training at all. Some IT people think that lack of training is the reason why business users get frustrated with Discoverer. Training alone does not work. The most common problem occurs when Discoverer is used to accommodate inadequate infrastructure. This presentation will provide a recipe for proper use of Discoverer including a demonstration of how to quickly and cost effectively deploy a data warehouse to optimize reporting and analysis. It will include common mistakes made by Discoverer users in the Oracle Applications environment and show how to avoid these mistakes.

The recipe for success with Discoverer includes several things. A properly designed EUL is important, but for analyzing data from Oracle Applications, this is not the right starting point; it is secondary. An additional "transformation layer" (TL) is required to provide optimum results. The EUL concept is meant to hide data structure complexity from Discoverer users. For simple applications, an EUL alone may suffice but for Oracle Applications, a TL is a necessity.

The good news is that components are now available that provide this transformation layer (in the form of packaged data warehouses) and are some are inexpensive to implement. The old fashioned methods of providing this layer are building a custom data warehouse or using views. The newer technologies include Oracle’s EDW, DBI, EBP and several 3rd party analytics products, and tools to build it yourself like Oracle Warehouse Builder.

This presentation will include a demonstration where we will show enabling complex analysis in a few minutes.

 

Stan Choflet, Mike Spencer – Jaros Technologies

Stan Choflet and Mike Spencer are Principals with Jaros Technologies, the company with the leading packaged data warehouse for manufacturing and distribution companies using Oracle Applications.  Mike has been involved in Manufacturing Industry solutions for over 15 years and his background includes 3 ½ years as an Oracle sales consultant and manufacturing applications specialist.  Mike’s deep understanding of Oracle Applications and data warehousing offers unique insight into business process improvement.  Stan, also an Oracle alum, has over 20 years experience in the high tech industry including extensive experience with enterprise software solution sales and generating ROI from software investments.

 

Oracle 9i Online

Dean Richards – Insession

For more than 15 years, Dean Richards has been applying his consulting management and business development skills to the management and support of Oracle databases throughout a diverse range of environments.  His expertise extends beyond Oracle database administration to encompass experience in legacy systems, development environments, systems integration, data migration and many other challenging environments.   Richards's past experience includes work as a Senior Engineer with McDonnell Douglas (now Boeing), Consultant at Daugherty Systems, and as a Consulting Practice Director with Oracle.  Richards is currently a Senior Marketing Analyst with the Oracle Tools Sales division at Insession Technologies.

 

Oracle's Daily Business Close - What it Means, How to Achieve

Oracle has been making a lot of noise around their ability for organizations to see a daily snapshot of their operations – the daily business close – including leads, sales, inventory, and revenue, to allow companies the ability to manage by fact rather than by opinion.  This presentation will discuss Oracle’s view of the daily business close and how it is achieved, then explore today’s reality and practical approaches to increasing information timeliness in your organization

Mike Zesch – Braun Consulting

Mike has been with Braun Consulting since being hired from Oracle Corp to initiate and build Braun’s Dallas office in 1998.  Mike draws expertise from having lead numerous Oracle implementation projects in the manufacturing, retail, telecommunications, and energy industries.  Leveraging previous experiences at Oracle, Nortel, and Raytheon, where he managed large systems implementation and software development projects, as well as his many roles at Braun Consulting, this presentation promises to be an informative and straightforward discussion of Oracle’s products, positioning, and capabilities

Do you have A-RICE List? A-RICE stands for Applications, Reports, Interfaces, Conversions, and Enhancement

A-RICE is a simple spreadsheet based tool developed

for documenting Applications-Reports, Interfaces, Conversions and Enhancements and their related information in a single centralized document.  The document will help in documenting the business software infrastructure.  A-RICE will also be very helpful in metrics about the E-Business Infrastructure and also in assessing impact and analysis of the same.

 

 

Mehesh Vallampati – Oracle Corp

Mahesh Vallampati is a Install Base Senior Sales Consultant at Oracle Corporation.  Prior to this role, he was a practice manager in Oracle Financial Services Industry group.  He has over 10 years of experience with Oracle and has worked at Oracle for 8 years consulting at several Fortune 500 companies.  His current role in Oracle is to facilitate customer interaction with support and Oracle processes.  He holds a Master's degree in Electrical Engineering from Texas A&M University.

 

Oracle Pricing – Basic to Advanced

The challenge of implementing the “pricing module” is understanding the overall impact of pricing within the Quote to Cash process.  This session will review the configuration steps and dependencies in an Oracle Pricing (Basic or Advanced) implementation.  This presentation will show lessons learned over various Oracle 11i implementations, options with pricing, approaches to data conversion and data maintenance.  During the presentation, simple to complex pricing will be discussed using real world examples.  Also included during the discussion will be a review of the latest pricing features from Oracle Application versions 11.5.7 and 11.5.8.  Highlights of the presentation include attribute mapping and pricing formulas. At the conclusion of the presentation, the audience will have a clearer understanding of the implementation of Oracle Pricing (Basic to Advanced) and the issues that await them

Joe Lenard – Torque Technology

Paying Time-off: The Oracle PTO Accrual Process

This presentation presents a case study of an Oracle HRMS PTO accrual process implementation. Drawing parallels to Oracle Payroll, it addresses the unforgiving nature of such an implementation and proposes methodology for "cleaning-up" the mistakes that are inevitably made. The paper also attempts to clarify some fundamental concepts of the Oracle PTO process and how, in this client's situation, it became necessary to directly modify the Oracle seeded "Carryover Process" for a successful implementation.

George Kong and Leah King-  VarTec Telecom, Inc

George Kong is a Lead Developer at VarTec Telecom. He has 9 years of Oracle Applications experience including Financials, HR, Payroll, and Benefits.  Leah King has two years experience implementing and supporting Oracle HRMS, Payroll, and OAB. She is currently employed at VarTec Telecom.

iSupplier Portal Vendor Set Up Options

iSupplier Portal provides your suppliers with greater visibility regarding their interactions with your company’s buying organization.  This session examines various processes for registering suppliers, the considerations for selecting a process, and communicating to your suppliers about using iSupplier Portal.

Faun deHenry - FMT Solutions

Faun deHenry is CEO of FMT Systems Inc., which provides professional services to assist companies in the areas of change management and business process integration. Ms. deHenry has 20 years experience delivering and overseeing professional services. After more than a decade of working on system integrations in manufacturing, professional services, utilities, and distribution environments, Ms. deHenry has refined her thinking into FMT’s change management and business process solution.

ERP Business Intelligence Options

When completing your ERP/MRP/CRM implementation, you will enter scores of information and in some areas, will struggle to get that information back out in a meaningful format for analysis and decision-making purposes.  There are a multitude of business intelligence solutions available to you for implementation, each of which has associated pros and cons.  This paper will discuss some of your options and considerations for a hybrid approach that combines parts of one or more of those options.

Craig Strus – Appsability

Mr. Strus Graduated with degrees in Engineering and Computer Science and is currently Vice-President of Appsability, LLC.  Mr. Strus has been working with Oracle technology for 8 years.  Through 15 years of consulting, he as designed, built, and directed the construction of over 50 systems, including OLTP, OLAP, ROLAP, and ERP solutions.

Sarbanes-Oxley and the new Oracle Internal Control Manager product

The scandals surrounding Worldcom, Enron and Tyco in 2002 have created an environment where the officers of a company have to warrant to their shareholders, not only the accounting information, but the controls they have in place to safeguard the assets of the company, and the validity of the financial statements they produce.  The passage of Sarbanes-Oxley now makes the officers of a company personally liable and responsible for the quality of their internal reporting.  Oracle will soon be introducing a new product, Oracle Internal Control Manager (ICM), that leverages their technology stack to help customers support several major components of Sarbanes-Oxley compliance.  This presentation provides an overview of the requirements of Sarbanes-Oxley, and discusses supporting functionality to be included in Oracle’s new ICM.

Nicholas Pollard, Mitch Damek – Deloitte

Mitch Damek is a Senior Manager in Deloitte & Touche’s Management Solutions and Services consulting practice.  Mitch’s primary service areas are Oracle, and Financial Transformation Services.  Mitch has over 12 years of consulting experience implementing information systems, developing system strategies and helping clients improve business processes.  The demands of the marketplace have recently forced Mitch to focus much of his time assisting client with Sarbanes-Oxley from a technology perspective, which led to his and Deloitte’s involvement with Oracle on the development of the new Oracle Internal Control Manager product and its early adopter program.

Database Archiving When and How

Most sites have been resigned to maintain all their historical data in their production database, for fear of losing access to historical data should they ever archive.  The consequence of this inaction is performance degradation, heavy maintenance requirements in effort and time (labor and batch processes), and increased hardware acquisition costs (processing power and storage).  For historical business information contained in Oracle as structured data, there were great technical challenges that make the separation, and archival of that data difficult and risky.  This presentation will share best practices and time-proven tools for database archiving.  The results of database archiving can be a smaller Oracle production database, without sacrificing on demand access to archive relational data.  Benefits of this approach include: * Improved performance with ad hoc queries; * Improved batch processing performance; * Reduced DBA maintenance time; * Faster data recovery and disaster recovery windows; * Reduced database infrastructure costs

Sue Prazuch - Princeton Softech

Sue Prazuch has over 30 years of experience in the software industry with specific expertise in the areas of application development, conceptual data modeling, database design/implementation, data migration, testing methodologies and programming tools.  Ms. Prazuch began her career in IT as a programmer in a banking environment, and has additionally worked in the areas of insurance, manufacturing and finance as a programmer analyst, system designer and database administrator.  She also has broad experience in technical education as in instructor, training developer and education manager.  Ms. Prazuch has addressed a wide variety of audiences both domestically and internationally, and is much sought after as a speaker and instructor.

 

11i… And Please Add RAC

This presentation charts the technical journey taken for one client that chose to implement 11i with 9i Real Application Clusters (RAC). The client chose RAC to meet their business requirement of no more than five minutes down time for the 11i application environment.

 

The 11i software can take advantage of 9i RAC’s ability to provide high availability for the database tier. However, Oracle does not include RAC as an option during the 11i installation. The following steps are required for 11i to use RAC:

 

1.       Install operating system cluster software

2.       Install 11i

3.       Install 9i

4.       Upgrade 8i to 9i

5.       Configure RAC

 

This presentation will cover each of the above steps in detail.

 

At the end of the presentation, we will briefly discuss the following closely related topics: