Tag Archive

Tag Archives for " PeopleTools "

PeopleSoft Master Notes for Common Issues

PeopleSoft is such a huge application with so many interconnected pieces that PeopleSoft consultants always find themselves fixing issues related to one or the other tool in PeopleSoft. Most of us usually head over to Oracle support and then start searching for the issues. Sometimes it may take lot of time to find the exact […]

Continue reading

PeopleTools 8.54 : New Features in PeopleSoft Application Designer

The most important tool for any PeopleSoft Developer is PeopleSoft Application Designer and any enhancements or update to this tool impacts PeopleSoft Developers. Oracle does deliver few changes to Application Designer features every now and then with PeopleTools releases. With release of PeopleTools 8.54, Oracle has again added few more features to this already robust […]

Continue reading

Navigation Pages Missing Styles, Background Colors and Incorrect Formatting after PeopleTools Only Upgrade

After PeopleTools 8.53 upgrade, I came across this rather annoying issue where some of the pages were not showing up properly and the background colors as well as formatting appeared to be absent in the Navigation pages that appears (see the picture below). Initial thought was that the cache is not able to build properly […]

Continue reading
3

How to Install Oracle 32 bit Client on Windows 64 bit and avoid the error INS-30131

You may receive the following error when trying to install the Oracle Client 32-bit and 64-bit on the same Microsoft Windows x64 (64-bit) machine: Installation of Oracle12c Release 1 Client 32-bit Failed: “[INS-30131] Initial Setup Required For The Execution Of Installer Validations Failed. You may receive this error when trying to install the  Oracle Client 32-bit […]

Continue reading

E-ORA SYS.DBMS_STATS has errors ORA-06508: PL/SQL: could not find program unit being called: SYS.DBMS_STATS

While doing PeopleTools upgrade via Change Assistant, you may encounter this error: E-ORA SYS.DBMS_STATS has errors ORA-06508: PL/SQL: could not find program unit being called: SYS.DBMS_STATS The error message is indicative enough to suggest that there are invalid dba_objects. To make sure, run the below command: SQL> select owner, object_name, object_type, status from dba_objects where […]

Continue reading

REL851unDBTSFIX Script Failed – PeopleTools Upgrade Bug

When upgrading database from PeopleTools 8.50 to PeopleTools 8.53.06, you’re likely to see a situation where the step “Updating PeopleTools System Tables” fails. The failure is while running REL851unDBFIX.sql. Subsequently the error is encountered for REL852unDBFIX.sql and REL853unDBFIX.sql as well. The REL851UNDBTSFIX.log will show that all the SQL statements were executed and no errors were […]

Continue reading
1

PeopleTools 8.54 Will Support 64-bit PeopleTools Development Client

PeopleSoft is supported on various 64-bit platforms but PeopleSoft development tools (eg. App Designer, Datamover) are still 32-bit. Currently, if your PeopleSoft application is installed using Oracle 64-bit database and you’re using Oracle 64-bit client to connect to database, you won’t be able to log into PeopleSoft Application Designer or Data Mover. Note: Application Server […]

Continue reading
1

This Oracle 12C Setting Can Jeopardize Your PeopleSoft Installation

Oracle Database 12C is supported with PeopleTools 8.53 but there is one feature in Oracle 12C that can jeopardize your PeopleSoft Installation. Recently while installing PeopleSoft 9.2 with PeopleTools 8.53 using Oracle 12C as database, I was struck at running initial database creation scripts like dbowner.sql and psroles.sql. Scripts weren’t creating users and roles as […]

Continue reading

Integration Gateway: PeopleSoftTargetConnector – username ( ) and password (XXXXX) incorrect

This error is common in several PeopleTools releases and we will show you how to troubleshoot the error “Integration Gateway: PeopleSoftTargetConnector – username ( ) and password (XXXXX) incorrect.” on Ping Node attempt. I encountered the issue in PeopleTools 8.53.06 While the error is descriptive enough, it can tend to be confusing at times and […]

Continue reading

Evolution of PS_HOME

1. PTools 8.49 and earlier – A single PS_HOME In PeopleTools 8.49.x and previous versions, there used to be a single home – PS_HOME, which contained the configuration files, source files, executables, customized code and everything else. It was just a single home for all the files delivered by PeopleSoft. With PeopleSoft 8.50.x version, we […]

Continue reading