Category Archives: Oracle

Workaround for Retaining Row Height in RTF Output Using Oracle BI Publisher

Generating PDF files using Oracle BI Publisher is pretty straightforward. If you have tables in your RTF template, and if the rows have a specific height and width, the PDF output would have exactly the same properties. But, that isn’t the case … Continue reading

Posted in Code, Oracle, PeopleSoft | Tagged , , , , , | Leave a comment

SpreadSheet Journal Import in PeopleSoft – Solving User ID Issues – Excel 2016

We’ve been using the JRNL1.xls file along with JRNLMACRO.xla file for PeopleTools 8.53, to import Journals into PeopleSoft FSCM 9.1 – all with lower versions of Excel. However, with Excel 2016 installed on their workstations, users thought they could start … Continue reading

Posted in Code, Oracle, PeopleSoft | Tagged , , , , | Leave a comment

CopyURL Icon Missing in PeopleTools 8.54

Have you seen this icon on the top right corner of a PeopleSoft page? If you haven’t, this icon is used to copy the current URL to the clipboard – which is controlled via Component properties. For PeopleTools instances before 8.52, this … Continue reading

Posted in Oracle, Uncategorized | Tagged , , , | Leave a comment

SFTP Issues with PutAttachment & GetAttachment PeopleCode

Hey everyone! Happy new year! It’s been a while since I had blogged – here’s an interesting issue that I worked on. I have an AE process that uses PutAttachment and GetAttachment functions to upload a file to an SFTP server. … Continue reading

Posted in Code, Oracle, PeopleSoft | Tagged , , , | Leave a comment

PS Query Statistics

All, Here’s a quick code snippet that you can run to get details on how many times a PS Query has been run, the most recent date time it was run and so on –  the table to use is PSQRYSTATS. … Continue reading

Posted in Code, Oracle, PeopleSoft, Uncategorized | Tagged , , | Leave a comment

Excel to CI utility not working in Excel 2016

The Excel to CI utility that comes with PeopleSoft is very useful when it comes to loading multiple rows of data from an Excel template onto PeopleSoft. This seems to have been working fine with Excel 2007/2010, but failed with … Continue reading

Posted in Code, Operating System, Oracle, PeopleSoft, Software | Tagged , , , , , , , | 14 Comments

Resolving Planned Exit Date cannot be before Job Effective Date. (1000,875) Error in PeopleSoft HCM 9.1

Here’s an error that I spent some time debugging when trying to insert a new row in the JOB component with the Expected End Date field (available in the JOB component, on the first tab, at the bottom left) populated. If the new … Continue reading

Posted in Code, Oracle, PeopleSoft, PeopleSoft HCM | Tagged , , , , | Leave a comment