Oracle Apps Adapter 6.0 | webMethods Oracle Applications Adapter Documentation | webMethods Oracle Applications Adapter 12.2.7 Predefined Transaction Services Documentation | Overview | Overview | Database Scripts
 
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:
*receiveDemandSchedule (WmOAMFG1227)
*sendSalesOrder (WmOAOMG1227)
*querySalesOrder (WmOAOMG1227)
*sendASN (WmOAOMG1227)
*sendARTransaction (WmOAFIN1227)
*sendCustomer (WmOAFIN1227)
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.