Peoplesoft Image 12 is out

1. Addition of recently viewed and favorites – This is a really interesting feature. Core HR user might find it very useful as now they can add all organization contacts to favorites (much like pages) and can quickly refer to them. Manager and employees will find it useful too. This is something I saw in workday for side by side comparison and though limited it was still useful.
2. New job detail view – We can now view employees full org hierarchy when viewing job information page. Clients will find this useful for communication and escalation.
3. Improved company directory page – We all love the split page functionality of related content. Now PeopleSoft has extended that framework to company directory and it looks very modern. New design is a big win for mobile users.

Digital Certificate Installtion

Digital Certificate Installtion

1)      Navigate to webserver /piabin folder (/psoft/XXXX/webserv/XXXX/piabin)

2)      List the certificates to ensure it is already not installed

Server name -/psoft/XXXX/webserv/XXXX/piabin>pskeymanager.sh -list

PeopleSoft PSKeyManager:

Enter your current keystore password [press ENTER to quit]:

password

Warning:  Your keystore password is set to the default password of

          'password'.  This is too obvious and should NEVER be used

          in a production environment.  You can change you keystore

          password via the -changekeystorepassword option.

Keystore type: JKS

Keystore provider: SUN

Your keystore contains 29 entries

3)      Import the certificate

pskeymanager.sh –import

Server name -/psoft/XXXX/webserv/XXXX/piabin>pskeymanager.sh -import

PeopleSoft PSKeyManager:

Enter your current keystore password [press ENTER to quit]:

password

Warning:  Your keystore password is set to the default password of

          'password'.  This is too obvious and should NEVER be used

          in a production environment.  You can change you keystore

          password via the -changekeystorepassword option.

All certificates and keys require an alias that they will be referenced by.

Press ENTER to use local machine name, to exit enter 'QUIT'.

 

Specify an alias for this certificate [server]

Certificate_name

 

Enter the name of the certificate file to import [press ENTER to quit]:

/psoft/a_common/certificates /Certificate_name.cer

Owner: OU=XXXX

Issuer: OU=XXXX

Serial number: 0

Valid from: Tue Jun 29 13:06:20 EDT 2004 until: Thu Jun 29 13:06:20 EDT 2034

Certificate fingerprints:

]

Trust this certificate? [no]:  yes

Certificate was added to keystore

 

4)      Bounce web domain

5)      Test the connection by pinging the node.

XXXX* is domain name

Test your Peoplesoft Skills!

Test your Peoplesoft Skills!

1. ) What are the various layers of PeopleSoft. Explain them.

2. ) Explain the architecture of Peoplesoft.

3. Explain the installation of Peoplesoft.

2.) What are various ways to trace a process / Application in PeopleSoft? Explain them.

3. ) How would you find out how many users are connected to Peoplesoft?

4. Situation-

a.) You want to enable debug mode in Peoplesoft Application Server. How would you do it?
b.) You want to setup file attachment / Report Servers. How would you do that?

5. Explain
a.) Compare reports
b.) Change Assistant

6. Situation: You want to upgrade a Peoplesoft tool. How would you do it?

7. Explain:

a.) REN Server
b.) Environment Hub


8. How do you find app server / Process Scheduler are up and running ?

9. Name a few third party tools / software required for PS to function.

10. Is it OK to install two different Peoplesoft versions on same machine? If yes, how would you do it?

11. Explain One to Many Relationship.

12. If you want to use a new Image in HRMS, where would it be stored?

13. Name the People Tools available for Integration Broker?

14. Explain Integration broker and its components.

16. How would you connect as a tier in Application Designer?

17. Explain BB and BBL.

18. What are the valid values in Peoplecode debugger?

19. Which tree types is NOT supported in the PeopleSoft tree manager?

20. Explain:
a.) Load balancing
b.) Session_timeout parameter
c.) Application Server Clustering
d.) Session_timeout parameter

21. How many Message nodes are possible for a database?

22. Explain the different menu types available.

23. Differentiate between:

a.) RowClass and RowSet
b.) DDDAUDIT and SYSAUDIT


23. What is a connectivity software? Where would youinstall it?

24. What views available in Application Designer project workspace?

26. What are the default values for PSAPPSRV and other servers when application designer starts?

27. Situation:

