| SCOUG Conference Agenda | ||||||||||||||||
| Time | JC Thompson Center (300 Theater | Turtle Creek I (70 Classroom) | Turtle Creek 11 (40 Classroom) | Turtle Creek III (40 Classroom) | Highland Park II (40 Theater) | Highland Park III (Campground) | Lonestar 150 Classroom Style | Houston (40 Classroom) | ||||||||
| Topic | Speaker | Topic | Speaker | Topic | Speaker | Topic | Speaker | Topic | Speaker | Topic | Speaker | Topic | Speaker | Topic | Speaker | |
| 7:15AM - Registration and Continental Breakfast | O A K L A W N , U N I V E R S I T Y P A R K I & II - - - V I S I T E X H I B I T O R S | |||||||||||||||
| 8AM - Kick-off and Keynotes | 8AM: Opening Remarks and Intro | Mark Clark | ||||||||||||||
| 8:10 Keynote | Colby Springer - CIO Club Corp | |||||||||||||||
| 8:40 Intro | Mark Clark | |||||||||||||||
| 8:45 Keynote | Keith Morrow CIO - 7-Eleven | |||||||||||||||
| Morning Sessions | Sys/Admin Track | Apps Development Track | Business Intelligence Track | Project Management Track | Oracle Campground | Oracle Track | Applications Track | |||||||||
| 9:15AM - 10AM - Breakout 1 | 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 | 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 | 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 Inc. | 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 | Kirk Williams - Frontier Consulting, Inc. | 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 | 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 | ||||
| 10:15AM - 11AM - Breakout 2 | 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 | 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 | 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 | 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. | 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 | ||||||
| 11:15AM - 12NOON Breakout 3 | 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, Julia Dane - Noetix Corporation | 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 | 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 | 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 | 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 | 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. | 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 | ||
| 12NOON Lunch | L A K E W O O D R O O M I & II - P R I Z E D R A W I N G A T 1 2 : 3 0 | |||||||||||||||
| Afternoon Sessions | Supply Chain Track | CRM Track | Decision Support Track | Sys/Admin Track | Oracle Campground | Oracle Track | Applications Track | |||||||||
| 1 PM - 1:45PM - Breakout 4 | This presentation will discuss
how our customers have leveraged Oracle Self-Service Applications with
document management technology to improve and streamline the procure-to-pay
process. These efficiencies extend beyond
the Purchasing and AP departments to the larger corporate-wide user
community. |
Patrick Mungovan, CPA - 170 Systems, Inc. | 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 Harrison - Skin Ceuticals; Dan Kubala - ClearOrbit | 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 | Garry Pearson - Torques Technology | 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 | Stan Choflet / Mike Spencer - Jaros Technologies | 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 | Oracle Campground | CRM, Financials, Supply Chain | 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. | 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 |
| 2PM - 2:45PM Breakout 5 | This presentation will discuss several features of Oracle 9i that increase database availability by allowing maintenance operations to occur online. Some features are new to Oracle 9i while others build upon the existing set of features from previous Oracle versions | Dean Richards - Insession | 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 | This presentation outlines Oracle's Contact Center Applications can be leveraged to improve customer loyalty and profitability | Matt Hampton - Braun Consulting | In this presentation, techinques 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 | 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 tablespace usage | Michael Shreeve - Braun Consulting | Oracle Campground | CRM, Financials, Supply Chain | 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 | 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 and Karen Brownfield |
| 2:45 - 3PM - AFTERNOON BREAK | O A K L A W N , U N I V E R S I T Y P A R K I & II - - - V I S I T E X H I B I T O R S | |||||||||||||||
| 3PM - 3:45PM - Breakout 6 | 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 |
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 | 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 | 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 - Appsibility | 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. | Oracle Campground | CRM, Financials, Supply Chain | 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 | 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 and Karen Brownfield |
| 4PM - 4:45 - Breakout 7 | 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 | 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 | 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. | Mitch Damek, Nicholas Pollard - Deloitte | 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 Systems Inc. | 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 | Kevin Dahl - Hencie Consulting | Oracle Campground | CRM, Financials, Supply Chain | Using 11i to cut costs | Steve Ryan - Oracle Corp | 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 |
| Room capacity is in parens classroom configuration first, then theater configuration | ||||||||||||||||