Optional Prompting in PS Query

If you don't fill in a prompt when running a PS Query, the query usually returns no row. If you want the query to still fetch data (ignoring the condition), this post is for you.

PeopleSoft Journal Import Error – User-defined type not defined

The Journal Import Spreadsheet is a handy tool that helps you import large number of Journals easily. This post can help you with an uncommon error, User-defined type not defined, that you may encounter while using this utility.