Home » Applications » Oracle Fusion Apps & E-Business Suite » Analogue of database triggers in apps (OeBS 11i)
Analogue of database triggers in apps [message #293270] Fri, 11 January 2008 09:05 Go to next message
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 #293360 is a reply to message #293270] Fri, 11 January 2008 16:14 Go to previous messageGo to next message
ggr88
Messages: 31
Registered: October 2007
Location: Wellington, New Zealand
Member
Hmm, off the top of my head:
1. Profile Option "Initialization SQL: Custom" (may trigger more than you need - each responsibility change - you may need to filter)
2. Custom Trigger on fnd_logins

Regards,
Gareth
http://garethroberts.blogspot.com
Re: Analogue of database triggers in apps [message #294131 is a reply to message #293270] Wed, 16 January 2008 10:07 Go to previous messageGo to next message
lennox
Messages: 4
Registered: January 2008
Junior Member
Thanks Gareth,

Is it possible to uniquely match fnd_logins to v$session?
I mean uniquely match apps session on dbms level.

Thanx in advance,
Lennox
Re: Analogue of database triggers in apps [message #294191 is a reply to message #294131] Wed, 16 January 2008 15:34 Go to previous message
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
Previous Topic: Need advice from all HRMS Functional consultants
Next Topic: otn delivery number
Goto Forum:
  


Current Time: Sat Dec 10 14:29:11 CST 2016

Total time taken to generate the page: 0.14799 seconds