Oracle OpenWorld: Register Now and Save!

OAUG Presentations at Oracle OpenWorld 2006

Back to the Oracle OpenWorld main page on OAUG.

Business Intelligence / Data Warehouse — Oracle Retail

Global Data Warehouse Implementation at Bausch & Lomb Using PeopleSoft EPM

Subhash Bandla, Bausch & Lomb

Bausch & Lomb has embarked upon a global implementation of PeopleSoft ERP to replace numerous commercial order entry and reporting systems around the globe. As part of this project, PeopleSoft EPM was implemented as the global data warehouse. This has been used extensively to provide analytical reporting to all areas of business, including finance, sales, marketing and supply chain. This presentation explains the details this global data warehouse implementation and will provide details to the existing PeopleSoft EPM users on how they can leverage their investment to benefit them further. For non-EPM users, this provides a framework for the global data warehouse implementation.

∧ back to top ∧

DMUG

Oracle’s User Productivity Kit and Tutor — A Winning Combination

Steve Canter, Berlin Packaging

Berlin Packaging uses UPK to create and deploy self-paced training. Tutor is used to create business process documentation. Integrating these systems forms a seamless environment that teaches users both how to use the applications and to understand the business processes to ensure compliance.

∧ back to top ∧

Financials

Retrofitting Public Sector Fixed Assets for GASB Compliance

Andy Pang, Solbourne

This is a case study of how St. Johns County School District retrofitted its Assets setup and successfully migrated Assets from Expensed to Capitalized type. The session explains the behind-the-scenes, GASB34-compliant accounting mechanism design, using one Asset and one General Ledger book.

Leveraging Your Dollars: Managing the Procure-to Pay Process with Oracle E-Business

Daya Haddock, Technical Information Associates (TIA)

Have you implemented or are you considering implementing the Oracle E-Business Suite? Are you confident that you have optimized these important procurement and financial processes? Does your system report key indicators for your finances, banking and vendor relationships? If not, come learn how TIA has helped a customer revamp an existing implementation to provide tight controls by streamlining processes from Procure-to-Pay. TIA will showcase a roadmap for assessing and implementing this corporate fine-tuning, including:

  1. assessing your current state, from organizational design to actual business process mapping;
  2. analyzing key metrics against company benchmarks;
  3. implementing a collaborative change management program; and
  4. building the future state, from systems implementation through training and end-user acceptance.

This case study will provide you with tangible tools and techniques, as well as questions to ask, so as to be best prepared to manage your Oracle E-Business update. These techniques can be applied to new implementations and upgrades, as well as to overhaul an existing one.

Sharing Jobs Between Diverse Business Divisions

Kevin Ellis, Humana, Inc.

Allow multiple divisions in your company to upload data into Oracle (such as an Excel spreadsheet) using the same custom interface, regardless if the local servers sharable. Assign separate responsibilities to these divisions and let your IT development staff take care of the rest.

Supplier Scorecard: Rating Your Buying Experience

Manjula Ganapathi, Johns Hopkins University Applied Physics Laboratory

This presentation demonstrates how JHU-APL developed a flexible and interactive system for scoring the performance of suppliers that seamlessly integrates with the Oracle Applications product and was built using the latest J2EE architecture and technology.

X-Men: Oracle E-Business Suite 11i.X Upgrade Secrets

Mohan Dutt, Hyperion Solutions Corporation

Upgrading to Oracle E-Business Suite 11i.X (11.5.10.2) has its share of excitement and thrills. The case study presents the challenges and learning from the upgrade of a full suite of Financials, Projects, Order Fulfillment, Service Contracts and self-service modules. It’s time you became one of the X-Men and shared the 11i.X upgrade secrets that we discovered during the upgrade.

Using Oracle to Facilitate Customer Credit Risk and Collections Management

Randy Dacus, Home Depot Supply

This presentation highlights the initial and ongoing implementation of Oracle credit and collections applications, which has enabled Home Depot Supply to assess and automate credit exposure and collections processes, and will include lessons learned during the initial implementation and optimization.

Migrating from SSNs as Person Identifiers in Oracle Applications Databases

Stephen Vender, Sandia National Laboratories

This presentation is a case study of Sandia National Laboratories successful conversion of 72 million SSNs to corporate-issued person identifiers in an Oracle Applications environment. Presentation entails Sandia’s conversion approach, as well as guidelines and lessons learned to aid others in similar data conversions.

