Friday Jul 18, 2014

Use Google Maps with Oracle Public Sector Revenue Management Analytics

Adding map configuration to Oracle Public Sector Revenue Management (PSRM) Analytics provides users an impactful view of revenue data.  See the attached document for steps to configure Google maps with Oracle PSRM Analytics.

[Read More]

Thursday Jul 17, 2014

IRS 1075 Risk Assessment Workshop

Learn how to achieve IRS 1075 compliance with Oracle Database 12c security solutions.  The Federal Government has issued mandatory guidelines, outlined in IRS Publication 1075, to ensure that effective security controls are in place wherever Federal Tax Information is received, processed, stored or maintained. This one-day workshop presents hands-on exposure to real-world use cases specific to IRS 1075, and provides participants with hands-on exposure to Oracle’s database security products to meet compliance with IRS 1075 security controls.  See the attached workshop datasheet for more information about this offering.

Oracle PSRM Self Service v1.1 is Now Generally Available!!!

We are pleased to announce that Oracle Public Sector Revenue Management Self Service is now generally available for download from the Oracle Software Delivery cloud. The solution provides tax and revenue authorities with a single citizen portal – powered by Oracle Policy Automation for Public Sector, Oracle WebCenter, Oracle Application Development Frameworkand Oracle SOA Suite – that can integrate across multiple tax types and tax processing systems.

Oracle Public Sector Revenue Management Self Service enables tax and revenue authorities to quickly provide more taxpayer services online – such as the ability to make payments, contact the tax agency with questions and requests or receive self-guided automated assistance with policies and tax law.  Tax and revenue authorities can implement Oracle Public sector Revenue Management Self Service – an out-of-the-box solution – quickly and easily, and lower the cost of taxpayer service operations by promoting a broader set of taxpayer self service features



Overview presentation:


Recorded Demo:

User Interface screen shots:  (posted as a zip file based on size)

Oracle Public Sector Revenue Management Analytics v2.0 Portuguese UI Available Now

We are pleased to announce the general availability of a Portuguese user interface (UI) language pack for Oracle Public Sector Revenue Management Analytics v2.0.

Language Patch Download:

To download the Portuguese language pack please log in to My Oracle Support

  • Select the 'Patches and Updates' tab
  • Type in the Patch number: 17968649
  • Click the Patch number
  • Download using the yellow download button on the right hand side

Password Management for Oracle PSRM

It is important for customers to understand how to maintain passwords for Oracle Public Sector Revenue Management (PSRM), which is built using Oracle Utilities Framework (OUAF).  PSRM and OUAF do not supply functionality to maintain a password.  It is Oracle's direction for industry products and core applications not to maintain security information as it is not their role in an architecture.  We recommend Oracle Identity Management Suite for password management as password rules and user provisioning ensure a secure and compliant security fabric across the product line.  However, PSRM and OUAF follow open technology standards, so 3rd party password management solutions may be used.

Please, refer to the link below for a sample that illustrates how to call an internal WebLogic API to change the password from a product via a JSP call regardless of the Authentication Provider within Oracle WebLogic.

Monday Jul 07, 2014

Private Cloud Planning Guide available for Oracle PSRM

Oracle Public Sector Revenue Management (PSRM) can be housed in a private cloud infrastructure which is either onsite or as a partner offering. Oracle provides a Private Cloud foundation set of software that can be used to house Oracle PSRM. A whitepaper has been developed and published that should aid customers and implementers in planning an installation of Oracle PSRM on a private cloud.

The Oracle PSRM Private Cloud Planning Guide (Doc Id: 1904915.1 from My Oracle Support) provides an architecture and software manifest for implementing a fully functional private cloud offering onsite or via a partner. It refers to other documentation to install and configure specific components of a private cloud solution.

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]

Friday Jun 06, 2014

Oracle PSRM V2.4.0 Portuguese UI Now Available

This provides a Portuguese user interface (UI) language pack for Oracle PSRM v2.4.0 

Please note, this language pack translates the PSRM UI (user interface) to Iberian Portuguese.

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: 18916310
  • Click the Patch number
  • Download using the yellow download button on the right hand side

Thursday Jun 05, 2014

Where to find Information on Software/Technologies Supported by PSRM

People often ask where they can find informatoin about software and technologies supported by PSRM and what versions are supported.  This information can be found in the following locations:

For X Path - See Script Engine Version dropdown in script Display/maintenance portal  in PSRM for three different kinds of scripts we support.

Reference Document:

    • For HTML/Java script -  As supported by supported browsers mentioned in Installation Guides.
    • For information related to supported platforms(OS, Browsers, App servers and Database Servers) -  See Certified and supported Platforms section.

Reference Document:

    • For Information related to Oracle client, Java, Micro Focus, Web servers  -  See Installation Checklist section.
    • For Third Party products, copy right and licensing notices (like Apache FWs/libraries) - See License and Copyright Notices section (Appendix B).

Friday May 30, 2014

Oracle Policy Automation YouTube Videos

The OPA YouTube site includes a large number of videos on various OPA topics including feature introductions, tutorials and overview presentations. Be sure to check these out if you would like to learn more about OPA and it's capabilities.[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.

Thursday Apr 10, 2014

PSRM Conversion Tool Overview

Converting the data from legacy application to Oracle Public Sector Revenue Management application is tedious process. It requires a good understanding of PSRM data model and how tables and fields are mapped to legacy entities.   Once the data is mapped it needs to be loaded to staging tables, validated and moved to PSRM production tables.

To learn how Conversion Tool  helps with this task listen to this overview.

Tuesday Apr 08, 2014

PSRM Attachments Overview

A number of PSRM implementers have asked about the new Attachments functionality in Oracle PSRM.  This has been added to the PSRM product training, and the following gives an overview of how it works.

Wednesday Apr 02, 2014

Oracle ETPM v2.3.1 Performance Benchmark Reports Available

The Oracle PSRM team is pleased to announce the exceptional results of the Oracle ETPM v2.3.1 performance benchmark.  Two reports were created that describe Oracle ETPM 2.3.1 throughput and scalability metrics for batch processing and OLTP.  [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.


« July 2016