Category Archives: PeopleSoft

PeopleCode MessageBox to display messages

PeopleCode’s MessageBox can be used to display messages on the screen or in a log. It can be used for issuing warnings, indicating lack of information, or to see the value of certain variables while developing. If the code is running on a page, record or component, the message will be displayed on screen, but using it within a process such as an Application Engine, the message will be written in the log file.

Syntax

MessageBox(style, title, catalog_message, number_message_catalog, default_text [,parameters] )

/*We indicate a catalog number and message number which does not exist to display the default message*/

MessageBox(0,””,99999,99999,”Test”);

/* If the message and catalog exist,the description defines for this message is shown*/
/* If the message doesn´t exist, the default message is displayed*/
MessageBox(0,””,30000,1,”Message could not be found”);

/* To display the value of a variable we can use the following statement*/
MessageBox(0,””,99999,99999,”variable1″ | &var1);

 

Checking for changed objects in PeopleSoft by LASTUPDOPRID

If you want to check for objects changed in your PeopleSoft database via sql you can run the statements below to find those objects. This can be quicker than doing a full database compare using Application Designer.

select ACEMODELID,DESCR,lastupddttm,lastupdoprid From PSACEMDLDEFN where lastupddttm > to_date('01012000','ddmmyyyy') and lastupdoprid <> 'PPLSOFT';
select ACTIVITYNAME,' ',lastupddttm,lastupdoprid From PSACTIVITYDEFN where lastupddttm > to_date('01012000','ddmmyyyy') and lastupdoprid <> 'PPLSOFT' ;
select AE_APPLID,DESCR,lastupddttm,lastupdoprid From PSAEAPPLDEFN where lastupddttm > to_date('01012000','ddmmyyyy') and lastupdoprid <> 'PPLSOFT' ;
select AE_APPLID,' ',lastupddttm,lastupdoprid From PSAESECTDEFN where lastupddttm > to_date('01012000','ddmmyyyy') and lastupdoprid <> 'PPLSOFT' ;
select AE_SECTION,' ',lastupddttm,lastupdoprid From PSAESECTDEFN where lastupddttm > to_date('01012000','ddmmyyyy') and lastupdoprid <> 'PPLSOFT' ;
select PSARCH_OBJECT,DESCR,lastupddttm,lastupdoprid From PSARCHOBJDEFN where lastupddttm > to_date('01012000','ddmmyyyy') and lastupdoprid <> 'PPLSOFT' ;
select BCNAME,DESCR,lastupddttm,lastupdoprid From PSBCDEFN where lastupddttm > to_date('01012000','ddmmyyyy') and lastupdoprid <> 'PPLSOFT' ;
select BUSPROCNAME,' ',lastupddttm,lastupdoprid From PSBUSPROCDEFN where lastupddttm > to_date('01012000','ddmmyyyy') and lastupdoprid <> 'PPLSOFT' ;
select CERTALIAS,' ',lastupddttm,lastupdoprid From PSCERTDEFN where lastupddttm > to_date('01012000','ddmmyyyy') and lastupdoprid <> 'PPLSOFT' ;
select CERTTYPE,' ',lastupddttm,lastupdoprid From PSCERTDEFN where lastupddttm > to_date('01012000','ddmmyyyy') and lastupdoprid <> 'PPLSOFT' ;
select CHNLNAME,DESCR,lastupddttm,lastupdoprid From PSCHNLDEFN where lastupddttm > to_date('01012000','ddmmyyyy') and lastupdoprid <> 'PPLSOFT' ;
select CLASSID,' ',lastupddttm,lastupdoprid From PSCLASSDEFN where lastupddttm > to_date('01012000','ddmmyyyy') and lastupdoprid <> 'PPLSOFT' ;
select COLORNAME,' ',lastupddttm,lastupdoprid From PSCOLORDEFN where lastupddttm > to_date('01012000','ddmmyyyy') and lastupdoprid <> 'PPLSOFT' ;
select OPRID,' ',lastupddttm,lastupdoprid From PSCOLORDEFN where lastupddttm > to_date('01012000','ddmmyyyy') and lastupdoprid <> 'PPLSOFT' ;
select CONQRSNAME,DESCR,lastupddttm,lastupdoprid From PSCONQRSDEFN where lastupddttm > to_date('01012000','ddmmyyyy') and lastupdoprid <> 'PPLSOFT' ;
select OPRID,DESCR,lastupddttm,lastupdoprid From PSCONQRSDEFN where lastupddttm > to_date('01012000','ddmmyyyy') and lastupdoprid <> 'PPLSOFT' ;
select ALTCONTNUM,DESCR,lastupddttm,lastupdoprid From PSCONTDEFN where lastupddttm > to_date('01012000','ddmmyyyy') and lastupdoprid <> 'PPLSOFT' ;
select CONTNAME,DESCR,lastupddttm,lastupdoprid From PSCONTDEFN where lastupddttm > to_date('01012000','ddmmyyyy') and lastupdoprid <> 'PPLSOFT' ;
select CONTTYPE,DESCR,lastupddttm,lastupdoprid From PSCONTDEFN where lastupddttm > to_date('01012000','ddmmyyyy') and lastupdoprid <> 'PPLSOFT' ;
select FILEID,' ',lastupddttm,lastupdoprid From PSFILEDEFN where lastupddttm > to_date('01012000','ddmmyyyy') and lastupdoprid <> 'PPLSOFT' ;
select FILEREFNAME,' ',lastupddttm,lastupdoprid From PSFILEREDEFN where lastupddttm > to_date('01012000','ddmmyyyy') and lastupdoprid <> 'PPLSOFT' ;
select FILEREFTYPECODE,' ',lastupddttm,lastupdoprid From PSFILEREDEFN where lastupddttm > to_date('01012000','ddmmyyyy') and lastupdoprid <> 'PPLSOFT' ;
select FLDDEFNNAME,DESCR,lastupddttm,lastupdoprid From PSFLDDEFN where lastupddttm > to_date('01012000','ddmmyyyy') and lastupdoprid <> 'PPLSOFT' ;
select FORMATFAMILY,DESCR,lastupddttm,lastupdoprid From PSFMTDEFN where lastupddttm > to_date('01012000','ddmmyyyy') and lastupdoprid <> 'PPLSOFT' ;
select HOLIDAYNAME,' ',lastupddttm,lastupdoprid From PSHOLIDAYDEFN where lastupddttm > to_date('01012000','ddmmyyyy') and lastupdoprid <> 'PPLSOFT' ;
select EFFDT,DESCR,lastupddttm,lastupdoprid From PSIBRTNGDEFN where lastupddttm > to_date('01012000','ddmmyyyy') and lastupdoprid <> 'PPLSOFT' ;
select ROUTINGDEFNNAME,DESCR,lastupddttm,lastupdoprid From PSIBRTNGDEFN where lastupddttm > to_date('01012000','ddmmyyyy') and lastupdoprid <> 'PPLSOFT' ;
select IMPNAME,' ',lastupddttm,lastupdoprid From PSIMPDEFN where lastupddttm > to_date('01012000','ddmmyyyy') and lastupdoprid <> 'PPLSOFT' ;
select IONAME,IODESCR,lastupddttm,lastupdoprid From PSIODEFN where lastupddttm > to_date('01012000','ddmmyyyy') and lastupdoprid <> 'PPLSOFT' ;
select OPRID,' ',lastupddttm,lastupdoprid From PSJPUPDEFN where lastupddttm > to_date('01012000','ddmmyyyy') and lastupdoprid <> 'PPLSOFT' ;
select PTJPLT_APPNAME,' ',lastupddttm,lastupdoprid From PSJPUPDEFN where lastupddttm > to_date('01012000','ddmmyyyy') and lastupdoprid <> 'PPLSOFT' ;
select PTJPLT_NAME,' ',lastupddttm,lastupdoprid From PSJPUPDEFN where lastupddttm > to_date('01012000','ddmmyyyy') and lastupdoprid <> 'PPLSOFT' ;
select MENUNAME,DESCR,lastupddttm,lastupdoprid From PSMENUDEFN where lastupddttm > to_date('01012000','ddmmyyyy') and lastupdoprid <> 'PPLSOFT' ;
select MOBILEPAGENAME,DESCR,lastupddttm,lastupdoprid From PSMPDEFN where lastupddttm > to_date('01012000','ddmmyyyy') and lastupdoprid <> 'PPLSOFT' ;
select MSGNAME,DESCR,lastupddttm,lastupdoprid From PSMSGDEFN where lastupddttm > to_date('01012000','ddmmyyyy') and lastupdoprid <> 'PPLSOFT' ;
select MSGNODENAME,DESCR,lastupddttm,lastupdoprid From PSMSGNODEDEFN where lastupddttm > to_date('01012000','ddmmyyyy') and lastupdoprid <> 'PPLSOFT' ;
select OPRID,' ',lastupddttm,lastupdoprid From PSOPRDEFN where lastupddttm > to_date('01012000','ddmmyyyy') and lastupdoprid <> 'PPLSOFT' ;
select PACKAGEID,DESCR,lastupddttm,lastupdoprid From PSPACKAGEDEFN where lastupddttm > to_date('01012000','ddmmyyyy') and lastupdoprid <> 'PPLSOFT' ;
select PACKAGEROOT,DESCR,lastupddttm,lastupdoprid From PSPACKAGEDEFN where lastupddttm > to_date('01012000','ddmmyyyy') and lastupdoprid <> 'PPLSOFT' ;
select QUALIFYPATH,DESCR,lastupddttm,lastupdoprid From PSPACKAGEDEFN where lastupddttm > to_date('01012000','ddmmyyyy') and lastupdoprid <> 'PPLSOFT' ;
select PM_SYSTEMID,' ',lastupddttm,lastupdoprid From PSPMSYSDEFN where lastupddttm > to_date('01012000','ddmmyyyy') and lastupdoprid <> 'PPLSOFT' ;
select PNLNAME,DESCR,lastupddttm,lastupdoprid From PSPNLDEFN where lastupddttm > to_date('01012000','ddmmyyyy') and lastupdoprid <> 'PPLSOFT' ;
select MARKET,DESCR,lastupddttm,lastupdoprid From PSPNLGRPDEFN where lastupddttm > to_date('01012000','ddmmyyyy') and lastupdoprid <> 'PPLSOFT' ;
select PNLGRPNAME,DESCR,lastupddttm,lastupdoprid From PSPNLGRPDEFN where lastupddttm > to_date('01012000','ddmmyyyy') and lastupdoprid <> 'PPLSOFT' ;
select PORTAL_NAME,' ',lastupddttm,lastupdoprid From PSPRDMDEFN where lastupddttm > to_date('01012000','ddmmyyyy') and lastupdoprid <> 'PPLSOFT' ;
select PROJECTNAME,PROJECTDESCR,lastupddttm,lastupdoprid From PSPROJECTDEFN where lastupddttm > to_date('01012000','ddmmyyyy') and lastupdoprid <> 'PPLSOFT' ;
select PORTAL_NAME,' ',lastupddttm,lastupdoprid From PSPRSMDEFN where lastupddttm > to_date('01012000','ddmmyyyy') and lastupdoprid <> 'PPLSOFT' ;
select PORTAL_OBJNAME,' ',lastupddttm,lastupdoprid From PSPRSMDEFN where lastupddttm > to_date('01012000','ddmmyyyy') and lastupdoprid <> 'PPLSOFT' ;
select PORTAL_REFTYPE,' ',lastupddttm,lastupdoprid From PSPRSMDEFN where lastupddttm > to_date('01012000','ddmmyyyy') and lastupdoprid <> 'PPLSOFT' ;
select OPRID,' ',lastupddttm,lastupdoprid From PSPRUFDEFN where lastupddttm > to_date('01012000','ddmmyyyy') and lastupdoprid <> 'PPLSOFT' ;
select PORTAL_LABEL,' ',lastupddttm,lastupdoprid From PSPRUFDEFN where lastupddttm > to_date('01012000','ddmmyyyy') and lastupdoprid <> 'PPLSOFT' ;
select PORTAL_NAME,' ',lastupddttm,lastupdoprid From PSPRUFDEFN where lastupddttm > to_date('01012000','ddmmyyyy') and lastupdoprid <> 'PPLSOFT' ;
select PORTAL_REFTYPE,' ',lastupddttm,lastupdoprid From PSPRUFDEFN where lastupddttm > to_date('01012000','ddmmyyyy') and lastupdoprid <> 'PPLSOFT' ;
select OPRID,' ',lastupddttm,lastupdoprid From PSPRUHDEFN where lastupddttm > to_date('01012000','ddmmyyyy') and lastupdoprid <> 'PPLSOFT' ;
select PORTAL_NAME,' ',lastupddttm,lastupdoprid From PSPRUHDEFN where lastupddttm > to_date('01012000','ddmmyyyy') and lastupdoprid <> 'PPLSOFT' ;
select OPRID,DESCR,lastupddttm,lastupdoprid From PSQRYDEFN where lastupddttm > to_date('01012000','ddmmyyyy') and lastupdoprid <> 'PPLSOFT' ;
select QRYNAME,DESCR,lastupddttm,lastupdoprid From PSQRYDEFN where lastupddttm > to_date('01012000','ddmmyyyy') and lastupdoprid <> 'PPLSOFT' ;
select QUEUENAME,DESCR,lastupddttm,lastupdoprid From PSQUEUEDEFN where lastupddttm > to_date('01012000','ddmmyyyy') and lastupdoprid <> 'PPLSOFT' ;
select RECNAME,RECDESCR,lastupddttm,lastupdoprid From PSRECDEFN where lastupddttm > to_date('01012000','ddmmyyyy') and lastupdoprid <> 'PPLSOFT' ;
select ROLENAME,DESCR,lastupddttm,lastupdoprid From PSROLEDEFN where lastupddttm > to_date('01012000','ddmmyyyy') and lastupdoprid <> 'PPLSOFT' ;
select SQLID,' ',lastupddttm,lastupdoprid From PSSQLDEFN where lastupddttm > to_date('01012000','ddmmyyyy') and lastupdoprid <> 'PPLSOFT' ;
select SQLTYPE,' ',lastupddttm,lastupdoprid From PSSQLDEFN where lastupddttm > to_date('01012000','ddmmyyyy') and lastupdoprid <> 'PPLSOFT' ;
select STYLENAME,' ',lastupddttm,lastupdoprid From PSSTYLEDEFN where lastupddttm > to_date('01012000','ddmmyyyy') and lastupdoprid <> 'PPLSOFT' ;
select STYLESHEETNAME,DESCR,lastupddttm,lastupdoprid From PSSTYLSHEETDEFN where lastupddttm > to_date('01012000','ddmmyyyy') and lastupdoprid <> 'PPLSOFT' ;
select MSGNAME,' ',lastupddttm,lastupdoprid From PSSUBDEFN where lastupddttm > to_date('01012000','ddmmyyyy') and lastupdoprid <> 'PPLSOFT' ;
select SUBNAME,' ',lastupddttm,lastupdoprid From PSSUBDEFN where lastupddttm > to_date('01012000','ddmmyyyy') and lastupdoprid <> 'PPLSOFT' ;
select OPRID,' ',lastupddttm,lastupdoprid From PSTOOLBARDEFN where lastupddttm > to_date('01012000','ddmmyyyy') and lastupdoprid <> 'PPLSOFT' ;
select EFFDT,DESCR,lastupddttm,lastupdoprid From PSTREEDEFN where lastupddttm > to_date('01012000','ddmmyyyy') and lastupdoprid <> 'PPLSOFT' ;
select SETCNTRLVALUE,DESCR,lastupddttm,lastupdoprid From PSTREEDEFN where lastupddttm > to_date('01012000','ddmmyyyy') and lastupdoprid <> 'PPLSOFT' ;
select SETID,DESCR,lastupddttm,lastupdoprid From PSTREEDEFN where lastupddttm > to_date('01012000','ddmmyyyy') and lastupdoprid <> 'PPLSOFT' ;
select TREE_NAME,DESCR,lastupddttm,lastupdoprid From PSTREEDEFN where lastupddttm > to_date('01012000','ddmmyyyy') and lastupdoprid <> 'PPLSOFT' ;
select FILEREFTYPECODE,' ',lastupddttm,lastupdoprid From PSTYPECODEDEFN where lastupddttm > to_date('01012000','ddmmyyyy') and lastupdoprid <> 'PPLSOFT' ;
select URL_ID,DESCR,lastupddttm,lastupdoprid From PSURLDEFN where lastupddttm > to_date('01012000','ddmmyyyy') and lastupdoprid <> 'PPLSOFT' ;
select OPTN_CATEGORY_LVL,DESCR,lastupddttm,lastupdoprid From PSUSEROPTNDEFN where lastupddttm > to_date('01012000','ddmmyyyy') and lastupdoprid <> 'PPLSOFT' ;
select USEROPTN,DESCR,lastupddttm,lastupdoprid From PSUSEROPTNDEFN where lastupddttm > to_date('01012000','ddmmyyyy') and lastupdoprid <> 'PPLSOFT' ;
select OPRID,' ',lastupddttm,lastupdoprid From PSWSRPCPHDEFN where lastupddttm > to_date('01012000','ddmmyyyy') and lastupdoprid <> 'PPLSOFT' ;
select PTWSRPPORTLETNAME,' ',lastupddttm,lastupdoprid From PSWSRPCPHDEFN where lastupddttm > to_date('01012000','ddmmyyyy') and lastupdoprid <> 'PPLSOFT' ;
select PTWSRPPRODUCERNAME,' ',lastupddttm,lastupdoprid From PSWSRPCPHDEFN where lastupddttm > to_date('01012000','ddmmyyyy') and lastupdoprid <> 'PPLSOFT' ;
select PTWSRPPORTLETNAME,PTWSRP_PLTDESCR,lastupddttm,lastupdoprid From PSWSRPPLTDEFN where lastupddttm > to_date('01012000','ddmmyyyy') and lastupdoprid <> 'PPLSOFT' ;
select PTWSRPPRODUCERNAME,PTWSRP_PLTDESCR,lastupddttm,lastupdoprid From PSWSRPPLTDEFN where lastupddttm > to_date('01012000','ddmmyyyy') and lastupdoprid <> 'PPLSOFT' ;
select PTWSRPPRODUCERNAME,' ',lastupddttm,lastupdoprid From PSWSRPPRDDEFN where lastupddttm > to_date('01012000','ddmmyyyy') and lastupdoprid <> 'PPLSOFT' ;
select REPORT_DEFN_ID,DESCR,lastupddttm,lastupdoprid From PSXPRPTDEFN where lastupddttm > to_date('01012000','ddmmyyyy') and lastupdoprid <> 'PPLSOFT' ;
select TMPLDEFN_ID,DESCR,lastupddttm,lastupdoprid From PSXPTMPLDEFN where lastupddttm > to_date('01012000','ddmmyyyy') and lastupdoprid <> 'PPLSOFT' ;

