This page has moved. Please update your links:Just a quick note: I added a few tables to the PeopleTools Tables list:
SQL Definitions
I also updated the Application Engine section with some links to related posts.
This page has moved. Please update your links:Here are the values for the AE_STMT_TYPE field. This is useful if you are looking for an Application Engine with a certain type of action.
AE_STMT_TYPE:
This page has moved. Please update your links:I found this great link the other day about good habits for consultants. Doing some Googling, I was able to build a quick list of posts about habits for consultants:
Here is another good tid-bit for consultants: 7 greatest challenges
In the past, I found some good jokes about consultants, but the links were broken. Here are some more:
This page has moved. Please update your links:Here is some SQL that lists the Log Message actions in Application Programs:
SELECT A.AE_APPLID, A.AE_SECTION, A.AE_STEP,
M.AE_MESSAGE_PARMS, S.MESSAGE_SET_NBR, S.MESSAGE_NBR FROM
PSAESTMTDEFN A, PSAESTEPMSGDEFN M, PSAESTEPDEFN S
WHERE A.AE_APPLID = M.AE_APPLID
AND A.AE_APPLID = S.AE_APPLID
AND A.AE_SECTION = M.AE_SECTION
AND A.AE_SECTION = S.AE_SECTION
AND A.MARKET = M.MARKET
AND A.MARKET = S.MARKET
AND A.DBTYPE = M.DBTYPE
AND A.DBTYPE = S.DBTYPE
AND A.EFFDT = M.EFFDT
AND A.EFFDT = S.EFFDT
AND A.AE_STEP = M.AE_STEP
AND A.AE_STEP = S.AE_STEP
AND A.AE_STMT_TYPE = ‘M’
This is a continuation of my virtual PeopleSoft installation. In this step, we will discuss how to install the PeopleTools home filesystem. To see the complete list of steps, click here. Read the rest of this entry »
I had an error with data mover:
[pshr@localhost ~]$ psdmtx -CT ORACLE -CD HRDMO -CO SYSADM -CP SYSADM -CI PEOPLE -CW PEOP1E -FP ~/test.dms
PeopleTools 8.49 - Data Mover
Copyright (c) 2008 PeopleSoft, Inc.
All Rights Reserved
dlopen in libpscompat failed for ‘libpsora.so’: libclntsh.so.9.0: cannot open shared object file: No such file or directory
PSDMTX Error: signon
Reason: Could not sign on to database HRDMO with user SYSADM.
The fix was to create a symbolic link:
[pshr@localhost ~]$ cd /home/pshr/app/pshr/product/11.1.0/db_1/lib
[pshr@localhost lib]$ ln -s libclntsh.so libclntsh.so.9.0
PSST0101 