Database Scripts
Database scripts are provided for each of its predefined transaction services. You use these database scripts to manage the triggers, views, and stored procedures that are used by the predefined transaction services.
The database scripts are located in the WmOAXXXnnnn\dbscripts directories, where WmOAXXXnnnn is the name of the package containing the predefined transaction services.
Each type of predefined transaction service has a set of database scripts, as described in the following sections.
Core Database Scripts
The predefined transaction services use a set of core components that you must install and manage on the Oracle Applications system to use any of the predefined transaction services.
The database scripts for these core components are located in the WmOACommon1227\dbscripts directory.
| Database Script File | Description |
|---|---|
| wm_install_core.sql | Use this script to install the core
components of the predefined transaction services.
You must install these components to use any of the predefined transaction services. |
| wm_drop_core.sql | Use this script to uninstall the core components of the predefined transaction services from the Oracle Applications system. |
| wm_common_vw.sql | Use this script to create common views for
transactions in the following predefined transaction services:
|
Database Scripts for Receive Services
Each receive service provides the following database scripts:
| Database Script File | Description |
|---|---|
| wm_install_into_Doc.sql | Use this script to install the Oracle Applications-related components of the service (such as triggers, views, and stored procedures) onto the Oracle Applications system. |
| wm_drop_into_Doc.sql | Use this script to uninstall all components of the service from the Oracle Applications system. |
Each service might also have supporting database scripts. You need not run these scripts directly; they are initiated by the supported database scripts.
Database Scripts for Query and Send Services
Query and send services that operate on the same business object share the following database scripts.
| Database Script File | Description |
|---|---|
| wm_install_from_Doc.sql | Use this script to install all components of the service onto the Oracle Applications system. |
| wm_drop_from_Doc.sql | Use this script to uninstall all components of the service from the Oracle Applications system. |
| wm_enable_from_Doc.sql | Use this script to enable all triggers associated with the service. Use this script if you have disabled the triggers. By default, triggers are enabled when you install them. |
| wm_disable_from_Doc.sql | Use this script to disable all triggers
associated with the service. Use this script if you are using the query service
but not its associated send service.
If you do not disable triggers for send services that you are not using, the custom tables will continue to grow in your Oracle Applications system, consuming resources. |
Each service might also have supporting database scripts. You do not have to run these scripts directly; they are initiated from the database scripts listed above.