Oracle by Example brandingDeploying Software Updates (ESUs) Using the Web Client

section 0Before You Begin

This 30-minute OBE shows you how to deploy application patches using the web client.

In this OBE, you will:

  • Download an ESU from the Oracle JD Edwards Update Center
  • Import the ESU using the web client
  • Run the software update on the web client
  • Validate the software update using reports
  • Assemble the software update package using the web client
  • Build the software update package using the web client
  • Schedule the software update package for deployment using the web client

Background

Starting with Release 23 and Tools Release 9.2.7.0, you can use the JD Edwards Web Client to deploy application patches.

Applying updates using the web client enables remote patch management and automation.


section 1Downloading the ESU from the Update Center

The web-deployable ESUs are in the multi-platform format.

  1. Access the Oracle JD Edwards Update Center.
  2. In the Search section, set these criteria and click Search:
  3. Enter the ESU name in the Search for Name field to further limit the search result.
    Description of sample-image-1.png follows
    Search criteria on the Oracle JD Edwards Update Center
  4. Review the search results. Note that the description of the multi-platform ESUs ends with _web. Only these ESUs can be downloaded and deployed from the web. Click the download icon corresponding to ESU JN19899 to add it to your Download Basket.
    Description of sample-image-1.png follows
    Search Results on the Oracle JD Edwards Update Center
  5. Go to the Download Basket and download the ESU as a portable archive.
    Description of sample-image-1.png follows
    Download Basket on the Oracle JD Edwards Update Center
    Note: You can also download the multi-platform ESU using Change Assistant if you have an AIS/REST connection.

section 2Importing the ESU Using the Web Client

  1. Sign in to EnterpriseOne on the web client.
  2. From the Software Updates menu (GH9612), select Work with Software Update - Web application (P96470W).
    Description of sample-image-1.png follows
    Navigation to the Software Update - Web Application (P96470W)
  3. On the Work With Software Updates form, select the Form exit and click Import.
    Description of sample-image-1.png follows
    Work With Software Updates - Import
  4. Click the Choose File button and access the downloaded file. Only one ESU can be imported at a time.
    Description of sample-image-1.png follows
    File Upload
  5. Click the Load button. The file is imported and the application returns to the Work with Software Update – Web (P96470W) application. The new ESU appears in the grid.
    Description of image follows
    Work With Software Updates - ESU Populated
  6. The system also populates the Software Update Status window on the screen which displays a visual of the deployment status highlighting the current deployment step and the percentage of update remaining.
    Description of image follows
    Software Update Status Window
    Note: If the Software Update Status window does not appear, select Software Update Status History from the Layout drop-down menu.
  7. To view objects delivered with this ESU, click Row Exit and select Objects.
    Description of image follows
    Work With Software Updates - Objects

    If you have not deployed the ESU, the system shows the list of objects from the manifest table (F96400). If the ESU is deployed, the system shows the list of objects from the Software Update Pathcode Information table (F9672).

    Description of sample-image-1.png follows
    Software Update Objects Form
  8. Click Close.

section 3Deploying the ESU Using the Web Client

  1. Access the Work With Software Updates form (GH9612 > Work with Software Update - Web application (P96470W)).
  2. Select the ESU from the grid. The Web Deploy column on the grid identifies the ESU as web deployable. You can only deploy ESUs that have not been installed on the Deployment Server.
    Description of image follows
    Work With Software Updates - ESU Populated
  3. Select the Row exit and click Deploy.
    Description of sample-image-1.png follows
    Work With Software Updates Form - Deploy
  4. The Software Update Environment Selection form appears. The Backup and Create OMW Project and Package Assembly check boxes are selected by default.
    Description of sample-image-1.png follows
    Software Update Environment Selection Form 

    If the Backup check box is selected, the system creates a backup of object specifications included in the update. If required, the original specs can be restored.

    If the Create OMW Project and Package Assembly check box is selected, the system keeps the OMW Project in the Object Management Workbench-WEB program (P98220W) and creates package assembly and build records for the software update in the Work with Packages programs P9601W and P9621W respectively.

    If the Create OMW Project and Package Assembly check box is not selected, the system removes the OMW project after the OMW load success. If the OMW load is not successful, the system retains the OMW project even if the check box is not selected.

    Note: If Backup is selected, the Create OMW Project and Package Assembly will also be automatically selected.
  5. Click the checkbox corresponding to the Environment(s) that you want to apply the ESU to.

    Note: For Trial Edition, use PS920 as DV920 does not exist.

    Description of sample-image-1.png follows
    Software Update Environment Selection Form
  6. To verify the the list of objects that will be applied, click Row Exit and select Affected Objects.
    Description of sample-image-1.png follows
    Software Update Environment Selection - Affected Objects
  7. The Install Status of the object is set to 1 - Marked for Selection in the Software Update Pathcode History form. If the Install Status is set to 0 - Not Selected, the object will not be applied.
    Description of sample-image-1.png follows
    Software Update Pathcode History Form

  8. Click OK.
  9. Click OK on the Software Update Environment Selection form to launch the ESU Deploy.
  10. The system launches the ESU Deploy form. The Software Updates Status on the Work with Software Updates form shows the percentage of progress.
    Description of sample-image-1.png follows
    Work With Software Updates - Software Update Status
  11. On completion of the deployment, the 100% completion status is seen.
    Description of sample-image-1.png follows
    Work With Software Updates Form - Software Update Status
  12. Click Find in the Software Updates Plan History CafeOne layout. The deployment generated reports are listed in the grid.
    Description of sample-image-1.png follows
    Work With Software Updates Form - Software Update Plan History
  13. Click on the View Output icons to view the corresponding reports. The Deploy Software Update on Web report (R96701W) summarizes the updated objects in a PDF file. The Spec Merge for Web Deploy (R98700W) report provides a summarized report of the specification merge of the objects for web deployment.

