| Analogue of database triggers in apps [message #293270] |
Fri, 11 January 2008 09:05  |
lennox
Messages: 4
Registered: January 2008
|
Junior Member |
|
|
Hello,
i want to implement some initialization routines for apps users (fnd_users). Whats analogue of database tigger LOGON ON in oracle applications for apps users?
thanx in advance
|
|
|
|
|
|
|
|
| Re: Analogue of database triggers in apps [message #294191 is a reply to message #294131] |
Wed, 16 January 2008 15:34  |
ggr88
Messages: 31
Registered: October 2007
Location: Wellington, New Zealand
|
Member |
|
|
Hi Lennox,
Forms based sessions, I think yes.
Web based "sessions", I think no.
Check this forum post:
http://forums.oracle.com/forums/thread.jspa?messageID=2278263
Summary:
1) Use the following SQL query to identify the sid and serial# associated with the session identified in the Monitor Users form:
SQL> SELECT SUBSTR(d.user_name,1,30) "User Name"
, a.pid
, b.sid
, b.serial#
FROM v$process a, v$session b, fnd_logins c, fnd_user d
WHERE a.pid = c.pid
AND c.pid = &PID
AND d.user_name = UPPER('&USER_NAME')
AND TO_DATE(c.start_time) = TO_DATE('&START_DATE')
AND d.user_id = c.user_id
AND a.addr = b.paddr
AND c.end_time IS NULL;
Regards,
Gareth
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
