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

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.   

Tuesday Oct 21, 2014

Oracle PSRM v2.4.0 Batch Benchmark Data Sheet

A recent batch performance benchmark was performed on Oracle PSRM v2.4.0 to ensure that prior benchmark results were at least maintained if not improved upon when using the latest version of the product. The benchmark showed that Oracle PSRM v2.4.0 processed the same amount of data in a shorter period of time with better scalability and throughtput compared to Oracle PSRM v2.3.1.

See this data sheet for more information about this benchmark, including a reference to the detailed report on My Oracle Support.

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 Oct 03, 2014

Oracle Public Sector Revenue Management Self Service V1. (Service Pack 1 ) is now Generally Available!

Oracle PSRM Self Service v1.  is now available for download on My Oracle Support. This version of product is integrated Oracle Public Sector Revenue Management (2.4.0 SP1).

Oracle PSRM Self Service v1. release contains following new features:

  • User registration and enrollment
  • Taxpayer personal information
  • Account summary with current state of all user’s tax accounts
  • Filing history
  • Payment history: received payments, their dates and amount
  • Payments and service requests for registered users
  • Account alerts including due date reminders, overdue warnings, collection notifications, payments and refund related notice
  • Tax form filing, pre-population,  validation, printing and submission
  • Filing guided assistance and personal help
  • Tax form designer to define form layout, presentation and business rules
  • Form definition import  from PSRM
  • Tax form integration with BI Publisher for form printing


Please refer to the Oracle Technical Network for the product documentation associated with this release. The Release Notes document includes more details on these and other enhancements as well as future deprecation announcements.

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]

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.


« February 2016