APPS Blogs

Updated: Creating Custom EBS 12.2 Applications White Paper

Steven Chan - Thu, 2018-04-12 13:01

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.

We have updated our white paper that describes steps for creating these custom application extensions:

Based on your feedback via Oracle Support, we've expanded various sections with additional background. Please feel free to comment on your experiences with this documentation or by logging a Service Request with Oracle Support.

Related Articles

 

Categories: APPS Blogs

New Whitepaper: Solutions to EBS 12.2 Upgrade Performance Issues

Steven Chan - Thu, 2018-04-05 11:51

Our Performance Group has just released a new whitepaper:

This white paper lists performance issues that may slow down your upgrade to E-Business Suite 12.2. It lists:

  • Upgrade performance issues fixed in EBS 12.2.7, 12.2.0 Cumulative Update Patch 8 (CUP8), or associated patches
  • Standalone performance upgrade issues with fixes
  • Database fixes for EBS upgrade performance issues
  • Workarounds for known upgrade performance bugs

This is a companion document to a previously-published white paper:

Both whitepapers are updated regularly with the latest information available, so they would be worth bookmarking and flagging for updates.

Related Articles

 

Categories: APPS Blogs

New OA Framework 12.2.6 Update 11 Now Available

Steven Chan - Mon, 2018-04-02 17:03

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.

We periodically release 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:

Oracle Application Framework (FWK) Release 12.2.6 Bundle 11 (Patch 27529582:R12.FWK.C)

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.

In addition, this latest bundle patch includes fixes for the following issues:

  • TO BE SUPPLIED

Related Articles

Categories: APPS Blogs

Set Thread Count for EBS 12.2 Application Tier Servers

Steven Chan - Mon, 2018-03-26 17:48

Our September 2017 updates to the Applications DBA (AD) and EBS Technology Stack (TXK) tools for EBS 12.2 contained an enhancement that you might have missed. The AD/TXK Delta 10 updates include a new context variable for the adstrtal and adstpall application tier control scripts:

s_srvctl_thread_count

This new context variable allows you to set the thread count for the adstrtal and adstpall application tier service control scripts. This parameter allows you to start managed servers in batches specified by the variable. One of our largest customers was experiencing some performance-related issues that were partially-addressed by this enhancement.

The default value of this variable is 10, which is the hardcoded value that was previously used in these scripts. Depending on your requirements, you can now change the value. Overriding this value could have a positive impact on performance, for example, in a large server where there are 64 CPUs. The setting should be based on the number of processors on the system. It must always be a value greater than zero, and should not exceed twice the number of processors. 

Remember, you should always upgrade your EBS 12.2 environments to the latest AD and TXK updates whenever they're released. 

References

Related Articles

Categories: APPS Blogs

Update Available for Integrated SOA Gateway in EBS R12.1.3

Steven Chan - Wed, 2018-03-21 12:16

Oracle E-Business Suite Integrated SOA Gateway (ISG) provides an infrastructure to provide, consume, and administer Oracle E-Business Suite web services. EBS public APIs registered in Integration Repository, can be deployed as SOAP and/or REST-based web services. ISG also provides a service invocation framework to consume external SOAP based web services.

Recently, we released a consolidated patch for Integrated SOA Gateway in EBS R12.1.3. It includes fixes related to JSON payload handling in REST Services, SOAP Service Auditing, and performance of ISG web services.

You can download the latest ISG consolidated patch here:

This is a cumulative patch update that includes all previously released ISG updates for EBS R12.1.3. We recommend you to apply the latest available consolidated patch for ISG.

References

Related Articles

Categories: APPS Blogs

Export List of Files Changed by an EBS Patch to CSV

Steven Chan - Tue, 2018-03-20 11:59

Patch Wizard compares patches in your EBS environment against a list of all recommended Oracle E-Business Suite patches. Recommended patches can include high-priority patches or patches that update to a new codelevel, such as release update packs (RUPs), product family RUPs, and pre-upgrade patches.

