Home » Applications » Oracle Fusion Apps & E-Business Suite » User id
User id [message #310137] Mon, 31 March 2008 07:03 Go to next message
hany_marawan
Messages: 195
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 Go to previous message
skooman
Messages: 912
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).
Previous Topic: Form development
Next Topic: Account reconsilation report
Goto Forum:
  


Current Time: Tue Dec 06 10:38:17 CST 2016

Total time taken to generate the page: 0.10656 seconds