Steven Chan

Subscribe to Steven Chan feed
Oracle Blogs
Updated: 4 hours 48 min ago

Using Patch Wizard to Identify Files Affected by Specific Patches

Fri, 2017-06-23 02:00

Patch Wizard compares your EBS environment against a list of all recommended EBS patches. It creates a list of high-priority patches that your environment is missing.

You can use Patch Wizard to assess the impact of a specific patch on your environment.  Patch Wizard can report on a variety of areas, including:

  • The applications patched
  • File types installed
  • New files introduced
  • Existing files that are changed
  • Flagged files that are changed
  • Menu navigation trees affected -- responsibilities that lead to patched functionality

Patch Wizard doesn't have the ability to analyze business logic in the affected files, so it cannot report on functionality that is affected by new files delivered by a given patch.  You can review a patch's README to see if there are functional changes introduced by a patch.

References

Related Articles

 

Categories: APPS Blogs

Webcast: Testing Oracle E-Business Suite Best Practices

Thu, 2017-06-22 02:00

Oracle University has a large collection of free recorded webcasts that EBS system administrations may find useful.  Here's a great webcast on testing E-Business Suite:

Prashanti Madireddi, Senior Director Product Development provides an overview of how the Quality Assurance team tests Oracle E-Business Suite. This session covers the main areas that you should consider during functional testing, approaches for new-feature and regression testing, how to reduce the test script generation and execution time, experiences on capturing and presenting metrics to showcase the ROI of testing investment, leveraging automation for testing Oracle E-Business Suite applications and more. This material was presented at Oracle OpenWorld 2015.

Related Articles

Categories: APPS Blogs

Whitepaper: E-Business Suite Upgrade Sizing and Best Practices

Wed, 2017-06-21 02:00

One of the most-common questions we see revolves around sizing for EBS upgrades -- that is, the amount of resources required when upgrading from one EBS release to another. It is difficult to make general statements about these types of requirements that apply uniformly to all customer environments, since every customer's database size, product usage mix, and concurrent end-user loads vary dramatically. 

That said, our Applications Performance Group has published a whitepaper that describes an EBS 12.1.3 to EBS 12.2 upgrade:

The upgrade scenario covers a 456 GB database prior to the upgrade, and compares the application tier sizes before and after the upgrade.  Individual tablespace requirements are listed in detail.

Related Articles

Categories: APPS Blogs

Webcast: Maintenance Strategies for Oracle E-Business Suite

Tue, 2017-06-20 02:00

Oracle University has a large collection of free recorded webcasts for Oracle E-Business Suite.  Here's an excellent primer for system administrators interested in creating a framework for regular EBS maintenance:

Elke Phelps, Senior Principal Product Manager presents the best techniques Applications DBAs can use to proactively maintain their Oracle E-Business Suite environment. It starts with a practical approach for defining a preventive maintenance strategy and then moves to detailed descriptions and tips for various tools and approaches for efficiently performing maintenance tasks. Topics include patching shortcuts, distributing worker processes across multiple servers, shared file systems, avoiding resource bottlenecks, and more. Leave this session with the tools required for creating a plan to keep your environment healthy and up to date. This material was presented at Oracle OpenWorld 2016. 

Related Articles

Categories: APPS Blogs

New OA Framework 12.2.5 Update 13 Now Available

Mon, 2017-06-19 02:00

Web-based content in Oracle E-Business Suite Release 12 runs on the Oracle Application Framework (also known as OA Framework, OAF, or FWK) user interface libraries and infrastructure. Since the initial release of Oracle E-Business Suite Release 12.2 in 2013, we have released a number of cumulative updates to Oracle Application Framework to fix performance, security, and stability issues.

These updates are provided in cumulative Release Update Packs, and cumulative Bundle Patches that can be applied on top of the Release Update Packs. In this context, cumulative means that the latest RUP or Bundle Patch contains everything released earlier.

The latest OAF update for Oracle E-Business Suite Release 12.2.5 is now available:

Where is this update documented?

Instructions for installing this OAF Release Update Pack are in the following My Oracle Support knowledge document:

Who should apply this patch?