Patch Wizard can analyze the impact of specific patches on your environment. It can list new files introduced and all of the files that are changed by those patches. You can then export the list of files to a Comma Separated Values (CSV) file that can be opened in a spreadsheet such as Microsoft Excel. 

The export functionality listing impacted files was delivered for both EBS 12.1 and 12.2:

You can always find the latest Patch Wizard updates for EBS 12.1.3 and 12.2 documented here:

Related Articles

Categories: APPS Blogs

New Recommended Patch Collection for Web ADI 12.2 Now Available

Steven Chan - Thu, 2018-03-15 11:40

Oracle Web Applications Desktop Integrator (Web ADI) allows you to use Microsoft Office applications such as Excel, Word, and Project to upload data to Oracle E-Business Suite. For example, you can use Excel to create formatted spreadsheets on your desktop to download, view, edit, validate, and upload Oracle E-Business Suite data. 

We have just released a new Recommended Patch Collection for Web ADI update in EBS 12.2:

This patch is cumulative and includes all previously released patches for Web ADI 12.2.  This includes the last patch collection released in July 2016 (23733865:R12.BNE.C).

We recommend that all Web ADI users apply this patch. It includes fixes for the following issues:

  • 17315839 - AFTER APPLYING PATCH 16536996, "EACH ROW" DOESN'T COMMIT VALID ROWS
  • 17455458 - UPLOAD INTERFACE TAKES MORE THAN ICX: SESSION TIMEOUT FOR 125K ROWS
  • 19527110 - PERF: GL JOURNAL UPLOAD SLOW COMPARED TO CLIENT ADI
  • 22512856 - R: CONNECTION LEAK OCCURS AFTER THE FIX OF BUG 20915362
  • 22575948 - 22512856: R: CONNECTION LEAK OCCURS AFTER THE FIX OF BUG
  • 20915362 23140772 - FWD-PORT REQUEST OF 17455458:R12.BNE.B ICX: SESSION TIMEOUT TO 12.2.4

Related Articles

Categories: APPS Blogs

New Update Available for Integrated SOA Gateway in EBS 12.2

Steven Chan - Wed, 2018-03-14 13:46

Oracle E-Business Suite Integrated SOA Gateway (ISG) provides an infrastructure to provide, consume, and administer Oracle E-Business Suite web services. It service-enables public integration interfaces registered in Oracle Integration Repository. These interfaces can be deployed as SOAP and/or REST-based web services. ISG also provides a service invocation framework to consume external SOAP based web services.

We have just released a new Integrated SOA Gateway update for EBS R12.2. It includes fix for issues in the PostClone script used for SOAP services.

PostClone script for SOAP services: This script is used to reinstate the SOAP services in an cloned EBS environment. If you have cloned an environment  configured with ISG SOAP Services, then you need to:

  1. Re-configure ISG for SOAP services
  2. Execute ISG PostClone script

For details, see Section 11 in: 

You can download the latest ISG consolidated patch here:

Patch 27498317:R12.OWF.C - ISG Consolidated Patch (18_1_3)

This is a cumulative patch update that includes all previously released ISG updates for EBS R12.2.  It can be applied on EBS R12.2.3 and higher releases. Check the Readme for this patch for information on prerequisite patches.

References

Related Articles

Categories: APPS Blogs

Finding your Ikigai

OracleApps Epicenter - Sun, 2018-03-04 09:24
Do you know , The Japanese Concept ‘Ikigai’ is a Formula for Happiness and Meaning Ikigai ( pronounce ee-kee-guy ): passion | love | mission | vocation | profession Everyone, according to Japanese culture, has an ikigai. Finding it requires a deep and often lengthy search of self. It is your reason to get up […]
Categories: APPS Blogs

Upgrading Oracle SOA Suite 11g to Oracle SOA Suite 12c in an Existing ISG configuration

Steven Chan - Mon, 2018-02-26 11:06

