Find Size of PeopleSoft Tables and indexes [SQL]

What is the biggest pain for PeopleSoft Admins/DBA or any PeopleSoft consultant supporting the application? That’s when performance of PeopleSoft application is really sluggish. There are hundreds of things that could go wrong and one of those is directly related to size of your PeopleSoft database. PeopleSoft database consists of PeopleSoft Tables, indexes and few other objects […]

Continue reading
1

PeopleSoft Jobs – PeopleSoft Interview Questions Set # 01

Looking for a PeopleSoft job? We’re here to help. We’ve compiled a huge database of PeopleSoft interview questions, which will help you sail through any interview for PeopleSoft jobs. The questions in this and other posts on “PeopleSoft Interview Questions” are good to know irrespective of whether you’re looking for a PeopleSoft developer jobs, PeopleSoft […]

Continue reading

New Features in PeopleTools 8.57

This post includes concise information about the new features in PeopleTools 8.57. We will post about these features in detail in other posts for PeopleTools 8.57. Below is based on comparison of features between PeopleTools 8.56 and PeopleTools 8.57.   Quick Navigation Application DesignerApplication EngineBI PublisherIntegration BrokerPeopleCodePeopleSoft Deployment PackagesFluid User InterfacePivot GridPortal TechnologyProcess SchedulerSearchSecurity AdministrationSystem […]

Continue reading

PeopleTools 8.57 Highlights [VIDEO]

Oracle recently released highlight video for PeopleTools 8.57. At first PT8.57 will be available for customers on Oracle Cloud. Below is the video that was published on Oracle’s Youtube Channel. Let us know in the comments section what do you think about these new features.

Continue reading

WARNING: LLE Configuration discovered! Note that LLE has been deprecated. You should upgrade to SSL to secure network links

If you’re working with one of the latest versions of PeopleTools, it is likely that you’d have observed this warning in the appserver Tuxedo log (TUXLOG.mmddyy) and Weblogic logs (like PIA_weblogic.log): WARNING: LLE Configuration discovered! Note that LLE has been deprecated. You should upgrade to SSL to secure network links It is essentially a warning message indicating […]

Continue reading

SQL to find PeopleSoft portal objects hidden from navigation

You can hide PeopleSoft portal objects (e.g. content reference) from PeopleSoft Navigation. This can be done by navigating to ‘Structure and Content’ and selecting  the checkbox ‘Hide from portal navigation’. Navigate to PeopleTools > Portal > Structure and Content  Incase you don’t have access to this page to view the configuration, you can check this […]

Continue reading

PTPSQLRT – Error Encountered

After PeopleTools Upgrade, you need to compile Cobol programs and the entire process becomes trickier if you have custom Cobols, or if you use a custom compile script instead of the usual process laid out by Oracle and MicroFocus. Due to this it is pretty common to face Cobol issues post-PeopleTools upgrade. In this article, […]

Continue reading

List of PUM Tables

PeopleSoft Update Manager or PUM has become part of daily life of PeopleSoft consultants and so has the task of troubleshooting issues related to PUM. While troubleshooting an issue related to PUM, I had the need to look at some PUM tables and felt that you may also have a need for the same. Hence, […]

Continue reading

How to Change Upgrade Options in Change Assistant

When performing upgrades using Change Assistant, most of the tasks, which require manual input are taken care by the Change Assistant itself. For example, when migrating a project or when copying a project manually using AppDesigner, you need to manually take care of the Copy and General Options. It is not the case when using […]

Continue reading

ORA-00997: illegal use of LONG datatype

During PeopleTools upgrade or PeopleSoft application upgrade, you may get an Oracle error: ORA-00997: illegal use of LONG datatype. This post will walk you through the steps to workaround and resolve the error. I encountered this error during PTools upgrade and based on the symptoms, it looks like you may face this error in PeopleSoft application […]

Continue reading

How to Verify if PeopleTools Install was Unicode or Non-Unicode

When you install PeopleTools, you’re asked whether the database is Unicode or Non-Unicode. Many-a-times, people make an incorrect selection because of incorrect information they had (I’ve heard comments like “I thought the database is Unicode but it turned out that production database was created as Unicode but the development database was created as Non-Unicode.” There […]

Continue reading

Database Setup Error – Character Length Semantics is not Enabled

During installation of PeopleTools with Oracle database, there is a common error, which occurs during the step of Database Setup. This error is Character Length Semantics (CLS) not Enabled. Character Length Semantics (CLS) is not enabled error occurs when you select the type of database as Unicode and then you’re prompted to select the type of PeopleSoft […]

Continue reading

ORA-60019: Creating initial extent of size 14 in tablespace of extent size 13

During PeopleTools upgrade, there is a step to convert LONG datatypes to CLOB and BLOB. When using Oracle database, you may get this error: ORA-60019: Creatin g initial extent of size 14 in tablespace of extent size 13 The numbers associated with the extend size may change according to the tablespace involved in the DDL statement […]

Continue reading
1 2 3 22