Category Archives: PeopleSoft

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

Populating Tree Selector Tables in PeopleSoft

Hello All, If you’re using Tree Selector tables for Department, Business Unit security, once you make changes to the Tree , the tree values in tree selector tables are deleted – while you can use nVision to populate the Tree Selector … Continue reading

Posted in Code, PeopleSoft, PeopleSoft HCM | 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

BI Publisher Report runs to No Success -End of Memory Error

Hi all, Here’s an issue we had encountered while running a BI Publisher report – that was supposed to be generated via an Application Engine. Provided below is the error message that was written to the log file. Caused by: java.io.UTFDataFormatException: … Continue reading

Posted in Code, 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