I am pleased to announce the certification of steps to upgrade Oracle SOA Suite 11g to Oracle SOA Suite 12c for an existing Oracle E-Business Suite Integrated SOA Gateway (ISG) configuration. In Oracle E-Business Suite Release 12.2, ISG’s SOAP service provider framework uses Oracle SOA Suite and its E-Business Suite Adapter.

If your Oracle E-Business Suite Integrated SOA Gateway R12.2 is already configured with Oracle SOA Suite 11g (11.1.1.9.0) for SOAP based web services and, if you plan to upgrade such Oracle SOA Suite to Oracle SOA Suite 12c (12.2.1.2), refer Section 4.2 of Installing Oracle E-Business Suite Integrated SOA Gateway Release 12.2 (MOS 1311068.1).

<<image>>

Major steps to upgrade Oracle SOA Suite for ISG include:

  1. Oracle Fusion Middleware Pre-upgrade tasks
  2. Upgrade tasks
  3. Post-upgrade tasks
  4. ISG Setup Verification

These steps apply for single node installation of Oracle SOA Suite as well as multiple node installation as per Oracle Fusion Middleware Enterprise Deployment Guide for Oracle SOA Suite.

References

Related Articles

 

Categories: APPS Blogs

Upcoming FMW/WLS for EBS Webinar - OAUG AppsTech 2018

Steven Chan - Fri, 2018-02-23 02:00

The Oracle E-Business Suite Release 12.2 technology stack employs Oracle Fusion Middleware (FMW) 11g, including Oracle WebLogic Server (WLS).

Join us for this upcoming webinar and learn about administration, configuration and troubleshooting of these key components of the current EBS architecture.

  • Presenters: Kevin Hudson (EBS Development), Elke Phelps (EBS Product Management)
  • Title: Oracle E-Business Suite 12.2: Fusion Middleware (WebLogic Server) Administration
  • Date and Time: Tuesday, February 27, 2018, 1:00 p.m. EST (6.00 p.m. GMT)

You can register here for this OAUG AppsTech eLearning Series session.

A complete listing of sessions for the OAUG AppsTech eLearning Series is available on the OAUG website.

References
Categories: APPS Blogs

New OA Framework 12.2.6 Update 10 Now Available

Steven Chan - Thu, 2018-02-22 11:16

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.

We periodically release 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:

Oracle Application Framework (FWK) Release 12.2.6 Bundle 10 (Patch 27308923:R12.FWK.C)

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.

In addition, this latest bundle patch includes fixes for the following issues:

  • When a Descriptive Flexfield (DFF) is in an advanced table under a query bean, some of its segments may not be displayed. Instead, other columns of the table may be repeated, or the same segment may be repeated.

Related Articles

Categories: APPS Blogs

EBS Release 12.2.7 VM Virtual Appliance Now Available

Steven Chan - Tue, 2018-02-20 12:10

[Contributing author: Robert Farrington]

We've just released an Oracle E-Business Suite Release 12.2.7 VM Virtual Appliance on the Oracle Software Delivery Cloud.

Note: The software package shown above includes a README document with useful getting started guidance.

You can use this appliance to create an Oracle E-Business Suite 12.2.7 Vision demonstration instance on a single, unified virtual machine containing both the database tier and the application tier.

Use with Oracle VM Manager or Oracle VM VirtualBox

This virtual appliance can be imported into Oracle VM Manager to deploy an Oracle E-Business Suite Linux 64-bit environment on compatible server-class machines running Oracle VM Server. It can also be imported into Oracle VM VirtualBox to create a virtual machine on a desktop PC or laptop.

Note: This virtual appliance is for on-premises use only. If you're interested in running Oracle E-Business Suite on Oracle Cloud, see Getting Started with Oracle E-Business Suite on Oracle Cloud (My Oracle Support Knowledge Document 2066260.1) for a comprehensive overview of what is available.

EBS Technology Stack Components

The Oracle E-Business Suite 12.2.7 VM virtual appliance delivers the full software stack, including the Oracle Linux 6.9 (64-bit) operating system, Oracle E-Business Suite, and additional required technology components.

The embedded technology components are listed below:

