WebSphere Adapter for Oracle E-Business Suite

Troubleshooting information for the sample applications

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.

Objects take a long time to generate

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 the Create operation, Objects are not moved to base tables

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.

If your customer object fails to appear in the application after the Create operation is run, but no errors are reported by the Adapter for JDBC, then you should query the INTERFACE_STATUS column in each interface table to see if any errors have been reported. These errors could be due to required values not being set, or use of a reference number or customer name that is already in the Oracle application's base tables.
Note: For more information on the error codes for this column, refer to your documentation for Oracle Applications.

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.


Terms of use |

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)