Archive for the ‘EnterpriseOne - SQLs’ Category
Over a year ago, I wrote about how to delete User Overrides in EnterpriseOne. Well, I had to use that process the other day and felt I should probably publish a fix to an unfortunate effects of using the User Overrides application. What are these effects? Well, when ...
August 4, 2008 | EnterpriseOne - SQLs | No Comments »
Background: In developing the Employee Self-Service user interface without using the portal, the development team had a need to be able to print out an employee's paystub and have it emailed to them. The email portion of the process is handled by Optio but before it gets to the ...
July 8, 2008 | EnterpriseOne - JAS (Java Application Server), EnterpriseOne - SQLs, IBM i/System i/iSeries/AS400 | No Comments »
The other day, one of my coworkers was presented a question from our development team: How can I use SQL to look for a "%" in a column? Well, the first guess is to use something like: SELECT * FROM MYLIB/MYFILE WHERE MYCOL ...
May 12, 2008 | EnterpriseOne - SQLs | 2 Comments »
<hint of sarcasm>Although JDE/PeopleSoft/Oracle has done such an awesome job with all of their products</hint of sarcasm>, sometimes you are forced to modify some of the objects. Unfortunately, now that you have modified the object an ESU, that you need, may get released that has that object in it. ...
March 13, 2008 | EnterpriseOne - Install/Upgrade, EnterpriseOne - SQLs | 1 Comment »
My current employer is a publicly traded entity. As such, we are subject to SOX regulations. Because of this we run many reports periodically to satisfy the auditing department. One of those reports determines if there are any terminated employees that still have active UserIDs. Here ...
March 12, 2008 | EnterpriseOne - SQLs, EnterpriseOne - Security | No Comments »
