Tuesday Jul 15, 2008

Case Study: Oracle's Own Oracle E-Business Suite Release 12 Upgrade

[Oct. 27, 2008 Update:  The latest version of this popular presentation from OpenWorld 2008 is now available for download.  For links to the latest version, see this article.]

I've heard anecdotal reports suggesting that some customers hold off on upgrading to a given E-Business Suite release until we've done so ourselves here at Oracle. Oracle went live on R12.0.3 in January 2008, and a reader reminded me that I haven't highlighted this adequately. Here's a critical presentation from Eugene Weinstein and Sharon Leong at OAUG Collaborate 2008 (Denver) that I've been remiss in profiling:

Eugene and Sharon cover a lot of ground in this technically-oriented presentation, including:

  • A primer on the R12 file system
  • Supported upgrade paths from earlier Apps releases (11.5.x, 11.0)
  • A detailed step-by-step flowchart of the upgrade process
  • Applications DBA (AD) improvements relating to the upgrade process
  • Performance improvements relating to the upgrade
  • Best practices for:
  • Reducing downtime
  • Performing pre-upgrade, upgrade, and post-upgrade steps
[Read More]

Tuesday Nov 20, 2007

Oracle OpenWorld Presentations Now Available

[Read More]

Tuesday Mar 06, 2007

JInitiator Upgrade Requirements for DST 2007

We held three more webcasts on the US 2007 Daylight Saving Time changes and their impacts on E-Business Suite environments.  Recorded versions of these webcasts are available online.


US Dept of Transportation Logo:

The Feb 26, 2007 version of Metalink Note 403311.1 for E-Business Suite Release 11i environments identified a known issue with Gantt chart functionality for a small number of products.  The Note has now been updated with a recommendation to apply a patch and upgrade to JInitiator 1.3.1.26 if you're using the affected products.  The latest version is dated "March 4, 2007" and includes the following changes:
  • Updated Section 3.3, Step 4, Jinitiator version 1.3.1.26 or higher:
    • Added requirements for Oracle Work in Process, Oracle Shop Floor Management, and Oracle Enterprise Asset Management Gantt charts.
  • Updated Section 3, Patches Required for E-Business Suite Environments
    • Added Oracle Work in Process patch requirements for the Oracle Work in Process, Oracle Shop Floor Management, and Oracle Enterprise Asset Management Gantt charts
  • Removed Known Issues Appendix. Issue resolved and documented for Oracle Work in Process, Oracle Shop Floor Management, and Oracle Enterprise Asset Management.
If you haven't already started on your DST 2007 upgrade process, I urge you to review this documentation at your earliest convenience.

Getting Support

If you have any questions about this documentation, please log a Service Request with Oracle Support, using the following information to ensure that the correct Support group is engaged:

Metalink SR entry screen #1:
  • Product:  Oracle Applications Technology Stack
Metalink SR entry screen #2:
  • Type of Problem:  Technology Stack Issues
References

Wednesday Feb 21, 2007

Invitation to US 2007 Daylight Saving Time Webcast #3

If you weren't able to join us for our last Daylight Saving Time webcast (recording  details available here), we're holding three more repeats of that session on February 22nd, 2007 at 7:00 AM Pacific Standard Time, 11:00 AM Pacific Standard Time, and 6:00 PM Pacific Standard Time.

US Dept of Transportation Logo:

The presentation focuses on the impact of the 2007 Daylight Saving Time change on E-Business Suite environments.  The 20 minute presentation discussing the impact will be followed by a Q&A session with Oracle Development.  All E-Business customers with environments inside the US and Canada are impacted by these changes, as well as customers with environments located outside the US and Canada, but doing business in the United States or Canada.   This presentation is different from the web casts that have been given by the Database team as it focuses specifically on the impact to the E-Business Suite customers.

All three webcasts will cover the same content.  We're repeating this three times in the same day to accommodate participants in different global regions:
  • Thursday, February 22nd:
    • 7:00 AM Pacific Standard Time
    • 11:00 AM Pacific Standard Time
    • 6:00 PM Pacific Standard Time