∧ back to top ∧

Human Capital Management

HRMS/Payroll Transaction Audit Solution — Meeting Sarbanes-Oxley Requirements

Ike James, Dresser, Inc.

Prior to 2005, Dresser, Inc.’s, human resource and payroll business processes were managed and supported at seven locations across the United States. In January 2005, we went live with Oracle HRMS/Payroll and OTL. Additionally, all human resource and payroll business processes were centralized. New processes, with adequate transaction audit controls, were required. Using seeded Oracle functionality, we developed an automated process for logging new/changed information to key fields. The process stores the HR representative’s ID who submitted the information and the payroll accounting administrator’s ID who entered the information. The process then triggers an e-mail to both, confirming new and/or updated information that has been entered.

∧ back to top ∧

Higher Education

Using a Biometric Self-Service Terminal to Improve Workforce Management Enhances Efficiency and Productivity

Barbara Garza, Dallas Independent School District

DISD has implemented a Biometric Self Service Terminal to improve the management of its workforce of over 26,000 employees. This system, directly interfaced with Oracle HR and Financials, makes significant improvements in the district’s ability to record time and attendance, track work orders, capture special financial transactions not associated with regular employee pay, as well as providing self-service benefits to employees, such as employee human resource information and other system enhancing functions. The presentation will ouline the features and functions of the system, as well as cover return on investment metrics.

Leveraging Oracle Workflow for Efficient Transaction Processing

Rahul Thadani, University of Alabama at Birmingham

UAB processes on an average of 40,000 document transactions per month. HR transactions include on-boarding, demographic changes, reorganizations and budget increases. Financial transactions include requisitions, invoices and journal entries. Due to UAB’s de-centralized management structure, multi-level approvals spanning intra- and inter-departmental units are needed. The very nature of a complex organization of clinics, schools, departments and divisions requires an efficient transactioning and tracking system that has not be easily achievable thru the seeded Oracle Supervisor/Position hierarchies. UAB resolved this dilemma by designing a custom application (Workflow Approval and Maintenance Module). This module empowers departmental personnel giving them ownership of their approval and maintenance changes.

∧ back to top ∧

Human Resources — PeopleSoft

Implementation and Integration with PeopleSoft Enterprise Learning Management (ELM) 8.81

Suzanne Simpson, Regional Municipality of Durham

This session will focus on how the Region of Durham was able to utilize ELM to deliver a learning solution allowing users to register, launch and track classroom and e-learning courses centrally from the application while utilizing delivered and customized integration points.

Top Tuning Tips for PeopleSoft Enterprise Tier by Tier

Edric De Armas, Home Depot, Inc.

What is the best way to keep your PeopleSoft Enterprise applications running at their peak performance? Come to this technical presentation to learn about top performance tuning tips in PeopleSoft Enterprise 8.4x with Oracle Database and PeopleSoft Applications.

∧ back to top ∧

Manufacturing, Distribution

Oracle Manufacturing: OPM and ODM in One Facility — Where Do You Draw the Line?

Joseph Lenard, NCH Corporation

One of the key decisions that NCH Corporation made when purchasing Oracle Applications was that both Oracle Process Manufacturing (OPM) and Oracle Discrete Manufacturing (ODM) were to be used. NCH is a diverse chemical producer that manufactures, picks and ships thousands of customer orders daily. The need for both OPM and ODM was directed by the end users in the manufacturing plants and in our distribution centers. But OPM and ODM have their own distinct processes. How easy will the day-to-day processes be for a small manufacturing facility using both OPM and ODM? Where do you draw the line?

Case Study: Implementing Oracle at 5 Manufacturing Sites in 9 Months — Strategy and the Lessons Learned

Lawrence Gray, DARC Corporation

The DARC Corporation embarked on a project to implement Oracle ERP at a division of a large defense contractor in a very compressed timeframe. A strategy and a viable plan to do this large-scale implementation needed to be developed. The challenge presented in early 2005 was to go-live with Oracle 11i9 for 5 sites in 9 months. This presentation is a case study of the implementation methodology and the lessons learned by that experience. The purpose of the presentation is to demonstrate that with the proper implementation planning, resources and strategy it is possible to move into Oracle from an outdated system quickly and at a reasonable cost.

Using 11i10 Oracle’s Manufacturing Execution Workbench and Quality Integration

