I have worked out that the Oracle Apps Adapter runs apps_initialize itself and we can control the username/responsibility by setting the jca.apps.username and jca.apps.responsibility properties.
I have the similar use case. I am using a seeded Oracle API to insert data into the tables. I want the user information to be populated in the WHO columns (CREATED_BY, LAST_UPDATED_BY). I have mentioned the jca.apps.username and jca.apps.responsibility in the Invoke activity.
But unfortunately, the columns are not populated with the data. I am using the Oracle Apps Adapter to call the API.
Any inputs will be really helpful.
This issue can be resolved by using a non XA data source connection type instead of XA data source. I faced this issue and was able to resolve by creating a new connection with non XA type and use it in the adapter JNDI.
There are two ways to fix this.
1. Use non XA data source
2. Use autonomous transaction while calling apps_initialize in PL/SQL