ATG Genie – AD Wish List Recommendations

At OOW12, the ATG CAB reviewed the existing wish lists for R12.2 for each ATG module and asked for new recommendations for the wish list. I requested 6 or 7 new wishes, and I was granted 4 wishes.

ATG CAB Wish list itemPlease send me your ideas for your wish list and I’ll forward them to the ATG CAB. Anything you really need can be requested. If it makes sense to the development groups they will submit a bug and you’ll be granted your wish.

 

 

 

 

Oracle Demo Presentations

Here are some of the URLs for the presentations at the Oracle Demo area:

http://www.oracle.com/us/solutions/optimized-solutions-171609.html?msgid=QROOW11

http://www.oracle.com/technetwork/oem/em-oow2011-content-454204.html?msgid=QROOW11

http://www.oracle.com/goto/optimizedsolutions?msgid=QROOW11

http://www.oracle.com/us/products/servers-storage/storage/index.html?msgid=QROOW11

http://www.oracle.com/us/technologies/virtualization/oraclevm/index.html?msgid=QROOW11

http://www.oracle.com/technetwork/developer-tools/adf/overview/index-092391.html?msgid=QROOW11

http://www.oracle.com/technetwork/middleware/soasuite/overview/index.html?msgid=QROOW11

http://www.oracle.com/technetwork/oem/em-oow2011-content-454204.html?msgid=QROOW11

http://www.oracle.com/technetwork/developer-tools/adf/overview/adf-mobile-096323.html?msgid=QROOW11

http://www.oracle.com/us/technologies/soa/index.html?msgid=QROOW11

http://www.oracle.com/us/products/applications/upk/index.html?msgid=QROOW11

http://www.oracle.com/webcenter?msgid=QROOW11

Oracle Open World 2011

Oracle Open World 2011 was the best ever! Everything is big at OOW. Exadata was everywhere.

Awesome presentations including some of my favorite presenters/authors, Tim Gorman, Cary Millsap, Debra Lilley, Dennis Horton and Deep Ram, Tanel Poder, Nadia Bendjedou and Cliff Godwin.

My Favorite presentation was from Cary Millsap on his presentation on “Skew”. Skew is everywhere. Did you know the average number of legs per person was 1.99? Why is it not greater than 2, because there are no three legged humans. (This is the best picture I could get of Cary, he thinks best when he’s moving).

The James Bond joke, if you don’t know what a Thermos is and someone tells you that it keeps hot things hot, and cold things cold, why didn’t it work when I put my coffee and my popsicle in my thermos?  Understand your data.

Skew exists everywhere, especially in systems, charaterized by CPU, memory, disks and networks. In 11.2.0.2 there are 1118 system calls, 6 dba calls and 2 psuedo calls. The system  processes are dominated by system calls, with a few critical DBA calls.

The Upgrade SIG

From Oracle: Nadia Bendjedou, Max Arderius, Lester Gutierrez , Anne Carlson

Chairperson – Barb Matthews, Panelists included: Sandra Vucinic (moderator), Kaberi Nayak, Bill Dunham, Michael Brown, Susan Behn and Mike Swing.

 Oak Table dinner sponsered by our gracious host Mogens Norgaard of Miracle AS included Tanel Poder, a real superman. Tanel has an excellent book out on ExaData.

The dinner was held at the Franciscan Crab Restaurant and the crab was truly better than I’ve ever had.

The conference had lots of exhibitors, two of our favorite are 2e2 (with a product called ConfigSnapshot) and ePrentice.  

One of the exhibitor gifts was a sumo wrestler from Hitachi Consulting, who looks interested in the Oracle Racing Team.

 

 

 

But the best gift of all, was winning back the America’s Cup. Thanks, Uncle Larry. The first model ship I ever built was the America, after reading a book about sailing.

 

 

Best two quotes from OOW on Monday

The first quote came from the presentation of the day, when Cary Millsap said. “When I look at the sky I see Mickey Mouse’s head”, in relation to understanding skew in idle wait events.

The second best quote came from Debra Lilley with regard to upgrading to R12.1.3 or waiting for Fusion. “Don’t Do Nothing”.

Monday at Oracle Open World

Awesome presentations including some of my favorite presenters/authors, Tim Gorman, Cary Millsap, Debra Lilley, Dennis Horton and Deep Ram, Tanel Poder, Nadia Bendjedou and Cliff Godwin.

My Favorite presentation was from Cary Millsap on his presentation on “Skew”. Skew is everywhere. Did you know the average number of legs per person was 1.99? Why is it not greater than 2, because there are no three legged humans.

The James Bond joke, if you don’t know what a Thermos is and someone tells you that it keeps hot things hot, and cold things cold, why didn’t it work when I put my coffee and my popsicle in my thermos?  Understand your data.

Skew exists everywhere, especially in systems, charaterized by CPU, memory, disks and networks. In 11.2.0.2 there are 1118 system calls, 6 dba calls and 2 psuedo calls. The system  processes are dominated by system calls, with a few critical DBA calls.

This system basically makes calls to the system and to the database.

