E1: UPGTC: Clarification On Manual Table Conversion For UBE R98403A XJDE0001 For ALL EnterpriseOne Application Releases (Doc ID 1269498.1)

Last updated on MAY 30, 2017

Applies to:

JD Edwards EnterpriseOne Tools - Version SP24 and later
Information in this document applies to any platform.

Goal

In this scenario here, customer is doing an EnterpriseOne software upgrade from EnterpriseOne 8.10 to 9.0 application release level. Following the JD Edwards EnterpriseOne Applications Release 9.0 Upgrade Guide (also applies to the 9.1 guide) - Chapter 13 - Manual Table Conversions, the last conversion recommended to be run is UBE R98403A|XJDE0001. This is run on the deployment server.
After customer ran the same, following the instructions, it caused customer major problems as it overwrote some tables as F00091 and F07901. Customer also found that the upgrade plan already ran this UBE, so why would they have to run this job twice?

To correct the issue, customer pulled the data from their E1 8.10 install and loaded it back into E1 9.0 and re-ran the R98403A. This time it was OK. However, looking at the UBE PDF, it clearly stated "APPEND", but it did not append, it overwrote. Looking for an explanation to this Manual Table Conversion and to see if this UBE is really required to run. What does this UBE really do?


The knowledge included in this document is meant for users that have a basic understanding of the Upgrade process and have read the Upgrade Guides. Refer to Document 705521.1 JD Edwards EnterpriseOne Applications Release 9.0 Upgrade Guides, Update. Refer to this link here for JD Edwards EnterpriseOne Upgrade Documentation - Release 9.1.x.

Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms