PUM: Finding PUM maintenance info using PS Query | PeopleSoft Tutorial

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


How To Verify Integrity of PeopleSoft Image Files And Perform Check Sum
If you get error anytime when trying to import PeopleSoft Images then you need to make sure that all the[...]
PeopleSoft Image shows incorrect time
Have you ever noticed that time for PeopleSoft Image is usually different than your local host time? If yes, in[...]
How to create a permanent share for Oracle Linux VM
Yesterday I published a post where I shared how to access the files on the Oracle Linux VM deployed on Oracle[...]
Access Virtual Box Files on Windows Host
When you deploy PeopleSoft Image, couple of directories such as pi_home and tools_client are already shared and can be easily[...]
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[...]