Tuesday Jun 18, 2013

Whitepaper List as at June 2013

The following Oracle Utilities Application Framework technical whitepapers are available from My Oracle Support at the Doc Id's mentioned below. Some have been updated in the last few months to reflect new advice and new features.

Unless otherwise marked the technical whitepapers in the table below are applicable for the following products (with versions):

Doc Id Document Title Contents
559880.1
ConfigLab Design Guidelines This whitepaper outlines how to design and implement a data management solution using the ConfigLab facility.
This whitepaper currently only applies to the following products:
560367.1
Technical Best Practices for Oracle Utilities Application Framework Based Products Updated! Whitepaper summarizing common technical best practices used by partners, implementation teams and customers.
560382.1
Performance Troubleshooting Guideline Series A set of whitepapers on tracking performance at each tier in the framework. The individual whitepapers are as follows:
  • Concepts - General Concepts and Performance Troublehooting processes
  • Client Troubleshooting - General troubleshooting of the browser client with common issues and resolutions.
  • Network Troubleshooting - General troubleshooting of the network with common issues and resolutions.
  • Web Application Server Troubleshooting - General troubleshooting of the Web Application Server with common issues and resolutions.
  • Server Troubleshooting - General troubleshooting of the Operating system with common issues and resolutions.
  • Database Troubleshooting - General troubleshooting of the database with common issues and resolutions.
  • Batch Troubleshooting - General troubleshooting of the background processing component of the product with common issues and resolutions.
560401.1
Software Configuration Management Series
Updated!
A set of whitepapers on how to manage customization (code and data) using the tools provided with the framework. The individual whitepapers are as follows:
  • Concepts - General concepts and introduction.
  • Environment Management - Principles and techniques for creating and managing environments.
  • Version Management - Integration of Version control and version management of configuration items.
  • Release Management - Packaging configuration items into a release.
  • Distribution - Distribution and installation of releases across environments
  • Change Management - Generic change management processes for product implementations.
  • Status Accounting - Status reporting techniques using product facilities.
  • Defect Management - Generic defect management processes for product implementations.
  • Implementing Single Fixes - Discussion on the single fix architecture and how to use it in an implementation.
  • Implementing Service Packs - Discussion on the service packs and how to use them in an implementation.
  • Implementing Upgrades - Discussion on the the upgrade process and common techniques for minimizing the impact of upgrades.
