Archive

Category Archives for "PeopleSoft Basics"
3

PeopleTools 8.54: 64-bit Development Client is Here

You might already know that PeopleTools 8.53 development clients such as application designer, data mover were 32 bit applications and needed 32-bit Oracle client to connect to Oracle database. Starting with PeopleTools 8.54, PeopleTools development client is now a 64-bit application and you won’t need to install Oracle 32 bit client for PeopleTools.  Having a […]

Continue reading
2

PeopleTools 8.54: Developing PeopleSoft Fluid User Interface Applications

PeopleSoft Fluid User Interface is one of the most significant feature in PeopleTools 8.54. It gives flexibility to a developer to dynamically change the PeopleSoft applications display based on user’s device type. As a developer you would still be using PeopleSoft Application Designer to create Fluid pages but there will be some difference when it […]

Continue reading
15

PeopleTools 8.54: How to Install PeopleTools 8.54

Oracle finally released the latest version of PeopleTools i.e. PeopleTools 8.54 on 11 July 2014. PeopleTools 8.54 has some really nice features which we will explore in upcoming posts. This post is to help you install PeopleTools 8.54 on Windows Platform. Step1: Download PeopleTools 8.54 Setup files from Oracle edelivery site (edelivery.oracle.com). PeopleTools 8.54 setup […]

Continue reading

Steps for a PeopleSoft Installation

PeopleSoft installations need to be done in a certain order to minimize the issues, which arise with installation. Following are the sequence of steps you need to go through for PeopleSoft installation. These steps are generic and give you an idea of the overall process irrespective of the software, hardware and PeopleSoft/PeopleTools version you decide […]

Continue reading

How to Get Latest Alerts on PeopleSoft Update Manager

PeopleSoft Update Manager is the new lifecycle management process for PeopleSoft 9.2 customers to use for all their application maintenance needs. PeopleSoft Update Manager will be of limited help if you do not stay current with the latest updates released by Oracle. This article highlights the process you should follow to stay current with any […]

Continue reading

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
2

What is PeopleSoft Update Manager (PUM)?

PeopleSoft Update Manager (PUM) is a new Lifecycle Management process aimed to help customers stay current on application patching and lower the cost of application maintenance. It’s only available for PeopleSoft 9.2 applications, so if your PeopleSoft application is currently not on 9.2 version, you would need to upgrade to utilize this feature. How does […]

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