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;