The main idea was to illustrate the common misconception that idle wait events can be ignored. The answer is, you have to drill down to the exac cause of the wait and not look at summary data that represents median values or averages.

Cary summarized his Method R process: Identify the Important Task, Measure the Response Time, Optimize Response, Repeat until satisfied.

Check out Simpson’s paradox, a baseball statistical conundrum. Bobby Bragan the 1966 manager of the Atlanta Braves, was quoted as saying, “If you have one foot in the oven and one foot in the icebox, the percentages would say you’re fine”.

Drill down on each issue and remove the skew from each case by understanding the details of each wait.

 

 

Nadia’s clarifications of the R12 Upgrade SIG Summary

 Corrections to my earlier summary of the R12 Upgrade SIG from Nadia. Thank you Nadia.

1)      [Mike said] Some initial promises about that capability have been nixed and the rule is Oracle will support 11.5.10.2 and 12.1, but when 12.2 comes out 11.5.10.2 is history.

a.       [Nadia edits]: The rule is that Oracle supports upgrade path from the last 2 releases of EBS, for example for Fusion V1 only 12 and 12.1 are ! the supported releases for Upgrade to Fusion. Hence 11i10 will not have an upgrade path to Fusion directly (of course the alternative for 11i10 customers is to re-implement in Fusion).

2)      [Mike said] Nadia explained that some products used in EBS, such as Forms, will be continued to be supported by the EBS group, even if they are desupported by the development group.

a.       [Nadia edits]: If a technology, that is used by EBS functionality, is desupported by the technology team at Oracle, then EBS will take over the support for that technology as long as it is needed by EBS functionality. A good example is the Oracle Workflow, which is a pre-req for EBS and is now supported by Oracle EBS development team and not by the Oracle Technology team. If one day, Oracle Forms are desupported by the technology organization and as long as Forms are required by EBS, then EBS will guarantee its support through the life of EBS.

      A few CEMLI questions came up and I thought Nadia said the CEMLI tool would become available without requiring a consulting engagement.

a.       [Nadia edits]: CEMLI is a great tool to report on the customization, but what is also interesting is to understand where those CEMLIs are being used in the customization. There is a session at Oracle OpenWorld that talks about the CEMLI Analyzer, a tool to help customer figure out the impact of CEMLIs, figure out where each customization is being used. The session is called “20920 – Oracle E-Business Suite: CEMLI Impact Analyzer”  on Thursday at at 3pm, Moscone West, Rm: 2014:

OOW Sunday Sessions I Liked

The R12 Upgrade SIG, see below post for the details.

Craig Shallahamer, as usual, had spectacular data points, charting and graphic representations of complex ideas in his presentation “Introduction to Oracle Buffer Cache Internals”. This was not an introduction, but a detailed thesis on the proper configuration and troubleshooting of the Buffer Cache. Bravo.

Kamran Agayev gave a very good overview of “11g RMAN New Features”. I was very impressed with his research, demos and presentation skills (video in his powerpoints!).

Tim Gorman, the godfather of Data Warehousing, presented “Partitioning – Scaling to Infinity and Beyond”. Excellent, I seen this presentation a dozen times and still learn something new each time.

 

OOW R12.1 Upgrade SIG

Chairperson – Barb Matthews, Panelists included: Sandra Vucinic (moderator), Kaberi Nayak, Bill Dunham, Michael Brown, Susan Behn and Mike Swing.

This was a very informative panel with major interaction with the EBS product team including Nadia Bendjedou, Max Arderius, Lester Gutierrez , Anne Carlson and another lady from support who seemed well integrated into the development cycle.

The first question is the question Nadia gets asked all the time; Why not wait for Fusion to upgrade from 11.5.10.2? Some initial promises about that capability have nixed and the rule is Oracle will support 11.5.10.2 and 12.1, but when 12.2 comes out 11.5.10.2 is history.

I answered the question based on Nadia’s presentation, that we should strive to stay current on our application release and prepare our customizations for Fusion by converting to a Fusion supported framework:  OBIEE, BI Publisher, JDeveloper/ADF and Enterprise Manager.

The second question was, “Why not wait for 12.2. and skip the 12.1.3 Upgrade?”

My answer was that the tech stack change to the application server, WebLogic, would complicate the upgrade and since R12.2 is not released, there is no guaranteed upgrade patch from 11.5.10.2 to R12.2. Michael Brown added that customers waiting for the R12.2 upgrade would run out of support before 12.2 was released. I stressed the importance of the 12.1.3 Upgrade, as not only the biggest financial change to EBS in years, but that users will need time to fully utilize the new SLA  functionality.

Floyd Teter interceded, though I chastised him for not asking questions, but making comments, even though he was no longer on the Upgrade SIG panel. This is pure jest, as I had invited Floyd to make comments, but had to give him a “hard time” for jumping in without a formal invite from Sandra, the moderator.

A further qualification of support as it relates to when the products are released was offered by Nadia. For instance, R12.1 was released in May 2009 and will be supported with premium suppport for 5 years. There will be another 3 years of extended support, followed by sustaining support. The bottom line is, you don’t want to be on sustaining support. If you’re using Payroll, that requires yearly updates, these updates are not included in Sustaining support. That means extended support for 11.5.10.2 will end November 2012. Any customers on Payroll will want to be upgraded before 2013.

