I have been working on Enterprise Scheduler Services (ESS) for Fusion environment. I want to find out the database SID for a particular ESS Job.
I can find the SESSION_ID from fusion_ora_ess.REQUEST_CP table. But unable to proceed further and find.
Does anyone have pointers on how can I find the database SID for a particular ESS Job in Fusion ?
Thanks in Advance !