All Oracle E-Business Suite Release 12.2.5 users should apply this patch.  Future OAF patches for EBS Release 12.2.5 will require this patch as a prerequisite. 

What's new in this update?

This bundle patch is cumulative: it includes 39 fixes in total, including all fixes released in previous EBS Release 12.2.5 bundle patches.

This latest bundle patch includes fixes for following bugs/issues:

  • When Descriptive Flexfield (DFF) is in advanced table under query bean, some of its segments may not be displayed and instead, other columns of the table get repeated.
  • The user is unable to switch to user Views from default View when the query bean views panel has HGrid results table.
  • 21779710    FLEXFIELD CCID IS NOT SEARCHABLE IN LOV WHEN AUTO COMMIT IS OFF
  • 21807962    DBS - LOGIN PAGE GETTING DELAYED INTERMITTENTLY
  • 22247201    VERTICAL SCROLLING FAILS IN KFF LOV TABLE
  • 22483762    22375010 FORWARD PORT: GETTING 'ROOT APPLICATION MODULE STATE CORRUPTION: AM HAS
  • 22590683    FORWARD-PORT 21465867 TO 12.2.5
  • 22690575    "CSS STYLE LOOKUP" ERRORS "FILE NOT FOUND" FOR CUSTOM.XSS DUE TO M

Related Articles

Categories: APPS Blogs

Webcast: Testing Recommendations for Oracle E-Business Suite Applications

Fri, 2017-06-16 02:00

Oracle University has a large collection of free recorded webcasts that EBS system administrators might find useful. Here's another webcast on testing EBS environments:

Prashanti Madiredd, Senior Director Quality Assurance shares best practices from the Oracle E-Business Suite Development team on the following topics: how the Oracle Development Quality Assurance team tests Oracle E-Business Suite, factors for customers to consider during functional testing, approaches for new feature and regression testing, reducing risk and production outages due to insufficient testing, capturing and presenting metrics to showcase the ROI of testing investment and leveraging automation for testing Oracle E-Business Suite application. This material was presented at Oracle OpenWorld 2014.

Related Articles

 

Categories: APPS Blogs

What Tools Do You Use to Patch EBS 12.2 ORACLE_HOMEs?

Thu, 2017-06-15 02:00

Oracle E-Business Suite 12.2 has several technology stack components.  Each component has its own ORACLE_HOME:

  • Oracle Fusion Middleware
    • Oracle WebLogic Server (WLS) 10.3.6
    • OHS (WebTier) 11.1.1 and Oracle Common (Common Modules)
  • Application Server (OracleAS)
    • Forms and Reports 10.1.2
  • Oracle Database
    • Oracle Database Server 11.2 or 12.0

Each of these technology stack components can be patched individually.  But what do you use to patch them?  For a quick cheatsheet, see:

References

Related Articles

Categories: APPS Blogs

Webcast: Testing E-Business Suite with Flow Builder

Wed, 2017-06-14 12:00

Oracle University has a large number of free recorded webcasts that EBS sysadmins might find useful.  Here's another good webcast on our testing tools:

Mazen Arar, Senior Director EBS Quality Assurance, provides an overview of how the Quality Assurance team tests Oracle E-Business Suite. It covers main areas that you should consider during functional testing, approaches for new-feature and regression testing, how to reduce the test script generation and execution time, experiences on capturing and presenting metrics to showcase the ROI of testing investment, leveraging automation for testing Oracle E-Business Suite applications and more. This material was presented at Oracle OpenWorld 2016. 

Related Articles

 

Categories: APPS Blogs

Where Did the EBS Certifications Page Go?

Mon, 2017-06-12 02:00

Regular readers of this blog know that they could find my one-page summary of all important E-Business Suite technology stack component certifications under the "Certifications" link in the sidebar menu.

Since Oracle's migration of our blogging engine to Compendium in April, some people have been having trouble finding the new location.  It's here:

You can access it from the new blog's "Quick Links" button in the top banner:

Due to some restrictions about how the new blogging engine displays content, this page might look a bit different than before.  But regardless, it still lists technology stack certifications for EBS 12.2, 12.1, 12.0, and 11i, covering everything all three tiers: desktop and mobile clients, application tier servers, and database tier servers.

 