Max added that extended support for R12.1.3 would be valid through June 2017.

The next question was about upgrade or re-implement. Everyone agreed that the upgrade process from 11.5.10.2 to R12.1.3 was robust and well documented and was far cheaper than re-implementing.  Someone pointed out that Oracle re-implemented, but that was before the advent of Upgrade by Request. In addition, Bill Dunham suggested that many Chart of Account changes may not really require re-implementation. Furthermore, ePrentice has a product that can map the new COA to the old COA eliminate the need to re-implement.

Nadia explained that some products used in EBS, such as Forms, will be continued to be supported by the EBS group, even if they are desupported by the development group. From this we found out that the 10.1.2 Forms home currently in R12.1 will be maintained by the EBS group and that Forms will be with us even in 12.2.

A few CEMLI questions came up and I thought Nadia said the CEMLI tool would become available without requiring a consulting engagement.

Mike’s OOW Schedule

Here’s my schedule during Open World. During the breaks I could talk with R12.1 Upgrade customers and help answer R12.1 Upgrade questions. Otherwise, I’ll spend some time at “Closed World”, sponsored by Miracle AS and have some fun with the “Oakies”.

Oracle Business Intelligence Enterprise Edition 11g Architecture 10/2/2011 10:15 AM 10:45 AM Moscone West 2003 Mark Rittman
28360 — Upgrade SIG 10/2/2011 10:45 AM 11:45 AM Moscone West – 3004
08949 — Introduction to Oracle Buffer Cache Internals 10/2/2011 12:15 PM 1:15 PM Moscone West – 2006
28224 — Demantra SIG 10/2/2011 1:45 PM 2:45 PM Moscone West – 3002
06787 — Oracle Recovery Manager (Oracle RMAN) 11g New Features 10/2/2011 2:45 PM 3:45 PM Moscone West – 2006
28240 — Atlanta OAUG 10/2/2011 4:15 PM 5:00 PM Moscone West – 3007
32180 — Oracle OpenWorld Welcome Keynote 10/2/2011 5:30 PM 7:00 PM Moscone North – Hall D
32181 — Oracle OpenWorld Keynote: Oracle and EMC 10/3/2011 8:00 AM 9:45 AM Moscone North – Hall D

16800 — General Session: Oracle E-Business Suite: Vision, Strategy, and Roadmap 10/3/2011 11:00 AM 12:00 PM Moscone West – 3002/3004
08637 — Do I Upgrade or Go Straight to Oracle Fusion Applications? 10/3/2011 12:30 PM 1:30 PM Westin San Francisco – Stanford
08709 — Deployment Patterns for Oracle Fusion Middleware 11g 10/3/2011 2:00 PM 3:00 PM Moscone South – 310
06788 — Thinking Clearly About Skew 10/3/2011 3:30 PM 4:30 PM Moscone South – 302
18022 — Oracle Fusion Financials’ Coexistence with Oracle E-Business Suite 10/3/2011 5:00 PM 6:00 PM Moscone West – 3018
31800 — Oracle WebLogic Server JMS Support: Architecture/Performance/Tuning Essentials/Best Practices 10/3/2011 6:30 PM 7:15 PM Marriott Marquis – Salon 7
32980 — High-Performance Traffic Management with Oracle Fusion Middleware on Oracle Exalogic 10/3/2011 7:30 PM 8:15 PM Marriott Marquis – Salon 9

30000 — CERN Achieves Oracle Database Scalability and Performance by Building on NetApp 10/4/2011 10:15 AM 11:15 AM Novellus Theater
18582 — General Session: Oracle Fusion Applications—Overview, Strategy, and Roa… 10/4/2011 11:45 AM 12:45 PM Moscone West – 2002/2004
13643 — Real-World Performance: How Oracle Does It 10/4/2011 1:15 PM 2:15 PM Moscone South – 104
34180 — Can an ERP Upgrade Now Help Transform Your Business? 10/4/2011 4:00 PM 5:00 PM Novellus Theater
Personal Meeting — Arjen’s party DBVisit
Time: 4:30pm to 6:30pm
Location: Hotel Nikko
222 Mason St, San Francisco 10/4/2011 5:00 PM 5:30 PM
17244 — Best Practices for Oracle E-Business Suite Performance Tuning 10/4/2011 5:30 PM 6:30 PM Moscone West – 2014

17220 — Oracle Fusion Applications: Technology Essentials Overview 10/5/2011 10:00 AM 11:00 AM Moscone West – 2005
14862 — Best Practices for Maintaining Oracle Fusion Middleware and Oracle Exalogic 10/5/2011 11:30 AM 12:30 PM Moscone West – 2020
15940 — Oracle Identity Manager 11g: Lessons from a Customer Deployment 10/5/2011 1:00 PM 2:00 PM Moscone West – 3022

17680 — Secrets of Demand and Trade Management with Oracle’s Demantra Applications 10/6/2011 12:00 PM 1:00 PM Moscone West – 2008