2nd Annual Training Day March 12, 2007 Presenters’ Abstracts
8:45am – 9:25am ------------------------------------------------------------Case Study: Implementing Oracle at 5 Manufacturing Sites in 9 Months - Strategy and the Lessons Learned – RM #42 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..
VENDOR PRESENTATION Seven Pillars of Strong Internal Controls for World-Class Accounts Payable Automation - RM #43 Toby Brzoznowski, 170 Systems, Inc. Finance departments under severe pressure to improve internal controls can use a magic bullet to hit three elusive targets—service, cost and controls—in one shot. This presentation will explore how business process automation software, when tightly integrated with existing ERP financial systems, strengthens seven key internal controls while lowering costs and improving service levels.
170 Systems surveyed over 1,000 finance professionals and asked them to rank the most important internal controls. The results—the top seven pillars of strong internal controls—were: 1. Early & End-to-End Visibility 2. Strong Approval Framework 3. Segregation of Conflicting Duties 4. Enforcement of Policies and Procedures 5. Properly Maintained Transaction-Level Backup 6. Support for Internal and External Audits 7. Error-Detection Techniques 170 Systems will discuss how the implementation of their MarkView® suite of software solutions can leverage technology to shore up controls in all these critical areas. This presentation examines how automating controls in a standardized, centralized fashion can deliver significant benefits to an AP organization. Road Map to Oracle Fusion – RM #45 Jeff Budge, CSC Consulting, Inc. Take Control of your Fusion Destiny! Oracle and CSC have teamed to offer the best of Oracle's technology and the best of CSC's services to address business and technology issues, such as integration, consolidation, security and compliance. CSC's Road Map to Oracle Fusion will help customers plot and navigate a path from today's application environment to a future that will include Oracle's Fusion Applications, leveraging Oracle's Fusion Middleware along the way. This session will provide an overview of the actions and steps companies can take today to plot a successful course to a Fusion future.
Oracle Time & Labor Without the Utilization of the Oracle Project module– RM #47 Svetlana Apreleva, WMS Gaming Inc Oracle Time & Labor (OTL) will meet your time entry needs for employees and contingent workers for the entire e-business suite. Workers enter their own time which you can subject to an approval process according to your individual business rules. This presentation will explain the implementation of OTL without the utilization of the Oracle Project module. The topics covered are: 1. Definition 2. Setups (Including Custom Timecards) 3. Process Flow Diagram to Illustrate Interaction Between HR and Finance 4. Common Issues 5. Reporting
Implementing Consigned Inventory Process – RM #49 Sandeep Gandhi, Omkar Technologies Inc Consigned Inventory is a business process which involves receiving goods from a supplier but not taking ownership until the goods are used up. This presentation will explain the Consigned Inventory process and how to set it up in Oracle. The topics covered are 1) Definition 2) Benefits 2) Setups (One time as well as Recurring) 4) Business Process Flow Diagram to explain interaction between Inventory, Purchasing, receiving and AP 5) Common Gotchyas and, 6) Implementation Checklist. The handout will consist of screen shots, glossary of terms and references for further reading 11i OIC Overview – RM #53 Lisa Barthel-Daluge, CCSI The 11i Oracle Incentive Compensation module provides a dynamic tool to incentify either internal and/or external resources. This session is recommended for new users, people evaluating the module and those that are upgrading to 11i.
VENDOR PRESENTATION Using MS Excel to manage your Projects Environment- RM #52 John O'Keeffe & Sarah Conzemius, More4Apps Microsoft Excel will always be the accountant's tool of choice for reviewing & manipulating data and modeling financial scenarios however desktop integration with Oracle Projects has been limited or required extensive programming. This presentation will review the current technologies for managing Oracle Projects using Excel and provide a demonstration of a range of solutions currently used in a large number of Oracle Projects sites around the world. This will include solutions for creating and maintaining project structure & budgets and loading project transactions and revenue & billing events.
Oracle Business Events - RM #57 Dheeraj Bhushan, Getrinate, Inc Discussion of Oracle Business Events technology with an example in perspective. How to leverage this technology to create efficient realtime integration with existing systems. Finally, the Business Events API overview to propagate changes in error free manner.
9:35am – 10:15am -------------------------------------------------------------Did You Get the Expected Return on Your ERP/CRM Investment? – RM #42 Roger Kuhn, O2works A radical new ideas aimed at increasing ROI and decreasing customer disruptions within ERP/CRM implementations. This session throws out the 'old' implementation playbook and takes a realistic look at how ERP/CRM initiatives should be planned, structured and executed.
Fax and Email from Oracle E-Business Suite using XML Publisher - RM #43 Mike Piland, STR Software Learn what it takes to utilize Oracle E-Business Suite's native functionality (workflow, forms, and database technology) to automate fax, email, and print delivery of any document or volume of documents. STR Software's presentation will cover the following objectives within the Document Delivery track:
Benefits of a document delivery solution Pros and cons of the native fax/email functionality of Oracle E-Business Suite and XML Publisher Features critical to a document delivery solution and the criteria to select a vendor A review of three document delivery implementations
Doing EDI with Fusion Middleware – RM #45 Bipin Raj, eAlliance Corporation Oracle has made EDI handling quite painless with Fusion Middleware. Business documents such as purchase orders, invoices and advanced ship notices can all be exchanged with minimum human intervention. Fusion Middleware components such as B2B Integrator, BPEL Process Manager and XML Gateway can be orchestrated to automate EDI document handling. Learn more about these components and how an actual EDI document such as an inbound Purchase Order is handled and inserted into the eBusiness Suite.
VENDOR PRESENTATION Microsoft Excel Automation for use with Oracle Financials – RM #47 Dan Havey, Global Software, Inc. Make spreadsheets more powerful by enhancing data integrity and placing more control on the spreadsheet process within the Oracle® Financials applications environment. Global Software, Inc. will introduce a variety of concepts and best practices within the
Microsoft® Excel environment that will enhance the overall Oracle® Financials application experience Reship Solution for Consolidated Shipments through Distribution Centers – RM #49 Prashanth Reddy, DARC Corporation Reship using Internal Orders allows you to authorize and execute the reship of Customer (External) Sales Orders, Purchase Orders and Internal Sales Orders through distribution centers for consolidation and optimization. Reship Process allows you to automate the warehouse change, creation/cancellation of internal orders, and create/transfer/cancellation of item reservations. Major benefits of this solution is a) Transportation cost control b) Ability to route customer, inter-plant, & supplier shipments through the distribution centers c) Ability to optimize, from a cost and customer service perspective, transportation d) Ability to generate a single invoice after the last point of control e) Reship internal sales orders through other inventory organizations for consolidation or trip optimization Effectively using Fulfillment Service for Collateral Distribution – RM #53 Ashok Kowdle, AST Corporation Thinking of sending Collateral to your Customers using Oracle's Standard Fulfillment Servers- Think Again. The various issues related to MES and OCM Integration make the the out of the box solution very inflexible even though the Fulfillment servers are very stable and have capacity to carry larger loads. This paper talks about using a Custom solution along with the standard features of the fulfillment services thereby making the solution highly flexible and attractive to the Business.
Oracle Projects - Implementing Family Pack M–RM #52 Gary Bach, DARC The Oracle Project Suite continues to morph from a projects based sub-ledger to a global solution that enables project-centric organizations and departments to establish operational processes that support full project lifecycle management of projects across operations and finance. As this continues to take place, organizations are constantly battling with new functionality and how to deliver it effectively. Understanding Family Pack M as it relates to this functionality is crucial to an organizations success. Oracle BI Publisher installation –RM #57 John Chemers, TW How to install Oracle BI Publisher (XML Publisher) for legacy PeopleSoft, JD Edwards and non-Oracle databases
10:25am – 11:05am -----------------------------------------------------------Oracle Support Strategy/Q&A – RM #42 T.B.D., Oracle Corporation Abstract Forthcoming. VENDOR PRESENTATION Document Processing in EBS– RM #43 Ramesh Kumar, eAlliance Corporation Organizations have adopted ERP systems to improve efficiency, standardize business processes, and achieve competitive advantage. Yet, many critical business processes continue to rely on transaction documents such as Purchase Orders, Invoices, Receipts, Statements, Acknowledgements, or Correspondence. With paper, email, and fax comes costly, time-consuming, error-prone manual processes for storage, retrieval, and distribution. FormScape V3 is the premier Document Process Automation solution that integrates documents, processes and business systems for the right people, at the right time, in the format they require. It allows customers to create professionally branded business documents from any Oracle e-Business or host application and deliver intelligent output management both internally and externally without reprogramming the original application. Additionally, many organizations have implemented Enterprise Resource Planning (ERP) systems and Shared Service Centers to achieve productivity gains and reduce the costs of financial administration; many are seeking added operational savings from their accounts payable and purchasing departments without sacrificing transaction quality or vendor relationships. An increasing number of these forward-thinking companies are investing in Web-based or outsourced Purchase-to-Pay solutions to achieve these goals, and more. Bottomline's Sprinter platform, a modular solution suite complemented by advanced invoice capture and imaging services, has been designed to meet this need and help organizations of all sizes configure the best possible AP automation solution.
A Technical Roadmap for Fusion, Release 12 and Oracle Fusion Applications (OFA) – RM #45 John Stouffer, Solution Beacon Searching for the correct map to Fusion and beyond? Please join us as we discuss a roadmap for the new Fusion technologies and their impact on Release 12 and Oracle Fusion Applications. A clear, concise look at the Fusion tools already in use today and how to merge them into a cohesive strategy for your corporate planning and budgeting efforts.
Case Study of 11.5.10 Forms Personalization’s Enforcing Business Rules in Oracle Assets – RM #47 Mark Clark, O2Works LLC Learn how one Oracle Applications customer was able to enforce very specific business rules in their Oracle Assets implementation without customization and without expensive 3rd party productions. The presentation will explain the custom business rules and show how the standard functionality of 11.5.10 was used to meet the business requirements. Oracle Transportation Management Overview – RM #49 Jim Gewargis , Oracle Corporation Oracle Transportation Management delivers robust transportation planning and execution capabilities to shippers and third party logistics providers. It integrates and streamlines transportation planning, execution, freight payment, and business process automation on a single application across all modes of transportation, from full truckload to complex multileg air, ocean, and rail shipments. In this session, you will learn how Oracle Transportation Management lowers transportation costs, improves customer service and asset utilization, and provides flexible, global fulfillment options. Come join this session to hear updates about this exciting product offering! A Case Study in Personalization with Order Management – RM #53 Bob Brown, DARC Corporation Release 11.5.10 includes a feature called Personalization that extends the customization options for forms-based screens beyond folders. This paper will present a case study involving the use of Personalization to alter the behavior and appearance of the Order Entry and Quick Order Entry forms. Topics will include adding options to the Tools menu, format masking, and flow control.
VENDOR PRESENTATION Projects Extensions for Billing, Revenue Accruals - RM #52 Josh Scheumann, INRANGE Consulting Use Oracle Projects Extensions to handle complex Billing & Revenue Accrual scenarios with Billing Assignments, control and validate Project setups with Status Verification, and bill on variable dates with custom Billing Cycles. These allowed a client to implement Project Billing in a 20,000+ projects per year environment and are just three examples of solutions available in the Projects suite. Integrating Oracle E-Business suite (EBS) with BPEL and its Advantages – RM #57 Muthukumar Narayanan, eAlliance Corporation BPEL (Business Process Execution Language) Process Manager is an Oracle Fusion Middleware component that helps the E-Business Suite customers adopt standards and retire customizations as well as hard-coded integration points. BPEL can be considered to
be the core of Oracle's Business Integration solution and provides a comprehensive, standards-based and easy-to-use solution for creating, deploying and managing crossapplication business processes. It can contain both automated and human workflow steps all in a service-oriented architecture. With BPEL, E-Business customers can deploy new solutions, decrease maintenance costs, and quickly adapt to new business requirements. We will see how quickly and easily BPEL can be integrated with E-Business suite and the benefits of it.
12:45pm – 1:25pm -------------------------------------------------------------Tools of the Trade: Navigating the sea of Training Tools– RM #42 Melissa Sider, DARC Corporation There are a wide variety of tools available to support training for your implementation or upgrade project. How can you determine which tools are the most cost-effective for your audience? The presenter will discuss training tool alternatives such as: Document Management Systems, Learning Management Systems and Simulation Builders. Real examples of successful projects will be shared.
VENDOR PRESENTATION Delivering Enterprise Security and User Provisioning – RM #43 Mike Rulf, Usinternetworking, Inc. Like most organizations, USi utilizes a wide range of packaged software and internally developed systems to support our corporate business practices. In order to meet regulatory and audit requirements, a robust identity management solution was required. The first half of the session will discuss some of the design issues and pitfalls encountered as we created our role based security model (RBAC), centralized our user management, and deployed the security model. The second half of this session will focus on how to provision users to multiple systems as well as manage a complex approval model using BPEL and SOA. Real-world experience using PeopleSoft, Oracle EBS, as well as 3rd party products and custom-developed software will be used as examples to illustrate the provisioning process. Release 11i/12 Features and Functionality – RM #45 Daryl Geryol, Solution Beacon This presentation will provide an overview of changes to the E-Business Suite, focusing on changes released to 11i in the last 18 months as well as a brief view of some of the key changes in R12. Emphasis will be on the core modules and business processes such as underlying technology, Financials, procure-to-pay, and order-to-cash.
Developing a Value Driven HR Delivery Model–RM #47 Steve Knill, Capgemini A high-level strategic mapping of HR functions against David Ulrich's model of HR. Evaluate the gaps between HR and business unit customer views in areas of perceived strengths and weaknesses, and identify improvement opportunities to close those gaps. The key business drivers of this solution set include: Create a more strategic role for HR Achieve flawless administration Connect the organization Measure HR performance Oracle Demantra Demand Management – RM #49 Peter Harlan, Oracle Corporation Can you predict and proactively respond to your customer demand?
Does your business work off of a single, consistent planning model? Do marketing, sales, operations, and fulfillment all work from the same plan? Can your business create a collaborative plan to align your strategic direction with trading partners across the enterprise?
Finally, a way to Manage Customer Demand Variability for improved productivity! With rich data analytics embedded in the platform, you'll be able to measure, predict, and maximize the impact of business decisions in real-time as part of your day-to-day planning and execution. Join this session and Oracle product expert to hear more about our Demantra solution! Oracle Applications Reporting – “How Can I Get What I Need?" – RM #53 David Fuston, Linium, LLC Most organizations find their reporting solution does not provide the level or degree of information they want after their Oracle Apps implementation. We will discuss the causes and results, alternative strategies for solutions, approach methodologies, and how to avoid these reporting frustrations. Most organizations find their reporting solution does not provide the level or degree of information they want after their Oracle Apps implementation, or they discover that the reporting products they acquired are not the best suited for the information they need to produce. We will discuss the causes and results, alternative strategies for solutions, approach methodologies, and how to avoid these reporting frustrations by using a matrix of Oracle products to match the user requirements. We will break the possible root causes of our reporting frustration into 4 categories and address each one individually: 1) Data requirements of ERP system for reporting not determined
2) Information requirements not determined before reporting products implemented 3) Reporting requirements did not drive selection of reporting products 4) Reporting requirements not incorporated into ERP configuration. We will then discuss the process of identifying our reporting requirements, along with a discussion on how to mix and match these requirements against the Oracle tools available, and then proceed to decide which products/modules to select to satisfy those needs. During this discussion, we will address the features and functionality of Financial Statement Generator (FSG), Oracle Financial Analyzer (OFA), Enterprise Planning and Budgeting (EPB), Business Intelligence System (BIS), Daily Business Intelligence (DBI), Balanced Scorecard (BSC), Oracle Business Intelligence Enterprise Edition (OBIEE, formerly Seibel), BI Publisher (formerly XML Publisher), Discoverer 10gR2 (formerly codename Drake), and Reports.
XML Publisher Reports - RM #52 Kiran Kumar Akkiraju, eAlliance Corporation Until now, customers relied on the powerful data extraction features of their Oracle EBusiness suite reports, but could not present this data in visually appealing and customized formats. They had to rely on expensive third-party solutions to create publishable documents such as invoices, purchase orders, sales orders, contracts, marketing material and financial reports. Learn using Oracle XML Publisher, a new java based product available within the technology stack of E-Business suite, that provides template-based and easy-to-use publishing solution to develop and maintain report formats.
10G-RAC-ASM-OCFS-RAW-PDQ Decoded – RM #57 Kevin Dahl, Solution Beacon Trying to make sense of the latest offerings from Oracle? Brush up on some of the latest items in the ―Grid Computing‖ architecture. Learn the difference between Oracle Clustered File Systems, RAW devices and Automatic Storage Management. Why does Oracle install and start a process called ocss.d? Why do I need it and how do I stop it? Why do these processes matter? Why do I need a database just for ASM? How does my database communicate with ASM? We attempt to find solutions for these and other questions regarding the new iteration of ―Grid Computing‖.
1:35pm – 2:15pm --------------------------------------------------------------VENDOR PRESENTATION Oracle Talent Management – RM #42 Lowry Page, KBACE This presentation will include a functional level demo of the new Talent Management functionality which was delivered with Family Pack K Rollup 1. This demo will include the use of the Objective Library, Performance Management Plans, Appraisal templates, Rating Scales, etc. Lowry Page has implemented seeded and custom talent management systems for several leading-edge companies running Oracle applications. Credit Cards and Oracle Applications: Security and PCI Compliance Issues – RM #43 Stephen Kost, Integrigy Corporation Credit card data breaches are headline news, thus organizations must properly protect credit card data or risk being tomorrow's headline. Oracle Applications implementations that 'store, process, or transmit cardholder data' must comply with Payment Card Industry (PCI) security standards regardless of size or transaction volume. PCI is focused on securely handling cardholder data, but also has a significant emphasis on general IT security. The difficultly with Oracle Applications and achieving PCI compliance is that even though credit card processing may be only a one minor feature, the entire application installation must be fully PCI compliant due to the tight-integration and data model of Oracle Applications. This presentation will review the credit card processing within Oracle Applications and will provide general guidance for Oracle Applications implementations on securing cardholder data and complying with relevant PCI requirements. Highlite of R12 Changes in Financials– RM #45 Ralph Doucette, DARC Corporation Tell and describe changes coming in Release 12 for Fixed Assets. Explaining some of the upcoming changes for intercompany in Release 12. Tell about changes in Payables for Mass Additions. Explain some of the changes in Responsibilities in Release 12. Talk about changes for Banks , Vendors and such. Also discuss the new SLA Sub Ledger Accounting coming in release 12.
How to Facilitate the Transfer of Assets Across Corporate Books – RM #47 Brian Bouchard, Chi-Star Technology Currently, the process to transfer assets between depreciation books is very manual. With the current process, the sending depreciation book retires the asset on its book. The receiving depreciation book must manually add the asset. This requires considering or calculating asset cost, year-to-date depreciation and accumulated depreciation, currency translations as applicable, and financial treatment. There is a solution that will streamline, and automate the transfer of assets between books. This solution is flexible enough to satisfy client policy and procedures. A solution such as this improves the capability of Oracle Fixed Assets. It automates: (1) the transfer of assets across corporate books, (2) the calculation of Translated Values, and (3) the addition method. Implement Oracle Demantra – RM #49 Sundu Rathinam, Chain-Sys Corp This presentation will walk through the Functional and technical aspects of implementing Oracle Demantra product. Will focus on the integration between Demantra with ASCP, IO and other APS suite modules. Will show as much of live demand forecasting model in this presentation.
VENDOR PRESENTATION Setting up a Successful Reporting Solution with Oracle Discoverer and Other Tools -RM #53 Mike Hoover, Noetix Corporation Learn the key elements in setting up a successful reporting solution with Oracle Discoverer – leverage dashboards and Microsoft Excel, along with other familiar reporting tools to empower users to securely create and share their own reports. Make query and reporting tool setup automatic for Discoverer super users and allow business users and executives to get the fast answers they need to make important daily decisions. Attend this session and discover options that enable your organization to securely access data from multiple sources in real-time across your enterprise—presenting data from disparate data sources as if that data resided in a single database. In this demonstration we will also discuss how to simplify and extend the value of Oracle DBI and use Oracle's BI tools, including Warehouse Builder for ETL and Discoverer 10g for performing multidimensional analysis.
Is Application Express Right For Me?– RM #52 Frank Bender, O2Works, LLC Web based applications are as common as tumbleweeds in west Texas. There is a vast array of tools and languages available to develop these applications. Many of these tools and languages are complex and difficult to learn. Application Express (formerly known as HTMLDB) is an Oracle development tool that will allow developers to quickly and effectively create web based applications. The presenter will discuss features, benefits and limitations that will help you to decide whether or not Application Express is the right tool for your next project. AutoConfig, Rapid Clone and Why Is the Sky Blue? – RM #57 James Morrow, Solution Beacon The introduction of Oracle Applications Release 11i dramatically changed in the way we configure and manage an Applications environment. Previously, we had a handful of simple files, easily edited to work with. The effort to manage and copy one environment to another fairly was manageable. The introduction of the ―NCA‖ architecture, used in 10.7NCA, along with Release 11.0 made things a little more difficult. Release 11i, however, dramatically changed the Applications DBA world. This highly complex configuration management made for highly unstable environments with no welldocumented approach for consistently and effectively producing a clone of a particular environment. This approach, in turn, put a lot of grey hairs on the heads of a lot of Apps DBAs. Enter AutoConfig and its cousin, Rapid Clone. We'll examine the basic workings of these tools and explain how you can most effectively put them to work for your environment. We'll cover customization and extension with these tools and give you the means to live peacefully with AutoConfig.
2:25pm – 3:05pm -------------------------------------------------------------Performance Tuning Users: How Training can Take you to the Winner's Circle– RM #42 Jeff Graunke, Graunke Consulting, Inc. The best car does not guarantee victory in auto racing. And neither does the best ERP system guarantee victory in the business world. The focus is often on the car or system, don't forget the drivers. Learn how training and retraining the users who drive your system everyday can increase your business performance and propel you to the winners circle. Learn the different types of ERP training (classroom, web-based, coaching, etc...) you can provide to prepare and keep users performing at their best.
An Easy Guide to defining Oracle financial Responsibilities so that Proper Segregation of Duties can be Obtained. – RM #43 Ken Kiesler, DARC Corporation With an increased emphasis and pressure on finance departments to have proper segregation of duties there is more of a need to design your responsibilities correctly up front. A number of tools currently exist in the market place to assist in this process; however by going through few manual steps the same results can be obtained. This presentation is designed to assist you in manually defining your Oracle financial responsibilities. Along with the steps detailed, examples are given to help understand how this process will work at your company. The examples provided are a result of this process being leveraged at a company during their certification process with proven results.
Release 12: Upgrade Versus Reimplementation Considerations - RM #45 Daryl Geryol, Solution Beacon An overwhelming question to most users contemplating an upgrade to 12 is ―should I reimplement or upgrade?‖ Considerations like multiple production instances and the extent of customizations can be clear indicators for re-implementation as opposed to upgrade. However, there are many other factors that contribute to the decision process. This presentation will discuss the factors that determine whether the right approach is a reimplementation or an upgrade. ―Real-world‖ experiences will be provided to help to sort out some of the ambiguities.
VENDOR PRESENTATION Eliminating Processing Bottlenecks in the Oracle EBS Financial Period Close – RM #47 Pat Higgins, AppWorx Corporation Manual processing bottlenecks in the Financial Period Close lengthen the close, introduce errors, increase risk and hamper compliance efforts. This presentation not only highlights potential bottlenecks but also discusses how automation can eliminate bottlenecks and drive more efficient processing.
Manufacturing- Value Solutions– RM #49 Brian Rogan, Sierra Atlantic The Oracle Configurator has undergone extensive enhancement in 11.5.10 in the areas of Oracle Configurator Developer (OCD), rule writing and user interface generation. This presentation will provide an overview of these enhancements as well as some specific examples of their use.
DBI: Moving from Data Chasing to Data Analysis – RM #53 Jason Bletz, New Generation Consultants This presentation will describe the benefits of DBI out of the box. Prior to the implementation of DBI, company wide information was derived from multiple departments and multiple reports and then entered into an excel spreadsheet for presentation purposes. This process required several departments and several people. As a result the information was delayed in getting to the right people. DBI empowered the decision makers by providing information in a timely manner to the right people at the right time through the use of dashboards.
Flex your ApEx: Implementing Oracle E-Business Suite Flexfields in Application Express – RM #52 Shane Bentz, InterVarsity Christian Fellowship/USA With every passing day, the functional boundaries between traditional client-server applications and web applications decrease. New technologies such as SOAP and AJAX enable web applications to function and perform like traditional fat-client software. For those of us in the Oracle E-Business Suite world, utilizing some of its built-in functionalities in our own custom web applications greatly increases code re-use and simplifies maintenance, specifically when it comes to flexfields. Flexfields are a versatile feature of the E-Business Suite allowing generic columns to use dynamic validation based on a specified context. In this session, I will show how to integrate the E-Business Suite flexfield functionality into Application Express. By leveraging the power of AJAX, Application Express can use descriptive flexfields to create rich web applications, applications that can change shape and purpose on-the-fly, enhancing the user experience by not reloading the page and minimizing future coding by developers.
Migrations to Linux Panel– RM #57 Sandra Vucinic, VLAD Group, Inc. This panel will discuss necessary steps and tasks to migrate Oracle database and Oracle 11i E-Business Suite from any platform to Linux platform. This panel of experienced database administrators will share with the audience experiences, tips and Linux migration techniques. Further, panel will review a new tool introduced by Oracle Linux Platform Migration utility, that allows customers to move existing Oracle Applications to Linux OS. Pros and cons of using this tool will be discussed. Attendees will gain practical knowledge of what it takes (including resource requirements, project steps and timeline) to successfully migrate and run Oracle Ebusiness Suite and database on Linux platform.
3:15pm – 4:00pm -------------------------------------------------------------VENDOR PRESENTATION RWD uPerform™ – RM #42 Nancy Williams, RWD Technologies Today’s business realities require that we continually seek to improve performance. The ability to do this is dependent on employee’s ability to adapt, learn and retain knowledge to do their jobs effectively. Because 80% of what we learn is learned on the job, it is critical that we enable end users to build up their own knowledge by interacting with their environment and address informal learning requirements by helping companies build communities of practice amongst employees with similar job roles and responsibilities. This session will discuss how RWD uPerform™ delivers solutions for organizations seeking to capture, share and retain knowledge that improves worker performance, productivity and collaboration across business units.
Internal Controls & Compliance Using Oracle Applications– RM #43 Jeff Taylor and Pathik Mody, Deloitte This presentation provides details on the requirements for, challenges with, and considerations to be made when implementing an internal controls and compliance initiative in your company. Real-life implementation examples and ideas will be provided, with details as to the configuration and rollout of a compliant environment. E-Business Suite R12, New Features – RM #45 Sara Surenders, Orabyte LLC. This is a overview class for ERP Architects and DBA's. Learn about R12 changes in JVM, Techstack, workflow, purging, Monitoring System Health, Networking & Architectures, Optimizing Performance, Patching Apps, Portal Integration. Using FSG's and ADI to Create and Review Financial Statements – RM #47 Andrew Diamond, DARC Corporation Your manager has asked you to create several Balance Sheet and P&L's by tomorrow morning. They must be created in a format that allows regeneration on a monthly basis without manual keying. In addition, you just know your manager will be asking for explanations about individual line items. Help!!!!
Discrete Manufacturing in a Process Environment – RM #49 Jason Bletz, New Generation Consultants This paper will discuss how and why discrete manufacturing was implemented at a BioTech company. The manufacturing of DNA Assays required discrete tracking capabilities. I will discuss the requirement of how parent item work orders needed to be
linked to specific component work orders in order to join the unique parts at the end of the production process to produce a viable assay. All this while limiting part numbers in the item master and reporting throughput costs rather than job costs. I will also discuss how workflows form order management were used to initiate the whole process as well as how generic BOMS and items were needed to avoid a possible item master of 300 million parts needed for specific DNA sequence tracking.
Enterprise Planning and Budgeting: Three Case Studies - The Good, Bad, and Ugly – RM #53 David Fuston, Linium, LLC We will talk about our experiences as early adopters, where the successes occurred in version 1 and 2 (a.k.a., ZPB.A and ZPB.B), what the technical challenges were and what still remains. We will identify the patches and strategies critical to our success using 20/20 hindsight for three different implementations. We will begin with a synopsis of the business case for EPB in each of the three environments, what alternatives were considered, what the strategic objectives were, and how the projects teams were structured. One project was a MS Excel budgeting system migration to EPB in retail sector, another project was an OFA actuals and forecast reporting migration to EPB migration in manufacturing sector, and the last project was a standalone implementation of EPB from scratch in conjunction with a data warehouse in a Federal DoD environment. Our methodology for requirements gathering, technical development, unit test, application test, user hands-on feedback, test and training setup, and production deployment will be shown in conjunction with the objectives for each phase for each project. After we have established the business case for each project, we will switch our focus to the technical implementation and how this was accomplished. Once we have completed the technical overview, we will then discuss our real life experiences as an early adopter of EPB, why EPB was chosen in each of the three project, and what kind of a team effort it takes to get the EPB application to stand up and perform. We will discuss the architecture and design of the FEM schema, identify areas of concern, required versions and patches, possible workarounds, significant TAR(s) and their resolution, and cover many of the technical hurdles necessary to make each implementation a success.
Oracle Applications Framework (OAF), Foundations with Java - RM #52 Lance Reedy, Solution Beacon The new Oracle Applications environment is being built out of an array of Java and open standards that are being built into Oracle Applications Framework and Developer Framework products. Deciphering the resulting mix of standards and acronyms can challenge even the most experienced developers. This presentation will sort the products into a easily understood set, identify the usage of each component, and attempt to highlight where there are Oracle specific nuances. Armed with the concepts covered in this presentation, developers can begin building the skills needed for creating leading edge Java applications.
VENDOR PRESENTATION Kill Two Birds with One Stone. Follow These Best Practices of Maintaining the Oracle E-Business Suite while Getting Compliant for Free – RM #57 Bryan McGee, RingMaster Software Increasing business productivity is never considered by legislators. Productivity is down since the introduction of Sarbanes-Oxley requirements. Compliance regulations have forced IT organizations to examine their practices of maintaining the Oracle E-Business Suite and it has resulted in some significant improvements, especially the introduction of solid change management practices. Other organizations have been clever enough to not only solidify the best practices of change management, but by automating procedures, they have simultaneously realized productivity gains. This paper discusses how you can regain productivity by automating change management practices while you apply changes to your E-Business Suite system.