During Create operation, Objects 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 problems such as not setting required values, or using 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 11.5.10.
In a production environment, these errors could be detected in a number of ways. You could run a separate Adapter for JDBC instance to look for and report errors from these columns. Another option could be to create an Oracle workflow to check for errors and report them using the Oracle E-Business Suite reporting system.