Removing Components for Predefined Transaction Services from the Oracle Applications Database
To remove the predefined transaction service components from the Oracle Applications database
1. Change your default directory to Integration Server_directory \packages\WmOAXXX1227\dbscripts directory, where WmOAXXX1227 is the name of the Oracle Applications package containing the service for which you want to run database scripts.
2. Log in to SQL*Plus. You can use any login.
3. From SQL*Plus, run the uninstall scripts. When prompted, supply the APPS user name/password, a Custom user name/password, custom tablespaces (for data and index), and a connection string:
a. Uninstall the core components for the 12.2.7 predefined transaction services by running the following script: @wm_drop_core.sql
b. Run the uninstall database script for each of the predefined transaction services you are using. For the name of a predefined transaction service’s uninstall script, see the section called "Database Scripts" for the specific service in the remaining chapters in this guide.
4. When the uninstallation is complete, you will see a message indicating the completion of the uninstallation.
5. Exit SQL*Plus.