Problem importing Oracle Apps Transactions
webMethods Integration Server version: 9.0
Oracle Apps Adapter version: 6.0
Upon attempting to perform either of these two:
- Adapters > OracleApps Adapter > Transaction Mgmt > Transaction Configuration
Adapters > OracleApps Adapter > Transaction Mgmt > Transaction Import
Error encountered has the following code:
Apply Oracle Apps Adapter 6.0 Fix 11, start the Integration Server, and enable packages: WmOAAdapter & WmOACommon11510 (or whatever release one is using).
In the Integration Server Administrator page:
- Go to Settings > JDBC Pools > Functional Alias Definitions.
- Check whether an Associated Pool Alias has been set next to Adapters.
- If not, set one, that points to the webMethods repository in the DB (internal or external). In my case, the repository WEBMETHODS REPOSITORY, pointing to Schema WMISAUDIT, was set under Settings > JDBC Pools > Pool Alias Definitions. To do this, click on the link “Create a new Pool Alias definition” in the page Settings > JDBC Pools, and then go to Adapters under Settings > JDBC Pools > Functional Alias Definitions, and use the link “Edit.”
Restart Integration Server.