OraFAQ Forum: Oracle Fusion Apps & E-Business Suite » How do I return the USERNAME in a package

Home » Applications » Oracle Fusion Apps & E-Business Suite » How do I return the USERNAME in a package (Oracle EBS 11.5.10 Solaris 10)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

How do I return the USERNAME in a package [message #611019]

Wed, 26 March 2014 15:57

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.

Report message to a moderator

Re: How do I return the USERNAME in a package [message #611020 is a reply to message #611019]

Wed, 26 March 2014 16:51

John Watson
Messages: 8965
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;

Report message to a moderator

Re: How do I return the USERNAME in a package [message #611146 is a reply to message #611020]

Fri, 28 March 2014 07:26

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.

Report message to a moderator

Re: How do I return the USERNAME in a package [message #611147 is a reply to message #611146]

Fri, 28 March 2014 07:30

John Watson
Messages: 8965
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.

Report message to a moderator

Re: How do I return the USERNAME in a package [message #611165 is a reply to message #611147]

Fri, 28 March 2014 09:09

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.

Report message to a moderator

Previous Topic:	Review Forms and reports
Next Topic:	Oracle Sales Order and Work Order Report

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Feb 15 10:42:21 CST 2025