Audio Feed Dial-In Instructions

Previous webcasts have had large numbers of participants.  To ensure that you get a spot:

1. Dial in to the number of your choice at least ten minutes prior to the call's start time:
  • Customers in the Americas, dial:
    • 1-888-967-2253
    • 1-650-607-2253
  • Customers in the Asia Pacific region, dial:
    • 1800 222 712 (Australia toll-free)
    • 800 9491 2777
    • 61 2 8817 6100
  • Customers in Europe, Middle East, and Africa, dial:
    •  44 118 924 9000
2.  Enter the Meeting ID followed by the # key (202264

3.  Speak your name and location at the prompt
4.  Enter meeting passcode followed by the #key (202264)

Webcast Conference Instructions
  1. Go to the Oracle Conferencing website:  http://conference.oracle.com
  2. In the Join Conference box, enter the conference id:
    • 7:00 am PST conference id:  70026572
    • 11:00 am PST conference id: 
      70026890
    • 6:00 pm PST conference id:  70027054
  3. In the Join Conference box, leave the conference key box blank
  4. In the Join Conference box, enter your first and last name
  5. Click "Join Conference"
We recommend that you go to the Oracle Conference website ahead of the meeting to ensure that your PC has no issues with the conference initialization process. The first time you log into this application, it takes extra time, so please try to log in in advance of the actual meeting.

If you have issues, the Quick Tutorial button below the Join Conference Box may be of help.

Related

Monday Feb 19, 2007

Personalizing and Extending Release 12

The JDeveloper 10g with OA Extension was recently released for use with the E-Business Suite Release 12.  Following on that theme of extending and personalizing Release 12, you might find it useful to review Sara Woodhull's excellent presentation on this topic from OpenWorld 2006.


Release 12 Personalization Screenshot:

Sara's OOW presentation covers the E-Business Suite Release 12's Oracle Applications Framework (OAF) architecture, which is designed to provide rich and upgradable personalization and extensibility capabilities in a declarative, object oriented model.  This allows Release 12 to be extended and customized without the overhead of traditional development projects.  Topics included in this presentation are:
  • OA Framework Model-View-Controller architecture and key features
  • Personalizations features, including:
    • The ability to hide and show page items and regions, reordering page items, adding new items, adding corporate branding
    • Importing and exporting personalizations with the Personalization Document Manager
    • New user interface for creating personalizations
    • Matching the Release 12 colors and fonts to match your corporate website
    • Using simple expression (SPEL) bindings for more control over fields, items, and regions
  •  Extensibility features, including:
    • The ability to add new business logic to existing screens
    • Durability of extensions, allowing them to be preserved across upgrades
    • Use of Oracle JDeveloper 10g with OA Extension to support J2EE development and integration with Release 12
    • Support for service interfaces, standalone components that can be deployed as web services, EJB session beans, or as co-located Java APIs
You can download her presentation here:
Related

Friday Feb 02, 2007

Invitation to US 2007 Daylight Saving Time Webcast #2

If you weren't able to join us for our last Daylight Saving Time webcast (recording  details available here), we're holding a repeat of that session on February 14th at 3:00 PM Pacific Standard Time.

US Dept of Transportation Logo:

The presentation focuses on the impact of the 2007 Daylight Saving Time change on E-Business Suite environments.  The 30 minute presentation discussing the impact will be followed by a Q&A session with Oracle Development.  All E-Business customers with environments inside the US and Canada are impacted by these changes, as well as customers with environments located outside the US and Canada, but doing business in the United States or Canada.   This presentation is different from the web casts that have been given by the Database team as it focuses specifically on the impact to the E-Business Suite customers:
  • Wednesday, February 14th, 3:00 p.m. - 4:30 p.m. PST
Audio Feed Dial-In Instructions

