Blog directory

Change Database values using MS Access (JDE E1 Oracle)

For people who have problems with SQL, there’s an easier way of changing backend database values. How about using MS Access where you can directly type in the values, and it gets updated or you can Insert, Update Delete & you can export, import…. and all. Following is the tutorial for setting up MS Access with Oracle Database Backend for JD Edwards EnterpriseOne. . . . → Read More: Change Database values using MS Access (JDE E1 Oracle)

Convert Julian Date to Gregorian Date (SQL)

A problem with SQL over JDE Data is the way Dates are stored in JD Edwards. JDE stores dates in Julian Format. The following SQL snippet can convert the Julian date into Gregorian Date format or Normal date. . . . → Read More: Convert Julian Date to Gregorian Date (SQL)

Send Email with PDF Output

E-Mail

E-Mail the output of your UBE using this simple functionality, by retrieving your JobNumber and simple JDE setups. Uses BSFN – B0500190 (SendEMailHRM) for Xe until 8.10, or B0500725 – Email Merge Letter for other versions. . . . → Read More: Send Email with PDF Output

EnterpriseOne 9.0 Demo/Standalone on Windows Vista

There are Workarounds to get EnterpriseOne installed and get working on a Windows Vista machine. Though Windows Vista, and other Server OS are not directly supported by Oracle EnterpriseOne 9.0, this article may help install and get your Vista to run JD Edwards Demo . . . → Read More: EnterpriseOne 9.0 Demo/Standalone on Windows Vista