Transaction Handling In BRM JCA Adapter 7.4 And Later : No More XA Transaction ? (Doc ID 1553055.1)

Last updated on SEPTEMBER 26, 2016

Applies to:

Oracle Communications Billing and Revenue Management - Version 7.4.0.0.0 to 7.5.0.0.0 [Release 7.4.0 to 7.5.0]
Information in this document applies to any platform.
Checked for relevance on 24-Oct-2014.

Goal

The <document 1535198.1> (Transaction Mode of BRM JCA Adapter for Communications Pre Built Integrations) conveys that LOCAL_TRANSACTION should be used. Oracle is suggesting that XA Transaction should not be used anymore.

Please clarify the reasoning and implications.

The above note is for below symptoms:
1. Transactional issue happening under certain race conditions
2. Transaction getting rolled back on BRM even though everything would seem fine from AIA

Below are few questions in this context :

1) Is this true (to use only LOCAL_TRANSACTION) for both 7.4 and 7.5?
2) What is the implication when one changes the transaction mode from XA to LOCAL_TRANSACTION?
     a. It seems like that LOCAL_TRANSACTION just means it is not XA anymore, so it will also cause data sync issues.
     b. Don’t understand how this will fix race conditions? It will be just faster, is that it?
     c. Would this lead to data sync issues? (e.g. BRM commits fine but AIA rolls back)
     d. If so, instead of #2 symptoms, it will be the same thing as transaction getting committed on BRM even though everything rolls back from AIA.
 

Solution

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