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.   


Monday Mar 03, 2014

PSRM Self Service Technical Architecture Overview

The Oracle Public Sector Revenue Management Self Service architecture includes world class Oracle technology products, such as Oracle WebCenter, Oracle Application Development Framework, Oracle SOA Business Process Execution Language (BPEL), Oracle Content Managment and Oracle Policy Automation. To learn about the role each plays in overall solution, how they fit and work together listen to this recording.

Wednesday Oct 30, 2013

Oracle PSRM v2.4 documentation is now available on oracle.com!

We are very excited that Oracle PSRM v2.4 will be released for General Availability very soon!  In advance of the release, the documentation for Oracle PSRM v2.4 has been posted to the OTN (Oracle Technology Network) on oracle.com.  You can find it here:  http://www.oracle.com/technetwork/documentation/pubsectrevmgmt-154608.html

You can also find it from the OTN documentation home page:  http://www.oracle.com/documentation , and scrolling down to find Public Sector Revenue Management.  Please note, if you previously bookmarked the Oracle Tax documentation page, the url has changed to the new url above.  

Oracle ETPM is renamed Oracle Public Sector Revenue Management (PSRM)

We are excited to announce to that with the upcoming release of v2.4, we are renaming ETPM to Oracle Public Sector Revenue Management (Oracle PSRM).  This is a pure name change, and all terms and conditions for existing customer licensing remain unchanged.  We feel that this updated naming is a better reflection of our current customer base, which includes tax revenue for many Departments of Revenue, as well as agencies that at manage non-tax revenue, such as regulatory fees, loans, and social benefits.   

Please note, as part of this name change, related products in the Oracle ETPM family, such as Oracle Tax Analytics, and Oracle ETPM Self Service, will be renamed at their next major product release to align to the Oracle PSRM theme.   

Wednesday May 08, 2013

Recorded Demo of Oracle Tax Analytics V2.0

The following is a 25 minute recorded demo of Oracle Tax Analytics v2.0.  For those that are interested is seeing what OTA looks like and learning more, this is a quick and convenient way to see the product.  You can stream the demo recording here:  


The Oracle Tax Analytics 2.0 Data Sheet is available at http://www.oracle.com/us/industries/public-sector/oracle-tax-analytics-ds-414292.pdf

Monday Apr 22, 2013

SDK documentation is now accessible from oracle.com

The SDK documentation is now available on oracle.com.   You can find them here:  http://www.oracle.com/technetwork/documentation/pubsectrevmgmt-154608.html, or by going to http://www.oracle.com/documentation, and selecting Oracle Public Sector Revenue Management.   Read on for more information...

[Read More]

Archiving Roadmap

The Oracle archiving option available with Enterprise Taxation and Policy Management was created to help customers speed response time, reduce hardware costs, and to retain historical records for viewing and reporting.  In order to have a consistent product across the entire Oracle application stack, the current solution will be retired, in favor of a new option that will make better use of native, high performance DB features. Oracle DB provides an "archive" option within a set of features that are called "Information Lifecycle Management", or ILM.

This article provides a short overview of our future direction.   

[Read More]

Oracle ETPM Partitioning Recommendation

Database partitioning is an important strategy for minimizing data contention between threads in a multi-threaded batch process, which improves batch system performance and scalabiity.  

The following is a short summary of partitioning strategy and recommendations with Oracle ETPM.  A special thank you to Graeme Robinson and Ilya Klebaner for developing this content!!!

[Read More]

Tuesday Mar 12, 2013

Now Available: Oracle ETPM V2.3.1 Arabic User Interface

Oracle Tax is pleased to announce the general availability of Oracle ETPM v2.3.1 UI (user interface) for Arabic 

Language Patch Download:

  • To download the ESA language pack please log in to My Oracle Support:  https://support.oracle.com/CSP/ui/flash.html.
  • Select the Patches and Updates tab
  • Type in the Patch number:  15925254   
  • Click the Patch number
  • Download using the yellow download button on the right hand side

Now Available: Oracle ETPM V2.3.1 Latin American Spanish (User Interface and Online Help)

Oracle Tax is pleased to announce the general availability of Oracle ETPM v2.3.1 UI (user interface) and On-line Help for Latin American Spanish (ESA)

Language Patch Download:

  • To download the ESA language pack please log in to My Oracle Support:  https://support.oracle.com/CSP/ui/flash.html.
  • Select the Patches and Updates tab
  • Type in the Patch number: 15992462
  • Click the Patch number
  • Download using the yellow download button on the right hand side

Recording Available: Oracle ETPM Self Service Foundation Demo

We've recorded a short overview and demo of the Oracle ETPM Self Service Foundation.  You can view the demo here:


Wednesday Jan 23, 2013

Tax and Revenue Management User Group

New and prospective customers frequently ask if we have a user group where they can discuss topics related to tax and revenue management, and to related Oracle products.[Read More]

Monday Sep 17, 2012

ETPM/OUAF 2.3.1 Framework Overview - Session 2

A number of sessions are planned to review the ETPM (OUAF) 2.3.1 Framework.  These sessions will include an overview of the Navigation, Portals, Zones, Business Objects, Business Services, Algorithms, Scripts, etc..

Session 2 includes a more in depth discusion of Business Objects (BO).  Session 2 specifically covers BO Schema, BO Options, and BO inheritance in more depth.  Click on the link below for Session 2 (52 minutes).

To stream the recording:  


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 2014