Categories: APPS Blogs

Is it Possible to Run Patch Wizard Offline?

Fri, 2017-06-09 02:00

Patch Wizard helps you identify useful or critical missing patches for your EBS environment.

Many of the largest EBS customers run their environments where external network connectivity is extremely limited or non-existent.  The latter architectures are sometimes "air gapped" from external networks for maximum security.

Patch Wizard identifies missing patches by comparing them to the Patch Information Bundle (a.k.a. "InfoBundle"), a master repository of the latest available patches. It is still possible to run Patch Wizard even if your environment is air-gapped.  You need to download the Infobundle file or the patches you wish to analyze from Oracle's Support Portal using a system that has network access to Oracle Support.  Once you've downloaded those files, you can move them to your secure or isolated EBS environment manually.

For more details about running Patch Wizard in network-isolated EBS environments, see:

References

Related Articles

Categories: APPS Blogs

Webcast: Advanced Architectures for Oracle E-Business Suite

Thu, 2017-06-08 02:00

Oracle University has a large number of free recorded webcasts for Oracle E-Business Suite.  Here's an excellent webcast for a wide range of architectural options for more-complex deployment requirements:

Elke Phelps, Senior Principal Product Manager shares how to build on the three-tier logical Oracle E-Business Suite architecture to meet your business requirements for high availability, scalability, and performance. Topics include load-balancing and clustering. Understand how to securely deploy Oracle E-Business Suite for internet access with a demilitarized zone (DMZ). Apply various topics covered in the session to assist you with planning a disaster recovery project for your environment. Learn about new tools that automate scale-out and other advanced architectures when deploying E-Business Suite to the Oracle Cloud. This material was presented at Oracle OpenWorld 2016.

 

Categories: APPS Blogs

Where Can I Find the Latest Patch Wizard Updates for EBS 12.2?

Wed, 2017-06-07 02:00

Patch Wizard helps you identify useful or critical missing patches for your EBS environment.

This tool is updated as needed, with patches that are cumulative: they include new updates as well as all fixes released previously.  The latest updates are always documented here:

The last updates to the EBS 12.2 Patch Wizard were released in September 2016 via this patch:

This patch fixed the following issues:

  • 14504286 - PATCH WIZARD - 12.1.3 - MANY PATCHES ARE INDIRECTLY APPLIED BUT MARKED UNAPPLIED
  • 16992893 - PATCH WIZARD: PATCH MERGE FAILING - UNABLE TO FIND PATCH FILES
  • 17081891 - 16992893 PCC - PATCH WIZARD: PATCH MERGE FAILING - UNABLE TO FIND PATCH FILES
  • 17244500 - PATCH WIZARD IS RECOMMENDING PATCHES FOR IN USE PRODUCTS = NO
  • 17335985 - 17244500 PCC - PATCH WIZARD IS RECOMMENDING PATCHES FOR IN USE PRODUCTS = NO
  • 17355203 - PCC 14504286 - MANY PATCHES ARE INDIRECTLY APPLIED BUT MARKED UNAPPLIED
  • 18617040 - PATCH WIZARD: ORA-06512: AT "APPS.AD_PATCH_ANALYSIS_ENGINE", LINE 519 
  • 18978837 - R12.2 OAM APPLIED PATCHES PROVIDES WRONG DATES, DOES NOT SHOW ALL PATCHES
  • 19412224 - FLAGGED FILE IMPORTS HANG AFTER 18598941
  • 20318695 - ADPAENGB.PLS 120.13.12020000.8 CAUSES ORA-06512 IN EBS R12.2.3
  • 21184697 - CAN'T FIND RESOURCE FOR BUNDLE ORACLE.APPS.AD.OAM.RESOURCES.PATCHRESOURCEBUNDLE
  • 21806033 - PATCH WIZARD APPLIED PATCHES ADVANCED SEARCH BY PRODUCT IS NOT WORKING
  • 22490144 - FILE HISTORY NOT SHOWING CORRECT VERSIONS OF THE ACTUAL APPLIED/UPLOADED FILES.
  • 9703082 - PROVIDE REPORT OR EXPORT BUTTON FOR PATCH WIZARD OUTPUT SUMMARY+IMPACT ANALYSIS