Component Version RDBMS Oracle Home 12.1.0.2 Application Code Level Oracle E-Business Suite 12.2.7 Release Update Pack (see My Oracle Support Knowledge Document 2230783.1) with AD-TXK Delta 10 (see My Oracle Support Knowledge Document 1617461.1) Oracle Forms and Reports 10.1.2.3 WebLogic Server 10.3.6 Web Tier 11.1.1.9 JDK JDK 1.7 build 1.7.0_161-b13 Java Plugin J2SE 1.7 Critical Patch Update (CPU) October 2017

 

REST Services Availability

Oracle E-Business Suite Integrated SOA Gateway (ISG) provides functionality to expose integration interfaces published in the Integration Repository as SOAP and REST based web services. Oracle VM Virtual Appliance for Oracle E-Business Suite Release 12.2.7 is configured for ISG REST Services. PL/SQL APIs, Java Bean Services, Application Module Services, and Concurrent Programs are REST enabled in this VM virtual appliance.

References Related Articles
Categories: APPS Blogs

Upcoming Desktop Integration Webinar - OAUG AppsTech 2018

Steven Chan - Tue, 2018-02-20 11:01

Join us for this upcoming Oracle E-Business Suite webinar and learn about recent enhancements and features in EBS Desktop Integration:

  • Presenter: Senthilkumar Ramalingam, Oracle Applications Technology Development
  • Title: Oracle E-Business Suite Desktop Integration
  • Date and Time: Wednesday, February 21, 2018, 1:00 p.m. EST (6.00 PM GMT)

You can register here for this OAUG AppsTech eLearning Series session.

A complete listing of sessions for the OAUG AppsTech eLearning Series is available on the OAUG website.

References
Categories: APPS Blogs

Oracle Adaptive Intelligent Applications for ERP

OracleApps Epicenter - Fri, 2018-02-16 11:51
Recently Oracle announced new AI-based Apps for Finance Leaders to empower CFOs w/ data-driven insights to adapt to change, develop new #markets & increase profitability! With Oracle Adaptive Intelligent Applications for ERP, finance leaders can benefit from: Better insight: Making use of analytics and synthetic intelligence to finance can enhance efficiency and will increase agility […]
Categories: APPS Blogs

When is the Best Time to Apply AD & TXK Patches?

Steven Chan - Tue, 2018-02-13 13:36

E-Business Suite 12.2's Online Patching feature allows you to apply patches to your environment while it is still running. For example, you can apply patches to Financials while your end-users are entering bills in Accounts Receivable. These patches are applied using our Applications DBA (AD) and EBS Technology Stack (TXK) tools.

A reader recently asked whether it's advisable to apply our latest EBS 12.2.7 update at the same time as our  AD-TXK Delta 10 updates. This is a great question, since it touches on both our goals for our AD and TXK tools as well as our internal testing practices for new updates and patches.

The short answer: You should apply the latest AD and TXK infrastructure tools in an initial patching cycle, and then apply EBS updates and patches (e.g. EBS 12.2.7) in a later patching cycle.

Why?

There are two reasons:

  1. Latest AD/TXK tools are better. The latest AD and TXK tool updates always include new patching-related features, as well as critical fixes for stability, security, and performance. For example, the September 2017 AD and TXK Delta 10 updates included new features for parallel index optimization, seed data handling, synchronization of theme files on cutover, and more.
     
    If you have the latest patching tools in place, the latest AD/TXK enhancements, improvements, and fixes reduce risk during the patching process itself. 
     
  2. Updates are always tested with the latest AD/TXK tools.  We do not generally have the resources to test new EBS patches with older patching tools. We always test the installation of our latest EBS updates (e.g. EBS 12.2.7) using the latest AD and TXK patches available at the time. In other words, you may encounter unexpected issues if you apply new patches using older patching tools.

Do new AD and TXK patches trigger functional re-testing?

New AD and TXK patches do not change any aspects of how EBS functional products work.  These infrastructure tools affect how patches are applied, not how patches work.  