Our last webcast had over 550 participants.  To ensure that you get a spot on this webcast, at least ten minutes prior to the call's start time, dial: 
  • Toll-free (US and Canada only):  (877) 664-4416
  • International Direct Dial:  (706) 679-7831
  • Provide the operator with the conference ID number:  8120235
  • Helpful keypad commands:  *0 - Operator assistance, *6 Self mute/unmute
  • If you have any trouble getting on to the call, you can get help by contacting Intercall Conference Service Customer Service: (toll free) 877-659-3037 or 706-634-9081
Webcast Conference Instructions
  1. Go to the Oracle Conferencing website:  http://conference.oracle.com
  2. In the Join Conference box, enter the conference id: 68022722
  3. In the Join Conference box, leave the conference key box blank
  4. In the Join Conference box, enter your first and last name
  5. Click "Join Conference"
We recommend you go to the Oracle Conference website ahead of the meeting to ensure that your PC has no issues with the conference initialization process.   The first time you log into this application, it takes extra time, so please try to log in in advance of the actual meeting.

If you have issues, the Quick Tutorial button below the Join Conference Box may be of help.

Meeting Replay

A digital recording of the conference is available. To access the recording, call:
  • Toll-free (US and Canada only):  (800) 642-1687
  • International Direct Dial:  (706) 645-9291
  • Enter conference ID:   8120235
Related

Wednesday Jan 24, 2007

Invitation to the 2007 Daylight Savings Time E-Business Customer Webcast #1

[Editor Feb 2, 2007 Update:  Another repeat webcast is scheduled for Feb 14.  See this article for details.]

[Editor Jan 29, 2007 Update:  The call lasted approximately 90 minutes; 25 minutes of presentation time followed by 60 minutes of question and answer.  The replay is available as an audio recording only, but you may follow along with the powerpoint presentation
which is located here.  To access the recorded version of this call:]


Dial: 1-800-260-2140 (International callers:  1-617-231-2053)
At the prompt, press 3 to replay the meeting
Listen for the prompts and enter 1#, 26#, then 202264#

If you still have outstanding questions about the impact of the US 2007 Daylight Saving Time changes, you're invited to join us for an Oracle Support webcast on this topic.  Senior staff from Oracle Support and the Applications Technology Group will be participating on this call, so this is your chance to get authoritative information directly from the source.

US Dept of Transportation Logo:

The presentation focuses on the impact of the 2007 Daylight Saving Time change on E-Business Suite environments.  The 30 minute presentation discussing the impact will be followed by a Q&A session with Oracle Development.  All E-Business customers with environments inside the US and Canada are impacted by these changes, as well as customers with environments located outside the US and Canada, but doing business in the United States or Canada.   This presentation is different from the web casts that have been given by the Database team as it focuses specifically on the impact to the E-Business Suite customers.
  • Friday, January 26th, 8:30 AM PST to 10:00 AM PST
This meeting will be recorded and available for playback on demand; I'll post links in a follow-up article on this site.

Audio Feed Dial-in Instructions
  • Toll-free (US only): 1-800-260-2140
  • Toll-free (Canada only): 1-866-701-6338
  • International Direct Dial: 1-617-231-2053
  • Press 1 to attend a meeting
  • Enter meeting ID (202264) followed by the # key
  • Follow the prompts to join the audio conference
Webcast Conference Instructions
  1. Go to the Oracle Conferencing website:  http://conference.oracle.com
  2. In the Join Conference box, enter the conference id: 67366701
  3. In the Join Conference box, leave the conference key box blank
  4. In the Join Conference box, enter your first and last name
  5. Click "Join Conference"
We recommend that you go to the Oracle Conferencing website ahead of the meeting to be sure your PC has no issues with the 'initialization process' required for first time users of Oracle Collaboration.   The first time you log into this application, it takes extra time, so please do not wait until 8:30 am Friday to try to log in.

If you cannot get Oracle Web Conferencing application working on your desktop, the meeting host will provide a link to a downloadable version of the presentation.  The link will be provided on the audio feed at the start of the meeting.

If you have issues, the Quick Tutorial button below the Join Conference Box may be of help.

Related

Tuesday Dec 26, 2006

Documentation Available for Daylight Saving Time 2007 Changes for Apps 11i

