Change Assistant Pre-requisites Issues

I was putting a Campus Solutions Bundle on a system for a client and as per usual PeopleSoft delivered an emergency ISIR patch to follow up.  However, this time when I went to apply the ISIR patch after the fact Change Assistant was complaining that the pre-requisite bundle was not applied yet.  Now I know my memory is bad, but it was just the other day, I know I put the patch on this environment.

First, I thought cache, so I stopped all the agents and all the environments cleared the cache and reset the PSEM Agents & Hub.  Fired it back up and still the same error.  I even reset the GUID on PSOPTIONS.

I checked the PS_MAINTENANCE_LOG and clearly the update I put on is there, however, it looks a little different on one of the fields for other bundles.  The FIXOPRID for the bundle was PS and not PPLSOFT like the other bundles.  Sure enough I did a

UPDATE PS_MAINTENANCE_LOG SET FIXOPRID = ‘PPLSOFT’ WHERE UPDATE_ID = ‘{CSBundle##}’

Re-ran the check and sure enough all is right in the world again.  All pre-requisites need to have the FIXOPRID be PPLSOFT otherwise things don’t go as planned.

Campus Solutions Patch # Change

Oracle decided to integrate PeopleSoft patching into their main database for patch fix, and in the process the commonly used Update ID, has been change to be associated with what I call the Bug Incident, but they are referring to as the Patchset in ARU.

The ARU is Oracle’s Automated Release Update system and has gone by various other names.  Since I maintain a few patch lists I have some serious updating to do, but at least they made some nice documents to show the old and new numbers.  The new system appears to be clunky and difficult to to use like all new patch systems in the past.  Hopefully it will get easier to use and understand with some more use.  Good luck!

Here is the list for the Campus Solutions 8.9 & 9.0 Campus Bundles:

Campus Solutions 9.0 Bundles

Bundle Number Update ID Patchset (in ARU)
1 682663 Patch 11397795
2 682678 Patch 11397828
3 682679 Patch 11397835
4 682702 Patch 11397868
5 687643 Patch 11404993
6 699734 Patch 11421010
7 701899 Patch 11423745
8 701900 Patch 11423746
9 701903 Patch 11423750
10 739496 Patch 11468844
11 739499 Patch 11468846
12 739503 Patch 11468847
13 739506 Patch 11468848
FP1 792325 Patch 11509618
14 739510 Patch 11468849
15 782226 Patch 11533599
FP2 795777 Patch 11555329
16 782227 Patch 11533601
17 782228 Patch 11533602
18 782229 Patch 11533603
19 782230 Patch 11533604
20 812865 Patch 11585702
21 812867 Patch 11585703
22 812869 Patch 11585704
23 861514 Patch 11701766
24 870591 Patch 12903599
25 877012 Patch 13622672
26 879831 Patch 13892711

Campus Solutions 8.9 Bundles

Bundle Number Update ID Patchset (in ARU)
 1  592864 Patch 11239530
 2  592866 Patch 11239533
 3  611993 Patch 11277406
 4  613404 Patch 11279838
 5  613408 Patch 11279853
 6  613411 Patch 11279867
 7  613681 Patch 11280184
 8  650846 Patch 11337433
 9  711549 Patch 11436520
 10  656272 Patch 11344503
 11  682701 Patch 11397866
 12  687640 Patch 11404988
 13  699733 Patch 11421005
 14  701891 Patch 11423729
 15  701895 Patch 11423737
 16  701896 Patch 11423739
 17  739491 Patch 11468852
 18  739492 Patch 11468853
 19  739493 Patch 11468854
 20  739494 Patch 11468855
 21  739495 Patch 11468857
 22  782234 Patch 11533612
 23  782235 Patch 11533613
 24  782236 Patch 11533614
 25  782237 Patch 11533615
 26  782238 Patch 11533616
 27  812859 Patch 11585698
 28  812863 Patch 11585699
 29  812864 Patch 11585700
 30  869531 Patch 12801464
 31  870589 Patch 12903619
32 877011 Patch 13622645
33 879832 Patch 13892785