What I Broke – Programming and Web Development

Category: PeopleSoft

  • ORA-28000: the account is locked – PeopleSoft

    Hey everyone, Just a small PeopleSoft issue I ran into while running an SQR: (SQR 5528) ORACLE OCISessionBegin(RDBMS) error 28000 in cursor 0: ORA-28000: the account is locked (SQR 4701) Cannot logon to the database. SQR for PeopleSoft: Program Aborting. For some reason the sysadm account had been locked, thankfully there’s a fairly easy fix:…

  • View Last Query Executed – Oracle

    Hey all, Just a quick post on how to view recent queries run into an Oracle database: SELECT sql_text, sql_fulltext FROM v$sql ORDER BY last_load_time DESC Cheers

  • Reserved Words – Oracle

    Just a quick post on how to check if a word is reserved using the v$reserved_words: SELECT * FROM v$reserved_words WHERE reserved = ‘Y’ Alernatively you can specify the word, i.e. to check if online is a reserved word, run the following: SELECT * FROM v$reserved_words WHERE UPPER(keyword) LIKE ‘%ONLINE%’

  • Unable 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 correct. It turned out that adding the EOPP_USER and PAPP_USER roles fixed the issue: 1: Navigate to the user’s profile (PeopleTools > Security > User Profiles > User Profiles)…

  • Access 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 the following: PSACCESSLOG OPRID: The users operator ID LOGIPADDRESS: The users IP address LOGINDTTM: A timestamp showing when the user logged in LOGOUTDTTM: A…

  • How 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 > Message Catalog Enter your message set number into the prompt. Note that if you do not know your message set number you can use the following to find it: SELECT *…

  • Sleep 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 are a couple of roundabout way you can go about doing this: #1: Works if you are sitting on an Oracle DB /* The following code creates…

Create a website or blog at WordPress.com