OAUG Connection Point® — AppsTech Online session materials are now available to OAUG members for download from the OAUG Conference Paper Database.
Tuesday, July 28
Tips and Techniques to Troubleshoot WebLogic Server Performance Issues
This session would provide tools and techniques to effectively troubleshoot performance issue on Fusion Middleware environment like Stuck Threads, Memory Leaks or any slowness on the system.
Best Practices For Extending Oracle E-Business Suite R12.2
This presentation is about extending your Oracle E-Business Suite application with some advanced techniques such as Oracle User Hooks, Processing Constraints, Key Flexfields on Descriptive Flexfields and Securing DFF’s. User hooks will consist of mostly used ones such as pricing, payable invoice validation, purchase approval, and HRMS APIs. Besides, some tips and tricks such as Online Patching with hands-on implementation experience will be presented and sample codes will be shown.
Oracle Advanced Compression: Taming SLA growth Challenge after Upgrade
Application Upgrade from 188.8.131.52 to 12.1.3 presented significant challenges in terms of Storage Footprint. Growth of the database increase from 6GB/Day to about 20GB/Day, after introduction of SLA tables. Purpose of the following presentation is to a) Present Strategy which we implemented in order to reduce growth of Database. b) Integrate Advanced compression with Archive Purge Strategy to keep database growth within expected growth limits. c) Cleanup procedures which we followed to reclaim space which was cleared up after advanced compression. d) Testing Methodology and Procedures we utilized to Performance test.
WebLogic Administration for R12.2 Apps DBAs: Beyond Basics
WebLogic is a new Application Server for Application DBAs. Coming from BEA WebLogic world, I have a lot of WebLogic world experiences to share with Application DBAs. I will cover WebLogic fundamental differences with OC4J (i.e. R12.1 vs R12.2 Application Servers), Common WebLogic Administration tasks, JVM Tuning, JDBC Tuning, WebLogic Patching, WebLogic Domain Deployment in R12.2, Tuning WebLogic Servers in R12.2, Making Configuration changes in R12.2 WebLogic, and Creating the R12.2 WebLogic Domain from scratch in the event of a failure, and many more tips and techniques for Application DBAs to run WebLogic effectively.
Technical Upgrade Best Practices for Oracle E-Business Suite 12.2
This session is ideal for organizations thinking about upgrading to Oracle E-Business Suite 12.2. It covers the fundamentals of upgrading to Release 12.2, including the technology stack components and supported upgrade paths. Hear from Oracle Development about the recommended practices for executing the Release 12.2 technical upgrade, with special considerations for minimizing your downtime. Also get to know about relatively recent upgrade resources.
The Big Picture of the R12.2.4 Upgrade
Release 12.2 is the latest version of the eBusiness suite. When should you consider upgrading to 12.2 vs 12.1.3? Ease your worries by attending this session, an overview of the upgrade from Release 11i and R12 to Release 12.2.4. I’ll describe the tried and true tips and techniques to ways to decrease your down time. We’ll discuss actual upgrades from 11i and 12.1.X to 12.2.4 as well as R12.2 Architecture concepts, including ADOP, the Online Patching Utility and the basics of the Weblogic server. The Big Picture shows at a high level the tasks and challenges of the R12.2.4 upgrade. It covers the technical upgrade steps and a few of the most important functional steps.
Wednesday, July 29
Our journey: using PaaS to extend Oracle Cloud Applications
Certus Solutions are committed to Oracle Cloud Applications (Fusion), but through our growing customer base have identified gaps or organisation specific functionality which needs to be addressed. We believe what makes Oracle different is the User Experience of Fusion and thus we announced plans to extend using PaaS. This is the story of our journey to date, what that means, how to extend, how we approached it and how Oracle helped. Not just a simple project but how we became a customer of Oracle PaaS and entered the brave new world of Fusion Ready Apps.
R12.2 Upgrade Customer Panel
The objective of this panel is to provide feedback on each clients experience upgrading to Oracle EBS R12.2. These end users represent a variety of industries providing different experiences and perspectives so the panel should be appealing to many organizations considering upgrading.
Upgrading an EBS Database to 12c with a Platform Change
This session will discuss the options considered and the final solution picked for a customer running R12.1.3 on Redhat Linux 5 with 184.108.40.206 on Solaris for the database, who needed to migrate to R12.13 with 220.127.116.11 for the database both on Redhat Linux 6. This migration was done as the first step in an upgrade to R12.2.4. This presentation will discuss the pitfalls encountered alone the way to a successful platform migration.
Workflow Setups That Make A Difference
Worklist Flexfields and custom notification views, exporting notifications to Excel, assistant administrators, using grants instead of worklist access to see SYSADMIN’s emails, controlling the LOV for the recipient for vacation rules and worklist access (12.2 only) are a few of the advanced and mostly undocumented setups that can increase your organization’s use and administration of workflow. Listen to Oracle ACE and author explain how to install and use these setups. Many of these setups are available in R12.1.3, but the presentation will cover new setups available only in R12.2
KPI your E-business Suite - An Oracle APEX solution
Extend Oracle Applications Manager using oracle apex based dashboard to business and applications team to report on Key performance indicators. Typical tools include alerts, thresholds, and setups for operations only. Also missing is graphical content. An apex dashboard with HTML5 charts, gauzes and drill down capability integrated into E-business suite. Examples include holistic view on invoices, purchase orders, sales orders, service orders, bank interfaces, integrations, Printing, Workflows, Notifications, Customization, Patches, Top Jobs, Long Running, and Queue Optimization
Concurrent Manager Express Lane: 15 Seconds or Less Please
How many times have you been at the grocery checkout trying to buy a pack of gum and you are stuck behind a person with an overflowing grocery cart? Isn’t it the same feeling when your concurrent program that completes in under a minute is stuck behind jobs running for an hour or longer? It is time to say enough, we’re not going to take it anymore. There has to be a better way. Well there is and we will show you all the steps to implement a time based concurrent manager model that will maximize batch throughput. We will also present two methods for better concurrent manager purging.
Thursday, July 30
Oracle Applications R12.1 Database 12c Upgrade
This session will provide an overview of 12c database upgrade steps for Oracle Applications R12.1/R12.1.3 environment. The session will go into install and pre/post issues/bugs faced by a real customer along with all the interoperability patches required for R12.1.
Advanced and Untold Tips and Techniques for Oracle Access Manager with Oracle eBusiness Suite
Oracle Access Manager (OAM) Integration with eBusiness Suite (EBS) is one of the most challenging tasks for Application DBAs. As a Senior Solution Architect in GE for more than 400 EBS system integrations with OAM SSO and OID, I have fine tuned the integration procedure to reduce errors, minimize the integration time, increase hardware resource consumption, and simplify the solution. For example, you dont have to run 10 WebLogic domains to run 10 EBS environments with OAM. You could rather use a single domain to host all AccessGates. So is the case with WebGates. You’ll be amazed with our level of expertise on OAM & EBS integration.
Migrating and Managing Customizations for Oracle E-Business Suite 12.2
Have you created custom schemas, personalized or extended your Oracle E-Business Suite environment? Attend this Oracle Development session to learn about selecting the best upgrade approach for existing customizations. This session will help you understand the new customization standards required by the Edition-Based Redefinition feature of Oracle Database to be compliant with the Online Patching feature of Oracle E-Business Suite. You’ll learn about customization use cases, tools, and technologies you can use to ensure that all your customizations are preserved during and after the upgrade. You’ll also hear about reports you can run before the upgrade to detect and fix your customizations to make them 12.2-compliant.
User Management Roles and Grants for Function and Data Security: Configurations required in R12
The configuration requirements for user management, along with grants for function and data security is rapidly expanding with each new release/patch set. This presentation provides the building blocks to understand how Oracle User Management (UMX) utilizes roles, function and data security features to strengthen access controls within the E-Business Suite. The newest changes in releases 12.1.3 and 12.2 that may surprise you during your implementation or upgrade will be demonstrated. Some of these examples are: (1) flexfield value set security to support separation of duties (required configuration) (2) Access to concurrent requests run by others (now requires grant configuration) (3) Integration Repository Access (4) Cash Management Security Wizard (required configuration)
A Sure Thing: Extending the E-Business Suite with Application Express (APEX)
Application Express (APEX) is a rapid application development tool that can be used to easily extend E-Business Suite functionality. APEX's ease of use and short learning curve make it an ideal development tool for DBAs and functional users. This session details the creation of an APEX application to add the ability to automate the request and approval for personnel actions within the E-Business Suite. The application is integrated with the E-Business Suite security model and with the Human Resource module.
Upgrading Oracle E-Business Suite (VCP - ASCP/Demantra) to 12.2.3
Sherwin William has upgraded it’s Oracle VCP (ASCP/Demantra) implementation to R12.2.3, running on Engineed Systems. This session will cover, business driver for adoption of EBS R12.2, experience with upgrading ASCP and Demantra to R12.2.3, challenges faced with Demantra customizations, key tasks involved in EBS 12.2 upgrade, lessons learned, performance improvements of Advanced Supply Chain and Demand Planning processes. This session emphasize leveraging the new capabilities of OnLine Patching in R12.2, running Demantra Analytical Engine and Collaborator Workbench on Linux using WebLogic.