Skip navigation.

Anthony Shorten

Syndicate content
Technical Advice for Oracle Tax and Utilities products
Updated: 5 min 44 sec ago

Updated Native Install/Clustering Whitepapers

Tue, 2015-01-06 15:04

The Implementing Oracle ExaLogic and/or Oracle WebLogic Clustering  (Doc Id: 1334558.1) and Native Installation Oracle Utilities Application Framework (Doc Id: 1544969.1) have been updated with the latest information and advice from customers and partners.

The updates include:

  • Configuring additional parameters for UTF8 sites
  • Compatibility settings for various versions of Oracle WebLogic
  • Java Flight Control configuration for Java 7.

The whitepapers are available from My Oracle Support.

A prosperous New Year

Tue, 2014-12-23 17:31

It has been a very very 2014 and 2015 is shaping up to be a bumper year for a number of the products we deliver. I have no updated this blog as much as I wanted the last few months for various reasons, mainly I have been very busy getting new versions and new products out of the door. More about that in the new year.

2015 is shaping up to be a stellar year for the products I manage personally with announcements and exciting new features I am sure customers and partners will embrace.

I wish all my readers, our partners and our customers a happy holidays and a prosperous new year.

Using ILM from Oracle Enterprise Manager

Mon, 2014-10-20 18:18

If you are upgrading to Oracle Database 12c for an Oracle Utilities Application Framework based product then you can use Oracle Enterprise Manager to manage your Information Lifecycle Management based data management solution.

To use it you simply install Oracle Enterprise Manager and then register the 12c database instance (PDB and non-PDB are supported) and then when selecting the database target use the Information Lifecycle Management menu option from the Administration --> Storage menus. For example:

ILM Menu option from OEM

This means that you can use Oracle Enterprise Manager as a viable alternative to ILM Assistant for Oracle Database 12c targets.

Presentations Available from OpenWorld

Tue, 2014-10-07 11:38

Last week I conducted three sessions on a number of topics. The presentations used in those sessions are now available from the Sessions --> Content Catalog on the Oracle OpenWorld site.Just search for my name (Anthony Shorten) to download the presentations in PDF format.

The sessions available are:

I know a few customers and partners came to me after each session to get a copy of the presentation. They are now available as I pointed out.

Objects versus Insert Statements

Tue, 2014-10-07 11:06

A few times I have encountered issues and problems at customers that can defy explanation. After investigation I usually find out the cause and in some cases it is the way the implementation has created the data in the first place. In the majority of these types of issues, I find that interfaces or even people are using direct INSERT statements against the product database to create data. This is inherently dangerous for a number of reasons and therefore strongly discouraged:

  • Direct INSERT statements frequently miss important data in the object.
  • Direct INSERT statements ignore any product business logic which means the data is potentially inconsistent from the definition of the object. This can cause the product processing to misinterpret the data and may even cause data corruption in extreme cases.
  • Direct INSERT statements ignore product managed referential integrity. We do not use the referential integrity of the data within the database as we allow extensions to augment the behavior of the object and determine the optimal point of checking data integrity. The object has inbuilt referential integrity rules.

To avoid this situation we highly recommend that you only insert data through the object and NOT use direct INSERT statements. The interface to the object can be direct within the product or via Web Services (either directly or through your favorite middleware) to create data from an external source. Running through the object interface ensures not only that the data is complete but takes into account product referential integrity and conforms to the business rules that you configure for your data.

Take care and create data through the objects.