The ManageForce Blog

Best Practices for Your JDE 9.2 Upgrade

Posted by Grant McIver | 11/27/17 10:56 AM

So, you've decided to upgrade to JDE 9.2? It's smart to stay up to date on the latest and greatest version; however, upgrades can be overwhelming and it can be difficult to predict potential obstacles prior to implementation. Just like your previous upgrades, you want to be armed with a treasure chest of lessons learned, so that everything goes as smooth as possible. Here are a few things that you need to consider that will help you minimize wasted effort and will prevent any feelings of "I wish I knew that then."

Evaluate Your Features

New features like UX One, Personal Forms, EnterpriseOne Search, and even some other features that have been around for a while (like E1 Pages & CafeOne) should be evaluated to see if they can and should be implemented as part of the upgrade. Our recommendations would include: 

  1. Taking a hard look at UX One to see if any of the content would be beneficial to your end users
  2. Implementing E1 Pages, if you haven't done so already. The latest 9.2 E1 pages style sheets and icons are visually beautiful and your users will thank you for giving them an option to navigate the system without forever clicking through the menus. See sample E1 Page (using latest CSS)Best Practices for Your JDE 9.2 Upgrade.png
  3. For other User Defined Objects (UDOs), you should at a minimum try to publish some grid formats as default for some high impacting screens like Voucher Entry or Journal Entry--try to get rid of those pesky "Basic" grids

It is also recommended that you have a limited scope for publishing Personal Forms and CafeOne. These features do require some good end user training (if you were to open up the functionality to all users), but another option is selecting a few applications and deploying the form updates at *PUBLIC. Publishing a CafeOne form for Payee Control (P0450) and a Personal Form for something like Work Order Entry (P17714) are two great examples that can make the data entry/review much quicker for end users.

The EnterpriseOne Search, although very nifty, can probably be an enhancement that you pursue as a post go-live project. Depending on your resource availability, budget, and ability to execute vision, putting in the EnterpriseOne Search at go-live would be "going the full distance" in terms of enhancing usability.

Overall, you'd like to utilize all of the cool features from 9.2 but you need to have a manageable scope. The above recommendations should help in getting maximum utilization with a low cost/effort.

Avoid Change Fatigue

Doing any sort of upgrade presents you with a prime opportunity to make some high-impact changes that you wouldn't normally be able to do during regular business operations. Hardware changes, security and menu redesigns, and data conversion fixes are all great examples of things you should take advantage of during this period of change. You want to get the most bang for your buck but you also can't change the entire world for the end user or have a scope so large that it will be "so big it will fail." When determining the ultimate scope of the upgrade, you can ask yourself these questions:

  1. Is this change urgent or is this a "nice to have?"
  2. If I don't do this change now, will I ever have the opportunity to do this?
  3. How will the benefits of this change impact the perception of success for the project?
  4. Will the effort/difficulty for this change pose a risk to my go-live target dates?

Just like anything in life, everything is a balance, so choose wisely in determining how much change you're feasibly going to put in for an upgrade project.

Look Out for "Gotcha's"

Whether you're upgrading from XE, 9.0 or another release, there are certain changes that may have happened along the way which impact 9.2, but are not necessarily part of the installation of 9.2 or upgrade instructions. Here are a few to keep in mind: 

Next Numbers

As part of data conversion, you'll definitely need the most recent values from your legacy system. However, you can't just copy over the F0002, F00021, and F00022 tables and leave them as is. Over the releases, JDE has added new system codes and new tables that require unique keys. Therefore, after you've transferred the next number data from your existing release to 9.2, be sure to insert records from pristine environment that are net new as well as perform a comparison between pristine and production for the F0002 table. You may need to manually update some of the next number columns for the already existing system codes in P0002. Performing this reconciliation will ensure that you're up to 9.2 standards as well as avoid any potential errors due to missing unique key records.

Check Printing

If you print checks from JDE then you've most likely customized the R04572 object in some way. This will require you to do some retrofitting and in doing so you need to make sure that the code is fully up-to-date; otherwise, you may discover an issue related to check skipping. The issue can be very hard to discover but works like this:

You perform the "Write" for your checks and see that the next number for the bank account is, for example, 10031 with 30 checks in the payment group. When you open the actual PDF for the checks you notice that the checks are actually numbered between 10061-10090 when you were expecting them to be numbered between 10031-10060.

The actual issue can be traced to SAR 8782932 so make sure your R04572 object includes the code for this SAR. Doing the retrofit may cause you to painstakingly update the code manually or cause you to do all the sensitive layout changes, but it still needs to be done and it's much easier to do that exercise during the upgrade as opposed to doing it post go-live. Overall, for an object like check print, you should always be up to date with the latest code so it is supportable by Oracle. 

View CSV Reports

You've installed 9.2 and are midway through unit testing and your users started identifying that their CSV reports look funny. The problem they see is that all of the data is in one column instead of their respective columns. At first glance you'll think it's a Windows or MS Excel setting that needs to be adjusted but actually there is an encoding setting that needs to be updated in JDE.

To fix this, go to Unicode Flat File Encoding Configuration Application (P93081) in the FAT client and enter the record for CP1252 encoding at *PUBLIC for *ALL environment and *DEFAULT versions with an Active status. The encoding has more impacts than just viewing CSV files so some JDE clients may choose to add individual batch applications into the Program ID field (instead of *DEFAULT).

For more information, see Oracle Support Doc ID 1985620.1.

Bottom line, we feel that it is incredibly beneficial to educate yourself on the potential obstacles you could run into prior to performing an upgrade to your critical JD Edwards ERP system. We hope that these few tips and tricks help you get started on a smooth transition to JDE 9.2!

As a certified JD Edwards Solution Provider, we're well-versed in managing JDE updates. Our team of experts can easily transition your team onto the latest version, getting you up to speed and allowing you to reap the benefits of the new JD Edwards as soon as possible. 

Download our complimentary guide to get started on your JD Edwards upgrade today!

JD Edwards Upgrade Guide

Or, if you're looking to get your JD Edwards applications into the cloud, download our complimentary eBook as a guide to help to get started.

JD Edwards

Topics: JD Edwards, JD Edwards Upgrade, JDE 9.2

Written by Grant McIver


Recent Posts