Home » Applications » Oracle Fusion Apps & E-Business Suite » User id
User id [message #310137] Mon, 31 March 2008 07:03 Go to next message
Messages: 198
Registered: April 2005
Location: Cairo - Egypt
Senior Member
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

Re: User id [message #311313 is a reply to message #310137] Fri, 04 April 2008 01:17 Go to previous message
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).
Previous Topic: Proration set up - HRMS
Next Topic: Log Messages
Goto Forum:

Current Time: Sat Aug 19 04:31:36 CDT 2017

Total time taken to generate the page: 0.14088 seconds