APPS Blogs

What Tools Do You Use to Patch EBS 12.2 ORACLE_HOMEs?

Steven Chan - 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

Steven Chan - 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?

Steven Chan - 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?

Steven Chan - 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

Balance sheet Basics

OracleApps Epicenter - Fri, 2017-06-09 00:47
To undestand this take a example from Individual to Business. If you want to consider your own financial situation ,then three things you will consider : How much is owns How much is owes and, these two makes how much is your net worth. net worth =owns - owes or owns =owes +net worth So […]
Categories: APPS Blogs

Webcast: Advanced Architectures for Oracle E-Business Suite

Steven Chan - 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?

Steven Chan - 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

Steven Chan - 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

Steven Chan - 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"

Steven Chan - 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

Steven Chan - 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

Steven Chan - 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"

Steven Chan - 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?

Steven Chan - 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

Steven Chan - 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

Recommended Database Parameters Updated for EBS 12.2

Steven Chan - Thu, 2017-05-25 11:46

We publish a definitive list of Oracle Database initialization parameter settings for the optimal performance of Oracle E-Business Suite 12.2, 12.1, and 12.0:  

This document covers all Oracle Database releases that are certified with EBS 12.x, including:

  • Oracle Database 12c Release 1 (12cR1)
  • Oracle Database 11g Release 2 (11gR2)
  • Oracle Database 11g Release 1 (11gR1)
  • Oracle Database 10g Release 2 (10gR1)

This document has just been updated with new information about the service_names parameter introduced in the April 2017 updates to the AD and TXK utilities.

Related Articles

Categories: APPS Blogs

Webcast: "Oracle E-Business Suite Internationalization and Multilingual Features"

Steven Chan - Wed, 2017-05-24 11:43

Oracle University has a large collection of free recorded webcasts for EBS.  If you're running your E-Business Suite environment in a multilingual configuration, see:

Oracle E-Business Suite supports more countries, languages, and regions than ever. Maher Al-Nubani, Senior Director Product Development shares an overview of internationalization features and capabilities as well as new Release 12 features such as calendar support for Hijra and Thai, new group separators, lightweight multilingual support (MLS) setup, new character sets such as AL32UTF8, newly supported languages, Mac certifications, Oracle iSetup support for moving MLS setups, new file export options for Unicode, new MLS number spelling options, and more. This session was recorded live at Oracle OpenWorld 2014.

Categories: APPS Blogs

SCAP OVAL SQL57_TEST Example For Oracle E-Business Suite

Last week I posted a blog introducing SCAP and OVAL. Here is a quick follow-up with a link to a sql57_test example using the Oracle E-Business Suite - it will suffice for any Oracle database.

A great book to read first on SCAP titled ‘Security Automation Essentials’ for $15 on Amazon is a must read:  https://www.amazon.com/Security-Automation-Essentials-Streamlined-Communication/dp/0071772510. I would highly recommend this book to anyone interested in SCAP and much thanks to Witte, Cook, Kerr and Shaffer for writing it.

If you have any questions, please contact us at info@integrigy.com

-Michael Miller, CISSP-ISSMP, CCSP, CCSK

References
 
SCAP OVAL, Oracle Database, Oracle E-Business Suite
Categories: APPS Blogs, Security Blogs

Webcast: "Enterprise Manager 13c Cloud Control for Managing Oracle E-Business Suite"

Steven Chan - Tue, 2017-05-23 02:00

Oracle University has a wealth of free recorded webcasts for Oracle E-Business Suite.  Here's a free webcast that covers our E-Business Suite plug-in for Oracle Enterprise Manager:

Application Management Suite delivers capabilities to facilitate management of Oracle E-Business Suite environments running in the Oracle Cloud and on-premises using a single pane of glass. Angelo Rosado, Senior Principal Product Manager, shares key new features provided in the latest release of Application Management Suite for Oracle E-Business Suite available with EM 13c. Application Management Suite features that will be covered include deploying patches and customizations across all environments; comparing configurations between instances; provisioning a new instance to the Oracle Cloud; migrating an existing instance to the cloud; enforcing compliance standards; and automated cloning. This material was presented at Oracle OpenWorld 2016. 

Related Articles

Categories: APPS Blogs

Webcast: "Faster and Better: Oracle E-Business Suite Desktop Integration Enhancements"

Steven Chan - Mon, 2017-05-22 17:35

Oracle University has a wealth of free recorded webcasts for Oracle E-Business Suite.  If you're looking for an update on the latest enhancements to Web ADI in EBS 12.2, see:

Senthilkumar Ramalingam, Group Manager Product Development, discusses the simplified user experience and the latest OOXML standards support in Oracle Web Applications Desktop Integrator and Oracle Report Manager. The session includes new features in Release 12.2 and other 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 2016. 

 
Categories: APPS Blogs

Pages

Subscribe to Oracle FAQ aggregator - APPS Blogs