Concurrent Request Query Not showing Details

Hi Community Members,

I had used a query to get details of long running concurrent requests for many years. I have noticed recently that it is no longer showing any results for many requests. The query completes, but no data is there.

I'm wondering if something changed in the database or something with the recent versions of EBS? Possibly, the concurrent request do not have a database session there in some cases? Appreciate any input as to what might be happening.

Here's the query:

SELECT a.inst_id, a.sid, d.spid AS DB_SERV_PROCESS, a.status, a.machine, a.process AS CLIENT_PROCESS,