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.
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:
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:
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.
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