APPS Blogs

Critical Patch Update for July 2017 Now Available

Steven Chan - Tue, 2017-07-18 15:03

The Critical Patch Update (CPU) for July 2017 was released on July 18, 2017. Oracle strongly recommends applying the patches as soon as possible.

The Critical Patch Update Advisory is the starting point for relevant information. It includes a list of products affected, pointers to obtain the patches, a summary of the security vulnerabilities, and links to other important documents. 

Supported products that are not listed in the "Supported Products and Components Affected" Section of the advisory do not require new patches to be applied.

The Critical Patch Update Advisory is available at the following location:

It is essential to review the Critical Patch Update supporting documentation referenced in the Advisory before applying patches.

The next four Critical Patch Update release dates are:

  • October 17, 2017
  • January 16, 2018
  • April 17, 2018
  • July 17, 2018
References Related Articles
Categories: APPS Blogs

Check Your EBS Database Configuration with Database Parameter Settings Analyzer

Steven Chan - Mon, 2017-07-17 15:31

Database ParaIn addition to helping customers resolve issues via Service Requests, Oracle Support also builds over 60 free diagnostic tools for Oracle E-Business Suite 12.2, 12.0, 12.1, and 11i. These Support Analyzers are non-invasive scripts that run health-checks on your EBS environments. They look for common issues and generate standardized reports summarizing that provide solutions for known issues and recommendations on best practices.

Here's an index to these tools:

Spotlight on Database Parameter Settings Analyzer

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 is updated regularly; for example, it was recently updated to account for changes introduced by the April 2017 updates to the AD and TXK utilities.

It can be challenging to keep up with those changes simply by scanning Note 396009.1 yourself.  You can automate this process by using the Database Parameter Settings Analyzer:

The Database Parameter Settings Analyzer compares your database's parameter settings to the latest recommendations in Note 396009.1.  It reports on any differences, and makes recommendations about your sga_target, shared_pool_size, shared_pool_reserved_size and processes parameters based upon the number of active users for your environment.  

This tool can be run manually or configured to run as a concurrent request, so it can be scheduled to be run periodically and included in regular database maintenance cycles.

Can this script be run against Production?

Yes. There is no DML in the Analyzer Script, so it is safe to run against Production instances to get an analysis of the environment for a specific instance. As always it is recommended to test all suggestions against a TEST instance before applying to Production.

Related Articles

Categories: APPS Blogs

acroread on Linux 6

Vikram Das - Sun, 2017-07-16 13:53
As per https://access.redhat.com/errata/RHSA-2013:1402 : Adobe Reader (acroread) allows users to view and print documents in Portable Document Format (PDF). Adobe Reader 9 reached the end of its support cycle on June 26, 2013, and will not receive any more security updates. Future versions of Adobe Acrobat Reader will not be available with Red Hat Enterprise Linux.

Some of our ERPs still use acroread for pasta printing.  When we did the upgrade of OS to OEL 6, we had to reinstall adobe by getting the rpm from adobe site ftp://ftp.adobe.com/pub/adobe/reader/unix/9.x/9.5.5/enu/ that I got from https://www.reddit.com/r/linux/comments/2hsgq6/linux_version_of_adobe_reader_no_longer/   Fortunately, adobe still hosts it. It is also available from Red Hat if you have a subscription:

Red Hat Enterprise Linux Server 6SRPMx86_64acroread-9.5.5-1.el6_4.1.i686.rpmSHA-256: ac0934cfe887c6f49238ebff2c963adc33c1531019660bbfa4f8852d725136a2Downloadacroread-plugin-9.5.5-1.el6_4.1.i686.rpmSHA-256: 8116e41e4825f74478731a7e970482274db5c9d4b9489b9f70ca4e1a278e526bDownloadi386acroread-9.5.5-1.el6_4.1.i686.rpmSHA-256: ac0934cfe887c6f49238ebff2c963adc33c1531019660bbfa4f8852d725136a2Downloadacroread-plugin-9.5.5-1.el6_4.1.i686.rpmSHA-256: 8116e41e4825f74478731a7e970482274db5c9d4b9489b9f70ca4e1a278e526bDownload

After installing the rpm with rpm -ivh AdbeRdr9.5.5-1_i486linux_enu.rpm command, we got dependency error for libxml2.so.  On installing libxml2.so, we got error for other missing dependencies.  So eventually we did yum install AdbeRdr9.5.5-1_i486linux_enu.rpm which installed about 80 rpms that acroread needs to function.

After installation, we kept getting this error:

dirname: missing operand

