Most of us are well aware of global transactions (XA) when using DB Adapter and setting XADataSourceName during creation of DB Connection Pool. ADF BC Services are widely used in Oracle Fusion Applications at Data Service layer instead DB Adapters. So it’s worth investigating or finding out the scope of transaction when calling these ADF BC Services.
Sample code for this demonstration can be found here and accepts string input, where valid values are ‘DB’ or ‘ADF’.
Conclusion:
- ADF BC Service call does not get enlisted into main BPEL txn, so system fault, user defined fault or Roll back fault will not revert the changes done by ADF BC Service. So developer should think of compensation in failure scenarios in case of faults.
Siva's Blog 
0 Responses to “Transactions when using DB Adapter vs ADF BC Service”