You’re Fired! …But You’re Still Here? – Cleaning EnterpriseOne (E1) Orphaned Records After Deleting a User Profile
Have you ever had the need to delete a user's profile, then find that there were tables where the deleted profile is still hanging around?...
EnterpriseOne (E1) Security – Reset It All!
The organization that I work for has a SOX requirement that all passwords need to be changed every 90 days. I think this is pretty...
EnterpriseOne (E1) Package Build Count
Recently we were asked the following question: "How many packages of each type per environment did you build last year?" Here is the SQL that...
EnterpriseOne (E1) Version Promotion With Security
The other day our development manager came to me and stated that she could not promote a version to production. In order to take any...
EnterpriseOne (E1) ESU Investigation
The title sounds like something out of CSI or Law & Order SVU... Today our Development Manager was inquiring about what ESUs have been applied...