Editor Feb 2 Update:  A recording of the first webcast discussing these changes is available here.  A second webcast will be held on Feb 14.

United States Time Zone Changes 2007:  E-Business Suite (Metalink Note 403311.1) is now available to help you plan for the U.S. 2007 Daylight Saving Time changes for your E-Business Suite environment. 

US Dept of Transportation Logo:

This Note covers:
  • Ways for checking whether end-users have set their preferences to use affected timezones
  • A list of affected E-Business Suite modules
  • Recommended Apps patches from Oracle
  • Recommended JDK patches from Sun, IBM, and HP
  • Recommended Forms patches for your operating system
Some of the E-Business Suite patches referenced in the Note are slated for release in January; I'll post an announcement here when they're available.

References

Monday Dec 11, 2006

Securing Your E-Business Suite 11i Deployment

Although most of our readers will be familiar with this material already, when it comes to security, it never hurts to keep ensuring that your doors and windows are locked.  In that spirit, today's post highlights Erik Graversen and George Buzsaki's OpenWorld 2006 session, "How to Secure Your Oracle E-Business Suite Deployment."

URL Firewall Example Configuration 2:

In their presentation, Erik and George cover the essentials of E-Business Suite security, including:
  • A framework for securing different segments of your E-Business Suite deployment, starting with the operating system
  • Pointers to essential Apps security reference materials, security alerts to monitor, and recommended patches
  • Guidance for securing internal deployments, including the database at the schema level and for database net access, the Apps web tier, and end-user PCs
  • Tips for hardening your EBS security setup
  • Monitoring security through Oracle Applications Manager (OAM)
  • Guidance for securing externally-facing deployments in DMZs, including the use of Responsibility filters, URL filters via the URL firewall, noise filters via mod_security
  • Sneak peek at upcoming security certifications
If it's been a while since you reviewed the latest advice on security, this is worth a look:
Related

Wednesday Dec 06, 2006

Master Class in Apps 11i Performance Tuning

Ahmed Alomari is one of Oracle's foremost experts in optimizing performance for the E-Business Suite.  His OpenWorld sessions are always filled with DBAs looking for practical tips on getting more out of their existing hardware, and this year's session was packed with more practical pointers than ever before. 

If you're looking for a master-class in Apps performance tuning, it doesn't get better than this.  Better yet, it's all contained in a single free download.

Gather Schema Statistics Screenshot:

In his presentation, Ahmed covers:

  • Optimization of Forms and Reports
    • Via socket mode, Forms Dead Client detection, and the latest performance-related Forms patches
    • Costs of using Cancel Query
    • Things that your end-users can do to improve performance
    • Tracing Forms performance via SQL and FRD tracing 
    • Optimization of Report via SQL tracing, or by enabling the built-in Reports Trace feature

  • Optimization of Concurrent Manager:
    • Using specialization rules and work shifts to bind jobs to specific time windows
    • Conflict Resolution Manager sleep time guidelines for parallel workers
    • Tips for using Transaction Managers for Inventory Transactions and other synchronous online processing
    • Pipes be gone!  Avoiding transaction manager instances per database instance for RAC
    • Tracing and debug options at the program and request level
  • Optimization of the Application Tier
    • Tuning Apache processes and clients via httpds.conf settings
    • Caching of non-HTML resources such as images, style sheets, and Java scripts via httpd.conf or apps.conf settings
    • Configuring dedicated mod_plsql listeners
    • Apache Jserv / JVM logging and auto load-balancing
    • Tuning Apache Hotspot and garbage collection settings, and interpreting GC output to tune JVM heaps
    • Reducing Java memory and connection leaks
    • Tracking JDBC connections
    • Performance benchmarks after upgrading to JDK 5.0:  ~ 15%!
    • New JDK 5.0 performance management tools, including Jconsole, jps, jstat, visualgc
    • Optimizing Java Server Pages via precompilation
    • Tuning Portal-related settings
    • Discoverer 10g performance-related options
  • Tuning Network performance
    • Testing latency with via ping and optimal packet sizes
    • Performance benchmarks for using Web Cache for compression
  • Tuning Database tier performance
    • Optimal buffer cache and shared pool settings
    • Use of asynchronous I/O, Quick I/O, and locally managed temp files
    • Use of Stats Pack and AWR to take performance snapshots, and things to look for in those snapshots
    • Database performance metrics to monitor
    • Allocating CPU resources via Database Resource Manager
    • Tips for minimizing the impact of gathering statistics, and how to interpret the results
    • Benefits of the new OA Tablespace Model, and before-and-after benchmark comparisons (e.g. a 1.4 TB database shrunk to 850 GB!)

  • And much, much more...
