Steven Chan

Subscribe to Steven Chan feed
Oracle Blogs
Updated: 1 hour 5 min ago

CPADMIN Utility for Managing Concurrent Processing Available for EBS 12.1

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

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

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

Webcast: Getting Optimal Performance from Oracle E-Business Suite

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

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?

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

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

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

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

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

Pages