Purge Inactive Sessions

Run "Purge Inactive Sessions" concurrent program in Oracle E-Business suite R12.1

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"
Type: Program

- Add concurrent program "Purge Inactive Sessions"

- save

- Submit new request "Purge Inactive Sessions"

Or,

To Manually Purge the ICX tables:

E-Business suite 11i: $ICX_TOP/sql/ICXDLTMP.sql

E-Business suite R12: $FND_TOP/sql/FNDDLTMP.sql