MVPRDEXP.DMS is your friend…

In the scripts directory of your PS_HOME you will find core tables for many PeopleTools objects. Use it as a reference.

MVPRDEXP.DMS

Example…

— PORTAL REGISTRY USER FAVORITES
EXPORT PSPRUFDEFN;

— PORTAL USER REGISTRY HOMEPAGE
EXPORT PSPRUHDEFN;
EXPORT PSPRUHTAB;
EXPORT PSPRUHTABPGLT;

PeopleSoft definitions that will NOT copy to a file…

There are two PeopleSoft definitions that will NOT copy to a file…
Message Catalog Entries
Roles

If you cant copy from database to database then you need to write a DMS script to move these…

--ROLES
EXPORT PSROLEDEFN;
EXPORT PSROLEDEFNLANG;
EXPORT PSROLECANGRANT;
EXPORT PSROLECLASS;

-- MESSAGES
EXPORT PSMSGSETDEFN;
EXPORT PSMSGSETLANG;
EXPORT PSMSGCATDEFN;
EXPORT PSMSGCATLANG;

Add JavaScript to a PeopleSoft Page

Add JavaScript to an HTML Area on a PeopleSoft Page to manipulate objects.
This hides a button till another object on the page appears…


I also added a group box around another object so it would give a unique id to a dynamic object. (win0divHRS_CE_LNK_WRK_PAGE_9)

