WebSphere Adapter for Oracle E-Business Suite
If you encounter problems while running the tasks for these samples, they could be related to either running the Adapter for JDBC or to interacting with the Oracle database. Two known issues are described.
The time it takes to generate objects varies according to the computing power of the hardware system on which you are running the Oracle E-Business Suite.
During a Create operation, after the adapter sets the values in the interface tables, an Oracle function call is made using a stored procedure. The function call moves the data from the Oracle interface tables to the base tables. If a problem occurs when this function call is made, Oracle writes error codes into the column in the interface tables called INTERFACE_STATUS.
In a production environment, these errors can be detected in a number of ways. You can run a separate Adapter for JDBC instance to look for and report errors from these columns. Or you can create an Oracle workflow to check for errors and report them using the Oracle E-Business Suite reporting system.
For problems while running the Adapter for JDBC, refer to the section "Configuring troubleshooting tools" in WebSphere Adapters: Adapter for JDBC User Guide. It describes how to enable logging and tracing, how to enable the Common Event Infrastructure, and how to install IBM® Support Assistant. To view that documentation, see http://publib.boulder.ibm.com/infocenter/dmndhelp/v6rxmx/topic/com.ibm.wsadapters602.jca_jdbc.doc/doc/stjdb_welcome.html.
Last updated: Mon 30 Oct 2006 03:46:26
(c) Copyright IBM Corporation 2005, 2006.
This information center is powered by Eclipse technology (http://www.eclipse.org)