Useful queries for PeopleSoft Update Manager

1) Sometime you need to identify all enhancement related to one bug in PeopleSoft Update Manager. Manually you may open each bug and check whether the bug has pre-requisite of one bug.
Below query is used to identify all enhancement for one bug.

Technically below query identifies all bugs in which one bug of your interest is pre-requisite.

SELECT PTIASPRPTNO, PTIASPRPTNOPRE, PTIASPRPTSUBJECT,
PTIASPSPVERS, TO_CHAR(CAST((PTIASPRPTPOSTDT)
AS TIMESTAMP),'YYYY-MM-DD-HH24.MI.SS.FF')
FROM PS_PTIASPRPTRQPRVW  WHERE PTIASPRPTNOPRE = &Bug_ID
ORDER BY PTIASPRPTPOSTDT;

 2) Below query provides list of objects present the Bug

SELECT PTIASPRPTNO, OBJECTTYPE, DESCR254, OBJECTID1,
OBJECTVALUE1, OBJECTID2, OBJECTVALUE2, OBJECTID3,
OBJECTVALUE3, OBJECTID4, OBJECTVALUE4, UPGRADEACTION,
PTIASPUPGACTION, PTIASPTAKEACTION, PTIA_COUNTER
FROM PS_PTIASPRPTMOLVW  
WHERE PTIASPRPTNO = &BUG_ID
ORDER BY DESCR254, OBJECTVALUE1, OBJECTVALUE2,
OBJECTVALUE3, OBJECTVALUE4;

Note : replcate &BUG_ID variable with correct BUG ID.

3) Below query provides Details of Bug including bug description, pi version, etc.

SELECT PTIASPRPTNO, PTIASPSPVERS, PTIASPRPTSUBJECT, PTIASPPRDCD,PTIASPRPTCUSTFLAG, PTIASPRPTTESTFLAG FROM PS_PTIASPRPTHEADVW WHERE PTIASPRPTNO=&bug_id ORDER BY PTIASPRPTNO;

Re-apply change package using PeopleSoft Update Manager

PeopleSoft Update Manager do not keep customization. To retain customization, Admin/Developer needs to re-apply customization after applying change package using PeopleSoft update Manager. However sometimes functionality may not work as expected after re-applying customization and you need to re-apply delivered change package to retain delivered objects.

PeopleSoft Update Manager do not create a change package for update ID which is already present in target database.

There is no delivered approach to re-apply change package using PeopleSoft Update Manager.

You need to remove the change package update ID information from PS_PTIASPLOGTGT table which allow PeopleSoft Update Manager to create a new change package with the update ID which was already installed.

PS_PTIASPLOGTGT is a copy of the Target environment's maintenance log that is stored in the Source in order to facilitate the PUM calculations and analysis.

You can query PS_PTIASPLOGTGT table in PUM (source) and identify rows related to Patch for your target database.

SELECT * FROM PS_PTIASPLOGTGT WHERE PTIASPRPTNO = <Patch ID> and dbname = <target DB>

Take the back up of table PS_PTIASPLOGTGT

Remove the entry of <Patch> from table PS_PTIASPLOGTGT

Login in PIA, Navigate to PeopleSoft update Manage Dashboard and define a new change package with the patch ID.

Thanks,
Ketan.