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

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]

Friday Mar 28, 2014

Updated PSRM Training Information

Oracle PSRM training content has been updated to reflect the latest version of the product, Oracle PSRM v2.4.0. Review this updated datasheet for course descriptions and contact your local Oracle PSRM representative to learn how to participate in these courses.[Read More]

Monday Mar 03, 2014

PSRM SS Technical Architecture Overview

Public Sector Revenue Management  Self Service architecture includes multiple layers of technical 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 which role each product is playing in overall solution, how they fit and work together listen to this recording.

Thursday Feb 27, 2014

Evaluating and Meeting SLAs - Performance Requirement Guidelines

Implementations typically need to establish performance goals that the system will need to meet.  At times these goals come from customer requirements in the form of Service Level Agreements (SLA).  When establishing performance goals, we use a set of “default” performance requirements, and any change from that (higher or lower) is an exception, usually based on the weight or complexity of the transaction.  Forms Validations and Posting is an example of an exception.  The implementation team will have to be careful about applying the general rules to everything.   

[Read More]

Wednesday Jan 08, 2014

Oracle Public Sector Revenue Management version 2.4.0 and 2.3.1 now support IE 9

Just a quick note to current PSRM implementers and customers:  We have added support for IE 9 in compatibility mode for PSRM 2.4.0 and ETPM 2.3.1. 

ETPM 2.3.1 and PSRM 2.4.0 currenlty support IE 7 and 8 in native mode and IE 9 in compatibility mode. 

Monday Dec 02, 2013

Oracle PSRM v2.4 Features & Functions and Datasheet Collateral Available

The most recent release of Oracle Public Sector Revenue Management, v2.4, includes a number of new features that expand the base product's coverage of features for customers that manage a wide variety of revenue types. These features include:

 - Asset and Valuation record maintenance

- Asset Billing using new configurable Calculation Engine

- Centralized Address Repository

- Production Controls

- Entity Correction

The Oracle PSRM v2.4.0 Features and Functions and Datasheet documents summarize the product's features and benefits for customers and implementation partners.


Wednesday Nov 20, 2013

Designing New Processes - Process Flow or Custom MO?

From time to time implementation/project teams will need to support business processes that are not provided by the base product. PSRM provides 2 main options for implementing custom business processes, Process Flows and custom Maintenance Objects (MOs).  This article provides information about each one.

[Read More]

Tuesday Nov 12, 2013

PSRM Frequently Asked Questions

Over time we have encountered common questions from customers and partners.  The document below answers some of the frequently asked questions related to sales and licensing, implementation and also general PSRM questions. 

[Read More]

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.   


Thursday Sep 19, 2013

Sizing Process

This article includes a presentation describing the sizing process as well as the questionnaire used during the sizing process. [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.

Friday Apr 13, 2012

Recording Available: Oracle ETPM Performance Forum: "Scalability", Wednesday March 21st, at 1pm EST - 4:30pm EST

Attached is the recording URL last months Oracle ETPM Performance forum meeting, from Wednesday, March 21st, at 1pm EST to 2:30pm EST. 

The topic was “Scalability".  The topic focuses on an overview of important Scalability concetps, scalability testing and troubleshooting, and ETPM scalability characteristics we have seen in our benchmark testing.  

Meeting Recording Playback URL:  https://oracletalk.webex.com/oracletalk/ldr.php?RCID=6047893f2716904ae91d0a09f852e946

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