Even if you're not having performance issues now, this is worth a look.  If you are having performance issues, reviewing this presentation should be your top priority today:
Related

Thursday Nov 30, 2006

Inside Oracle's Own Global Operations Data Center

[Oct. 27, 2008 Update:  The latest version of this popular presentation from OpenWorld 2008 is now available for download.  For links to the latest version, see this article.]

Every year at OpenWorld, Bret Fuller discusses how Oracle consolidated over 70 individual E-Business Suite instances into a single instance serving all global operations.  The statistics for Oracle's own Global Single Instance keep rising impressively every year:

Oracle Global Single Instance Statistics:

Bret's presentation this year covers:
  • The business metrics before and after the consolidation
  • Savings estimates and a discussion of business benefits
  • Oracle's Global Single Instance architecture, including a glimpse of the off-site production and disaster-recovery setups in our Austin and Colorado Springs data centers
  • Before and after hardware comparisons
  • Tips on project management best practices
  • Detailed view of the change management processes around the Global Single Instance
  • Critical success factors and tips
You can download this year's presentation here:
Related

Tuesday Nov 14, 2006

Summary of Oracle E-Business Suite Technology Updates

If you're a regular of this site, you might be wondering how to convey all of the latest Apps techstack news to your management.  If so, you'll find Lisa Parekh's OpenWorld 2006 presentation useful. 

Release 12 ORACLE_HOMEs:

I report to Lisa, so her presentation covers all of the breaking news reported here on this site, and more, including:
  • Release 12 technology stack changes, such as the use of Oracle Application Server 10g 10.1.2 and 10.1.3 in different ORACLE_HOMEs and the latest 10gR2 database
  • Release 12 user interface screenshots
  • Release 12 supported browsers, including IE 6.0, Firefox 1.5, and Safari 2.0
  • OA Framework Personalization enhancements
  • Oracle Portal and WSRP support for E-Business Suite portlets
  • XML Publisher enhancements in Release 12, including the new Data Extraction Engine, Bursting Engine, and other new RTF template features
  • Workflow enhancements, including Workflow Flexfields and Workflow Bulk Interface
  • Release 12 Integration Repository previews
  • Upcoming technology stack certifications for the E-Business Suite Release 11i application and database tiers, such as:
You can download her presentation here:
Related
The above is intended to outline our general product direction.  It is intended for information purposes only, and may not be incorporated into any contract.   It is not a commitment to deliver any material, code, or functionality, and should not be relied upon in making purchasing decision.  The development, release, and timing of any features or functionality described for Oracle's products remains at the sole discretion of Oracle. 

Tuesday Nov 07, 2006

Diving Deep Into the Release 12 Techstack

Ivo Dujmovic is an architect in our hard-working Applications Technology Integration team.  We were lucky to get some of his time at OpenWorld 2006 this year, where he discussed the deep innards of the Release 12 technology stack. 

Release 12 Techstack Overview: Overview of three-tier logical architecture for E-Business Suite Release 12, including the database, application server, and desktop tiers. 

