Go to page content
OAUG Connection Point® Seminars
OAUG Connection Point® — AppsTech
July 11-15, 2016
↓ ↓ Menu ↓ ↓

Monday, July 11

11 a.m. - 12 p.m. EST

R12.2 Extension and Development Tips and Tricks

John Peters

With R12.2 custom development now more than ever needs to follow standards. In this session I will share my 20+ years of Oracle EBS development experience and provide an exhaustive list of tips and tricks I have used throughout the years. I will emphasize what is critical now in R12.2 while providing lists of my development standards the go beyond the Oracle Development Standards that will make your extensions easier to maintain and debug.

Registered users may download the presentation slide deck (PDF file) and session recording (MP4 file).

1 p.m. - 2 p.m. EST

EBS Reports and Dashboards for the People by the People

Patrick Cimolini

Learn how to create flexible ad-hoc reports and dashboards by using Oracle Application Express (APEX) to present your Oracle E-Business Suite (EBS) data. EBS uses older reporting technology that tend to present static report layouts. Also, EBS drilldown dashboards are difficult to implement. APEX circumvents these shortcomings by allowing you to easily create an EBS reporting environment by using APEX Interactive Reports and Dashboards that have powerful drilldown capability.

Registered users may download the presentation slide deck (PDF file) and session recording (MP4 file).

3 p.m. - 4 p.m. EST

EBS Developers - Preparing for Life in the Cloud

Scott Mankin

The transition to Cloud is not just coming, it is here. EBS application developers have an opportunity to leverage existing skills on future projects that are sourced as a SAAS offering. While familiar tools are provided for Oracle developers to extend the core application, many restrictions are also in place and developers need to know the customization possibilities to be effective. This presentation will review Cloud development from the perspective of an EBS lifer to highlight technical restrictions, extension opportunities and the new competencies that are required to get the job done.

Registered users may download the presentation slide deck (PDF file) and session recording (MP4 file).

5 p.m. - 6 p.m. EST

After the Clone: Things adcfgclone Doesn’t do…

James Morrow

Oracle’s E-Business Suite cloning tool is a tremendous help in managing E-Business Suite environments and has been improving over time. Unfortunately, there are still a number of things that it doesn’t do. Here we will discuss ways to produce a more complete and consistent clone of E-Business Suite.

Registered users may download the presentation slide deck (PDF file) and session recording (MP4 file).

Tuesday, July 12

11 a.m. - 12 p.m. EST

Turbocharge your E-Business Suite Development with Oracle Application Express!

Alfredo Abate, Brake Parts Inc

This presentation will demonstrate how you can turbocharge your E-Business Suite 12.1.3 Development with Oracle Application Express 5.0. Oracle Forms, Reports and Application Framework development are not going anywhere but what if you could do much more much quicker? What if you could turn project development around in hours instead of days or weeks? Meet (or beat) your deadlines and make your business users happier. With Oracle Application Express (APEX) you can rapidly produce highly scalable applications that can be easily integrated with Oracle E-Business Suite 12.1.3. Learn about the Oracle APEX 5.0 architecture and how it can be configured with Oracle E-Business Suite 12.1.3. A demonstration of how you can rapidly turn a SQL query into an Oracle APEX interactive report will be presented. Additionally, a demonstration of a real use case of how we solved an Accounts Payable business issue with an Oracle APEX application.

Registered users may download the presentation slide deck (PDF file) and session recording (MP4 file).

1 p.m. - 2 p.m. EST

Grants That Make A Difference

Karen Brownfield, InfoSemantics

Grants secure access to data and/or actions on data. Oracle is using this functionality more and more in each subsequent release. Without creating grants, 12.1 no longer permits access to any reports except those you ran. Without grants, in 12.2.4 and higher, NO ONE has access to view/update flexfield value sets. This presentation will explain what a grant is and give several examples of using grants to selectively enable access and actions. This knowledge will enable organizations to increase their controls but at the same time, increase the ability of appropriate individuals to perform their jobs

Registered users may download the presentation slide deck (PDF file) and session recording (MP4 file).

3 p.m. - 4 p.m. EST

WEBADI Can Do More Than Journal Entries!

Karim Asebbane

WEBADI is a powerful tool that can do much more than Journal Entries. Learn how to get the most out of WEBADI and discover the possibilities. This session will show how to leverage Oracle’s APIs for HRMS to create/maintain employees information, contacts, salaries and raises. How to use WEBADI with Inventory module to create or update Items, BOMs and Routes. And how to upload data to custom tables using your custom built PL/SQL Packages.

