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.
Want to get an MBA? The Complete MBA for Dummies, 2nd Edition, is the practical, plain-English guide that covers all the basics of a top-notch MBA program, helping you to navigate today’s most innovative business strategies. From management to entrepreneurship to strategic planning, you’ll understand the hottest trends and get the latest techniques for motivating employees, building global partnerships, managing risk, and manufacturing.
What is a public image? One that is created by your personality (labels you display while using attire, cells, jewellery, books you read and talk about, social causes you support etc. etc and etc.), or the one others create for you (media as in colleagues, friends, bosses, relatives, in short your peer group, whether at home or outside), or is it YOU?
If You Never Failed… You Never Lived… is an inspiring video which says Winners are not those who never fail, but those who never quit. The Video gives instances of Lucille ball, The Beatles, Ulysses, Grant Thomas, Thomas Edison, Walt Disney, Abraham Lincoln
A small guide to access JD Edwards EnterpriseOne Demo/Standalone from other computers on the same network. For this to accomplish you need to open a port on the computer, and then access the E9 Web client from other systems
Some of Gandhiji’s Top Fundamentals which specifies on changing the world, and evolving. The Article features on some of his famous quotes, and its implications. Hope it instills some thought within each individual.
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.
There are many instances where we do Report Interconnects from Interactive Applications, like print the Order from an order screen, or process something from an interactive application button. But, in all those cases, the report fires on the Server, and you need to go visit the Work Submitted Jobs to check the output. Every User asks for the same convenience, if they can get the output direct on the screen without going to the WSJ.
Here is a crude way of popping up a UBE output onto the screen, without going to the Work Submitted Jobs. This makes life easy for the users.
UTC stands for Universal Time Coordinate and is a long integer containing the elapsed minutes since Midnight on January 1, 1970 in Greenwich, England. Lets try some ER which would help converting timezones, from and to. Similarly use UTC time zone and its format effectively for Multi-Location Projects/softwares.
BSFN – B8000002 (Delete All Rows From Table) does a delete * from tablename. The B8000007 and the B8000002 business functions must be used together to delete all the rows in a table. They will not delete the table specifications or the physical table in the database. B8000007 must be called first to get the environment handle, with the handle only then B8000002 is able to delete all records from the specified table. B8000007 must be called again to free the handle.
