Quick Upgrade Guide

When you already have an older version of AOP installed.

  1. Unzip the file you downloaded from https://www.apexofficeprint.com

  2. Update the PL/SQL API.
    In the APEX workspace where AOP is installed, navigate to SQL Workshop -> SQL Scripts -> Upload. Select aop_db_pkg.sql which is located in the "db"-directory of the unzipped install package, 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. Repeat these steps for the aop_modal_pkg.sql file. The aop_db_pkg.sql file will install the AOP tables, PL/SQL API for the new version, and synonyms needed to use AOP. The synonyms will be set to point to the new version of AOP, but you can easily switch back to the previous version by changing the synonyms.
    The aop_modal_pkg.sql file will install the required components for the AOP Modal APEX plug-in.

  3. Import new versions of the plug-ins.
    These files are located in the "apex"-directory of the unzipped install package. You will see multiple subdirectories, select the directory that corresponds to the version of APEX you are using - NOT the version of AOP.
    Import dynamic_action_plugin_be_apexrnd_aop_da.sql, process_type_plugin_be_apexrnd_aop.sql and dynamic_action_plugin_be_apexrnd_aop_convert_da.sql, dynamic_action_plugin_be_apexrnd_aop_modal.sql. If using the cloud version of AOP, make sure the API Key is set for each plug-in. An API Key is not necessary for on-premises installations.

  4. Optional: Install the Sample PL/SQL Scripts and AOP Sample Applications.
    Run aop_db_sample_pkg.sql (in the "db"-directory of the unzipped file) in your AOP schema (SQL Workshop -> SQL Scripts -> Upload -> Select file and hit Upload, then Run), which will create some sample PL/SQL Scripts.
    We also recommend you to install the latest version of AOP Sample Apps (located in the "apex/app"-directory of the install package). If you already installed an older version of the AOP Sample App, we recommend to remove it first.

  5. For on-premises versions of AOP: Update the AOP Server
    Stop the AOP executable.
    Copy the server folder from the install package to your AOP Server and restart AOP with the new executable.