Registered users may download the presentation slide deck (PDF file) and session recording (MP4 file).

5 p.m. - 6 p.m. ET

Best Practices for Getting Started With Oracle Database In-Memory

Maria Colgan

Oracle Database In-Memory is one of the most fascinating new database features in a long time, promising an incredible performance boast for analytics. This presentation provides a step-by-step guide on when and where you should take advantage of Database In-Memory, as well as outlining strategies to help you ensure you get the promised performance boast regardless of your database environments. These strategies include how to identify which objects to populate into memory, how to identify which indexes to drop, and details on how to integrate with other performance enhancing features. With easy-to-follow real-world examples, this presentation explains exactly what steps you need to take to get up and running on Oracle Database In-Memory.

Registered users may download the presentation slide deck (PDF file) and session recording (MP4 file).

Wednesday, July 13

11 a.m. - 12 p.m. EST

Automating Your Clone in E-Business Suite R12.2

Mike Brown

Businesses rely on cloning their production E-Business Suite environment for a variety of reasons including development, support, and reporting.  The 12.2 release of the E-Business Suite has increased the complexity of the cloning process.  This session will review the required steps for making a clone of a 12.2 environment using Rapid Clone, discuss what can be done to automate this process, cover the impacts of an open patch cycle on the clone, and review required post Rapid Clone steps.  This session will also cover how these topics can be applied to earlier releases of the E-Business Suite.

Registered users may download the presentation slide deck (PDF file) and session recording (MP4 file).

1 p.m. - 2 p.m. EST 

Personalize and Extend Oracle E-Business Suite for Desktops and Mobile Devices

Vijay Shanmugam and Maher Muhanna, Oracle

This Oracle Development session explains how to personalize and extend your Oracle E-Business Suite applications. See the latest personalization capabilities in Oracle Application Framework, and learn about gesture support and other Oracle Application Framework features intended to optimize operation on iOS or Android tablets. Also learn about the technologies and approach used to build smartphone apps for Oracle E-Business Suite, including services available for authentication, session management, and more.

Registered users may download the presentation slide deck (PDF file) and session recording (MP4 file).

3 p.m. - 4 p.m. EST

The Release 12.2.5 Upgrade: Online Patching and Customizations

Mike Swing, TruTek

Release 12.2 is the new standard for the E-business suite. What do you need to focus on to complete your 12.2 upgrade: Online Patching, Customizations? Ease your worries by attending this session, an overview of the upgrade to Release 12.2.5. I’ll describe the tried and true tips and techniques to ways to decrease your down time. We'll discuss the upgrade to 12.2.5, R12.2 Architecture concepts, including ADOP, the Online Patching Utility, apply ng customizations and the Weblogic server. We will discuss in detail how to modify customizations to make them minimally online patch compliant or fully online patch enabled. Understand the detailed technical steps required to upgrade to R12.2.5. Learn about ADOP, the Online Patching Utility, the options and how to use the options. Examine the required steps to fully enable custom code for online patching.

Registered users may download the presentation slide deck (PDF file) and session recording (MP4 file).

5 p.m. - 6 p.m. EST

Configuring a DMZ in an Oracle E-Business Suite 12.2 Environment with Reverse Proxy

Rajesh Tenukuntla, Application Software Technology (AST) Corporation

This session shares the possible configuration methods that are available to configure a demilitarized zone (DMZ) in the new Oracle E-Business Suite 12.2 environment. The session details the steps involved in configuring Oracle E-Business Suite with reverse proxy to set up access to external applications, such as Oracle iRecruitment and Oracle iSupplier Portal. The differences between setup for Oracle E-Business Suite 12.1 and Oracle E-Business Suite 12.2 are also covered.

Registered users may download the session recording (MP4 file).

Thursday, July 14

11 a.m. - 12 p.m. EST

Survival Tips for Upgrade to E-Business Suite Version 12.2

Brian DeFrates

In Southern Company's Enterprise E-Business Suite upgrade from release 11i to release 12.2, we were able to successfully complete the project in less than 12 months. This session is to share the lessons learned from our upgrade to prepare you for the journey. We will explore topics related to that upgrade, such as the impacts of E-Business Suite application changes, including subledger accounting and payables. We will share changes required to business processes, an overview of technology stack changes and the impact of the upgrade on customizations and extensions. Finally, we will share upgrade best practices.

Registered users may download the presentation slide deck (PDF file) and session recording (MP4 file).

