Home » Applications » Oracle Fusion Apps & E-Business Suite » How do I return the USERNAME in a package (Oracle EBS 11.5.10 Solaris 10)
How do I return the USERNAME in a package [message #611019] Wed, 26 March 2014 15:57 Go to next message
d0dger
Messages: 7
Registered: July 2000
Location: South Dakota
Junior Member
New to creating packages. I am looking for a way to return the user who is logged onto the EBS application from either ONT or ASO forms similar to $PROFILES$.USERNAME.
I am not looking for an entire package just what sql I would use to return this value.
Re: How do I return the USERNAME in a package [message #611020 is a reply to message #611019] Wed, 26 March 2014 16:51 Go to previous messageGo to next message
John Watson
Messages: 8922
Registered: January 2010
Location: Global Village
Senior Member
Depending on the exact release and the module, the client id my be set to the session's EBS username. Try
select sys_context('userenv','client_identifier') from dual;
Re: How do I return the USERNAME in a package [message #611146 is a reply to message #611020] Fri, 28 March 2014 07:26 Go to previous messageGo to next message
d0dger
Messages: 7
Registered: July 2000
Location: South Dakota
Junior Member
Thanks for your help on this. I was not able to get the username to return data using client_identifier or external_name. It does return data using os_user or host. I think this is on the right path though and will continue testing. Thanks again.
Re: How do I return the USERNAME in a package [message #611147 is a reply to message #611146] Fri, 28 March 2014 07:30 Go to previous messageGo to next message
John Watson
Messages: 8922
Registered: January 2010
Location: Global Village
Senior Member
There is also fnd_profile.value('username') and fnd_global.login_id if I remember correctly. Look them up.
Re: How do I return the USERNAME in a package [message #611165 is a reply to message #611147] Fri, 28 March 2014 09:09 Go to previous message
d0dger
Messages: 7
Registered: July 2000
Location: South Dakota
Junior Member
fnd_global.user_id gave me what I was looking for. Thanks much for your assistance with this.
Previous Topic: Review Forms and reports
Next Topic: Oracle Sales Order and Work Order Report
Goto Forum:
  


Current Time: Thu Mar 28 11:52:06 CDT 2024