Monday 18 January 2016

Easy Import of Config File

I want to import PeopleSoft configuration files without going through the UI.

Let's use a .bat file.

Friday 15 January 2016

Remove Dead Worklist Entries

I want to remove worklist entries which have dead links.

But they only gave me a screenshot of the worklist page.

  1. Get OPRID of recipient
  2. Get OPRID of sender. If you look at the screenshot, it's the guy under FROM column.
  3. Get EOAWTHREAD_ID. If worklist is delivered, look at the 2nd value of the Link column.
  4. Execute SQL below.