1 p.m. - 2 p.m. EST

R12: Reducing the data footprint of Oracle E-Business Suite

Rusty Schmidt, Apollo Group, Inc. (Univ of Phoenix)

Eliminating the data elephant in the room one byte at a time, there are many tips and tricks that you can learn which will allow you to reduce the footprint of your Oracle e-Business Suite application like: researching tables and tablespaces, R12 specific changes, file system bloat, data backups, interface tables, user data storage, purging, archiving, and compression. I will share my experiences with going through a project to reduce space consumption in our environment, and what steps we took to make the system more proactive.

Registered users may download the presentation slide deck (PDF file) and session recording (MP4 file).

3 p.m. - 4 p.m. EST

Getting the Best of Oracle Cloud Enterprise Manager 12c

Austin Davis, Chain-Sys Corporation

To drive down the managerial aspect of your application, middle ware, databases and server hosts, we need to leverage the advantages of EM 12c. Few important drill down out-of-box features of 12c EM includes, RMAN backup setting up, creating and managing physical standby databases, implementing Load Balancers and cloud management. This paper discusses the full advantage of Oracle Cloud EM 12c rather than using EM for basic capabilities, such as monitoring, metrics, bottle-necks, alerting through e-mails.

Registered users may download the presentation slide deck (PDF file) and session recording (MP4 file).

5 p.m. - 6 p.m. EST

The 60 Minute APEX Extension for EBS

Sylvain Martel

This 60 minute session will give you 60 great reasons to use Oracle Application Express (APEX) the next time you want to customize Oracle E-Business Suite (EBS). That’s because 60 minutes is all it takes to create a fully functional EBS extension. You will see the explicit steps required to integrate APEX with the EBS environment, including profile options, multi-org and language support.

Registered users may download the presentation slide deck (PDF file) and session recording (MP4 file).

Friday, July 15

11 a.m. - 12 p.m. EST

Application Upgrades Panel Discussion

Panel: Mike Brown, Susan Behn, Sandra Vucinic, Mike Swing

This panel will discuss differences between available release 11i, R12.1 and R12.2 cloning methods. Advantages and disadvantages of each cloning method will be discussed in depth. This panel of experienced database administrators will lead a discussion focusing on the questions such as “which cloning method is best to use in your particular environment”. Attendees will gain practical knowledge, tips and tricks to assist with cloning of Oracle E-Business Suite release 11i, R12.1 and R12.2 environments.

Registered users may download the session recording (MP4 file).

1 p.m. - 2 p.m. EST

Tips to Extend OA Framework Pages: Case Study

Manjula Ganapathi, Johns Hopkins University - Applied Physics Laboratory

Oracle Application Framework (OAF) extensions is geared to enable the users to add new functionality by overriding or extending existing business logic which cannot be accomplished using OAF personalization. OAF extensions are implemented by modifying the underlying code or by implementing new code. This presentation will focus on few business case studies for OAF Extensions by analyzing the real time requirement, and provide tips on when and how to write extensions to meet the requirements. Focus of the presentation will also include the steps involved in migrating the xml file and class files to the server.

Registered users may download the presentation slide deck (PDF file) and session recording (MP4 file).

3 p.m. - 4 p.m. EST

OAF Personalization Examples — Great rewards with low effort

Susan Behn, InfoSemantics

This presentation benefits managers who need to know what can be done easily as well as functional superusers and developers who need to understand what can be done without customizing and how to do it. There is something for everyone. OAF personalizations can add significant value to your business with very little effort. Potential benefits include streamlined processing, improved audit controls, improved customer experience, setting default values, adding fields, tips and tables to existing pages and much more. Oracle is continuing improving the user interface by adding more features in this area. I will include examples new to 12.2 and plenty of examples that still work with functionality in 12.1, 12.0 and even 11i.

Registered users may download the presentation slide deck (PDF file) and session recording (MP4 file).

5 p.m. - 6 p.m. EST

Patch Wizard for the Masses: An APEX Version of the Patch Impact Analysis Reports

Chad Johnson, Polk County

This session will demonstrate how Application Express (APEX) can be used to generate custom, user friendly reports of the patch impact analysis to any functional user — in summary and in detail. Patch Wizard provides a great deal of useful information to patch testers. Unfortunately, to view the reports the user must have System Administrator rights which are seldom given to functional users. The lists of affected files and menus are not presented in an easy-to-use format. Learn to overcome these issues.

Registered users may download the presentation slide deck (PDF file) and session recording (MP4 file).