Lawrence Gray, DARC Corporation

The largest benefits of manufacturing execution systems come from capitalizing upon the visibility they can provide into manufacturing performance without compromising on the shop floor execution needs. This presentation will discuss the advantages of using the built-in tight integration of Oracle Quality with Oracle Work in Process. Quality can be setup to ensure that material cannot progress in Work In Process until a quality inspection is completed and the quality data recorded.

Configure and Extend Oracle WMS to Meet Complex Warehouse Requirements

Vishal Choudhari, HCL Technologies (IL), Inc.

Learn how Oracle WMS can be configured and extended to meet requirements common to a distribution-centric warehouse. We’ll cover how to integrate carton-level RFID/EPC tagging into picking processes, build optimized shipping pallets and model realistic inbound and outbound material flows.

∧ back to top ∧

Order Management

Oracle Applications Use in the Software Industry

Ellen Terwilliger, Cavaya, Inc.

This presentation will describe the modules of Oracle Applications that are highly leverageable by companies in the business of producing software. It will also point out the common areas for enhancing these modules to meet the unique needs of the software industry.

The Wizard of OKS: Tips and Tricks for 11i10 Oracle Service Contracts

Mohan Dutt, Hyperion Solutions Corporation

Release 11i10 for Oracle Service Contracts (OKS) incorporates a wholly new architecture. Learn how to take advantage of the new features in 11i10 as part of your implementation or upgrade. The presentation also includes a case study from the frontiers of upgrading OKS to 11i10. You would be on a path to become a wizard of OKS!

Picking Made Easy — Rules-Based Guided Picking Without Customizations

William Powell, Doskocil Manufacturing

Doskocil required a picking and shipping solution to optimize warehouse efficiency and meet customer order compliance requirements. We implemented a rules-based Guided Picking solution pre-integrated with Oracle Inventory/Order Management, avoiding customization and a WMS implementation.

∧ back to top ∧

ORUG

Oracle Retail: Observations on Faster Implementations and Better Operations

Alex Givens, AppWorx Corporation

Oracle Retail is one of the most complex implementations a retailer can undertake. Implementation takes months and then, after go-live, comes daily operational processing. This session discusses how to shorten the implementation, while simultaneously setting up for smooth operational processing.

Integrating Merchandising System Packages to a Third-Party POS/Store System

Miles Thomas, Tesco plc

This case study presents Tesco’s experience of integrating Oracle Retail Merchandising System v10 to the Retalix Storeline management system.

Retek Performance Tuning Best Practices

Venkatesh Krishnababu, Nordstrom, Inc.

This presentation details various tuning and design techniques that help to increase performance and scalability of Retek applications by leveraging Oracle 9i/10g new features. This is based on collection of practical tuning techniques performed on a 3TB production Retek system.

∧ back to top ∧

Payroll

OTL Best of Breed Hybrid — Deciding Which Time and Labor Solution to Employ

Joe Palladino, Kaba Benzing America

When automating time and labor management for Oracle Applications, users are faced with decisions on utilizing OTL versus an external workforce management solution or a hybrid. Learn about the features provided and the key indicators to measure when making decisions on which direction to take.

Successfully Manage Payroll — 10 Keys to Make Oracle Payroll Work for You

Matthew Wilson, Intermountain Healthcare

Since implementing seven years ago, Intermountain Healthcare has had tremendous success using Oracle Payroll for 27,000 employees. From a management and analyst perspective, this presentation will cover key payroll topics, such as balances, performance monitoring, data growth, upgrade procedures, customization and more.

∧ back to top ∧

PeopleSoft

Managing Multiple Moving Parts in a PeopleSoft Enterprise Upgrade

Jim Maynard, CherryRoad Technologies, Inc.

When typically planning an upgrade, conventional wisdom says you should minimize the number of things you are changing.

Global Upgrade to Enterprise HCM v8.9 at Morrison & Foerster

Joe Davila, Optimum Solutions

Morrison & Foerster, LLP, is one of the world’s largest law firms with 1,000 attorneys in 19 offices worldwide. Morrison & Foerster leadership will describe how they deployed the HCM v8.9 solution globally to upgrade all employment business processes necessary to hire, employ and manage its 2,400 staff and attorneys worldwide.

PeopleSoft Enterprise HCM v8.9 Recruiting Solutions Real-Life Experiences

