Technology Stack - EBS (MOSC)

MOSC Banner

Need to know number of users login in EBS

edited Jun 12, 2014 12:00PM in Technology Stack - EBS (MOSC) 2 commentsAnswered

Hi all

I need to know the number of users login between particular period

I am executed below command


select * from icx_sessions where  disabled_flag != 'Y' and (last_connect + decode(FND_PROFILE.VALUE('ICX_SESSION_TIMEOUT'), NULL,limit_time, 0,limit_time,FND_PROFILE.VALUE('ICX_SESSION_TIMEOUT')/60)/24) between to_date('01-JUN-2014','DD-MON-YYYY') and to_date('05-JUN-2014','DD-MON-YYYY');


But when I login today (4th June 2014), I could not find my session.

Kindly suggest

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center