Thursday Jan 17, 2013

Forms and Reports 10g certified with EBS 12

Oracle E-Business Suite Release 12 uses Oracle Forms & Reports 10g in its internal technology stack. Each of the three EBS 12 Rapid Installs included newer versions of the Forms & Reports-based components:

EBS Release 12 Rapid Install Version

12.0.0 12.0.4 12.1.1
OracleAS 10.1.2 Forms & Reports
OracleAS 10.1.3 OC4J
App Tier Java (JDK) 1.5.0_10 1.5.0_13 1.6.0_10
Desktop Client Java (JRE) 1.5.0_10-erdist 1.5.0_13 1.6.0_u10

Oracle Fusion Middleware periodically issues bundle patches -- collections of critical bug fixes, security updates, and minor enhancements.  Bundle patches are cumulative: they include all patches released in previous bundle patches.

The latest Oracle Forms & Reports 10g Bundle Patch 2 is now certified with all Oracle E-Business Suite 12 releases. Note that the Forms version remains unchanged after application of this patch.  All EBS 12.0 and 12.1 environments should be upgraded to this Bundle Patch:


  • This bundle is specifically and exclusively designed for application to the OracleAS (Forms and Reports) Oracle Home used in all Oracle E-Business Suite 12.0.x and 12.1.x releases.
Certified Platforms
  • The bundle is available for all certified platforms that support the Oracle E-Business Suite releases mentioned.


Related Articles

Wednesday Apr 18, 2012

