My Oracle Support Banner

E1: ESU: Information and Troubleshooting Of EnterpriseOne Software Update (ESU or ASU) Backup and Restore (Doc ID 1126197.1)

Last updated on JUNE 07, 2021

Applies to:

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


This document contains information and known issues on Software Updates "Backup" and "Restore Backup" procedures. It also contain information on how to back out a ESU. The knowledge provided here is not meant to be as a substitute for the Software Updates Guide, but as an aid for better understanding and troubleshooting issues involving Backup and Restore Backup during an E1 Software Update (ESU or ASU) Install. The knowledge included in this document is meant for users that have a basic understanding of the Software Update (ESU or ASU) Install process and have read the Software Updates Guide. Refer to JD Edwards EnterpriseOne Tools 8.98 Software Update Guide, Revised (Doc ID 757166.1); for JD Edwards EnterpriseOne Tools 8.98 Software Update Guide, Revised; refer to this link here for JD Edwards EnterpriseOne Tools Documentation - Software Updates Guide - Release 9.1.x; and refer to this link here for JD Edwards EnterpriseOne Tools Documentation - Software Updates Guide - Release 9.2.x.

During a software update patch install, you have the option to do a "Backup" of the objects being installed. If you have the backup check box selected when applying an ESU, then the system will make a back up of the affected EnterpriseOne objects. These objects are kept in a database on the deployment server located in the E9XX/Planner/Package/ESU#/Pathcode.BAK directory. This backup copy of the objects is also used during the Retrofitting of your modifications, using Visual ER Compare. The backup will contain your added or modified Event Rules to Oracle JDE objects that you will bring over using the Visual ER Compare tool. On the [Software Update Environment Selection] screen, selecting an environment and using the "Restore Backup" Button will fully restore all objects affected in the ESU process from the created, backup access database. It is important to realize that once the "Restore Backup" button is selected, then the process can not be stopped. The process will automatically restore the objects included in the Software Update, however it will not delete any Newly added objects from your Central Objects. In addition, you should be aware that the Restore Backup checkbox does not restore other items included in a Software Update like Control Tables and Data Dictionary items. And lastly, the Backup checkbox and restore functionality should NOT be used for large Cumulative Updates (ASUs) such as E1 9.0 Update 2. These ASUs Updates require a full system backup.

For more details in this process and many others occurring during a Software Update install, refer to <Document 1318978.1> Understanding ESUs Installs - Software Updates (ESUs and ASUs) Under the Covers - Updated to EnterpriseOne 9.0, 9.1 and 9.2.

Refer also to <Document 1052047.1> E1: DB: How to Backup and Restore the Local Planner Database (OEE or SSE) - for information on how to backup and restore the local Planner Database.


Information pertains to all customers installing Electronic Software Updates (ESUs) or Application Software Updates (ASUs). 


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
 How To Back Out A Software Update (ESUs and ASUs)
 How to Back Out an ESU
 Proper Order to Back Out ESUs
 Problems With Not Using the Proper Back Out Method
 Update Uninstall to Remove the ESU from the System
 Reinstalling an ESU that Has Been Backed Out
 Software Updates (ESUs and ASUs) " Restore Backup" Option Explained
 How Does ESU Backup and Restore work with Tools Release 8.98 Onwards
 Failed Restore of ESU Backup
 How To Remove An ESU When There Is No ESU Backup
 Reference To Known Issues Related To Backup Or Restore Software Updates / ESUs Backup Option

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