Related Articles

Categories: APPS Blogs

Webcast: Standards-based Desktop Integration in Oracle E-Business Suite

Tue, 2017-06-06 02:00

Oracle University has a large number of free recorded webcasts for Oracle E-Business Suite.  Here's a useful one on Web Applications Desktop Integrator (Web ADI) and Oracle Report Manager:

Padmabrabodh Ambale covers the latest standards support in Oracle Web Applications Desktop Integrator and Oracle Report Manager. The session includes new features in Release 12.2 and other proposed design changes that result in vastly improved performance and spreadsheet experience. In addition, it offers information on how you can use Desktop Integration Framework to build your own custom desktop integrations between Oracle E-Business Suite and Microsoft Excel for enhanced end user productivity for mass upload/download of spreadsheet data. This material was presented at Oracle OpenWorld 2015.

Related Articles

 

Categories: APPS Blogs

Providing Limited Patch Wizard Access to EBS End-Users

Mon, 2017-06-05 14:40

Patch Wizard helps you identify useful or critical missing patches for your EBS environment.  

One of the most common questions we get is how to provide Patch Wizard access to end-users without giving them full access to the rest of the system administration features included with the System Administration responsibility.

In response to these questions, we created a responsibility for Non-Sysadmin users that contains only the Patch Wizard screens. Tips on using this new responsibility are covered here:

  • Patch Wizard FAQ (Note 976688.2) - see tab "Setup Patch Wizard Responsibility for End Users"

This Note shows how to create a new Patch Wizard responsibility for end-users, how to configure preferences and how to add restrictions for specific menus and functions.

References

Related Articles


 

Categories: APPS Blogs

Webcast: "Managing Oracle E-Business Suite Auditing and Security"

Fri, 2017-06-02 02:00

Oracle University has a large number of free recorded webcasts for Oracle E-Business Suite.  One of the essential webcasts on security that all EBS sysadmins should review is:

Eric Bing, Senior Director Product Development and Elke Phelps, Senior Principal Product Manager share recommendations for auditing, monitoring and securing your Oracle E-Business Suite environment and sensitive data.  Configuration guidelines for monitoring and auditing activity in your Oracle E-Business Suite application and database will be provided.  The session will provide an overview of our secure configuration guidelines, updates to the secure configuration scripts, and optional security integrations. Also shared is a summary of some of the new security features available in Oracle E-Business Suite 12.2 including enhancements for proxy user functionality and how to reduce your attack surface by reducing cookie scope, allowed JavaServer Pages (JSPs), and external redirects. This material was presented at OOW 2015.

Related Articles

 

Categories: APPS Blogs

New OA Framework 12.2.6 Update 3 Now Available

Thu, 2017-06-01 02:00

Web-based content in Oracle E-Business Suite Release 12 runs on the Oracle Application Framework (also known as OA Framework, OAF, or FWK) user interface libraries and infrastructure. Since the initial release of Oracle E-Business Suite Release 12.2 in 2013, we have released a number of cumulative updates to Oracle Application Framework to fix performance, security, and stability issues.

These updates are provided in cumulative Release Update Packs, and cumulative Bundle Patches that can be applied on top of the Release Update Packs. In this context, cumulative means that the latest RUP or Bundle Patch contains everything released earlier.

The latest OAF update for Oracle E-Business Suite Release 12.2.6 is now available:

Where is this update documented?

Instructions for installing this OAF Release Update Pack are in the following My Oracle Support knowledge document:

Who should apply this patch?

All Oracle E-Business Suite Release 12.2.6 users should apply this patch.  Future OAF patches for EBS Release 12.2.6 will require this patch as a prerequisite. 

What's new in this update?

This bundle patch is cumulative: it includes all fixes released in previous EBS Release 12.2.6 bundle patches.

