Oracle Apps DBA

My photo
More than 5+ Years of IT Experience in administering Enterprise wide Multi Vendor UNIX Servers, Oracle Databases (8i to 11gR2), Middle-tiers, Applications and Clusters. I am a Sun Certified System Administrator (SCSA) for Solaris 10, oracle 10g database certified associate(OCA), Oracle 10g Database certified professional (OCP) and Oracle E-Business suite R12 certified professionl(OCP)

Oracle Database and Applications

Sunday, 21 October 2012

Purge Inactive Sessions - Apps R12

This article illustrates how to 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.


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""

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

 Hope helps :)

Thanks for reading.


1 comment:

Anonymous said...

Wonderful article.