Anthony Shorten

Subscribe to Anthony Shorten feed
Oracle Blogs
Updated: 2 hours 44 min ago

Oracle Functional/Load Testing Advanced Pack for Oracle Utilities 5.0.0.1.0 Released

Wed, 2015-12-02 17:28

A new version of the Oracle Functional/Load Testing Advanced Pack for Oracle Utilities is now available for download from Oracle Software Delivery Cloud.

Look for Oracle Functional Testing Advanced Pack for Oracle Utilities, looking for Version 5.0.0.1.0, as this download includes support for Functional and Load testing.

This new version of the pack now supports a bigger range of Oracle Utilities products and a bigger range of versions. It also includes a component generator and component verifier to allow implementations to build custom components quickly from the meta data.

This new version of the pack supports the following releases:

  • Oracle Utilities Customer Care And Billing 2.4.0.3 (new)
  • Oracle Utilities Customer Care And Billing 2.5.0.1
  • Oracle Utilities Mobile Workforce Management 2.2.0.3 (updated)
  • Oracle Real Time Scheduler 2.2.0.3 (updated)
  • Oracle Utilities Application Framework 4.2.0.3 (new)
  • Oracle Utilities Application Framework  4.3.0.1
  • Oracle Utilities Meter Data Management 2.1.0.3 (new)
  • Oracle Utilities Smart Grid Gateway (all adapters) 2.1.0.3 (new)
  • Oracle Utilities Work And Asset Management 2.1.1 (updated)
  • Oracle Utilities Operational Device Management 2.1.1 (new)

The pack is content for Oracle Application Testing Suite for Functional Testing and Load Testing.

Channel Based Architectures

Tue, 2015-12-01 22:43

Over the last few releases of the Oracle Utilities Application Framework, architecture changes have been introduced to move towards a more channel based architectures. The idea is that a channel is an interface method that allows access to the product. One of the key principles is to divide the traffic interfaces into different channels to allow for those channels to be sized, managed and secured using different methods optimized for that channel.

In the Oracle Utilities Application Framework we have implemented the following channels:

  • Online Server - This is the Web based interface that allows online users access to the OLTP functionality of the product.
  • Integration Server - This is a web service based interface supporting SOAP, MDB, SOA, REST etc to allow interfaces to integrate to the product.
  • Batch Server - This is a command Oracle Coherence based channel to support background or batch processing.
  • Mobile Server (New) - This is a new channel we have started to introduce to progressive products to support a connected and disconnected mobile solution.

This channel based architecture is designed with the following principles:

  • Each channel can be installed separately or as a composite installation. In the latest version of the Oracle Utilities Application Framework we introduced the idea of an installation role. When you install the product you decide its role (or roles) which enables a channel for that installation. The role can be decided at installation time but can be changed, for flexibility, after installation without the need for re-installation. This also allows for what we call disparate installations which are installations across many hosts (for availability/scalability). We introduced an environment identifier which allows products like Oracle Enterprise Manager to recognize virtual disparate installations.
  • Each channel can be deployed individually. This allows for flexibility in implementing Oracle's Maximum Availability Architecture based solutions to support high levels of availability and scalability. This means the channel can be clustered individually or implemented in component clusters as well (depending on your preferences).
  • Each channel can be secured appropriately using the technology available to you. This essentially means you can use the facilities in the J2EE Web Application Server and associated security products to secure each channel appropriately. For example, the Integration Server which is Web Services based can be secured additionally with Oracle Web Services Manager and the policies supported by the Oracle WebLogic Server. We support the security connectors that Oracle supplies for its servers and also the advanced security offered by other Oracle Security products such as Oracle Identity Management Suite.
  • Each channel can be sized and ring fenced using features like Database Resource Manager and Oracle WebLogic Work Managers. This allows each channel to be controlled at the architectural level to isolate and preserve capacity. This is important in cloud implementations for example to ensure that capacity is maintained. This also allows flexibility in processing capacity with rules for allocating capacity able to be specified at the channel level or lower.
  • Oracle Enterprise Manager and the Application Management Pack for Oracle Utilities have been updated to reflect this new architecture to allow you to track and monitor appropriate metrics for the channel.