The post on http://www.linuxquestions.org/questions/slackware-14/error-message-dirname-missing-operand-when-starting-acroread-827012/ recommended a fix:

The issue was fixed by commenting line 529 in the bash script /opt/Adobe/Reader/bin/acrobat

529 #  [ -n "${MozPath}" ] || mozillaPath="`readlink "$MozPath" | xargs dirname`"

The DBAs were getting this error when they used sudo to login as applmgr:

Adobe Reader does not need to be run as a privileged user. Please remove 'sudo' from the beginning of the command

The post on https://forums.freebsd.org/threads/17345/ recommended that we comment line 331,332,333 and 334:

# Do not allow launch using 'sudo'.
#if [ "${ACRO_ALLOW_SUDO+set}" != "set" -a \( "${SUDO_USER+set}" = "set" -o "${SUDO_UID+set}" = "set" -o "${SUDO_GID}" = "set" \) ]; then
# printf "%s\n" "Adobe Reader does not need to be run as a privileged user. Please remove 'sudo' from the beginning of the command."
# exit 1
#fi

That fixed the sudo issue.

I have asked the DBA team to reach out to the Developers to stop using acroread and migrate to an alternative that is natively supported in Linux.  Here's more from Red Hat on their security advisory https://access.redhat.com/errata/RHSA-2013:1402 :

Red Hat advises users to reconsider further use of Adobe Reader for Linux,
as it may contain known, unpatched security issues. Alternative PDF
rendering software, such as Evince and KPDF (part of the kdegraphics
package) in Red Hat Enterprise Linux 5, or Evince and Okular (part of the
kdegraphics package) in Red Hat Enterprise Linux 6, should be
considered. These packages will continue to receive security fixes.
Red Hat will no longer provide security updates to these packages and
recommends that customers not use this application on Red Hat Enterprise
Linux effective immediately.
Categories: APPS Blogs

CPADMIN Utility for Managing Concurrent Processing Available for EBS 12.1

Steven Chan - Wed, 2017-07-12 02:00

I recently profiled a new CPADMIN command line utility for E-Business Suite 12.2.  That same tool is also available for EBS 12.1.3.  This tool consolidates various utilities for concurrent processing into a single menu-based utility. This ADADMIN-style utility can be used for multiple tasks, including:

  • View Concurrent Manager status
  • Clean CP tables
  • Set Concurrent Manager diagnostics
  • Start, stop, or verify an individual Concurrent Manager
  • Rebuild Concurrent Manager views
  • Move request files
  • Analyze requests
  • Configure request log/out file directory locations

Details for running the CPADMIN utility are published here:

This rollup patchset (RUP) also includes fixes for the following Concurrent Processing issues:

  • Bug 12821441 : JAVA CONCURRENT PROGRAMS DOES NOT ALWAYS WRITE OUTPUT VIA FND_FILE
  • Bug 14828523 : PREREQ PATCH FOR AFCMGR.ODF
  • Bug 14841198 : IPP PRINTER OPTIONS SET INCORRECTLY FOR DELIVERY
  • Bug 15981176 : ISSUES AFTER APPLYING FAILOVER PATCH 14828518:R12.FND.B
  • Bug 16602978 : STANDARD MANAGER ACTUAL AND TARGET PROCESSES ARE DIFFERENT.
  • Bug 17287546 : UNABLE TO SELECT AM/PM WHEN TRYING TO SCHEDULE CONCURRENT REQUESTS
  • Bug 17075600 : CONCURRENT REQUEST NOTIFY PART DOESN'T WORK SOMETIMES
  • Bug 18455555 : FNDCRM DOWN WHEN FND_CONFLICT_DOMAIN CONTAINS 65K+ ROWS
  • Bug 19479047 : R12.2.3 UPGR : INTERNAL CONCURRENT MANAGER CORE DUMPS AFTER ADOP CUTOVER
  • Bug 19887645 : ALTERING A SCHEDULE DATE GETS TODAY'S DATE RATHER THAN DATE ENTERED
  • Bug 20013011 : AFTER STEP 6.2.7 IS RUN ( NOTE 1070033.1 ) , WORKSHIFTS OF INTERNAL MONITOR IS W
  • Bug 20691679 : CANNOT INPUT REQUEST NAME WHEN SCHEDULING REQUEST 
  • Bug 21101859 : WHEN USING MLS FUNCTION XML REP DOES NOT PICK TRANSLATION
  • Bug 21251552 : CONCURRENT REQUEST VIEW PAGE FNDCPREQUESTVIEWPAGE SHOWS ALL REQUESTS OF OTHER US
  • Bug 21256003 : COMPETION NOTIFICATION SHOWING JUNK CHARACTERS WHEN
  • Bug 21385444 : AFCMGR.ODF FAILS WITH UNABLE TO COMPARE OR CORRECT TABLES OR INDEXES OR KEYS
  • Bug 21386094 : HIDDEN PARAMETERS NOT PASSED VIA SCHEDULE REQUEST PAGE - CPPROGRAMPG
  • Bug 21782311 : WHEN CANCEL A RUNNING REQUEST ON OAF STATUS GOT CANCELLED NOT TERMINATED

