Friday Mar 04, 2016

Now Available Announcement: Oracle Public Sector Revenue Management V2.5.0.0

 The Oracle Public Sector Revenue Management team is pleased to announce the general availability of Oracle Public Sector Revenue Management Version It is ready for customers and partners to download and install via the Oracle Software Delivery Cloud.

Key Features & Benefits:

Oracle Public Sector Revenue Management V2.5.0.0 is based on Oracle Public Sector Revenue Management V2.4.0.2 business functionality. Key features in this release include:

Adoption of Oracle Alta User Interface (UI): The Oracle Alta UI is the new standard for Oracle Applications and Oracle Cloud-based services. The new user interface enables a strikingly modern, simpler and more engaging experience to address customers’ increased user interface expectations.

Browser Support Options: Support for Internet Explorer in native mode and Mozilla Firefox.

Full Java Release: Take advantage of the world’s top programming language and leverage additional Java Platform Enterprise Edition features that were previously not accessible with COBOL. COBOL has been removed from the technology stack and is no longer supported, including customer extensions.

Adoption of Oracle Utilities Application Framework Version 4.3: Further alignment with Oracle’s technology roadmap including support for 12c and the latest technology platforms.

Supporting Materials:

• Product Documentation can be found on the Public Sector Revenue Management Page on the OTN.

• Updated versions of our PSRM datasheet, PSRM FAQ, PSRM Features and Functions,and PSRM Training datasheet documents are posted to our blog.

Software Download:

• Navigate to Oracle Software Delivery Cloud and sign in.

• Search for Oracle Public Sector Revenue Management Foundation.

• Select the platform, e.g. Oracle Solaris on SPARC (64-bit) and hit Continue.

• Agree to the standard terms and conditions for download.

• Select the required Oracle Public Sector Revenue Management media pack.

• Download the required components.

Software Installation and Product Documentation:

The complete set of installation and product documentation is also available for Oracle Public Sector Revenue Management V2.5.0.0 with the product download.


We would like to thank our Product Development group whose hard work, long hours and dedication has made this release possible. Their efforts are greatly appreciated.

For questions related to the release, please contact the PSRM product management team

Friday Aug 21, 2015

Announcement: Oracle PSRM v2.4 Service Pack 2 is now Generally Available

I am pleased to announce the General Availability of Oracle Public Sector Revenue Management v2.4 service pack 2.  This is the newest service pack update to the PSRM v2.4 release, which includes several new enhancements that have been requested by our customers and partners.  The service pack is available for download from My Oracle Support.   This post outlines the new features and enhancements that were added with this Service Pack,  

[Read More]

Tuesday Apr 28, 2015

Using Notepad++ as a visual XML editor for PSRM config tools

There have been a few inquires about visual editors for PSRM config tools.  There are several editors you can use, Notepad++ is a popular choice, it allows you to color code here's an example:


Notepad++ is a free editing tool. One of its features is the ability to have additional languages defined, which allows code mark-up, for example.

