PeopleSoft Basics | PeopleSoft Tutorial - Part 13

Archive

Category Archives for "PeopleSoft Basics"
1

SQL to Retrieve Navigation of a Process in PeopleSoft

Following SQL is used to find out all Processes Defined in PeopleSoft System. Additionally this query also provides Components attached with Process Definition and Navigation from where this process can be executed. This query is tested on Oracle platform. Select S.prcsname,S.prcstype, S.pnlgrpname,N.navigation From (Select A.prcsname, A.prcstype,B.pnlgrpname From PS_PRCSDEFN A, PS_PRCSDEFNPNL B Where A.prcsname = B.prcsname) […]

Continue reading
1

Understanding PeopleSoft Architecture

This article is specially for new PeopleSoft database administrators and PeopleSoft administrators, who for the most of time try to figure out how to find the details regarding a PeopleSoft application. PeopleSoft application consists of database server, application server and PeopleSoft webserver. Batch server is also present for reporting purposes. PeopleSoft is a web based application […]

Continue reading
1 11 12 13
>