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: 

https://blogs.oracle.com/tax/resource/Extracting_PSRM_BO_Extension_data_using_Materialized_Views.pdf

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.   

http://thatoracledude.blogspot.com/2014/01/installing-oracle-psrm-24-former-etpm.html

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.

https://blogs.oracle.com/tax/resource/PSRM_Attachments_Overview.pdf


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]
About

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.

Search

Categories
Archives
« April 2014 »
SunMonTueWedThuFriSat
  
1
3
4
5
6
7
9
11
12
13
14
15
16
17
19
20
22
23
24
25
26
27
28
29
30
   
       
Today