Archive

Category Archives for "PeopleSoft Basics"

PeopleSoft Financials – Commonly Used Tables

PeopleSoft Financials – Commonly Used Tables VENDORS VENDOR             Vendor Header Table – Main Vendor table which contains many important fields related to the vendor. (i.e. Vendor ID, Name, Address) VENDOR_LOC         Vendor Location – Location Information for each Vendor VENDOR_ADDR         Vendor Address – Address Information for each Vendor VENDOR_WTHD_JUR […]

Continue reading
1

Complete List of PeopleSoft ELM 9.1 Tables

Here is the complete list of PeopleSoft ELM 9.1 tables along with brief description. Recname LM_ACCTG_LN – ELM Account Line LM_ACMDTN_TBL – Accommodation Setup Table LM_ACT – Activity Table LM_ACT_ATCH – Activity Attachments LM_ACT_ATCH_VW – Activity Attachment View LM_ACT_CI_UI_VW – Activity CI UI View LM_ACT_CI_VW – Activity CI View LM_ACT_CI_VW3 – Activity CI View LM_ACT_COST […]

Continue reading

PeopleTools 8.53 – Understanding Installation Locations

From PeopleTools 8.5 onwards, the installation locations have been split up to make it easier to perform upgrades and provide maintenance. PeopleTools 8.53 has 5 Installation Locations, which are as mentioned below: PS_HOME PS_APP_HOME PS_CFG_HOME PS_CUST_HOME PIA_HOME As you proceed through the PeopleSoft PeopleTools installation process, you are asked to specify several installation locations. This […]

Continue reading
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