WebSphere Adapter for Oracle E-Business Suite
This task is optional. In this sample application, WebSphere® Adapter for JDBC is set to pass a delete operation to the server for customer objects that are identified as inactive by event data sent from Oracle. If you do not want the adapter to pass a delete operation for an inactive customer, modify a SQL script to change the operation from delete to update.
About this task
This task is only necessary if you want change the operation the Adapter for JDBC performs on customers that have become inactive in the Oracle database.With Oracle E-Business Suite, you can make a customer inactive and modify data for an inactive customer, but you cannot delete customer data from the base tables. When the stored procedure used for inbound processing receives event data from Oracle that indicates a customer has become inactive, it sets the operation to delete for the customer object and then posts that information to the event table used by the Adapter for JDBC. The adapter uses that information to process the object and pass it to WebSphere Process Server. However, if you want to keep the customer object in WebSphere Process Server rather than deleting it, edit the sample SQL package to change the operation that the adapter reads from the event table.
How to perform this task
Last updated: Mon 30 Oct 2006 03:46:27
(c) Copyright IBM Corporation 2005, 2006.
This information center is powered by Eclipse technology (http://www.eclipse.org)