773473.1
Oracle Utilities Application Framework Security Overview A whitepaper summarizing the security facilities in the framework. Now includes references to other Oracle security products supported.
774783.1
LDAP Integration for Oracle Utilities Application Framework based products A generic whitepaper summarizing how to integrate an external LDAP based security repository with the framework.
789060.1
Oracle Utilities Application Framework Integration Overview A whitepaper summarizing all the various common integration techniques used with the product (with case studies).
799912.1
Single Sign On Integration for Oracle Utilities Application Framework based products A whitepaper outlining a generic process for integrating an SSO product with the framework.
807068.1
Oracle Utilities Application Framework Architecture Guidelines This whitepaper outlines the different variations of architecture that can be considered. Each variation will include advice on configuration and other considerations.
836362.1
Batch Best Practices for Oracle Utilities Application Framework based products Updated! This whitepaper outlines the common and best practices implemented by sites all over the world.
856854.1
Technical Best Practices V1 Addendum Addendum to Technical Best Practices for Oracle Utilities Customer Care And Billing V1.x only.
942074.1
XAI Best Practices This whitepaper outlines the common integration tasks and best practices for the Web Services Integration provided by the Oracle Utilities Application Framework.
970785.1
Oracle Identity Manager Integration Overview This whitepaper outlines the principals of the prebuilt intergration between Oracle Utilities Application Framework Based Products and Oracle Identity Manager used to provision user and user group security information. For Fw4.x customers use whitepaper 1375600.1 instead.
1068958.1
Production Environment Configuration Guidelines Updated! A whitepaper outlining common production level settings for the products based upon benchmarks and customer feedback.
1177265.1 What's New In Oracle Utilities Application Framework V4? Updated! Whitepaper outlining the major changes to the framework since Oracle Utilities Application Framework V2.2.
1290700.1 Database Vault Integration Whitepaper outlining the Database Vault Integration solution provided with Oracle Utilities Application Framework V4.1.0 and above.
1299732.1 BI Publisher Guidelines for Oracle Utilities Application Framework Whitepaper outlining the interface between BI Publisher and the Oracle Utilities Application Framework
1308161.1 Oracle SOA Suite Integration with Oracle Utilities Application Framework based products This whitepaper outlines common design patterns and guidelines for using Oracle SOA Suite with Oracle Utilities Application Framework based products.
1308165.1 MPL Best Practices Oracle Utilities Application Framework This is a guidelines whitepaper for products shipping with the Multi-Purpose Listener.
This whitepaper currently only applies to the following products:
1308181.1 Oracle WebLogic JMS Integration with the Oracle Utilities Application Framework This whitepaper covers the native integration between Oracle WebLogic JMS with Oracle Utilities Application Framework using the new Message Driven Bean functionality and real time JMS adapters.
1334558.1 Oracle WebLogic Clustering for Oracle Utilities Application Framework This whitepaper covers process for implementing clustering using Oracle WebLogic for Oracle Utilities Application Framework based products.
1359369.1 IBM WebSphere Clustering for Oracle Utilities Application Framework This whitepaper covers process for implementing clustering using IBM WebSphere for Oracle Utilities Application Framework based products
1375600.1 Oracle Identity Management Suite Integration with the Oracle Utilities Application Framework This whitepaper covers the integration between Oracle Utilities Application Framework and Oracle Identity Management Suite components such as Oracle Identity Manager, Oracle Access Manager, Oracle Adaptive Access Manager, Oracle Internet Directory and Oracle Virtual Directory.
1375615.1 Advanced Security for the Oracle Utilities Application Framework This whitepaper covers common security requirements and how to meet those requirements using Oracle Utilities Application Framework native security facilities, security provided with the J2EE Web Application and/or facilities available in Oracle Identity Management Suite.
1486886.1 Implementing Oracle Exadata with Oracle Utilities Customer Care and Billing This whitepaper covers some advice when implementing Oracle ExaData for Oracle Utilities Customer Care And Billing.
878212.1 Oracle Utilities Application FW Available Service Packs This entry outlines ALL the service packs available for the Oracle Utilities Application Framework.
1454143.1 Certification Matrix for Oracle Utilities Products This entry outlines the software certifications for all the Oracle Utilities products.
1474435.1 Oracle Application Management Pack for Oracle Utilities Overview This whitepaper covers the Oracle Application Management Pack for Oracle Utilities. This is a pack for Oracle Enterprise Manager.
1506830.1 Configuration Migration Assistant Overview Oracle Utilities Application Framework New This whitepaper covers the Configuration Migration Assistant available for Oracle Utilities Application Framework V4.2.0.0.0
1506855.1 Integration Reference Solutions Oracle Utilities Application Framework New This whitepaper covers the various Oracle technologies you can use with the Oracle Utilities Application Framework.
1544969.1 Native Installation Oracle Utilities Application Framework New This whitepaper describes the process of installing Oracle Utilities Application Framework based products natively within Oracle WebLogic.
1558279.1 Oracle Service Bus Integration New

This whitepaper describes direct integration with Oracle Service Bus including the new Oracle Service Bus protocol adapters available. Customers using the MPL should read this whitepaper as the Oracle Service Bus replaces MPL in the future and this whitepaper outlines how to manually migrate your MPL configuration into Oracle Service Bus.

Note: In Oracle Utilities Application Framework V4.2.0.1.0, Oracle Service Bus Adapters for Outbound Messages and Notification/Workflow are available.

1561930.1 Using Oracle Text for Fuzzy Searching New This whitepaper describes how to use the Name Matching and  fuzzy operator facilities in Oracle Text to implemement fuzzy searching using the @fuzzy helper fucntion available in Oracle Utilities Application Framework V4.2.0.0.0