Enable SMTP trace in PeopleSoft

When you need to enable trace change this in your appserver configuration (psappserv.cfg) or batch server Configuration (psprcs.cfg)

SMTPTrace=1
;1 means enabled, 0 – Disabled.
This setting is dynamic and does not require reboot of the Server. Once turned on, it will generate Trace file SMTP.LOG in LOGS Folder under

$PS_HOME\appserv\domain_name\logs\SMTP.LOG

$PS_HOME\appserv\prcs\domain_name\logs\SMTP.LOG


PeopleSoft Application Engine Trace Options

Suggested trace example…
-TRACE 391 -TOOLSTRACESQL 143 -TOOLSTRACEPC 1996

-TRACE 7 -TOOLSTRACEPC 4044

PeopleTools > Process Scheduler > Processes (Override Options – Parameter List)

1. Application Engine Trace File

Follow the steps listed below to generate an Application Engine trace file:
1. Go to PeopleTools – Process Scheduler – Processes
2. Open Process Name = -enter application engine name here-
3. Click on Override Options tab
4. Set Parameter List = Append
5. In Parameters field enter: -TRACE 391 -TOOLSTRACESQL 143 -TOOLSTRACEPC 1996
6. Save page

Sum up the options below to the level you desire.

Application Engine tracing:
-TRACE 