In other words, having the latest AD/TXK updates may reduce the risk of applying, say, a new HRMS patch, but it will not affect any Human Resources-related functionality at all.

Likewise, applying the latest AD/TXK update does not affect the functionality of any existing EBS products. Infrastructure tools only affect the patching process, not how installed EBS products work. 

How do I find the latest AD and TXK tools?

Check the following reference:

You should periodically check Document 1617461.1 on My Oracle Support for updates, which are made as required. For example, new bundled fixes or critical one-off patches may become available, or the release update packs may be superseded by newer versions.

Related Articles

Categories: APPS Blogs

Forms & Reports Developer 10g Requires Windows 7

Steven Chan - Fri, 2018-02-09 12:02

Forms & Reports Developer 10g (10.1.2.3) is required to maintain customizations in EBS 12.1 and 12.2. We previously announced certifications for Windows 10 (32-bit and 64-bit) and Windows 8.1 (32-bit and 64-bit) clients for Forms & Reports Developer 10g.

Since those certifications were announced, we have identified issues that prevent us from delivering fixes for those configurations. Unfortunately, we must rescind those certifications.

EBS 12.1 and 12.2 system administrators must retain a Windows 7 (32-bit) PC to maintain customizations using Forms & Reports Developer 10g (10.1.2.3).

References

Categories: APPS Blogs

New Report Manager 12.2 Feature: Copy Custom Templates

Steven Chan - Thu, 2018-02-08 12:46

Oracle Report Manager is an online report distribution system that allows you to produce and manage point-in-time reports. Oracle Report Manager users can be either report producers or report consumers. Report producers submit, publish, and set security for reports. Report consumers view and approve reports.

Our Report Manager team has just released a new feature for EBS 12.2: you can copy custom Financial Statement Generator (FSG) report templates between Oracle E-Business Suite 12.2 instances. For example, you can use this new feature to transfer templates from a test instance to a production instance.

For details, see:

The Report Manager - Transfer FSG Custom Templates program lets you transfer custom FSG report templates between Oracle E-Business Suite instances. You can transfer a single template, a group of templates whose names begin with the same value, or all custom templates in the source instance. If the target instance already contains a template whose name matches a template being transferred from the source instance, you can choose whether to overwrite or preserve the existing template in the target instance.

This program does not transfer Rich Text Format (RTF) templates. For information on uploading RTF templates, see the Oracle XML Publisher Administration and Developer's Guide.

This program transfers only custom templates. To add or upgrade templates provided by Oracle, apply the patches containing those template definitions.

Related Articles

Categories: APPS Blogs

New OA Framework 12.2.5 Update 19 Now Available

Steven Chan - Tue, 2018-02-06 11:46

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 (TBS) 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:

  • Tip type is not displayed in advanced search region in 'Screen Reader Optimized' accessibility mode.

Related Articles

Categories: APPS Blogs

Join Us for the OAUG AppsTech 2018 eLearning Series

Steven Chan - Mon, 2018-02-05 12:15

Mark your calendar and join us for the upcoming OAUG AppsTech eLearning Series.  As part of this OAUG sponsored series, members of Oracle E-Business Suite Development and Product Management will be providing the following webinars:

Technical Essentials for Running Oracle E-Business Suite on Oracle Cloud
Speaker:  Santiago Bastidas,
Date & Time: Tuesday, February 13, 1:00 PM EST

Faster and Better:  Oracle E-Business Suite Desktop Integration
Speaker:  Senthilkumar Ramalingam
Date & Time: Wednesday, February 21, 2018, 1:00 p.m. EST

Oracle E-Business Suite 12.2:  Fusion Middleware (WebLogic Server) Administration
Speakers:  Kevin Hudson and Elke Phelps
Date & Time: Tuesday, February 27, 2018, 1:00 p.m. EST

A complete listing of sessions for the AppsTech eLearning Series is available on the OAUG website.

References

 

Categories: APPS Blogs

Pages

Subscribe to Oracle FAQ aggregator - APPS Blogs