Integrate Oracle E-Business Suite Release 12.2 With Oracle APEX

APEX2EBS - Part 8

Cleanup / Uninstall

• To re-configure the APEX instance

  • Run these SQL to cleanup the configuration:

   DELETE FROM A2E_INSTANCE_INFO;
   DELETE FROM A2E_SESSIONS;
   DELETE FROM A2E_DEBUG;
   DROP DATABASE LINK APEX_TO_EBS;
  

  • Delete the page mapping and options if you don't want to keep them (keeping these mappings will allow them to be reused after fresh setup):

   DELETE FROM A2E_RESP_PAGE_MAPPING;
   DELETE FROM A2E_PAGE_EXTENDED;
  

  Note
  

  The mapping of Page Group A2E Admin assigning to System Administrator will be re-created when running the setup.

• To remove the APEX2EBS framework

  • On EBS side

    • connect to APPS, run EBS-REMOVE-APPS-OBJECTS.SQL

    • If custom schema is used, connect to this user and run EBS-REMOVE-APEX-OBJECTS.SQL

  • On APEX side

    • connect to APEX2EBS, run 9-UNINSTALL.SQL

| Table of Content | Next |

| Home | Repositories | Blog |

© 2026 by Christopher Ho. All Rights Reserved