Purge Inactive Session in Oracle Apps

We cannot see Purge Inactive Session by default. This program will purge all session which are not active. 






"Purge Inactive Sessions" concurrent program is not included in request group of  system administrator responsibility. So first we need to add this request to system administrator responsibility request group.

Navigation:

login as sysadmin > 

System Administrator > Security > Responsibility > Request

- Here search for Group "System Administrator"




- Add concurrent program "Purge Inactive Sessions"



- save 

- Submit new request "Purge Inactive Sessions""



It is will ask for no of days of retention as parameter.


- After successful completion of this request then check no. of records in table icx_sessions.



select count(*) from icx_sessions;





Please do like and subscribe to my youtube channel: https://www.youtube.com/@foalabs If you like this post please follow,share and comment