Related Articles

 

Categories: APPS Blogs

Check Concurrent Processing's Health with CP Analyzer

Steven Chan - Tue, 2017-07-11 11:10

In addition to helping customers resolve issues via Service Requests, Oracle Support also builds over 60 free diagnostic tools for Oracle E-Business Suite 12.2, 12.0, 12.1, and 11i. These Support Analyzers are non-invasive scripts that run health-checks on your EBS environments. They look for common issues and generate standardized reports summarizing that provide solutions for known issues and recommendations on best practices.

Here's an index to these tools:

Spotlight on Concurrent Processing Analyzer

I recently profiled the Workflow Analyzer. In addition to that tool, I'd recommend taking a look at the Concurrent Processing Analyzer:

The Concurrent Processing Analyzer reviews CP configurations and compares them against Oracle's best practices.

This tool can be run manually or configured to run as a concurrent request, so it can be scheduled to be run periodically and included in regular Workflow Maintenance cycles.

Can this script be run against Production?

Yes. There is no DML in the Analyzer Script, so it is safe to run against Production instances to get an analysis of the environment for a specific instance. As always it is recommended to test all suggestions against a TEST instance before applying to Production.

Related Articles

 

Categories: APPS Blogs

Mobile Approvals 1.6 Now Available for iOS and Android

Steven Chan - Mon, 2017-07-10 12:44

We are pleased to announce updates for the Oracle E-Business Suite Mobile Approvals 1.6 smartphone app for iOS and Android. These updates are delivered as part of Oracle E-Business Suite Mobile Release 7, which supports both Oracle E-Business Suite Release 12.1.3 and 12.2.3 and beyond.  Oracle E-Business Suite Mobile Release 7 is a coordinated release of 17 Oracle E-Business Suite mobile apps, excluding Mobile Expenses and Mobile Field Service, which have their own off-cycle releases. 

For information on the Approvals app, see:

For more details on the updates for all EBS mobile apps, see:

What's New in Mobile Approvals 1.6

  • Ability to reassign an approval notification
  • Support for push notifications when using Oracle Mobile Cloud Service and enterprise distribution
  • Mobile Foundation:
    • Ability to import custom CA or self-signed server certificates to standard apps for TLS connections to Oracle E-Business Suite
    • Ability to download the mobile app configuration automatically from the server
    • Technical updates with uptake of Oracle Mobile Application Framework (MAF) 2.4.0

Related Articles

Categories: APPS Blogs

ASC 606 & IFRS 15: Revenue from Contracts with Customers

OracleApps Epicenter - Sun, 2017-07-09 02:44
As we all know, on May 28, 2014, the International Accounting Standards Board (IASB) and the Financial Accounting Standards Board (FASB) together issued a converged standard about recognition of revenue from contracts with customers. Known as ASC 606, Revenue from Contracts with Customers, the standard will improve the financial reporting of revenue and improve comparability […]
Categories: APPS Blogs

Webcast: Getting Optimal Performance from Oracle E-Business Suite

Steven Chan - Thu, 2017-07-06 02:00

Oracle University has many free recorded webcasts that are useful for E-Business Suite system administrators.  Here's a good one on EBS performance tuning (this is always one of our most-popular sessions at OpenWorld):

Samer Barakat, Director Application Performance summarizes practical tips and lessons learned from performance-tuning and benchmarking the world’s largest Oracle E-Business Suite environments. Application system administrators will get concrete tips and techniques for identifying and resolving performance bottlenecks on all layers of the technology stack. They will also learn how Oracle’s engineered systems such as Oracle Exadata and Oracle Exalogic can dramatically improve the performance of their system. This material was presented at Oracle OpenWorld 2015.

Related Articles

Categories: APPS Blogs

Check Workflow's Health with Workflow Analyzer

Steven Chan - Wed, 2017-07-05 02:00

In addition to helping customers resolve issues via Service Requests, Oracle Support also builds diagnostic tools for Oracle E-Business Suite. Here's an index to all of these tools:

What do Support Analyzers do?

