When configuring Oracle apps adapter do you use Oracle apps password or do you use service account (DB account with limited permissions). Our Oracle apps admins are concerned that apps adapter will have full privileges as it has apps password. Please let us know what is the best practice.
Well while making the oracle apps datasource connection in weblogic you need to configure with the db account with permission(you can check in oracle documentation).
For using oracle apps adapter in soa composite you just need to set the jca properties while invoking the EBS service in the invoke activity. Look at the link below: