PeopleSoft 9.2 Upgrade: Databases used in Upgrade Initial Pass

by Prashant on August 21, 2015

in Upgrade

In this article, we will discuss about different environments that are used during PeopleSoft 9.2 upgrade initial Pass. You will also learn about the specific use of each of these environments and what they represent.

New Release Demo Database (Source)

New Release demo database refers to the database delivered with your new PeopleSoft release. If you’re upgrading from PeopleSoft HCM 9.0 application to PeopleSoft HCM 9.2 application then you would need to have a HCM 9.2 Demo database installed and configured to be used during your initial Pass. This New Release Demo Database is considered to be source for Initial Upgrade Pass and new release objects are exported from this environment and imported into your target environment.

With PeopleSoft 9.2 upgrade, you have 2 options for using your source environment. Either install a fresh PeopleSoft 9.2 application or use PeopleSoft Upgrade Source image. Upgrade Source image may not be applicable for all the customers as it can only be used as source for environments with Oracle database and English only. Make sure to go through documentation (PeopleSoft Upgrade Source Images Home Page (Doc ID 1552580.1)) for using and deploying PeopleSoft upgrade source before deciding to use it.

Note: There have been lot of confusion with use of different PeopleSoft virtual images. Please be clear that PI (PeopleSoft Image for PUM) can’t be used as source for your Upgrade Initial Pass.

image

Copy of Production Database (Target)

During PeopleSoft upgrade, you would want to upgrade your existing PeopleSoft old release application to a newer version. For that purpose, we take a fresh copy of production database and then specify it as target for Initial Upgrade Pass. Objects from New Release Demo database are imported into this environment and after completion of Initial Pass, this environment will become upgraded copy of production (with latest application release e.g. 9.2).

Copy of Current Demo

PeopleSoft Upgrade Initial Pass also uses a copy of current demo i.e. the demo environment of your existing release (e.g. HCM 9.0 demo). Purpose of using a copy of current demo is to identify the customization done by customer to the PeopleSoft application as delivered by Oracle in its demo environment. These changes/customizations are recorded in UPGCUST project.

After initial pass is finised, we won’t need ‘New Release Demo’ and ‘Copy of Current Demo’ for other upgrade passes. Copy of Production will be come ‘Upgraded copy of Production’ and will be used as source for next upgrade pass (Test Move to Production).

Related Posts Plugin for WordPress, Blogger...

{ 9 comments… read them below or add one }

Ajay February 3, 2016 at 2:45 pm

Thanks Prashant. Good Cheat-sheet to jog your memory. Does UPGCUST get created in Current Demo or COP?

Reply

Prashant February 3, 2016 at 11:37 pm

Thanks Ajay. UPGCUST is created in COP after db compare between current demo & COP. Main reason for this project creation is to identify the customization done to delivered application.

Reply

JorgeA April 12, 2016 at 4:31 pm

Do you create and save the UPGCUST project in Application Designer and then run the current demo to cop compare? I’m not clear what creates the UPGCUST project.

Reply

Prashant May 11, 2016 at 5:30 pm

Jorge, you don’t create this project manually but it’s created as part of Initial Upgrade Pass Job. This project contains the customizations that you have made to current demo. UPGCUST project is then migrated to Upgrade source(e.g 9.2 upgrade source) and 9.2 objects are added to it by upgrade process. Now your UPGCUST contains your existing customizations and new 9.2 objects. A compare is run between upgrade source and COP to identify the impact on customizations.

Reply

Shirley June 29, 2016 at 11:36 am

Hi Prashant,
When prepare the initial pass, I asked the DBA to create copy of production (still in old tool and application). My question is, do I need to create application server domain, process scheduler for this copy of production? or only database is good enough?
Also, the old tool and application is on Oracle database 11g, should we upgrade this to 12c before Peoplesoft upgrade?
Thanks.

Reply

Prashant June 30, 2016 at 12:22 pm

Shirley,
You don’t necessarily have to create App, Web and prcs domain as initial pass is run on the database. Even if you create these domains, you would need to shut down when running initial pass as you don’t want anyone to access the application while upgrade related changes are applied to databases.
When deciding to upgrade to 12c, please consider the following:
– Is Oracle 12c the only version certified for your target PeopleTools? If yes, then you would want do it before.
– If 11g is also certified for target PeopleTools, then you can decide based on the resources available to you. Whether you want to do it before or later.
– If you enough resources (time/budget/people) to do the Oracle db upgrade before starting PS upgrade, that would be nice.

Hope it helps.

Reply

Prateek September 19, 2016 at 2:56 am

Hi Prashant,

We are in a process of Upgarding our Application fronm 9.1 to 9.2, while we have already upgraded our tools release to 8.55 ( froom 8.51). We are facing a wierd issue, where in the the CA fails at step, Creating the UPGCUST Project, without giving any error. In the log file, we can see that the “Records Application Upgrade Customized Project Generation started” time, Nothing is logged after that. Can you please suggest any thing. Following is the command line parameter, which are being passed :

pside.exe -CT ORACLE -CS -CD DBname -CO VP1 -CP * -CI people -CW * -PJRCUST UPGCUST -OBJ All -LF D:\temp\UPGCUST_compare.log -HIDE -QUIET -SS NO -SN NO

Reply

Prashant September 26, 2016 at 3:20 pm

Hi Prateek,
You mentioned that you’ve already upgraded to PeopleTools 8.55 so I am assuming that you’re using Change Assistant ver 8.55 and created upgrade change package using PUM application. While upgrading from 9.1 to 9.2 with PeopleTools 8.55 , UPGCUST is created by Application Engine Program instead of old method of using copy of current demo.
Here is I would check:
– Applied Required for Upgrade fixes
– Configuration Manager settings are correct
– CA environment configuration (source and target) pointing to correct PS_HOMEs
– Try to run the command using command prompt and see if it fails or shows any additional errors

I feel most likely issue would be with configuration.
Hope it helps.

Reply

sudheer November 16, 2016 at 2:31 am

Hi Prateek,

Is the issue resolved? I am also facing same issue.

Reply

Leave a Comment

Previous post:

Next post: