SCOUG/SCOAUG 2003 Conference Presentation Files

Please right-click the title and select "Save Target As..." to download the presentation.

11i…and please add RAC (215k)
A case study.

Kevin Dahl, Hencie

Improve performance and lower costs of your Oracle Applications with Application Resource Management (1073k)

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

Enforcing Business Rules and Security in Oracle Applications. Two Approaches (545k)

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

Introducing Oracle iSetup (542k)

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 – TEC-R Consulting
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 (537k)

Centralizing Data Access and Management of the Reporting Environment (525k)

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

Joe Lenard, (Julia Dane and Eric Nelson)

Collaboration Suite (2678k)

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.

Database Resource Manager: Another Tool in the DBA's Arsenal (937k)

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 (780k)

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 (126k)

Abstract in regular

Mark Clark, o2Works

 

Supply Chain (2455k)

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  (1505k)

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.

Collaborative Procurement: A quantum leap in supply chain efficiency (1175k)

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.  

SQL – DBA’s Best Friend (80k)

Abstract

Lee Millikin, Consultant

11i HR/Payroll/Benefits Strategies after Financials (141k)

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