I have a java subscription to event "oracle.apps.csm.download.startsync"
which I raise from PL/SQL.
But when WF JAVA deferred Agent Listener processes the WF_JAVA_DEFERRED
Queue, in debug log, I can see the Error:
[Oct 30, 2008 12:29:55 AM PDT]:1225351795790:-1:-1:rws60052rems:220.127.116.11:-1:-1:1:20420:SYSADMIN(0)
:-1:Thread[inboundThreadGroup1,5,inboundThreadGroup]:18.104.22.168:89796:1225 351003545:23:ERROR:[fnd.wf.bes.SavePointUtility.setSavePoint(conn, name, savepoint)]:Could not create Savepoint: java.sql.SQLException: could not set
a Savepoint with auto-commit on
How to solve this issue ?
If I restart the Agent listener, Savepoint is getting created fine for the first time this api is called after restart.