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


PeopleSoft HCM Image 44 Released
Oracle has released PeopleSoft HCM Image 44 and with the release of new HCM image, lots of bugs have been[...]
How to Easily Create a Demo Database from a PUM Database
The topic of this article may be misleading and may make sense only to those who have found a need[...]
What is YUM and how it is used in PeopleSoft?
YUM is the utility that is used to install and update RPM packages on Linux based systems. YUM utility can[...]
PUM Error: ImportError: libncursesw.so.5: cannot open shared object file: No such file or directory
When deploying a PeopleSoft Image or deploying PeopleTools DPK, the deployment may fail with an error given below: ImportError: libncursesw.so.5:[...]
PeopleSoft Tax Updates 2022
PeopleSoft Tax Updates are a critical part of HCM payroll processing and must be applied to your PeopleSoft application to[...]
PeopleSoft Update Manager (PUM) Tables
There may be occasions when you need to know the tables associated with PUM (PeopleSoft Update Manager) Images. You can[...]