PUM: Finding PUM maintenance info using PS Query

PUM has changed the way how you apply bugs and get new features for PeopleSoft 9.2 applications. Critical part of PUM process is the PeopleSoft Image which is cumulative and contains thousands of bugs, patches and enhancement.

These bugs (or new features) can be extracted from PUM Image (SOURCE) and then applied to your TARGET environment as and when you decide to do that.

At times you may also want to review the current status of your target PeopleSoft application to see what bugs have already been applied so that you could plan your future maintenance schedule.

Once the PUM target is configured, you could use PUM Dashboard which has really nice graphs and filter to review the maintenance information for the target databases.

PUM Dashboard

  PUM Dashboard

If you like to see the data in excel or tabular format, you could use delivered PeopleSoft Queries for PUM. These queries start with prefix PTIA and can be found in PS Query Manager.

These PUM queries are available in PeopleSoft Image for PUM and can be run directly from query manager or you could grab the SQL and then run it in your favorite SQL tool like Toad, SQL developer.

  • PTIASP_DB_APPLIED_BUGS_LAG                                    – Applied Bugs Lag Information
  • PTIASP_DB_BUGS_BY_TAGS                                              – Database Bugs by Tags
  • PTIASP_DB_BUGS_BY_TAGS                                              – Database Bugs by Tags
  • PTIASP_DB_BUG_CUST_DEP_BY_RANG                       – Customization Impacts By Bug
  • PTIASP_DB_BUG_DEP_BY_RANGE                                  – Bugs By Dependency
  • PTIASP_DB_BUG_STATUS                                                    – Database Bug Status
  • PTIASP_DB_ENHANCEMENT_BUGS                                – Database Enahncement Bugs
  • PTIASP_DB_ML_BUGS_BY_TAGS                                      – Bugs by Language
  • PTIA_BUG_DB_STATUS                                                         – BUG Status by Target Database
  • PTIA_BUG_MOL_DETAIL                                                      – BUG MOL Details
  • PTIA_STATUS_BY_PROD                                                      – BUG Status by Product
  • PTIA_STATUS_BY_TAG                                                         – BUG Status by TAG

When you run the PUM queries without uploading the target database, you won’t see the output data. For these queries to display results, you need to first upload the target database information using Change Assistant and then run these in query manager.

You may have noticed the name and description of these PS queries and these are nothing but the same information that you see in the PUM dashboard.
You can even use these delivered queries to create any reports of your own to review PUM data.

In case you’re wondering the tables involved in PUM , check out this post with list of all PUM tables

 

What is PeopleSoft Release Patchset (PRP)
As you know that PUM is the only way to apply maintenance to 9.2 applications (and IHUB 9.1), there are[...]
PUM for PeopleSoft Functional users
Whenever the word 'PUM' a.k.a 'PeopleSoft Update Manager' is mentioned it's assumed that it's only a job of PeopleSoft Administrator[...]
What does PeopleSoft DPK files contain
PeopleSoft uses DPK for almost all kinds of install and deployment which are delivered in zip files. Have you ever[...]
PUM: Install PeopleSoft Image on External Hard Drive
I get this question a lot that my system doesn't have enough disk space to deploy PeopleSoft Image so can[...]
PUM Error: Source and Target must be the same product line
In another recent post, we discussed how to fix PUM Error: Incompatible PeopleTools version and in this post we will[...]
PUM Error : Incompatible PeopleTools version
It's very true that more you practice something better you become at it. No matter how many times I do[...]
Prashant
 

Click Here to Leave a Comment Below 0 comments