Monday Jun 17, 2013

Fuzzy Searching sypport in OUAF V4.2.0.0.0

One of the most common requirements in products using Oracle Utilities Application Framework is searching for records using various criteria. In Oracle Utilities Application Framework we provide a set of Query Zones that allow SQL to be used to retrieve information using whatever criteria is configured. In most cases we support precise and/or wildcarding (this is configurable). In Oracle Utilities Application Framework V4.2.0.0.0 we added support for inprecise or fuzzy searching using the facilities provided in Oracle Text.

Oracle Text is a component of all editions of the Oracle Database that allows for special indexes and additional clauses to provide a wide range of text searching and processing options. One of the major features of Oracle Text in Oracle Database 11gR2 is Name searching. This facility allows implementations to specify addtional SQL clauses to implement fuzzy or inprecise searching names and addresses in 20+ languages natively in the database.

For example, say you were looking for a customer with the name Bill. Fuzzy searching would allow Bill, William, Willy, Billy etc to be returned as well as they are valid variations of the name. This applies to surnames and addresses as well. For example, if you were looking at a surname of Smith, you could get results back of valid variations such as Smythe, or Smithe etc...

This Oracle Text facility is now interfaced using a new @fuzzy helper function (that is what I call it) to get the SQL query to implement the new SQL clauses easily in Query zones.

The process to implement this is summarized as follows:

  • Enable Oracle Text on the database. By default, it is not enabled. This is a one off DBA DCL statement.
  • Grant access to Oracle Text to the product users.This is a one off DBA DCL statement.
  • Create Oracle Text indexes with the necessary parameters on the columns you want to apply the searching on. This will build special entries and variations for the SQL to use for you. The index creation allows you to customize the attributes and dictionaries used by the search to return the variations.
  • Use the @fuzzy helper function in your Query zone SQL against the columns indexed and with the necessary configuration.

The @fuzzy helper function provides a number of parameters:

@fuzzy(term, score, numresults, weighting) where:

 term Value to search on
 score The degress of fuzziness. Values between 1 - 80. The higher the number the more precise the search. Default is 60.
 numresults Number of variations to consider for the term. Number between 1 and 5000. Default is 100.
 weighting Whether the results are returned in order of score/weight. Specify WEIGHT to enable this. 

In the query zone you can default the values or provide them as parameters. For example:

To pass user data as term parameter and use default values of the remaining fuzzy operator parameters the zone SQL will need to be defined as following:

SELECT USER_ID, LAST_NAME from SC_USER WHERE CONTAINS(LAST_NAME, @fuzzy(:F1)) > 0;

To pass user data as term parameter in fuzzy operator, and to set score to 70, number results to 6, and to specify weight the zone SQL will need to be defined as following.

SELECT USER_ID, LAST_NAME from SC_USER WHERE CONTAINS(LAST_NAME, @fuzzy(:F1, 70, 6, ‘weight’)) > 0;

To pass user data as term parameter and a score in fuzzy operator, to set number results to 6, and to specify weight the zone SQL will need to be defined as following:

SELECT USER_ID, LAST_NAME from SC_USER WHERE CONTAINS(LAST_NAME, @fuzzy(:F1, :F2, 6, ‘weight’)) > 0;

Skip unnecessary parameters using the appropriate number of commas. For example:

SELECT USER_ID, LAST_NAME from SC_USER WHERE CONTAINS(LAST_NAME, @fuzzy(:F1,,,‘weight’)) > 0;

For more details of this facility and some general advice about Oracle Text refer to the Using Oracle Text for Fuzzy Searching Oracle Utilities Application Framework (Doc Id: 1561930.1) whitepaper available from My Oracle Support.

The key to the right results is the configuration of the Oracle Text Index. Refer to the Oracle Text documentation

Software Configuration Management Series Updated

A series of whitepapers has been available for Oracle Utilities Application Framework for the last few releases that deals with Software Configuration Management. This is a broad set of topics that cover aspects of managing code, data and environments in an implementation. These documents have been updated to reflect the latest advice and new facilities available within the Oracke Utilities Application Framework to handle this information.