section 4Validating the Software Update

  1. To verify the backup project PAR file generated in the F96700R table, run the Software Update File Repository program (P96700R). Search for the ESU deployed JN19899_01_70 and verify if the corresponding backup file PRJ_JN198899_DV920_60_99.par is generated.  
    Description of sample-image-1.png follows
    Work With Software Archives Form
  2. To verify the objects included in the package assembly, access the Object Management Workbench - Web program (P98220W). Enter the ESU number followed by *, for example JN19899* in the Project field and then select the project. The system displays the objects included in the package in the lower grid of the form.
    Description of sample-image-1.png follows
    Object Management Workbench - Web

    To ensure there were no errors, click the Row Exit and select Logging.

    Description of sample-image-1.png follows
    Work With Project Logs


section 5Assembling the Software Update Package

  1. From the Package and Deployment Tools menu (GH9083), select Package Assembly (P9601W).
    Description of sample-image-1.png follows
    Navigation to Package Assembly
  2. Enter the ESU name JN19889 in the Package Name field on the QBE line and click the Find icon.
    Description of sample-image-1.png follows
    Work With Packages Form
  3. On the right, click the tab labeled Individual Objects.
  4. The Individual Objects tab displays the objects included in the package.
    Description of sample-image-1.png follows
    Work With Packages Form - Individual Objects Tab
  5. To review Package Build Revision settings, click Row Exit and select Define Build.
    Description of sample-image-1.png follows
    Navigation to Package Assembly
  6. The Package Build Revision form is displayed. Clear the Client check box to build the package only on the Enterprise Server.
    Description of sample-image-1.png follows
    Package Build Revision Form
  7. To ensure the correct server has been marked for selection, click the Form Exit and select Server Selection.
    Description of sample-image-1.png follows
    Package Build Revision Form - Server Selection
  8. Select the Primary Server check box, if not selected.
    Description of sample-image-1.png follows
    Work With Packages Form - Individual Objects Tab
  9. Click OK.
  10. Click OK on the Work With Packages form.

section 6Building the Software Update Package

  1. On the Work With Package Build program (P9621W), the Active Status column indicates the status of the package. Click on the Red box icon to activate the package.
    Description of sample-image-1.png follows
    Navigation to Package Assembly
  2. When the package is ready to submit, the Active Status changes to a green circle indicating that the status is Active.
    Description of sample-image-1.png follows
    Work With Package Build Form
  3. To submit the package to build, click Row Exit and select Submit Build.
    Description of sample-image-1.png follows
    Work With Package Build - Submit Build
  4. The running package can be viewed in the Recent Reports section on the left section of the form.
    Description of sample-image-1.png follows
    Recent Reports
    Description of sample-image-1.png follows
    Submitted Job Search
  5. You can also watch the status at the bottom of the form by pressing the Find icon periodically.
    Description of sample-image-1.png follows
    Package Build Status
  6. When build status shows complete on Package Assembly – Work with Package Build, click on View Job Status (WSJ).
    Description of sample-image-1.png follows
    Package Build Status
    Description of sample-image-1.png follows
    Submitted Job Search
  7. To view the reports, click the View Output icon on the Submitted Job Search form.
  8. The Server Package Build report (R9621S) shows success in the Package Build Status field.
    Description of sample-image-1.png follows
    Package Build Status

section 7Deploying the Software Update Package

  1. On the Work With Package Build program (P9621W), click the Row Exit, and select Deployment.
    Description of sample-image-1.png follows
    Work With Package Build - Deployment
  2. On the Package Deployment Revision form, click the Enterprise Server checkbox.
    Description of sample-image-1.png follows
    Package Deployment Revision
  3. To select the enterprise server, click the checkbox next to the server.
    Description of sample-image-1.png follows
    Package Deployment Revision
  4. An Approved status indicates that the package is ready to be deployed to the enterprise server.
    Description of sample-image-1.png follows
    Enterprise Server Tab
  5. Click the Deploy button. The Status Description changes to Processing.
    Description of sample-image-1.png follows
    Package Deployment Status
  6. Click the Refresh button to monitor the status.
    Description of sample-image-1.png follows
    Package Deployment Status
  7. When the deployment process is complete, the package status changes to Deployed.
    Description of sample-image-1.png follows
    Package Deployment Status

                    NOTE: *ALTER Table Conversions via Package Deployment
                    If there are any tables in the package, Package Deployment submits the R98405W UBE for table changes.
                    Full Package: The R98405W UBE runs all Table and Index Create and all *ALTER conversions for any deployed ESU.
                    Update Package: The R98405W UBE runs Table and Index Create and *ALTER conversions for any tables in the update                     package. If you deferred *ALTER when deploying ESUs on the Deployment Server, Package Deploy runs them as well.

more informationWant to Learn More?