Over the next few releases, additional facilities will be included to enhance and reinforce the channel based architecture we have implemented. We feel that it will make implementations easier to plan and software easier to manage in the long term.

Database Resource Plan Support

Tue, 2015-12-01 16:59

Database resource plans in the database allow users and sessions limits to be managed to allow for finite control of resource usage on machines. They allow database administrators to set resource limits and configure resource sharing so that transactions, users and channels can have appropriate access to finite resources on the machine.

For Oracle Utilities products it is now possible to use database resource plans to control resources. The support varies with each version of Oracle Utilities Application Framework but the use cases you can use this for are as follows:

  • In Oracle Utilities Application Framework V4.x we introduced a different database user for each channel (online, web services and batch). These can be used in the database resource plan definition to control resources at a user level. In older versions of Oracle Utilities Application Framework (V2.x) we supply common users but it was possible, using templates, to implement separate users for at least online and batch so Database Resource Plans can be implemented there as well. This means that you can setup plans at the user level to control resources if necessary.
  • In all versions of Oracle Utilities Application Framework we have a separate Read-Only user. This is used typically for reporting tools. You can attach resource plans to this user to limit the resources used by reporting tools (for example, CPU and time limits).
  • In Oracle Utilities Application Framework V4.x we introduced additional session values to display module, action, client_identifier and client_info for active sessions. It is possible to also use these values to setup advanced resource plans if desired.

Setting up database resource plans is done at the database level using database tools such as SQL*Plus, SQL Developer, EM Express or Oracle Enterprise Manager. A whitepaper has been written to explain the facility as well as a example plan which is available from My Oracle Support at Using the Database Resource Manager to Manage Database Server Resources (Doc ID 2067783.1).

Whitepaper List as at November 2015

Thu, 2015-11-05 16:55
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 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:
Technical Best Practices for Oracle Utilities Application Framework Based Products Whitepaper summarizing common technical best practices used by partners, implementation teams and customers. 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.
Software Configuration Management Series
A set of whitepapers on how to manage customization (code and data) using the tools provided with the framework. Topics include Revision Control, SDK Migration/Utilities, Bundling and Configuration Migration Assistant. 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.
Oracle Utilities Application Framework Security Overview A whitepaper summarizing the security facilities in the framework. Now includes references to other Oracle security products supported. 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. Oracle Utilities Application Framework Integration Overview A whitepaper summarizing all the various common integration techniques used with the product (with case studies). 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. 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. Batch Best Practices This whitepaper outlines the common and best practices implemented by sites all over the world. Technical Best Practices V1 Addendum Addendum to Technical Best Practices for Oracle Utilities Customer Care And Billing V1.x only. 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. 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. Production Environment Configuration Guidelines 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?  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
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
This whitepaper covers the Configuration Migration Assistant available for Oracle Utilities Application Framework V4.2.0.0.0. This replaces ConfigLab for some products.
1506855.1 Integration Reference Solutions
This whitepaper covers the various Oracle technologies you can use with the Oracle Utilities Application Framework. 1544969.1 Native Installation Oracle Utilities Application Framework This whitepaper describes the process of installing Oracle Utilities Application Framework based products natively within Oracle WebLogic. 1558279.1 Oracle Service Bus Integration  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 and above, Oracle Service Bus Adapters for Outbound Messages and Notification/Workflow are available 1561930.1 Using Oracle Text for Fuzzy Searching 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 1606764.1
Audit Vault Integration This whitepaper describes the integration with Oracle Audit Vault to centralize and separate Audit information from OUAF products. Audit Vault integration is available in OUAF 4.2.0.1.0 and above only.
1644914.1
Migrating XAI to IWS
Migration from XML Application Integration to the new native Inbound Web Services in Oracle Utilities Application Framework 4.2.0.2.0 and above.
1643845.1
Private Cloud Planning Guide
Planning Guide for implementing Oracle Utilities products on Private Clouds using Oracle's Cloud Foundation set of products.
1682436.1
ILM Planning Guide
Planning Guide for Oracle Utilities new ILM based data management and archiving solution.
1682442.1
ILM Implementation Guide for Oracle Utilities Customer Care and Billing
Implementation Guide for the ILM based solution for the Oracle Utilities Customer Care And Billing.
207303.1
Client / Server Interoperability Support Matrix
Certification Matrix.
1965395.1
Cache Nodes Configuration using BatchEdit utility
Using the new Batch Edit Wizard to configure batch quickly and easily
1628358.1
Overview and Guidelines for Managing Business Exceptions and Errors
Best Practices for To Do Management
2014163.1
Oracle Functional/Load Testing Advanced Pack for Oracle Utilities Overview
Overview of the new Oracle Utilities testing solution. Updated for 5.0.0.1.0.
1929040.1
ConfigTools Best Practices
Best Practices for using the configuration tools facility
2014161.1
Oracle Utilities Application Framework - Keystore Configuration
Managing the keystore

