Oracle Application Object Library (FND): Active Users Data Collection

1. Login to Oracle E-Business Suite
2. Select the responsibility "Oracle Diagnostics Tool"
3. Select application "Oracle Application Object Library" from the "Application" list of values
4. Click the "Advanced" tab
5. Scroll down to group "Data Collection"
6. Select test name "Active Users"
7. Input Parameters (* required)

Responsibility Id (LOV) *

8. Output contains

Product Installation Status and Patchset Level

Parameters

Key Profile Options

Self Service Web Application Users

Forms-Based Products Users

Concurrent Programs Users

References

Find SID from Concurrent Program Request ID

SELECT sid
FROM v$session
WHERE paddr LIKE
(SELECT addr
FROM v$process
WHERE spid =
(SELECT oracle_process_id
FROM fnd_concurrent_requests
WHERE request_id = TO_NUMBER(<your request id>)
)
);