Instructions for Cloning a Database

This page has moved.  Please update your links:
http://psst0101.digitaleagle.net/2010/04/14/instructions-for-cloning-a-database/

In an OTN Discussion Thread, I saw that Nicholas Gasparotto pointed out a document with instructions on cloning PeopleSoft instances.

The document is ID #643499.1 on support.oracle.com.  You can find it by pasting the document ID in the search box on the upper right-hand corner just after you login.

The information seemed like it had some great pointers, and if you haven’t already seen it, you might want to read through the steps to make sure you are taking all these things into account.  On the other hand, I think it is very important to keep a step by step list of tasks for your particular system that you keep up to date.  You will probably have specific things that you have to do for your environment that are unique to your installation.  For example, if you are cloning to a test environment, what about blanking out the email addresses so that test emails don’t get sent out as production emails.  Also, some people put a special message in the heading of the test instances so that it is obvious when you are in Test versus Production.

Thanks, Nicholas for the pointer — this is something I want to keep handy.

New Version in PeopleSoft

This page has moved.  Please update your links:
http://psst0101.digitaleagle.net/2010/04/08/new-version-in-peoplesoft/

I came across a couple of links regarding newer versions of PeopleSoft.

The first live version of HCM9.1 is Ricoh Electronics.  Sounds exciting — I am ready for a project like that 🙂

I also saw that Oracle is requesting feedback and stories on implementing PeopleTools 8.50.  I have my hands in that a little, but I wish I had more to report.

Record Type Values

This page has moved.  Please update your links:
http://psst0101.digitaleagle.net/2010/04/07/record-type-values/

Here are the values for the RECTYPE field in the table that stores the information about the records in PeopleSoft: PSRECDEFN.  Here are what the values mean:

• 0 = SQL Table
• 1 = SQL View
• 2 = Work Record
• 3 = Subrecord
• 5 = Dynamic View
• 6 = Query View
• 7 = Temp Table

For example, you can do something like this to find all the tables that have the OPRID field:

SELECT A.RECNAME
FROM PSRECDEFN A, PSRECFIELDALL B
WHERE A.RECNAME = B.RECNAME
AND A.RECTYPE = 0
AND B.FIELDNAME = 'OPRID'

See the PeopleTools Tables for more information.