Installing Service Components on the Oracle Applications Database
To set up the Oracle Applications database for use with adapter services
1. Copy files from the appropriate directory as follows:
If you are using Oracle Applications 11.5, copy all files from the
Integration Server_directory \packages\WmOAAdapter\sampleTxns\setup\11.5 directory into the bin directory of your Oracle database (
orant\bin).
If you are using Oracle Applications 11.0, copy all files in the
Integration Server_directory \packages\WmOAAdapter\sampleTxns\setup\11.0 directory into the bin directory of your Oracle database (
orant\bin).
If you are using Oracle Applications 10.7SC, copy all files in the
Integration Server_directory \packages\WmOAAdapter\sampleTxns\setup\10.7S C directory into the bin directory of your Oracle database (
orant\bin).
2. Log in to SQL*Plus. You can use any login.
3. From SQL*Plus, run the installation script: @wmOASetup.sql.
When prompted, supply the APPS username/password, a Custom username/password, custom tablespaces (for data and index), and a connection string.
Note:
Make sure you enter the APPS user and its associated password. In addition, the procedures and views being created must be in the APPS schema.
When the installation is complete, you will see the message “Installation Completed.”
4. Exit SQL*Plus.
Note:
If you install the setup files in a schema other than APPS (for Oracle 11.0) or APPS_APPDEMO (for Oracle 10.7), you must update the following Oracle Applications‐to‐IS transaction definitions:
InvoiceOutbound
InvoiceOutbound_Ack
PurchaseOrderNew_Ack
PurchaseOrderChange_Ack
AdvanceShipNotice_Ack (10.7 only)
These transaction definitions call stored procedures with the schema.package.procedure format. You must edit the schema on these calls to match your installation. For more information about editing transaction definitions, see the webMethods Oracle Applications Adapter Installation and User’s Guide .