This latest bundle patch includes fixes for the following issue:

  • Cosmetic issue: Framework email notifications have boxes around headers
  • Launching Forms application in Accessibility mode fails in the second iteration in IE11 browser.
  • In attachment image style, adding an attachment fails when a primary key of an entity map has the value as null.
  • In Japanese enabled environment, the text in the advanced table Total cell is getting split into multiple lines when the text has spaces.

Related Articles

Categories: APPS Blogs

Enabling an EBS Global Diagnostics Trace

Wed, 2017-05-31 12:23

Oracle E-Business Suite provides several types of logs.  One of the tools you can use is the Logging Framework, which allows you to collect and view log messages in Oracle Applications Manager.  The Logging Framework collects debug messages, errors, and alerts.

A Global Diagnostics Trace can help you diagnose issues if errors occur when users click a button or select an option. It's a targeted trace that can be run per user, thereby minimizing the impact on the overall performance of your environment. This kind of trace is also known as an FND Diagnostics Trace or Oracle Applications Logging.

You can find a quick summary of steps to enable a Global Diagnostics trace here:

There's lots more information about more-powerful logging options in the following manuals

Related Articles

Categories: APPS Blogs

Webcast: "E-Business Suite 12.2 Upgrade Best Practices to Minimize Downtime"

Tue, 2017-05-30 12:56

Oracle University has a large selection of free recorded webcasts for Oracle E-Business Suite.  If you're planning to upgrade to EBS 12.2, the following webcast is worth your time:

This session is ideal for organizations thinking about upgrading to Oracle E-Business Suite 12.2. Samer Barakat, Director Application Performance, covers best practices and performance optimizations to minimize 12.2 upgrade downtime. This material was presented at Oracle OpenWorld 2015.

Related Articles

Categories: APPS Blogs

Can EBS Nodes Be at Different Operating System Levels?

Mon, 2017-05-29 02:00

Oddly, a category of EBS architecture questions that I'd thought long-settled is starting to reemerge.  I've recently seen several queries along the lines of:

  1. Can EBS database nodes and application tier nodes be on different operating systems?
  2. Can multiple EBS database nodes be on different operating systems or levels?
  3. Can multiple EBS application tier nodes be on different operating systems or levels?

Here are the answers to these questions:

1. Can EBS database nodes and application tier nodes be on different operating systems?

Yes.  In some cases, the operating systems certified for EBS database nodes cannot be run on the application tier. These are called "database tier only" certifications. It is quite common to see this configuration, especially in large EBS environments.

2. Can multiple EBS database nodes be on different operating systems or levels?

No.  From our "Installation Guide: Using Rapid Install" documentation:  

"All database tier nodes must be at the same operating system patch level."

3. Can multiple EBS application tier nodes be on different operating systems or levels?

No. From our "Installation Guide: Using Rapid Install" documentation:  

"All application tier nodes must be at the same operating system patch level."

Here's a screenshot from our EBS 12.2 documentation (emphasis in red):

References

Related Articles

Categories: APPS Blogs

Another Personal Milestone at Alliance 2017

Fri, 2017-05-26 02:00

I was deeply moved when I received a Lifetime Service Award from the Oracle Applications User Group (OAUG) in 2011. I still think I was awfully young for that award at the time, but I was honored and consider it an important milestone.

I reached another milestone at the recent Higher Education User Group (HEUG) Alliance conference in Las Vegas. I was in a meeting with the HEUG's Product Advisory Group when I noticed something unusual hanging on someone's nametag:

To this day, I don't think that my friends or family really understand what I do for a living.  But when my name shows up unexpectedly on a button, that's powerful positive feedback from the people who really count.

I'd like to thank the Higher Education User Group and the Oracle Applications User Group for their ongoing support for our EBS user community. I know that I speak for the entire E-Business Suite team when I say that your energy and enthusiasm inspires us to keep building the best products for you.

And, if you're an EBS user who isn't an HEUG or OAUG member, I strongly encourage you to sign up.  The cost is trivial but the benefits substantial.  In addition to running some of the most-useful independent conferences for EBS, these groups advocate tirelessly on behalf of the EBS user community. They have influenced our products and policy in countless ways and they deserve your support.

Categories: APPS Blogs

Pages