For the most comprehensive preview released so far on how the Release 12 technology stack will be architected and work, take a look at his presentation.  He covers:
  • Highlights of new R12 techstack components
  • New Application Server 10g (10.1.2 & 10.1.3) ORACLE_HOMEs replacing the 9iAS 1.0.2.2.2 O_HOMEs from 11i
  • Switch from JServ to Oracle Containers for J2EE (OC4J) for running servlets, Java Server Pages (JSP), and Enterprise Java Beans (EJB)
  • OC4J Deployment details, including replacements for jserv.conf and jserv.properties configuration files
  • New R12 filesystem layout, including the introduction of an Instance Home (INST_TOP)
  • New use of Oracle Process Manager & Notification Server (OPMN)
  • New Forms 10g deployment
  • Comparison of 11i and R12 environment variables
  • Discussion of relative benefits of Forms Servlet vs. Server (socket) mode deployments
  • Disabled mod_plsql in R12 (more about this in a later article)
  • Things you can do today to prepare for R12
Related
The above is intended to outline our general product direction.  It is intended for information purposes only, and may not be incorporated into any contract.   It is not a commitment to deliver any material, code, or functionality, and should not be relied upon in making purchasing decision.  The development, release, and timing of any features or functionality described for Oracle's products remains at the sole discretion of Oracle. 

Monday Nov 06, 2006

Using OracleAS 10g With The E-Business Suite

Editor Jan. 12, 2007 Update:  Oracle Identity Management 10g 10.1.4.0.1 is now certified with the E-Business Suite. 

No matter how hard I try to avoid it, my inbox always seem to pay for any time spent away, regardless of whether the time taken is for work or pleasure.  This is doubly true for time taken for conferences, since they tend to generate even more email.  That's life in the information era, I suppose.

Apps 11i + OracleAS 10g Architecture:

So, in a belated attempt to quell the tide from interested readers and conference goers, here's a pointer to the presentation materials for my session (S281709):
Remember that the OpenWorld 2006 Content Catalog requires the following credentials to download conference materials:
In my presentation you'll find coverage on:
  • Features and benefits of integrating the E-Business Suite with:
    • Single Sign-On & Oracle Internet Directory 10g
    • Discoverer 10g
    • Portal 10g
    • Web Cache 10g
  • Technical integration overview, covering:
    • Simple and advanced physical architectures
    • Logical architectures
  • Integration with third-party single sign-on and LDAP products
  • Release 11i application tier certification roadmap
  • Release 12 technology stack plans
  • Selected snapshots of customer architectures, including the use of :
    • Microsoft Active Directory
    • Windows Native Authentication (Kerberos)
    • Highly Available configurations
Related

Thursday Nov 02, 2006

Maximum Availability Architectures and the E-Business Suite

Put all your eggs in one basket and --- WATCH THAT BASKET.


Following the IT industry's never-ending quest to introduce new and confusing names for well-understood concepts, our gurus in the High Availability engineering teams for the Oracle database and application server products have coined a new term:  Oracle Maximum Availability Architecture.

MAA Architecture:

From their OTN website:
  • "Oracle Maximum Availability Architecture (MAA) is Oracle's best practices blueprint based on proven Oracle high availability technologies and recommendations. The goal of MAA is to remove the complexity in designing the optimal high availability architecture."

This team held a fascinating session at OpenWorld 2006, "MAA Best Practices: Building an Oracle E-Business Suite Maximum Availability Architecture" (S283064).  They covered a range of MAA topics for E-Business Suite environments, including:
  • RAC, ASM
  • Flashback databases
  • Data Guard Redo Apply
  • Disaster recovery
  • Minimizing outages while converting to MAA architectures
  • Switchover and failover procedures
  • Hardware vendor partner validations on:
    • HP-UX, HP 9000, HP Integrity, HP StorageWorks, HP ServiceGuard
    • Sun Solaris, Sun Clusters, Sun Fire, Sun StorEdge

Excellent stuff.  Associated with their OpenWorld session, they have a Powerpoint and a detailed whitepaper available for download.  See the article below for pointers to the OOW Content Catalog.

Oct. 14, 2011 Update: This presentation is available here.

Related


About

Search

Categories
Archives
« April 2014
SunMonTueWedThuFriSat
  
1
4
5
6
7
8
9
10
11
12
13
14
18
19
20
21
22
23
24
25
26
27
28
29
30
   
       
Today