Author Archives: Manikandan Surendren

About Manikandan Surendren

A PeopleSoft Techno-functional Consultant. An engineering graduate in Computer Science. Technology Enthusiast. Movie freak. Gadget geek.

Delete PS Queries assigned to a User

Quick post after a very long time… 🙂 Here’s a code snippet that you can use to Delete PS Queries that are assigned to a particular user. Hope this helps! 🙂   Advertisements

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

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

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