Cool Data Selection When Purging Work Submitted Jobs
Normally, we purge out all records from the Work Submitted Jobs screen that are at least 45 days old. However, one of our clients requested...
SQL To Get The Email Address From The Address Book Who’s Who For Each User Profile
Below is the SQL used to get the emails address from the Address Book Who's Who (F01151) for each user profile (F0092): SELECT A.ULUSER,A.ULAN8, B.EAEMAL...
Use Oracle SQL Developer To Modify The JDE LOCAL Database
During our upgrade process, we apply all of the ESUs to become "code current" before mirroring the upgraded code to the other pathcodes. The process...
Upgrade Gotcha: Media Objects
I got a great reminder from a post today on Shannon's JDE CNC Technical Blog titled "Media Objects Gotcha-upgrade / deployment server name". During an...
How To Compare Field Values Between Tables
I used the following SQL to compare the difference between the F9200 (Data Dictionary) used for EnterpriseOne 9.1 and the one used for EnterpriseOne 8.12...