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 Oct 30, 2013

Oracle PSRM v2.4 documentation is now available on!

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  You can find it here:

You can also find it from the OTN documentation home page: , 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

Monday Apr 22, 2013

SDK documentation is now accessible from

The SDK documentation is now available on  You can find them here:, or by going to, and selecting Oracle Tax.   You can bookmark the library for quick and convenient reference.  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:
  • 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:
  • 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:

Thursday Jun 21, 2012

Accessibility Update: The Oracle ETPM v2.3 VPAT is now available on

Oracle Tax is committed to building accessible applications.  Oracle uses a VPAT (Voluntary Product Accessibility Template) to document the accessibility status of each product.  The VPAT was created by a partnership of the Information Technology Industry Council (ITI) and the U.S. General Services Administration (GSA) to create a simple document that could be used by US Federal contracting and procurement officials to evaluate a product with respect to the provisions contained in Section 508 of the Americans with Disabilities Act (ADA).

The Oracle ETPM v2.3 VPAT is now available on 

  [Read More]

Thursday May 10, 2012

Recording Available: Features & Functions Case Management

Recordings are available to provide an overview of the ETPM Case Management Module.  The recordings provide an overview of the Collections and Compliance features.

The Collections Recording provides an overview of the Overdue Process, Overdue Events, Collection Cases and Pay Plans.

The Compliance Recording provides an overview of the Audit, Appeals, Bankruptcy and Suppression process.


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.


« April 2014