Installing Components for Predefined Transaction Services on the Oracle Applications Database
To install the Oracle Applications components of the predefined transaction services
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 installation scripts. When prompted, supply the APPS user name/password, a custom user name and password, custom tablespaces (for data and index), and a connection string:
a. Install the core components for the 12.2.7 predefined transaction services by running the following script: @wm_install_core.sql
b. Run the database script for each of the predefined transaction services you are using. For the name of a predefined transaction service’s installation script, see the section titled “Database Scripts” in the description of each specific service in the remaining chapters of this guide. For general information on database scripts, see
Database Scripts. 4. Exit SQL*Plus.