Although you typically don’t want to do this, let’s say you set up a GLBU in a non-production environment that really shouldn’t be there. Here is some SQL to get rid of the GLBU. Other ideas would be to enable BU security and restrict access to the GLBU’s or just manage them through the Open/Closed periods control, but this should get them out of everyone’s prompt list.

My hope is that SOMEDAY Oracle / PeopleSoft will allow for the INACTIVATION of GLBU’s, but that’s been a feature request for what seems like ever. Don’t hold your breath.

Note: replace US001 with your business unit(s). Also, this is valid as of PeopleSoft Financials v9.1, Tools 8.52.

Need help to sort using XLATLONGNAME. Currently we have a search record that returns results in a grid (on the search page) Results are displayed in 4 columns. One of the columns has a translate value. So the sort is based on the translate value. We want it to be by the XLATLONGNAME. Is that possible.

In every GL implementation I’ve been involved with, auditors or managers always ask for the ability to audit who posted their own journal entries. Unfortunately PeopleSoft doesn’t provide the means to do this very easily, so I’ve written a couple of queries that you can use to build a report or a view that satisfies this requirement.

The first query is only valid if you’ve disallowed users from On-Demand Posting journals (the “Journal Post” option in the drop-down box on the JE Lines screen). If you disable this process, users have to utilize the batch journal post process. Here is the SQL: