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.

Thursday Apr 14, 2016

Lesotho Revenue Authority exceeds collections targets by 13%

Here's an great article about one of our PSRM customers, Lesotho Revenue Authority (LRA).  LRA, recently completed an implementation of PSRM and PSRM Analytics across all of their major tax types (VAT, PAYE, Corporate Income, Individual Income) and business processes.

LRA partnered with Tatis International for the implementation.

Friday Mar 11, 2016

New PSRM v2. Consolidated Virtual Machine Now Available

We are pleased to announce that a new PSRM v2. consolidated VM is now available for partners and customers. This VM includes integrated instances of PSRM, PSRM Self Service, OPA, Oracle DB, Documaker and BI Publisher. This provides an easier means of establishing a PSRM environment for playpen, demo, or training needs.  [Read More]

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

Monday Nov 09, 2015

Updated PSRM Sizing Materials Available

Updated materials are available for anyone who needs to do an initial hardware sizing for PSRM as part of a customer RFI or RFP. See the attached collateral for the more information. The presentation discusses the high level process to create a sizing estimate while the questionnaire can be used to gather the details necessary for the PSRM product team to create the sizing estimate.

 These materials replace those that were previously referenced in the post titled Sizing Process found here.

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]

Monday Aug 10, 2015

Supporting Multiple Parallel PSRM Development Teams

The Oracle PSRM framework supports the use of multiple "CM" application instances. These can be used for either distributed development teams or co-located teams working on different sets of extensions. A whitepaper is available that explains how to use these features.
[Read More]

New Consolidated PSRM Demo Virtual Machine Now Available!

We are pleased to announce that the new PSRM Demo VM is now available for partners and customers. This new consolidated VM includes integrated instances of PSRM, PSRM Self Service, OPA, Oracle DB, Documaker and BI Publisher. This provides an easier means of establishing a PSRM environment for playpen, demo, or training needs.  [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).

Thursday Jan 15, 2015

The Altman Z-score and Bennish M Score in PSRM Analytics

As part of the new version of PSRM Analytics, we introduced the Altman Z Score and the Beneish Model M Score in the product.  The following is an explanation of each calculation.  

Altman Z-Score

NYU Stern Finance Professor, Edward Altman, developed the Altman Z-score formula in 1967. In 2012, he released an updated version called the Altman Z-score Plus, that can be used to evaluate both public and private companies, both manufacturing and non-manufacturing companies and both U.S. and non-U.S. companies. Investors can use Altman Z-scores to help determine whether they should buy or sell a particular stock if they're concerned about the underlying company's financial strength. The Altman Z-score Plus can be used to evaluate corporate credit risk.

Definition of 'ALTMAN Z-SCORE'

The output of a credit-strength test that gauges a publicly traded manufacturing company's likelihood of bankruptcy. The Altman Z-score, is based on five financial ratios that can be calculated from data found on a company's annual 10K report. The Altman Z-score is calculated as follows:

Z-Score = 1.2A + 1.4B + 3.3C + 0.6D + 1.0E


A = Working Capital/Total Assets
B = Retained Earnings/Total Assets
C = Earnings Before Interest & Tax/Total Assets
D = Market Value of Equity/Total Liabilities
E = Sales/Total Assets

A score below 1.8 means the company is probably headed for bankruptcy, while companies with scores above 3.0 are not likely to go bankrupt. The lower/higher the score, the higher/lower the likelihood of bankruptcy.

Beneish Model - M Score

Created by Professor Messod Beneish, the M-Score is a mathematical model that uses eight financial ratios to identify whether a company has managed / manipulated its earnings. The variables are constructed from the company's financial statements and create a score to describe the degree to which the earnings have been manipulated. In many ways it is similar to the Altman Z-Score, but it is focused on  detecting earnings manipulation rather than bankruptcy. 

Interestingly, students from Cornell University using the M score correctly identified Enron as an earnings manipulator, while experienced financial analysts failed to do so.

- See more at:

Calculation / Definition of the M-Score 

The M score is based on a combination of the following eight different indices:

  1. DSRI = Days’ Sales in Receivables Index. This measures the ratio of days’ sales in receivables versus prior year as an indicator of revenue inflation.
  2. GMI = Gross Margin Index. This is measured as the ratio of gross margin versus prior year. A firm with poorer prospects is more likely to manipulate earnings.
  3. AQI = Asset Quality Index. Asset quality is measured as the ratio of non-current assets other than plant, property and equipment to total assets, versus prior year.
  4. SGI = Sales Growth Index. This measures the ratio of sales versus prior year. While sales growth is not itself a measure of manipulation, the evidence suggests that growth companies are likely to find themselves under pressure to manipulate in order to keep up appearances.
  5. DEPI = Depreciation Index. This is measured as the ratio of the rate of depreciation versus prior year. A slower rate of depreciation may mean that the firm is revising useful asset life assumptions upwards, or adopting a new method that is income friendly.
  6. SGAI = Sales, General and Administrative expenses Index. This measures the ratio of SGA expenses to the prior year. This is used on the assumption that analysts would interpret a disproportionate increase in sales as a negative signal about firms future prospects
  7. LVGI = Leverage Index. This measures the ratio of total debt to total assets versus prior year. It is intended to capture debt covenants incentives for earnings manipulation.
  8. TATA - Total Accruals to Total Assets.  This assesses the extent to which managers make discretionary accounting choices to alter earnings. Total accruals are calculated as the change in working capital accounts other than cash less depreciation.

The eight variables are then weighted together according to the following formula:

  • M = -4.84 + 0.92*DSRI + 0.528*GMI + 0.404*AQI + 0.892*SGI + 0.115*DEPI – 0.172*SGAI + 4.679*TATA – 0.327*LVGI

There is also a five variable version which excludes SGAI, DEPI and LVGI (as these were not significant in the original Beneish model).

  • M  = -6.065 + 0.823*DSRI + 0.906*GMI + 0.593*AQI + 0.717*SGI + 0.107*DEP

The exact threshold varies depending on the probability of mis-classification but, broadly speaking, a score greater than -1.78 (i.e. less negative or positive number) indicates a strong likelihood of a firm being a manipulator.

Wednesday Jan 14, 2015

PSRM Analytics v2.1 Datasheet now available

We are pleased to announce that a new datasheet for PSRM Analytics version 2.1 is now available:  

PSRM v2.4.0 Installation Walkthrough for Linux

The Oracle Global Customer Support team has recorded a subtitled video that demonstrates how to install Oracle PSRM 2.4.0 (and later versions) on a Linux environment. This video can be found on My Oracle Support under document 1608404.1.

This process can be used for either a new PSRM 2.4.0 installation or upgrading an existing installation to (2.4 SP1).

Monday Jan 05, 2015

Oracle PSRM Fundamentals recordings now available on the PSRM Training YouTube channel

We are pleased to announce that a new PSRM Fundamentals Overview series is now available on the PSRM YouTube channel.  This includes 15 videos, each about 10 to 20 minutes long (on average), covering many of the key business function areas in the PSRM.  This provides a nice introduction to PSRM to supplement training.  


(or, go to YouTube, and search for "Oracle PSRM Training").


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