My Oracle Support Banner

E1: ESU: Information And Troubleshooting Known Errors And Issues With UBE R98407 - "Table and Index Creation" When Installing A Software Update Patch (ESU or ASU) (Doc ID 1502692.1)

Last updated on FEBRUARY 02, 2022

Applies to:

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


This document is part of an Information Center - to see other documents related to Software Updates, please use the links provided below:

Information Center: Software Updates(ESUs, ASUs), Product Packaging, Change Assistant, Configuration Assistant and OBA in the JD Edwards EnterpriseOne Tools and Technology Product > Information Center: Troubleshooting Software Updates(ESUs and ASUs) in the JD Edwards EnterpriseOne Tools and Technology Product > Software Updates - "Application Table Merges" section

This document was created to provide vital information on UBE R98407 and assist customers on troubleshooting the different scenarios, causes and resolutions for issues involving Software Update (ESU or ASU) patch install errors when there are errors occurring on running UBE report

Solution: To correct this issue, follow these steps:

  1. On the Deployment Server, log into the JDEPLAN environment. 
  2. Go to (GH9612) into the Software Updates application (Electronic for an ESU or Application for an ASU).
  3. Highlight and Select the ESU or ASU you are attempting to apply. Click Next.
  4. Highlight the desired environment. UNCHECK the Unattended Workbench checkbox (to place install in "Attended" Mode and allow the ESU install process to stop through the workbenches scheduled to run) and UNCHECK the Backup checkbox and the Create OMW Project checkbox. Click Next. 
  5. Once the application stops (should be at the Table Conversion screen with the failed R98407), leave the screen up and return to the main menu screen.
  6. Go to menu GH961 and launch the Custom Installation Plan application.
  7. In the Custom Installation Plan -[Work with Installation Plans] (P98240/W98240B) form click Find.
  8. Expand the ESU or ASU's latest plan. Each time the ESU/ASU is run, a new project is created with a unique name by appending the project with the next sequential number, e.g. JL123-4. The highest number should match the project you are currently working with in the other window.
  9. Expand Base Location, the Location, Environments, and then the given environment, e.g. DV900. Set focus on Table Conversion and click Select. 
  10. In the grid row for the environment, it should have a row where Table Name is F0101 and the Program Name as R98407. Focus in the Dtl Sts box on that grid row and use the Visual Assist to choose 60 (Installed). Click Save and return to the ESU/ASU application.
  11. Return to the active window for the Software Updates application and click the Back button until you get to the screen before the R98407.
  12. Click Next. If there is another process on the Table Conversions, it will stop there so you can complete any unprocessed conversions. If the R98407 was the only unsuccessfully processed job, the Software Updates application should move past it to the next workbench in the installation.

 NOTE: Please note that in some cases, the customer issue got resolved after rerunning R98407.



Troubleshooting Steps

To view full details, sign in with your My Oracle Support account.

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

In this Document
 Overview of UBE R98407 and Examples of R98407 XJDE0001 PDF Results
 Table and Index Generation UBE R98407: Table Mappings and Generation for Software Updates
 How to Reset the Status of the Table and Index Creation (R98407) to Success to Continue On With Software Update Installation
Troubleshooting Steps
 Scenario 1 - F98611 Fetch Failed Error On R98407 (Table And Index Creation) When Applying ESU
 Scenario 2 - EnterpriseOne 8.12 ASU UK3 Install, UBE R98407 Fails on UDB/DB2 Databases
 Scenario 3 - During ESU Installation UBE R98407 Index Table Creation Fails Due to Incorrect CCSID - AS400 iSeries Platform Only
 Scenario 4 - Applying Cumulative Update (ASU) - R98407 UBE Errors - JDB9900299 - Failed to Create Global Table Specs / JDB9900307 / JDB9900318 Errors
 Scenario 5 - ASU Patch Install to an Environment Fails on Table and Index Creation UBE R98407 - JDB and Fatal System Error - JDB3300020 / JDB9900913 / JDB9900307 Errors
 Scenario 6 - Errors Applying EnterpriseOne Xe ASU Update 8 (XU8) with AS/400 - R98407 and R98700 Errors
 Issue 1: R98407 Errors Generating F9070* Tables
 Issue 2: R98700 Errors on D8300003
 Solution 1: R98407 Errors Generating F9070* Tables
 Solution 2: R98700 Errors on D8300003

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.