Oracle SOA Mediator Error - ORAMED-03503

In this post, I'll share the solution that worked for a SOA composite runtime error. I have created a soa composite with a WebService component, a mediator and a database adapter. Below error encountered during the composite web service test-

Error JCA Resource , Error Oracle Mediator , ORAMED-03503: [Transaction Commit] Unable to commit transaction , Transaction has - been rolled back , XA JCA Resource

SOLUTION
Below solution worked for issue resolution-

The issue was majorly associated with JDBC connection profile created in weblogic server. So we need to fix this inside weblogic console as per the below steps-

1. Login to weblogic server console- http://192.168.0.112:7001/console and navigate to Data Sources and click on that data source. In my case it is 'DBConnLocal06102017'.




2. Go to configuration tab and click on Transaction sub-tab. Check (mark) on 'Support Global Transactions' and select 'Emulate Two Phase Commit' option.

3. Just save it and restart the Weblogic server.

4. Ideally the issue ORAMED-03503 should get resolved as worked for mine.

UPDATE[23-May-2019]
In addition to Mediator error, the same error was populated during web service invocation in a BPEL process-

JDBC driver does not support XA, hence cannot be a participant in two-phase commit.

Environment- 
1. Oracle SOA Suite 12c(12.1.3.0.0) 
2. Oracle Database 12cR2(12.2.2.1) using RAC
3. JDBC connection- GridLink
4. WebLogic Server 12c

After following the STEP2 & STEP3, the targeted servers of JDBC connection were restarted (in my case soa_server1 & soa_server2 :soa_cluster) and web service invocation was successful.