We require the need to track the security of a financial system such as oracle cloud with a close look. Thus, tracking of the user location and activity becomes critical to the well being of the ERP system like Oracle ERP cloud. We can use the below query to extract the IP address of a particular user for a date range or of all the users for a date range.
select fs.SESSION_ID,
fs.USER_NAME,
fs.FIRST_CONNECT,
fs.last_connect,
fsa.NAMESPACE
,fsa.ATTRIBUTE_NAME
,fsa.ATTRIBUTE_VALUE
from FND_SESSIONS fs
,FND_SESSION_ATTRIBUTES fsa
where 1=1
and UPPER(USER_NAME) LIKE UPPER(:p_username)
and fsa.session_id=fs.session_id
and FIRST_CONNECT>sysdate-:p_days
and ATTRIBUTE_NAME like ‘FND_USER_IP_ADDR’
ORDER BY fsa.LAST_CONNECT