These Support Analyzers are non-invasive scripts that run health-checks on your EBS environments. They look for common issues and generate standardized reports summarizing that provide solutions for known issues and recommendations on best practices.

What areas do they cover?

There are over 60 different analyzers for EBS 11i, 12.0, 12.1, and 12.2. There are analyzers for the following product families:

  • E-Business Suite Core (Technology)
  • Financials
  • Manufacturing
  • Human Capital Management  
  • Customer Relationship Management  

Spotlight on Workflow Analyzer

If you haven't tried any of these tools, I'd strongly recommend getting started with the Workflow Analyzer:

The Workflow Analyzer reviews Workflow configurations and compares them against Oracle's best practices. The script reviews Workflow queues, runtime data, stuck activities, looping activities, and purging processes.

This tool can be run manually or configured to run as a concurrent request, so it can be scheduled to be run periodically and included in regular Workflow Maintenance cycles.

Can this script be run against Production?

Yes. There is no DML in the Workflow Analyzer Script (workflow_analyzer.sql), so it is safe to run against Production instances to get a current detailed overview of the Workflow environment for a specific instance. As always it is recommended to test all suggestions against a TEST instance before applying to Production.

References

Related Articles

 

Categories: APPS Blogs

Is It Possible to Link to Specific EBS Pages?

Steven Chan - Thu, 2017-06-29 02:00

This question comes up periodically:  Is it possible to bookmark a specific EBS OA Framework page and then successfully open that page even if the user is not logged in?

The answer is a qualified yes.  This is technically possible, but the page must be built to support that by an OA Framework developer.  It is not possible for EBS end-users to change an OAF page's definition.

Developers can make pages bookmarkable by following the instructions described in the OA Framework Developer's Guide, Chapter 6: Advanced OA Framework Development Topics > Security > Accelerated Validation > Bookmarkable Pages. Here's a link to the latest version:

The main requirement is that the page be self-secured with some associated supporting code.  The same requirement applies to EBS links included in Workflow email notifications, too.

Related Articles

Categories: APPS Blogs

New CPADMIN Utility for Managing Concurrent Processing Now Available

Steven Chan - Wed, 2017-06-28 02:00

In Oracle E-Business Suite, concurrent processing simultaneously executes programs running in the background with online operations. When a user runs a report, a request to run the report is generated. The command to run the report is a concurrent request. The program that generates the report is a concurrent program. Concurrent programs are started by a concurrent manager.

A new CPADMIN command line utility for E-Business Suite 12.2 consolidates various utilities for concurrent processing into a single menu-based utility. This ADADMIN-style utility can be used for multiple tasks, including:

  • View Concurrent Manager status
  • Clean CP tables
  • Set Concurrent Manager diagnostics
  • Start, stop, or verify an individual Concurrent Manager
  • Rebuild Concurrent Manager views
  • Move request files
  • Analyze requests
  • Configure request log/out file directory locations

Complete details for running the new CPADMIN utility are published here:

Related Articles

 

Categories: APPS Blogs

Webcast: Managing and Monitoring Oracle E-Business Suite On-Premises and Cloud

Steven Chan - Tue, 2017-06-27 02:00

Oracle University has a large number of free recorded webcasts that are useful for E-Business Suite system administrators.  Here's a new one on the latest Application Management Pack updates:

Vasu Rao, Senior Principle Product Strategy Manager, shares the latest tools including the Application Management Suite for monitoring and managing an Oracle E-Business Suite 12.2 environment. Among the topics covered for Oracle E-Business Suite on-premises and cloud environments are online patching management; monitoring the technology stack; configuration comparison between run and patch editions; provisioning an instance; technology stack patch recommendations; customization management; and automated cloning. This material was presented at Collaborate 17.

Related Articles

 

Categories: APPS Blogs

Creating Custom Applications in EBS 12.2

Steven Chan - Mon, 2017-06-26 02:00

The least invasive method of fine-tuning your E-Business Suite environment to your users' needs is via personalizations.  If that approach is insufficient, you can create custom applications via Forms, Reports, and other technologies that segregate your customizations from the standard functionality provided with Oracle E-Business Suite.

If you're considering that approach for customizing EBS 12.2, see:

This Note covers:

  • Using adsplice to create a custom application
  • Verifying the creation of custom products in the database 
  • Running AutoConfig to set-up application servers
  • Creating custom objects, including tables, indexes, and sequences
  • Propagating changes to your file systems

Related Articles

Categories: APPS Blogs

Using Patch Wizard to Identify Files Affected by Specific Patches

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

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

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

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

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

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

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

Pages

Subscribe to Oracle FAQ aggregator - APPS Blogs