Oracle Utilities on Oracle Technology Network

Thu, 2015-11-05 15:45

Information about the Oracle Utilities solutions is now available from the Oracle Technology Network.

This site includes links to download software, find documentation, connect to the user community and learn more about our solutions.

Flow Builder/OpenScript and Oracle Test Manager

Wed, 2015-11-04 19:32

The Oracle Functional Testing Advanced Pack for Oracle Utilities provides the content to use Oracle Application Testing Suite to verify your business processes via flows using your test data for multiple scenarios.

Customers have asked the relationship with the tools in the Oracle Application Testing Suite. Here is the clarification:

  • The Oracle Functional Testing Advanced Pack for Oracle Utilities is loaded into the Oracle Flow Builder component of the Oracle Application Testing Suite Functional Testing product. The components represent all the functions within the product.
  • You build a flow, using drag and drop, sequencing the provided components that matches the business process you want to verify. If there is no component we ship that covers your extensions then you can use a supplied component builder to build a meta data based service component. If you want to model a user interface then OpenScript can be used to record a component to add to the component library.
  • You then can attach your test data. There are a number of techniques available for that. You can natively input the data if you wish into the component, generate a spreadsheet to fill in the data (and attach it after you filled it out) or supply a CSV data file that represents the data in the flow.
  • You generate (not code) a script. No additional coding is required. As part of the license you can code OpenScript if  you have developers for any work if you wish but it is typically not required.
  • You then have a choice to execute the script.
    • You can execute the script from the OpenScript tool in Eclipse (if you are a developer for example).
    • You can execute the script from a command line (for example you can do this from a third party test manager if you wish)
    • You can automatically execute the script from Oracle Test Manager. This will allow groups of script to be scheduled and it reports on the results for you.
    • You can load the script into the Oracle Load Testing toolset and include it in a performance test suite of tests.

Remember our testing pack is service based not user interface based. You will need to make sure that the Web Services Accelerator is installed.

Essentially Flow Builder builds the flow and script from the components in the pack, Openscript or Oracle Test Manager executes it for you.

Updated Testing Advanced Pack Overview Whitepaper

Mon, 2015-11-02 13:00

An updated version of the Oracle Functional/Load Testing Advanced Pack for Oracle Utilities has been released on My Oracle Support at Doc Id: 2014163.1. The updates to the whitepaper include updates for the 5.0.0.0.0 release with the following information:

  •  Updates for the new content for Oracle Mobile Workforce Management, Oracle Real Time Scheduler, Oracle Utilities Application Framework, Oracle Utilities Customer Care and Billing and Oracle Work And Asset Management.
  • Updates for the new Component Builder and Component Verifier utilities that allow the addition of new custom components.
  • Updates to the Frequently Asked Questions covering licensing and the common implementation questions you may have about the Advanced Pack.

This new version now only adds new content and new capabilities but utilizes the power and facilities of the Oracle Application Testing Suite (Oracle Flow Builder, OpenScript and Oracle Load Testing) to deliver the ability to rapidly test, implement and upgrade Oracle Utilities products.

Pages