Skip to main content

Quick Upgrade Guide

When you already have an older version of AMS installed, follow this guide.

This guide will update the PL/SQL packages and the Oracle APEX plug-ins for AMS​

  1. Unzip the file you downloaded from https://www.united-codes.com/products/apexmessageservice/

  2. Update the PL/SQL API.

    • Go in APEX to SQL Workshop > SQL Scripts > Upload
    • Select file /ddl_uc_ams_update_install.sql
    • Give it a name and click the Upload button.
    • Click the run icon for the script you just uploaded, confirm that the schema in the upper right-hand corner of the screen is correct, and click Run Now.
    • All statements should be successful.

  3. Import new versions of the plug-ins.

    • Go in APEX to App Builder > Your application > Shared Components > Plug-ins > Import
    • Be sure to select the directory corresponding to the version of Oracle APEX you are using - NOT the version of AMS.
    • Select file plugin/process_type_plugin_united_codes_ams_process.sql (for the AMS Process type plug-in)
    • Select file plugin/dynamic_action_plugin_unitedcodes_ams_da.sql (for the AMS Dynamic Action type plug-in)
    • Enter the details of the AMS Server or, in case the AMS Cloud is used, the API key. If using the AMS cloud version, ensure the API Key is set for each plug-in.
      An API Key is not necessary for on-premises installations.

That is it!

  1. Update the AMS Sample Applications.

    • If you already installed an older version of the AMS Sample App, we recommend removing it first.
    • Import the AMS Sample Apps you find in /apex_version/app

For on-premises versions of AMS: Update the AMS Server​

  1. Stop the AMS executable.
  2. Copy the server folder from the install package to your AMS Server
  3. Restart AMS with the new executable