Joe Davila, Optimum Solutions

Oracle’s PeopleSoft Enterprise Recruiting Solutions 8.9 release is the third and most significant release for Recruiting Solutions (now Candidate Gateway and Talent Acquisition Manager) since their initial launch in late 2000. Learn real-life implementation challenges from v8.9 Recruiting Solutions implementations, as with global law firm, Morrison & Foerster, LLP.

Customer Data Hub Real-Life Experiences

Joe Davila, Optimum Solutions

The Oracle Customer Data Hub is a fully integrated customer data management solution. Learn how the CDH centralizes and enriches customer data by automatically synchronizing all data sources to provide a single 360 degree view of its customers.

∧ back to top ∧

Procurement and Advanced Planning

Professional Services iProcurement Implementation Success for an Oracle Projects-Centric Company

Andy Hegler, Landor Associates

We implemented iProcurement and Purchasing in an 11.5.10 Projects-centric environment. We will review our business requirements and solutions, and show an online demonstration of our system at the end of the presentation.

Using Oracle Sourcing for Supplier Performance Evaluations

Elizabeth Ross, Tetra Tech, Inc.

In the E&C industry, suppliers receive an extensive qualification process. Criteria include qualitative evaluations of past performance. How do we manage supplier performance, health and safety, etc., in Oracle Sourcing? We will look at integrating the process into the subcontract management lifecycle.

iProcurement — Maximizing the Benefits

Firat Ozkan, Intuit, Inc.

Intuit, Inc., the makers of Quicken, TurboTax and QuickBooks, is a mid-size company with more than $2 billion in annual revenue. Intuit implemented Oracle 11i Financials and iProcurement Catalog and Requisitioning Tool in September 2004 to support and streamline its processes. This presentation will give audiences an overview of Oracle’s iProcurement solution, explain the steps in requisition creation, approval flow and self-service receiving from a functional perspective. It will also demonstrate how and when to utilize iProcurement functionalities, such as cataloging goods and services, requisition templates (public lists), information templates (special item information) and other stores for indirect goods and services.

Enterprise Life Cycle Management — A Business Strategy for Fusion

Michael McCann, U.S. Department of the Treasury

Ownership of an ERP solution brings significant benefits when the organization makes a long-term commitment of resources. Creating an Enterprise Life Cycle Management strategy allows the organization to establish long-term business expectations and maximize benefits.

∧ back to top ∧

Projects

Integrating Task Workplan Resources with Project Resource Management and Financial Plans

John Sasali, Project Partners, LLC

Projects patch set M has enhanced the task definition of the workplan. This presentation illustrates how to assign workplan resources at the task level and create a financial plan or team roles from the workplan resources. Practical examples demonstrate the many benefits of this new project functionality.

The Magic Bullet for Oracle Projects Customizations — User-Defined Attributes

Neeraj Garg, Project Partners, LLC

Learn to use user-defined attributes (UDAs) in Oracle Projects applications. UDAs are similar to DFFs, but much more powerful in four major ways:

  1. You can use an unlimited number of UDAs;
  2. You can have many records of data associated to a single entity as opposed to only one record;
  3. They can be setup in Oracle Projects to look and feel like a standard setup option for the project eliminating additional training; and
  4. UDAs provide for a function accessed via a link or a button that can be used to call any validation/processing logic needed.

Cradle to Grave: Reconciling General Ledger to Payables to Projects

Thomas Simkiss, BizTech

Projects is a powerful tool that may be used to monitor revenues and expenses at as macro or micro a level as is required. Care must be taken to ensure transactions are accounted, costed and transferred from the subledgers at appropriate times. This presentation will discuss the techniques developed and used to perform reconciliations using Discoverer and FSGs.

∧ back to top ∧

Public Sector / Education / Government

Rapid Transit to the Future Using UPK for Oracle’s E-Business Suite

Jan Edwards, Solbourne

Rapid transit indeed! Come to this session and learn how the Denver Regional Transportation District is utilizing Oracle’s User Productivity Kit and Solbourne content to create a complete training development and delivery program for their integrated implementation of the E-Business Suite and Maximus.

Oracle Public Sector Budgeting by Position Intergrated with Peoplesoft HR

Louis Shih, EDFUND