The documents cover the following topics:

  • Concepts - General concepts and introduction.
  • Environment Management - Principles and techniques for creating and managing environments.
  • Version Management - Integration of Version control and version management of configuration items.  Updated to include mode information about revision control.
  • Release Management - Packaging configuration items into a release. Updated to include advice around Configuration Migration Assistant.
  • Distribution - Distribution and installation of releases across environments. Updated to include advice around Configuration Migration Assistant. 
  • Change Management - Generic change management processes for product implementations.
  • Status Accounting - Status reporting techniques using product facilities. Updated to include advice around Configuration Migration Assistant.
  • Defect Management - Generic defect management processes for product implementations.
  • Implementing Single Fixes - Discussion on the single fix architecture and how to use it in an implementation.
  • Implementing Service Packs - Discussion on the service packs and how to use them in an implementation.
  • Implementing Upgrades - Discussion on the the upgrade process and common techniques for minimizing the impact of upgrades.

The documents are available from My Oracle Support at Doc Id: 560401.1.

Thursday Jun 13, 2013

New version of What's New in FW4 whitepaper

A new updated version of the What's New in FW4 has been released which includes the latest information about the features of Oracle Utilities Application Framework up to an including version 4.2.0.1.0.

The whitepaper also features updated information for existing functionality including references to new whitepapers and more content describing key new features. This whitepaper is design to help customers who are considering upgrading from products using V2.x of the Oracle Utilities Application Framework to products using Oracle Utilities Application Framework V4.x.

The whitepaper is available in My Oracle Support at What's New In Oracle Utilities Application Framework V4 (Doc Id: 1177265.1).

Monday Jun 03, 2013

New Oracle Service Bus Integration Whitepaper

As part of Oracle Utilities Application Framework V4.2.0.1.0 a new set of Oracle Service Bus protocol adapters are available to allow Oracle Service Bus to process outbound communications initiated from the product. This complements the inbuilt and Oracle Service Bus integration for inbound communications that already has been released over the last few Oracle Utilities Application Framework releases.

The Oracle Service Bus Integration allows the following:

  • Definition of XAI Inbound Services as Business Services within Oracle Service Bus with support for Oracle Web Services Manager functionality for flexible security of inbound calls.
  • Optionally, using a Proxy Service on the Business Service to allow you to load balance Web Services calls across clusters or managed services.
  • A set of protocol adapters than can be easily installed within Oracle Service Bus to implement outbound communications for Outbound Messages (by Outbound Message Type) and for Oracle Utilities Customer Care And Billing and Oracle Enterprise Taxation And Policy Management, Notification and Workflow (by NDS Type),

A whitepaper has been released outlining the integration with step by step instructions on configuration and includes advice for customers migrating from the Multipurpose Listener (MPL). Customers migrating from the MPL should read this whitepaper and attend appropriate training to fully exploit the Oracle Service Bus integration.

The whitepaper is available from My Oracle Support - Oracle Service Bus Integration Oracle Utilities Application Framework (Doc Id: 1558279.1).

About

Anthony Shorten
Hi, I am Anthony Shorten, I am the Principal Product Manager for the Oracle Utilities Application Framework. I have been working for over 20+ years in the IT Business and am the author of many a technical whitepaper, manual and training material. I am one of the product managers working on strategy and designs for the next generation of the technology used for the Utilities and Tax markets. This blog is provided to announce new features, document tips and techniques and also outline features of the Oracle Utilities Application Framework based products. These products include Oracle Utilities Customer Care and Billing, Oracle Utilities Meter Data Management, Oracle Utilities Mobile Workforce Management and Oracle Enterprise Taxation and Policy Management. I am the product manager for the Management Pack for these products.

Search

Archives
« June 2013 »
SunMonTueWedThuFriSat
      
1
2
4
5
6
7
8
9
10
11
12
14
15
16
19
20
21
22
23
24
25
26
27
28
29
30
      
Today