A set of new releases of the Oracle Utilities Software Development Kit are now available for customers on Oracle Utiltiies Application Framework V2.2 and V4 based products.

As mentioned in a previous post the SDK is available from My Oracle Support at the following Patches:

9537502 - Oracle Utilities SDK 2.2.0.11 (for OUAF V2.2 based products)
10043375 - Oracle Utilities SDK 4.0.0.4 (for OUAF V4.0.2 based products).

As previously mentioned a new Fusion like User Interface is now implemented in Oracle Utilities Application Framework V4.0.2 (it is also available as a patch for Oracle Utilities Application Framework V2.2 based products - Patch 9584975).

If you install an Oracle Utilities Application Framework V2.2 or Oracle Utilities Application Framework V4 based product and you attempt to execute a batch/background process you may receive the error:

"User AUSER does not exist" or similar.

This is a list of the current whitepapers available for Oracle Utilities Application Framework based products from My Oracle Support:

Customers and Partners who have installed Oracle Utilities Application Framework Service Pack 8 have experienced some issues with the configureEnv utility on selected platforms.

A new patch has been released to address the issue.

Patch 10031967: TERM::READKEY ISSUE IN CONFIGUREENV.PLX WITH ORACLE CLIENT PERL

Are you interested on which specific fixes are in the Service Packs in Oracle Utilities Application Framework V2.2?

There is an article in My Oracle Support that outlines all the fixes per Service Pack. Each time a Service pack is released this document is updated. The artticle details are as follows:

Single Fixes included in Oracle Utilities Framework v2.2.0 Service Packs (FW SP1-SP8) [ID 943636.1].

If you are a DBA or an application developer, here are some sessions for you at Oracle Open World 2010 San Francisco:

Session#: S316995
Developing, Deploying, and Diagnosing Applications on Oracle Database 11g
Track: Database Development
Date: 20-SEP-10
Time: 10:00 - 11:00
Venue: Hotel Nikko
Room: Golden Gate

Session#: S317092
End-to-End Java: Decide When to Adopt Java in the Database and Best Practices
Track: Database Development
Date: 20-SEP-10
Time: 13:00 - 14:00

The Oracle Utilities Application Framework can execute on a variety of hardware architectures from the simple to the complex. The key is understanding which hardware architecture best suits your sites requirements.

A whitepaper was written to help sales and our consultants to assist in helping customers help decide on the hardware architecture for their implementation of our products. It was released externally a while back and now has been updated to include the latest architectural facilities available.

There's a new feature in the latest listener posted a few minutes ago that makes it easier than ever to get up and running thanks to Sun.   There is now a built in webserver thanks to Glassfish.  That means for desktop or testing there's no need to download any webserver.

For customers who have products using Oracle Utilities Application Framework V2.2 and Oracle Utilities Application Framework V4.0.2, there is a new document summarizing the framework changes made between these releases available from My Oracle Support.

The document briefly outlines each enhancement and where possible a screen shot of the new enhancement is included for more information.

With the release of Oracle Utilities Mobile Workforce Management V2.0.1 comes the latest in the releases of the Oracle Utilities Application Framework. This releases adds a new set of functionality and also changes some existing functionality. Here is a summary of what is in the release:

A mandartory release of Oracle Utilities Mobile Workforce Management V2 is available. The new version is V2.0.1 and includes a number of important new features.

This means that we are now on Oracle Utilities Application Framework V4.0.2 as the baseline for new products going forward.

The new downloads are available from edelivery.oracle.com (Under Oracle Utilities Mobile Workforce Management Release 2.0 Media Pack) or My Oracle Support (KB Id: 9953161).

Well, it has been a while, I have been away on vacation but work has been busy with a raft of new functionality released and some notable fixes you might be interested in for customers with produucts using Oracle Utilities Application Framework V2.2.

The 11g version of the TranslationHub tool for Oracle Forms and Reports is now available. As the name suggests, TranslationHub allows you to translate your Oracle Forms applications into multiple languages. You can find the download on the Fusion Middleware Download Page

So this newest release is a "staggered" release - meaning it supports two Eclipse platforms - both 3.6 and 3.5 to give users more time to migrate forward.

Oracle Enterprise Pack for Eclipse (OEPE) 11.1.1.6. aka "Mission" was officially released this morning. You can download it here, or of course pull the plug-ins from the Eclipse Marketplace or OTN. This release supports Eclipse 3.6 (Helios).

Great news today, the design time environments of those stalwarts of the Oracle Tools world, Oracle Forms and Oracle Reports are now certified on Windows 7 64bit. You can now run the 32bit builders of the 11g versions on Windows 7 64bit and be supported!
As ever, for the latest platform certification information go to the middleware pages on OTN. This new certification should be reflected in the spreadsheet in the next day or so.

It's amazing to me - but hardly unusual - when information is crammed into a user interface with no reference or explanation. The yellow roads on my nav app could be promising alternate routes, or they could lead to Oz - I can't find out. Customer support doesn't know why.

I was wondering what java component is still missing inside Oracle Forms.

I've already made some beans which could do the following:

• Graphics/Charts with jFreeChart
• PDF documents (from the database and from an URL)
• Images
• URL's through the enhance webbrowser
• chat bean through the XMPP protocol

The documentation for Oracle Utilities Mobile Workforce Management is now available from the Oracle Technology Network.

The documentation can be found by navigating via Documentation -> Oracle Utilities or directly.

These are copies of the documentation that are usually available from edelivery.oracle.com.

 Ever tinker with SQL to get the best plan possible but have to track what changed by flipping screens or not sure what session stats change due to the new plan ?  Here's the feature for you.  It highlights what changed in the tree as well as shows all the session stats that change from one plan to the next.

Free event (TISATAAFL) OTN Developer Days Database Coming to You: in Boston http://ning.it/aowUgZ, at Oracle HQ http://ning.it/aNz77V and in Vancouver http://ning.it/9X6y1Y.
Register now, seats fill up fast!

Most log analysers do not produce all statistics that a site might want to track. One of the important usage statistics that needs to be calculated is to track the number of active users (i.e. users that are actively using the system - not idle users) to try and correlate performance events with level of usage on the system.
It is possible to post process the access.log files using a set of UNIX script to summarize the information as the basic information such as userid and date time are contained in the file. The key to processing this data is to:

One of the most useful logs that is available from the Web Application Servers used by the Oracle Utilities Application Framework based products is access.log. It is also known as the Apache log or the HTTP Access Log.

Everytime a web resource is accessed on a server this log records it along with other information including:

So – my co-worker wanted to learn about PL/SQL exceptions. Here you go! I have put comments at the end by way of discussion. set serveroutput on <<DEMO_AND_TEST_EXCEPTIONS>> DECLARE MYOWNNODATAFOUND EXCEPTION; --ERROR CAUSED BY PRAGMA EXCEPTION_INIT (MYOWNNODATAFOUND, -1403); -- Cannot rename Oracle native exceptions if their numbers are already named -- in DBMS_STANDARD, e.g., ORA-01403 [...]

One of the features of all the versions of the Oracle Utilities Application Framework is its implementation of caching to improve performance.
The idea is simple enough, load data or function into a faster media (e.g. memory) to minimize calls for the data or function on slower media.
Caches are typically in a number of places in an architecture and this is the case for the Oracle Utilities Application Framework based products.

Here is a summary of the various caches and their typical usage in the Oracle Utilities Application Framework:

In Oracle Utilities Application Framework V4 a number of Zone enhancements have been added to provide additional functionality:

Andreas Weiden

Hafed Benteftifa

Dave Bettinger