Setup Procedure

  • Download and install Notepad++ from any source (for example: )

  • Download a local copy of the PSRM Config Tools UDL file (configTools.xml

  • Install the User-Defined Language (UDL) for PSRM Config Tools by doing the following after launching Notepad++:

    • Select Language > Define your language ... from the menus.

    • Click Import.
    • Select your local copy of configTools.xml, then click Open.
    • An "Import successful." dialog box will come up.
    • Close the confirmation dialog box and restart Notepad++.

    • You should now see "ConfigTools" as an option (near the bottom) when you click Language from the menu.


To use the PSRM Config Tools language definition:

  • Edit or paste a config tools text into Notepad++.

  • Select Language > ConfigTools from the menu.

  • Your text will now be treated as a ConfigTools and will be marked-up as such.


Here's a version of the UDL for presentation purposes, like for training. This is called "ConfigToolsPresent" and uses bigger text and fancier fonts.

Pros and Cons:

  • Pro: Provides visual cue to developer while viewing/writing xPath or XML.
  • Con: Configuration file needs to be updated and distributed when script syntax changes (new keywords, etc).

Thursday Oct 09, 2014

Oracle Public Sector Revenue Management Analytics v2.1 is now Generally Available!!!

We are pleased to announce the General Availability release of Oracle PSRM Analytics v2.1.  The release is now available for download on the Oracle Software Delivery Cloud.  

The Oracle PSRM Analytics v2.1 release contains following new features:

  • Payment Analytics, with tons of new KPIs, operational dashaboards, and compliance dashboards
  • Financial Balance Sheet Analytics, using XBRL corporate balance sheet data
  • Predictive Analytics, including support for
    • Beneish M-Score, which predicts the propensity for fraud by scoring the likelihood that a business is manipulating their corporate balance sheet reporting
    • Altman Z-score, which predicts the likelihood that a business will be bankrupt soon based on the corporate balance sheet reportings
  • Re-branding form Oracle Tax Analytics (OTA) to the Public Sector Revenue Management brand

Please refer to the PSRM documentation library on the Oracle Technical Network for the product documentation associated with this release. The Release Notes document includes more details.  

Oracle Public Sector Revenue Management Analytics is pre-built enterprise data warehouse solution for public sector authorities.  The solution includes pre-built data model, pre-built analytical models, operational reports, KPIs, dashbaords, and metrics.  PSRM Analytics includes everything you need to quickly stand up a data warehouse, just load the data it it works from day 1.  The solution is flexible, extensible, and upgradeable, and built on world class Oracle BI technology.  .  

Friday Sep 19, 2014

Oracle PSRM Forms Configuration training now available on YouTube

We are pleased to announce that a new series of Oracle PSRM training and recordings have been posted on our PSRM YouTube channel. 

This is intended as a freely accessible, self paced tutorial to PSRM Forms Configuration, from a hands on perspective.  These recordings are somewhat technical in nature, and intended for Oracle PSRM configurers.  These videos are intended as a supplement, not a substitute, for Oracle PSRM classroom training.

[Read More]

Monday Jul 21, 2014

PSRM Virtual Machine are now Available to Partners

We are pleased to announce that partners can now gain access to PSRM VirtualBox VMs.  You can initiate the process by contacting your Oracle PSRM sales representative.  The PSRM Virtual Machine can be used for sales, demo, or sandbox purposes.[Read More]

Tuesday Jul 01, 2014

Oracle PSRM Config Tools training on Youtube!!!

We are pleased to announce that a new series of Oracle PSRM Config Tools training and recordings have been posted on our new PSRM Youtube channel.

This is intended as a freely accessible, self paced introduction to PSRM Config Tools from a hands on perspective.  These recordings are technical in nature, and intended for Oracle PSRM config tools users.  These videos are intended as a supplement, not a substitute, for Oracle PSRM classroom training. 

[Read More]

Monday Apr 21, 2014

Extracting PSRM BO extension data using Materialized Views

Thank you to Chocks Subramanian for putting this together!

Business Objects defined with XML schemas in PSRM can be extended to include custom data elements.  These custom data extension elements are in XML format in a Business Object extension column, which is a CLOB data type in the database. When accessing this information through the PSRM application, always use the Business Object, which is easy to interact which. However, if you need to interact directly with the database (rather than the application), there are a number of ways you can access Business Object extension data stored in XML format in the BO data extension column (CLOB datatype). Of the many methods, this job aide is to provide a recommendation to use materialized view to flatten the xml element into relational column. The materialized view will be created with all the elements from the CLOB data that are required for reporting and the query predicates. To improve the performance further, indexes can be created on the columns of materialized view. 

This job aid has addition information on the recommended approach:

Friday Apr 18, 2014

Link to blog post about the Angola PSRM v2.4 installation


I came across this interesting blog post today while searching for something else.  This is from a member of the PSRM project team in Angola who was installing their PSRM v2.4 environments.  He posted step by step information.  It looks like the installation went well.  I thought is was worth sharing for other project teams who may be doing their first PSRM installations.

Wednesday Apr 02, 2014

Oracle ETPM v2.3.1 Performance Benchmark Reports Available

The Oracle PSRM team is pleased to announce the exceptional results of the Oracle ETPM v2.3.1 performance benchmark.  Two reports were created that describe Oracle ETPM 2.3.1 throughput and scalability metrics for batch processing and OLTP.  [Read More]

Thursday Feb 27, 2014

Evaluating and Meeting SLAs - Performance Requirement Guidelines

Implementations typically need to establish performance goals that the system will need to meet.  At times these goals come from customer requirements in the form of Service Level Agreements (SLA).  When establishing performance goals, we use a set of “default” performance requirements, and any change from that (higher or lower) is an exception, usually based on the weight or complexity of the transaction.  Forms Validations and Posting is an example of an exception.  The implementation team will have to be careful about applying the general rules to everything.   

[Read More]

Wednesday Jan 08, 2014

Oracle Public Sector Revenue Management version 2.4.0 and 2.3.1 now support IE 9

Just a quick note to current PSRM implementers and customers:  We have added support for IE 9 in compatibility mode for PSRM 2.4.0 and ETPM 2.3.1. 

ETPM 2.3.1 and PSRM 2.4.0 currenlty support IE 7 and 8 in native mode and IE 9 in compatibility mode. 

Monday Dec 02, 2013

Oracle PSRM v2.4 Features & Functions and Datasheet Collateral Available

The most recent release of Oracle Public Sector Revenue Management, v2.4, includes a number of new features that expand the base product's coverage of features for customers that manage a wide variety of revenue types. These features include:

 - Asset and Valuation record maintenance

- Asset Billing using new configurable Calculation Engine

- Centralized Address Repository

- Production Controls

- Entity Correction

The Oracle PSRM v2.4.0 Features and Functions and Datasheet documents summarize the product's features and benefits for customers and implementation partners.

Wednesday Nov 20, 2013

Designing New Processes - Process Flow or Custom MO?

From time to time implementation/project teams will need to support business processes that are not provided by the base product. PSRM provides 2 main options for implementing custom business processes, Process Flows and custom Maintenance Objects (MOs).  This article provides information about each one.

[Read More]

Tuesday Nov 12, 2013

PSRM Frequently Asked Questions

Over time we have encountered common questions from customers and partners.  The document below answers some of the frequently asked questions related to sales and licensing, implementation and also general PSRM questions. 

[Read More]

This blog is for our Oracle Public Sector Revenue Management customers, delivery partners, and even our fellow Oracle professionals, and is dedicated to all things Oracle Tax and Revenue Management. We will focus on support and implementation tips, announcements, and FAQs (frequently asked questions) for all of our Oracle Public Sector Revenue Management products. This include Oracle Public Sector Revenue Management (PSRM), Oracle Tax Analytics, and our Oracle PSRM Self Service and integration products.


« July 2016