1 Initiates the Application Engine Step trace
2 Initiates the Application Engine SQL trace
4 Trace dedicated Temp Table Allocation to AET file
128 Initiates the Statement Timings trace to file, which is similar to the COBOL timings trace to file
256 Initiates the PeopleCode Detail to the file for the Timings trace
1024 Initiates the Statement Timings trace, but, instead of writing to the trace file, this trace stores the results in the following tables: PS_BAT_TIMINGS_LOG and PS_BAT_TIMINGS_DTL
2048 Adding this value requests a database optimizer trace file
4096 Requests a database optimizer to be inserted in the Explain Plan Table of the current database
8192 This value sets a trace for Integration Broker transform programs

SQL tracing:
-TOOLSTRACESQL

1 Trace SQL statements
2 Trace SQL statement variables
4 Trace SQL connect, disconnect, commit and rollback
8 Show fetched rows (indicates that it occurred, not data)
16 Show all other API calls except ssb
32 Set Select Buffers (identifies the attributes of columns to be selected).
64 Show database API specific calls
128 Show COBOL statement timings
256 Show Sybase bind information
512 Show Sybase fetch information
4096 Show manager information
8192 Show Mapcore information

PeopleCode tracing:
-TOOLSTRACEPC

1 Trace instructions
2 List the program
4 Show assignments to variables
8 Show fetched values
16 Show stack
64 Trace start of programs
128 Trace external function calls
256 Trace internal function calls
512 Show parameter values
1024 Show function return values
2048 Trace each statement in program