EDFUND, the nation’s second largest student loan guarantee services, implemented position budgeting using Oracle PSB and extracted data from PeopleSoft HR using Web Services/API call. Users were able to run adhoc reports using Discoverer, Web Services, custom Oracle10g Forms or drill-down Reports.

∧ back to top ∧

Service / Sales / CDM

Oracle Customer Data Management and D&B’s DUNSRight™ Process

Dan Power, D&B (Dun & Bradstreet)

Customer Data Management (CDM) is challenging! We’ll discuss CDM capabilities, and how you can leverage D&B’s alliance with Oracle. We’ll discuss D&B’s real-time, batch and local capabilities for the E-Business Suite and Customer Data Hub. We’ll close with best practices from successful projects.

How to Develop a Business Case for DQM Improvements

Jack Dally, Transitions II, Inc.

This presentation will highlight Identifying data quality issues within your organization, and a framework for developing a business case for investments in data quality management. Will cover the methods of improving data quality, and processes for effective continuity of data quality management.

Sell the Business Value of Customer Data Mamagement to the Executive Suite

Jay Glick, D&B (Dun & Bradstreet)

Technology leaders need to frame the business case for CDM in terms that senior management understands and acts upon. Unlock the value of CDM in key marketing, risk, supply chain and compliance processes to build a compelling ROI that ensures your initiatives receive corporate focus and funding.

New Oracle Sales with D&B Integration Resolve Duplicate Customer Data

Kim Flannagan, USi

After discovering that more than 60 percnet of the customer database was duplicates, my client looked to “D&B for Oracle” integration to identify existing duplicate records and implement a workflow process that would prevent duplicate customer data going forward.

Securing Access to Customer Data Using Oracle’s TCA Data Sharing Groups

Stephen Frizzola, BizTech

Utilizing Oracle’s TCA Data Sharing Groups, the tools for securing access to customer data without customization is at your fingertips. This presentation will provide an overview of Data Sharing Groups and how they can be implemented to prevent unauthorized access to your organization’s customer data.

∧ back to top ∧

Siebel

AstraZeneca’s Successful Global Deployment of Siebel Analytics 7.8

Aaron De Los Reyes, Cognizant Technology Solutions

This presentation will highlight AstraZeneca and its deployment of Siebel Analytics 7.8, which is the largest deployment project of Siebel Analytics disconnected users.

Optimizing Oracle/Siebel Applications for Sun CMT Platform

Khader Mohiuddin, Sun Microsystems, Inc.

This presentation discusses the performance optimization of a complete Siebel enterprise solution on the Sun platform. Solaris OE tuning, Siebel tuning, Oracle database server tuning, Sun Storage tuning and Sun Java Webserver tuning is presented in detail. Additionally, unique features of the Solaris Operating System that reduce risk while helping improve the performance and stability of Siebel applications are discussed. All of the techniques discussed are lessons learned from a series of performance tuning studies, which were conducted under the auspices of the Siebel Platform Sizing and Performance Program (PSPP).

Integration of Enterprise Authentication and Authorization Methods with Siebel Analytics Security Model

Shankar Babu, Cisco Systems, Inc.

This session is a case study about how Cisco Systems integrated the Enterprise Siebel Analytics Instances with external authentication, authorization and data-level security models. Audience will learn how Cisco implemented the business users self-service authorization model for their Siebel Dashboards.

∧ back to top ∧

Technical and System Administration

Concurrent Manager Queue Overlap Analysis

Andy Rivenes, Lawrence Livermore National Laboratory

This presentation will explore how to map Oracle Applications concurrent manager queue utilization for a given time period. A new technique called “queue overlap analysis” will be introduced and used to show how to visualize what jobs ran and when for a given query.

Rapid Migrations to Release 11.5.10

John Stouffer, Solution Beacon, LLC

Release 11i10 is more stable and robust than previous point releases. In addition to some basic facts about the technology and features of the newest release, we’ll share proven strategies and lessons we’ve learned to help make your migration project efficient and successful.

Applications Database Optimization Panel

Mark Farnham, Rightsizing, Inc.

The panel will be a question-and-answer format focusing on performance challenges of Oracle databases serving the Oracle Enterprise Applications. The session will start with quick tips from experienced database pros, followed by attempts to answer questions from the audience. The recommended audience is Oracle DBAs, applications sysadmins, opsys admins and IT directors. This is the well-known panel sponsored by the OAUG Database SIG.

∧ back to top ∧