Monthly Archives: May 2016

Using Colon in an Expression result in PeopleSoft PS Query

Here’s a quick PS Query snippet : If you’ve ever wanted to use a colon in an expression – say something like displaying a colon between HH(hours) and MM(minutes), PeopleSoft PS Query would throw an error – because the Query … Continue reading

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

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