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...
SQL Server Error: Cannot resolve the collation conflict between "Latin1_General_CI_AS_WS" and "SQL_Latin1_General_CP1_CI_AS" in the equal to operation
I received the following error when trying to join an EnterpriseOne 9.1 table with an EnterpriseOne 8.12 table that was copied to the SQL Server...