| User id [message #310137] |
Mon, 31 March 2008 07:03  |
hany_marawan
Messages: 198
Registered: April 2005
Location: Cairo - Egypt
|
Senior Member |
|
|
Hello
I built a customized form on the application and I creat created_by,creation_date,last_update_date,last_updated_by fields like the oracle tables.
How can I get the user id to put it in these fileds.
I used fnd_global.user_id but it always retrieve -1
thanks
|
|
|
|
| Re: User id [message #311313 is a reply to message #310137] |
Fri, 04 April 2008 01:17  |
skooman
Messages: 913
Registered: March 2005
Location: Netherlands
|
Senior Member |
|
|
|
Are you aware of the fact that fnd_global only gives results while in a session with EBS? (so, logged in into the EBS application as an end-user). So, if you test it while working in SQL*Plus (or some tool like Toad), it can not give a user_id since you don't have one (you're working with a proper database account, either apps or some custom user).
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