a.) All the application servers in production environment have reached a threshold. How would you configure a new application server so that the web server is

not bounced?

b.) You are receiving an error "Application server is down at this time" but hthe application server is running. What could be the problem?How will you debug

it?

c.) You want to authenticate a user in Peoplesoft. How would you do that?


28. Explain recycling the server processes.

29. Explain PSSTATUS table. What is its use?

30. Tell us about:
a.) Application server tuning.
b.) Web servers.


31. Situation:

a.) You want to change the system passowrd. How would you do it?
b.) You want a single output by comining two or more queries. How would you do that?

32. You just started a new application server. What problems you may encounter?

33. What are the different types of reports in Peoplesoft?

34. Explain state records. What is its purpose?

35. Which PeopleTools System table is used to track object changes?<br /><br />

36. Which Crystal Report does PeopleSoft Query tool create by default?

37. How would you set up table-sharing in PeopleTools applications?

38. What statuses are available in PeopleSoft Domain Status Menu?

39. Can a PeopleTools 8.4 and a PeopleTools 8.1x database run on the same machine?

40. Which command is valid in both bootstrap and regular mode when operating the data mover?

41. Which events get fired after DB Update?

42. What Search Keys do you use to find Patches and Fixes?

42. What BEA product is used for DB transaction in Peoplesoft? How would you log into the BS mode?

List of peoplesoft Integration Broker Tables

List of peoplesoft Integration Broker Tables:-

– Message Nodes

PSMSGNODEDEFN;
PSNODEDEFNLANG;
PSCONNECTSTRING;
PSNODEURITEXT;
PSNODECONPROP;
PSNODCONPRPLANG;
PSNODELOCKDOWN;
PSNODEPROP;
PSNODEPROPLANG;
PSNODESDOWN;
PSTRUSTNODES;

– Message Channels

PSCHNLDEFN;
PSCHNLDEFNLANG;
PSCHNLNODE;
PSSUBCHNL;

– Message Definitions

PSMSGATTR;
PSMSGDEFN;
PSMSGDEFNLANG;
PSMSGFLDOVR;
PSMSGPARTS;
PSMSGREC;
PSMSGVER;

– App Messaging

PSAPMSGARCHPC;
PSAPMSGARCHPD;
PSAPMSGARCHPH;
PSAPMSGARCHSC;
PSAPMSGARCHTMP;
PSAPMSGPUBATTR;
PSAPMSGPUBCERR;
PSAPMSGPUBCERRP;
PSAPMSGPUBCLOCK;
PSAPMSGPUBCON;
PSAPMSGPUBCSYNC;
PSAPMSGPUBDATA;
PSAPMSGPUBERR;
PSAPMSGPUBERRP;
PSAPMSGPUBHDR;
PSAPMSGPUBINST;
PSAPMSGPUBLOCK;
PSAPMSGPUBSYNC;
PSAPMSGSUBCERR;
PSAPMSGSUBCERRP;
PSAPMSGSUBCLOCK;
PSAPMSGSUBCON;
PSAPMSGSUBCSYNC;
PSAPMSGSUBPRCID;
PSAPMSGXTB;

– Services

PSSERVICE;
PSSERVICELANG;
PSSERVICEOPR;
PSSERVICEUDDI;

– Service Operation

PSOPERATION;
PSOPERATIONLANG;
PSOPERATIONURI;

– Service Operation Routings

PSIBRTNGDEFN;
PSRTNGDFNLANG;
PSRTNGDFNCONPRP;
PSRTNGDFNPROP;
PSRTNGDFNPROPLG;
PSIBRTNGSUBDEFN;
PSRTNGDFNPARM;

– Service Operation Handlers

PSOPRHDLR;
PSOPRHDLRLANG;
PSOPERATIONAC;
PSOPERATIONAE;
PSOPERATIONCI;
PSOPERATIONDMS;

– Service Operation Versions

PSOPRVERDFN;
PSOPRVERDFNLANG;
PSOPRVERDFNPARM;
PSOPRVERQUEPARM;
PSOPRGENRTGPARM;
PSOPRVERDEPLOY;
PSOPRVERDPLYVER;

– Integration Broker Queues

PSQUEUEDEFN;
PSIBQUEUEINST;
PSQUEUEDEFNLANG;
PSQUEUEOVRD;
PSQUEUEPART;

