Select SID from v$session where module = <name>.
The <name> is either the concurrent request shortname or the executable shortname, I can't remember which offhand. This is assuming the report is not being run multiple times at the same time. You can insure that by making it incompatible with itself.
Dig Deeper on Oracle E-Business Suite
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.