ORA-28000: the account is locked - PeopleSoft
Hey everyone, Just a small PeopleSoft issue I ran into while running an SQR: For some reason the sysadm account had been locked, thankfully there’s a fairly easy fix:…
Read postPeopleSoft
View Last Query Executed - Oracle
Hey all, Just a quick post on how to view recent queries run into an Oracle database: Cheers
Read postReserved Words - Oracle
Just a quick post on how to check if a word is reserved using the v$reserved_words: Alernatively you can specify the word, i.e. to check if online is a reserved word,…
Read postUnable to Login to AppDesigner - PeopleSoft
I couldn’t login to Application Designer today for some reason. I kept getting an “Invalid User ID and password for signon.” error despite my credentials being…
Read postAccess Log - PeopleSoft
I came across a requirement today where I needed to find out when a user had last logged into PeopleSoft. The record PSACCESSLOG came in handy here, it stores all of…
Read postHow to Edit a Message Catalog Definition - PeopleSoft
Editing a message catalog definition in PeopleSoft is pretty straight forward, simply browse to the following menu path: PeopleTools > Utilities > Administration >…
Read postSleep Function Within PeopleCode - PeopleSoft
While at work today I discovered that there doesn’t appear to be any built in functionality to allow for a delay to be implemented within PeopleCode. Thankfully there…
Read post