– Integration Group

PSIBGROUPDEFN;
PSIBGROUPLANG;
PSIBSBGROUPLANG;
PSIBSRVGROUP;
PSIBSUBGROUP;
PSIBSUBSRVGROUP;

– Integration Broker Schema

PSIBSCMADFN;
PSIBSCMADATA;

– Integration Broker WSDL

PSIBWSDLDFN;
PSIBWSDLDATA;

– XML Publisher Data Source

PSXPDATASRC;
PSXPDATASRCLNG;
PSXPSCHEMAFLMN;
PSXPSMPLDTMN;

– XML Publisher File Definition

PSFILEDEFN;
PSFILEDATA;

– XML Publisher Report Definition

PSXPRPTDEFN;
PSXPRPTDEFNLNG;
PSXPRPTOUTFMT;
PSXPRPTPROP;
PSXPRPTSCOPEFLD;
PSXPRPTSRCHKEYS;
PSXPRPTTMPL;
PSXPRPTTMPLCTRL;
PSXPRPTVIEWER;

– XML Publisher Template Definition

PSXPTMPLDEFN;
PSXPTMPLDEFNLNG;
PSXPTMPLFILEDEF;
PSXPTMPLTRINFO;

– XML Service Info

PS_XMLSERVICEINFO;

To put all Jobs on hold which are in Queue.

To put all Jobs on hold which are in Queue.

update PSPRCSRQST set runstatus=4 where runstatus=5;
update PSPRCSQUE set runstatus=4 where runstatus=5;

Shell script to Create multiple folders on Unix server

Shell script to Create multiple folders on Unix server:-

Suppose I am giving it name abc.sh...Inside abc.sh is

#!/bin/bash

#exec >

/u01/psoft/XXXX/XXXX/interface/InterfaceDirectory.log 2>&1

set -x

mkdir ./pc123a

mkdir ./pc123a/doc

mkdir ./pc123a/doc/archive

mkdir ./pc1234a/erm

Place it in the place where you want to create folders and execute.
./abc.sh

IPC KILL

IPC KILL

If you get below error while bringing down the services.Then do IPC cleanup.

tmshutdown: internal error: CMDTUX_CAT:764: ERROR: can't attach to BB

==============ERROR!================

Shutdown attempt encountered errors! Check the TUXEDO log for details.

==============ERROR!================

server name.-<PS_HOME>>cd app*

server name.--<PS_HOME>/appserv>ls -la

total 808

…

-rwxr-xr-x   1 XXXX      xxxx         2393 Nov  9  2007 ipcrmall.sh

…

-rwxr-xr-x   1 XXXXX   xxxxx           450 Apr 16 00:27 killipc.sh

…

 

You always need to run IPCRMALL script first

Server name-<PS_HOME>/appserv>ipcrmall.sh XXXX xxxx

Examine killipc.sh and then use it to kill resources

You may examine the resulting file

Server name-<PS_HOME>/appserv>more killipc.sh

#!/bin/ksh

#       

# Run this to remove ipc resources for user XXXXand group xxx

#       

# WARNING:             

#   Removing ipcs resources is not the normal way to shut down a domain.

#   This will not cause data integrity problems, although in rare cases

#   the TUXEDO domain may need to be reconfigured before you can boot it.

#       

ipcrm -q 703046400

ipcrm -q 887041

ipcrm -q 1030443

ipcrm -q 1209647

ipcrm -q 412208

ipcrm -q 394289

ipcrm -q 376370

ipcrm -q 448051

ipcrm -q 564532

ipcrm -q 349493

ipcrm -q 394294

ipcrm -q 349495

ipcrm -q 465976

ipcrm -q 394297

ipcrm -q 349498

ipcrm -q 403259

ipcrm -q 367420

ipcrm -q 349501

ipcrm -q 349502

ipcrm -q 358463

ipcrm -q 349504

ipcrm -q 349505

ipcrm -q 349506

ipcrm -q 349507

ipcrm -q 349508

ipcrm -q 349509

ipcrm -q 349510

ipcrm -q 349511

Then you must run the resulting “KILLIPC” file

Server name-<PS_HOME>/appserv>killipc.sh

ipcrm: msqid(448051): not found

ipcrm: msqid(564532): not found