PeopleTools Tables Updated

This page has moved.  Please update your links:
http://psst0101.digitaleagle.net/2008/11/21/peopletools-tables-updated/

Just a quick note: I added a few tables to the PeopleTools Tables list:

SQL Definitions

  • PSSQLDEFN — header record; last update time, etc.
  • PSSQLTEXTDEFN — stores actual text in the SQL definition

I also updated the Application Engine section with some links to related posts.

Advertisements

App Engine Action Types (AE_STMT_TYPE)

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:

  • H = Do When
  • N = Do Until
  • C = Call Section
  • W = Do While
  • X = XSLT
  • M = Log Message
  • S = SQL
  • P = PeopleCode
  • D = DoSelect

Good Habits for Consultants

This page has moved.  Please update your links:
http://psst0101.digitaleagle.net/2008/11/20/good-habits-for-consultants/

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:

Log Messages in Application Engine

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’

Step By Step Virtual PS Install: PeopleTools Install

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 »

libclntsh error


This page has moved. Please update your links:
http://psst0101.digitaleagle.net/2008/11/04/libclntsh-error/

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

Resources

Unable to boot the apserver… Need to install 32 bit library for window to fix the Missing or invalid version of SQL library libpsora