Friday May 13, 2016

Oracle PSRM support for Oracle PaaS (Platform as a Service)

We are pleased to announce that our latest release, PSRM v2.5, is supported on Platform As A Service (PaaS) on Oracle Public Cloud. As part of that support, our application framework team has published a new whitepaper outlining the process of migrating an on-premise installation to Platform As A Service (PaaS) on Oracle Public Cloud.

The whitepaper covers the following from a technical point of view:

  • The Oracle Cloud services to obtain to house the products, including the Oracle Java Cloud Service and Oracle Database As A Service with associated related services.
  • Setup instructions on how to configure the services in preparation to house the product.
  • Instructions of how to prepare the software for transfer.
  • Instructions on how to transfer the product schema to a Oracle Database As A Service instance using various techniques.
  • Instructions on how to transfer the software and make configuration changes to realign the product installation for the cloud. The configuration must follow the instructions in the Native Installation Oracle Utilities Application Framework (Doc Id: 1544969.1) available from My Oracle Support which has also been updated to reflect the new process.
  • Basic instructions on using the native cloud facilities to manage your new PaaS instances. More information is available in the cloud documentation.

The whitepaper applies to PSRM v2.5 only, and any product on OUAF 4.3 or above.  Customers and partners wanting to establish new environments (with no previous installation) can use the same processes to install PSRM on the cloud instance.  Customers and partners considering Oracle Infrastructure As A Service can use the same processes as well.  

The Migrating From On Premise To Oracle Platform As A Service (Doc Id: 2132081.1) whitepaper is available from My Oracle Support

New PSRM v2.5 Consolidated Virtual Machine Now Available

We are pleased to announce that a new version of the  PSRM Demo virtual machine (VM) is now available for partners and customers. This VM image includes integrated instances of PSRM, PSRM Self Service, OPA, Oracle DB, Web Center, UCM, Weblogic, Documaker and BI Publisher. As mentioned in an earlier post, these VM images are a convenient means of establishing a PSRM environment for playpen, demo, or training needs.  This new VM image includes PSRM v2.5, and updated demo data. The VM includes: 

  • The new Oracle Alta User Interface standard 
  • A Full Java release.  A Microfocus license key is no longer required.
  • New Property Tax Asset Billing examples
  • Oracle BI Publisher integration.
  • Pay Plan applications via Self Service 
  • New optional Tabular tax form display

The release notes for the virtual machine explain this configuration in more detail.

Please contact the PSRM VM group at to learn how to get a copy of the new VM image.

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]

Wednesday May 27, 2015

Oracle PSRM java SDK recordings now available on the PSRM Training YouTube channel

We are pleased to announce that a new PSRM java SDK overview series is now available on the PSRM YouTube channel.  This includes 20 videos, each about 10 minutes long (on average), covering many of a number of key concepts for working with the PSRM SDK.  The SDK is used to make java extensions to Oracle PSRM that are easily upgraded to each new version of PSRM.  This provides a nice introduction and overview to the PSRM SDK, including what's used for (and not used for), as well as overviews of the wizards and tools provided, and several examples.  

I'm sure you will find this useful, enjoy!

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).

Friday Nov 21, 2014

Oracle PSRM Self Service v1.1 Service Pack 1 demonstration database is now available

We are pleased to announce that the Oracle PSRM Self Service demonstration database for PSRMSS v1.1 Service Pack 1 is now available. You may download it from MyOracleSupport using patch ID 18978475.  The download is password protected, please contact Oracle Support if you need to download it.  

 This release of PSRM Self Service demo data includes configuration data for the new PSRMSS v1.1 and PSRM v2.4 features.  The demo data for PSRMSS and PSRM are now combined, to simplify playpen and demo usage of PSRM together with Self Service.   

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]

Tuesday Sep 16, 2014

Press Release for Ohio STARS

The Ohio STARS project went live on Sales and Use Tax in July, 2014.  Since Employer Withholding and School District Withholding went live in October 2013, and Natural Gas Tax and Tire Replacement Fee went live in February 2014, that means Ohio STARS had 3 go lives in 9 months!  The following press release was just issued:

It was picked up by Yahoo right away:

Friday Sep 12, 2014

Accessibility Update: Oracle PSRM and PSRM Self Service VPATs are now available

VPATs for Oracle PSRM and PSRM Self Service have been published on Oracle's Accessibility portal.
[Read More]

Monday Jul 28, 2014

Need to View PSRM base product Source Code? Yes, this is possible!

From time to time we receive a request to view base PSRM source.  For example, you may need it to help troubleshoot or analyze something, or you may want to use it to accelerate your site specific plug-ins.  [Read More]

Tuesday Jul 22, 2014

Oracle Public Sector Revenue Management v2.4 Dutch UI Language Pack Available Now

We are pleased to announce the general availability of Oracle Tax PSRM v2.4 UI Dutch.

[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]

Friday Jul 18, 2014

Now Available - PSRM 2.4.0 Webcast

Watch the following webcast for an overview of new features in PSRM version 2.4.0.


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.


« June 2016