Webcast Replay Available: Diagnosing E-Business Suite JVM and Forms Performance Issues (Performance Series (Performance Series Part 4 of 4)

I am pleased to release the replay and presentation for the latest ATG Live Webcast: 

Diagnosing E-Business Suite JVM and Forms Performance Issues (Performance Series (Performance Series Part 4 of 4) (Presentation)

Debugging JVM logs

Dave Suri, Project Lead, Applications Performance and Gustavo Jimenez, Senior Development Manager discussed some of the steps involved in triaging and diagnosing E-Business Suite systems related to JVM and Forms components (March 2012).

Finding other recorded ATG webcasts

The catalog of ATG Live Webcast replays, presentations, and all ATG training materials is available in this blog's Webcasts and Training section.

Friday Mar 23, 2012

ATG Live Webcast March 29: Diagnosing E-Business Suite JVM and Forms Performance Issues (Performance Series Part 4 of 4)

The next webcast in our popular EBS series on performance management is going to be a showstopper.  Dave Suri, Project Lead, Applications Performance and Gustavo Jimenez, Senior Development Manager will discuss some of the steps involved in triaging and diagnosing E-Business Suite systems related to JVM and Forms components.

Please join us for our next ATG Live Webcast on Mar. 29, 2012:

Triage and Diagnostics for E-Business Suite JVM and Forms

Debugging JVM logs

The topics covered in this webcast will be:

  • Overall Menu/Sections
    • Architecture
    • Patches/Certified browsers/jdk versions
    • JVM Tuning
    • JVM Tools (jstat,eclipse mat, ibm tda)
    • Forms Tools (strace/FRD)
    • Java Concurrent Program options location
    • Case studies
  • Case Studies
    • JVM Thread dump case for Oracle Advanced Product Catalog
    • Forms FRD trace relating to Saving an SR
    • Java Concurrent Program for BT

Date:               Thursday, March 29, 2012
Time:              8:00 AM - 9:00 AM Pacific Standard Time
Presenters:  Dave Suri, Project Lead, Applications Performance
                        Gustavo Jimenez, Senior Development Manager

Webcast Registration Link (Preregistration is optional but encouraged)

To hear the audio feed:
   Domestic Participant Dial-In Number:            877-697-8128
    International Participant Dial-In Number:      706-634-9568
    Additional International Dial-In Numbers Link:
    Dial-In Passcode:                                              99342

To see the presentation:
    The Direct Access Web Conference details are:
    Website URL:
    Meeting Number:  597073984

If you miss the webcast, or you have missed any webcast, don't worry -- we'll post links to the recording as soon as it's available from Oracle University.  You can monitor this blog for pointers to the replay. And, you can find our archive of our past webcasts and training here.

If you have any questions or comments, feel free to email Bill Sawyer (Senior Manager, Applications Technology Curriculum) at BilldotSawyer-AT-Oracle-DOT-com. 

Tuesday Aug 31, 2010

New Forms and Reports Bundle Patch Certified with EBS 12

Our Oracle Forms team has consolidated a large number important fixes on top of Forms and Reports version into a new bundle patch. This patch is available for download now under the ungainly title of:
This bundle patch is now certified with EBS Release 12 for all supported platforms except Linux on IBM System z.

Screenshot of download screen for Forms 10 1 2 3 1 bundle patch 9593176

This patch contains a total of 113 fixes. We strongly recommend that you apply this bundle patch on the Forms and Reports Oracle Home following the instructions in:
EBS customers should ignore the README

An important note: this bundle patch's README is not applicable to EBS environments. EBS customers should ignore the patch's README and refer to the Note above.  This bundle patch contains some of the E-Business Suite interoperability patches that are already documented in Step 2.1.2 of the Note above, including interoperability patches needed to resolve Forms focus issues. 

Any conflicts reported by the opatch utility while applying this bundle to E-Business Suite environments can be safely ignored.

Doesn't change the Forms & Reports version

Application DBAs need to note that the Forms and Reports version after applying this patch remains at  Hence, it is more like a CPU or MLR patch that is applied on this Oracle Home.

You can run the following command to check if this patch has been successfully applied:
> opatch lsinventory
Related Articles

Wednesday Jun 17, 2009

Which is Better: Forms Servlet or Socket Mode?

Many products within the Oracle E-Business Suite have screens that are built with Oracle Forms.  Oracle Forms can be run in either servlet mode or socket mode.  Apps 11i is based on Forms 6i and is configured to run in socket mode by default.  Apps 12 is based on Forms 10g and is configured to run in servlet mode by default. What are these modes, and which is better?

What is Forms Servlet Mode?

The Forms Listener Servlet is a Java servlet that delivers the ability to run Oracle Forms applications over HTTP and HTTPS connections. It manages the creation of a Forms Server Runtime process for each client, as well as network communications between the client and its associated Forms Server Runtime process.

The desktop client sends HTTP requests and receives HTTP responses from the web server. The HTTP Listener on the web server acts as the network endpoint for the client, keeping other servers and ports from being exposed at the firewall.

Forms listener servlet diagram showing firewalls desktop client and oc4j container on application tier

What is Forms Socket Mode?

Initial releases of the Oracle Forms Server product used a simple method for connecting the client to the server. The connection from the desktop client to the Forms Listener process was accomplished using a direct socket connection.  The direct socket connection mode was suitable for companies providing thin client access to Forms applications within their corporate local area networks. For the direct socket connection mode, the client had to be able to see the server and had to have permission to establish a direct network connection.

Although the direct socket connection mode is perfectly suited for deployments within a company’s internal network, it's not the best choice for application deployment via unsecured network paths via the Internet. A company connected to the Internet typically employs a strict policy defining the types of network connections that can be made by Internet clients to secure corporate networks. Permitting a direct socket connection from an external client exposes the company to potential risk because the true identity of the client can be hard to determine.

Servlet Mode Advantages

  1. HTTP and HTTPS traffic is easily recognizable by routers, while socket mode communications is generally considered suspect and treated on an exception basis. 
  2. Existing networking hardware can be used to support basic functions such as load-balancing and packet encryption for network transit.
  3. More resilient to network and firewall reconfigurations.
  4. More robust: servlet connections can be reestablished if network connections drop unexpectedly for Forms, Framework, and JSP-based pages.
  5. Is the only supported method for generic Oracle Forms customers, and therefore is more thoroughly tested by the Forms and E-Business Suite product groups.
  6. Performance traffic can be monitored via tools like Oracle Real User Experience Insight (RUEI).
  7. Socket mode is not supported on Windows-based server platforms.

Socket Mode Advantages

  1. Uses up to 40% less bandwidth than Forms servlet mode.  This may be perceived by Wide Area Network (WAN) users as causing slower responsiveness, depending upon network latency.
  2. Uses fewer application-tier JVM resources than servlet mode, due to fewer TCP turns and lack of overhead associated with HTTP POST handling.

Switching Apps Deployments Between Modes

Due to its numerous advantages, Forms servlet mode is the preferred and recommended deployment model for Forms on the web. 

There may be circumstances where you need to switch between the default Forms modes.  You might wish to switch your Oracle E-Business Suite Release 12 environment to socket mode to improve performance or reduce network load.  You might wish to switch your Apps 11i environment to servlet mode as part of your rollout to external web-based end-users outside of your organization.

If you're running Apps 11i and would like to switch to servlet mode, see:

If you're running Apps 12 and would like to switch to socket mode, see:

Related Articles

Saturday Mar 28, 2009

Premier Support for Forms Ends in April 2009

Oracle Fusion Middleware Forms Logo

Oracle E-Business Suite Release 12 includes OracleAS Forms & Reports 10g as part of its technology stack.  EBS 12.0.0 shipped with Forms  We certified Forms with EBS 12 in August 2007 and with Forms in November 2008.

You should be aware that the Forms grace period will end in April, 2009.  After April 2009, you will still be able to download existing Forms patches, but new patches will be issued only for the latest release.

If you're running your E-Business Suite environment on Forms, I would strongly recommend planning an upgrade to the most-current certified Forms release. As of today, that's Forms  Future readers coming across this article should refer to this blog's one-page Certifications summary for the latest certified configurations.

Want To Know More About Support Policies?

The Server Technologies support policies have recently changed in some important ways.  I've discussed the E-Business Suite implications of those changes in these articles: 

Your Thoughts?

I don't represent Server Technologies organization (I'm in E-Business Suite Development), but I'm happy to pass on your thoughts and feedback about Oracle's support policies to management teams in those groups.  Feel free to post a comment below or send me a private email.

Related Articles

Monday Nov 24, 2008

OracleAS 10g Forms and Reports Certified With EBS R12

I am pleased to announce that OracleAS 10g Forms and Reports version is now certified with Oracle E-Business Suite Release 12. EBS 12 ships with Forms If you're still running that version, you now have the choice of updating to either Forms or Forms We strongly recommend Forms For the steps to upgrade to this latest version of Forms, refer to the Metalink Notes in the Documentation section below. Along with Form and Reports Services, Developer Suite is also certified. AS10123.PNG[Read More]

Tuesday Sep 04, 2007

Using Forms + Reports 10g Builders with Release 12

[Oct 19, 2007 Update:  A bug prevented the execution of any Oracle Reports on on the IBM AIX platform.  Patch 6341158 has been released to resolve this issue]

Good things always seem to happen while I'm out of the office.  This may be a good incentive for me to spend more time on vacation (even though my groaning inbox begs to differ).

Expenses R12 Screenshot:

While I was out, a new Note was published externally:
The newly-published Note 444248.1 provides the rest of the picture outlined in this companion document:
How Do These Notes Relate?

We now have a complementary set of documents.  Once you've upgraded your E-Business Suite Release 12 environment with the latest version of Forms & Reports 10g using Note 437878.1, you can configure your development environment using the guidelines and procedures in the newly-published Note 444248.1.

The latter Note is full of tips on:
  • Running the Forms 10g Builder
  • Running the Reports 10g Builder
  • Setting up an R12 environment with a separated Developer Suite 10.1.2 instance
  • Compiling forms and reports


Monday Aug 13, 2007

Upgrading Release 12 to Forms

I'm pleased to announce that you can now upgrade your Release 12 environments to use the latest version of Forms & Reports 10g.  This caps off a string of recent new certifications, including Single Sign-On, Portal, and Web Cache

Expenses R12 Screenshot:

This update allows Release 12 users to take advantage of the latest stability, performance, and security updates in the latest Forms & Reports 10g release. 

Supported Platforms
  • Linux x86-32
  • Linux x86-64
  • Sun Sparc Solaris
  • HP-UX PARisc
  • HP-UX Itanium
  • Microsoft Windows 2003
For More Information

Tuesday Jul 18, 2006

Forms Personalization - Get It While It's Hot!

 So, it's all about J2EE, right?

Well, it will be - and we're all excited by the move to the Fusion Applications platform, and its early form, Oracle Applications Framework.

But we still live in a world with Oracle Forms, and we will continue to do so for  Release 12. Importantly, you can stay on these releases as long as they provide you business value, so you can move to Fusion Applications on your timeframe, not ours. (Close your eyes and say 'Applications Unlimited' . Feels good, doesn't it?)

So it's important for us to let you change your business practices at the lowest cost of ownership on the Forms stack, and Forms Personalization lets you do that. It's a feature that's been out just under 2 years, but this is a great venue to highlight it to make sure you're taking maximum advantage of it.

What now?

Forms Personalization takes the Custom Library (CUSTOM.PLL) concepts and makes them much easier to implement. Like much easier. Like going from your VCR to a Tivo easier. CUSTOM.PLL coding is all hand-tooled PL/SQL which is controlled in a single source file, by default. It allows implementers to trap various Forms triggers and take actions based on them.

All Forms Personalizations, on the other hand, are stored as metadata, and so they are all seamlessly upgraded without needing to be re-applied or addressed - just like Flexfields or Folder definitions! Forms Personalization provides tools to perform the same configurations, in the form of a Form. (Say that fast, huh?)

Open any Form in 11i10, and go to Help->Diagnostics->Custom Code-> Personalize. This brings up the Personalization Form in the context of the Form and Function that you were in. This is where you build the Personalizations specific to that Form or Function.

The page has two major tabs: Conditions and Actions. Forms Personalization is basically a big set of if-then statements that can execute because of various events that take place on that Form.


Conditions determine IF a personalization executes after a specific event or Forms trigger (including MENU or SPECIAL triggers). Triggers (WHEN-NEW-ITEM-INSTANCE, WHEN-VALIDATE, etc.) can be attached to objects, such as this example - when the user tabs out of the Purchase Order Type field into the Supplier Name field. Note that Conditions include conditional logic (only if the PO Type is 'Planned Purchase Order', e.g.), and scopes (only for Purchasing Superuser responsibility or Vision Operations organization or Joe the useless intern).



Actions are the list of specific things that you want to have happen. The major actions are:

  • Builtin: Form or PL/SQL built-ins like executing a procedure, mimicking a key stroke, navigating to another function, opening a URL, etc. Very powerful indeed.

  • Property: Set the Forms property value of a form item (If it's a Planned Purchase Order, set the Required property of the Description item in the PO_Header block to TRUE, e.g.)

  • Message: put up a prompt warning like an OK box (cool because you can populate the message with data from screen variables, lookups, or calculations)

  • Menu: Enables a special menu entry, defining its label, icon name and blocks to which it applies.


How now? (.... 'brown cow?')

Those are the basics, and I think you can see how much more accessible this power is now. It's easily managed, as well. For example, there are delivered FNDLOAD scripts for migrating these personalizations between instances (DEV > TEST > PROD), as well as entering them in version control systems.

Also, there is a central form for identifying the personalizations and turning them off! Pretty good if you completely hose up the WHEN-NEW-FORM-INSTANCE event... (Not that I've done that. Not that I would tell you, anyway.)

Couple of last notes

Forms Personalization receives events before CUSTOM.PLL does but then passes them normally to CUSTOM.PLL... Your existing CUSTOM.PLL logic will continue to work, but you can introduce these Personalizations first.

Forms Personalization was tested for performance and has been found to have very low impact. So don't worry about using this on heavily trafficked forms.

You need FND 11.5.10 minipack (FND.H), patch 3262159; alternately, it's included in ATG Family Pack H with additional niceties.

In all, it's great stuff, and while many folks have already done a bunch of CUSTOM.PLL library work, some may have shied away from it, or might have other small tasks that can now be trivially done. Of course, if you're just implementing, you'll find this very valuable.


Wednesday Apr 26, 2006

Why Use Two ORACLE_HOMEs for Release 12's Application Tier?

Why use two different OracleAS 10g releases in two different ORACLE_HOMEs for the upcoming Oracle E-Business Suite Release 12?  Because you asked for it, of course.  Well, indirectly, perhaps.  You've been asking us when E-Business Suite users can take advantage of the latest Oracle technologies.  So, we're biting the bullet and putting them into our Release technology stack.

Release 12 Application Tier ORACLE_HOMEs:

The latest version of Forms and Reports available today is included in Oracle Application Server 10g, so that release, at minimum, will be part of the E-Business Suite Release 12.

You've been clamoring for the ability to use Oracle Containers for Java (OC4J), the next-generation successor to JServ.  The latest version of Oracle Containers for Java available today is included in Oracle Application Server 10g 10.1.3, so that release, at minimum, will be part of the E-Business Suite Release 12, too.

The slightly tricky thing is using these two releases together.  In a nutshell, all major services will be started out of the 10.1.3 ORACLE_HOME.  The E-Business Suite modules (packaged in formsapp.eap) will be loaded into the OC4J-Forms instance running out of the 10.1.3 ORACLE_HOME, and frmweb will be invoked out of the 10.1.2 ORACLE_HOME.

The above is intended to outline our general product direction.  It is intended for information purposes only, and may not be incorporated into any contract.   It is not a commitment to deliver any material, code, or functionality, and should not be relied upon in making purchasing decision.  The development, release, and timing of any features or functionality described for Oracle's products remains at the sole discretion of Oracle.

E-Business Suite Release 12 to Include Oracle Application Server 10g

Sharp-eyed readers of my OAUG Collaborate 06 presentation will have noticed some sneak previews of Oracle E-Business Suite Release 12's technology stack buried in an appendix.

The most significant news:  Oracle E-Business Suite Release 12 will use Oracle Application Server 10g for its application tier.  We're officially in the 21st Century now, so it's about time.

This long-awaited configuration will use:
[Cheering is heard from Oracle Applications DBAs worldwide]

Now, a word from Oracle Legal, which I'm obliged to append to all Release 12-related posts:

The above is intended to outline our general product direction.  It is intended for information purposes only, and may not be incorporated into any contract.   It is not a commitment to deliver any material, code, or functionality, and should not be relied upon in making purchasing decision.  The development, release, and timing of any features or functionality described for Oracle's products remains at the sole discretion of Oracle.

Related Articles:



« March 2017