Data Is Marked as READ in the Oracle Database is not Committed in SAP (Doc ID 1910988.1)

Last updated on JULY 28, 2014

Applies to:

Oracle Service Bus - Version 11.1.1.7.0 and later
Information in this document applies to any platform.

Symptoms

When using OSB for integration between Oracle Database and SAP.

Sometimes data is marked as READ in Oracle Database but is not committed in SAP.

The flow used for this process:

[Oracle Database]
(1) ---> Proxy Service with DB Adpater with Logical Delete polling
(2) ---> routes to
(3) ---> Business Service with JCA Adapter iWay for SAP
(4) ---> [SAP]

 
1) JDBC Datasource used for polling is XA
2) Proxy Service is Transaction Required
3) Route to has QoS "Exactly once", and in a request model (not request-response)
4) weblogic-ra.xml of the iWay SAP adapter has <transaction-support>LocalTransaction</transaction-support>

 

In OSB logs, the transaction seems to be processed, rows extracted from DB (READ=0) and committed successfully into JCA LocalTransaction.
After this, the records marked the row as READ = 1.  

Reviewing JCO Logs, the connection against service_SAP is correctly opened and the function IDOC_INBOUND_ASYNCHRONOUS is executed with the right information. After this, the method RfcConfirmTransId is invoked in SAP.



Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms