Re: Re[1]:reg APPS standard WHO column ?

  • From: "Sultan Syed" <ssyed@xxxxxxx>
  • To: <oracle-l@xxxxxxxxxxxxx>
  • Date: Tue, 20 Jul 2004 17:06:51 +0400

Sometimes when u run bug fix scripts
support update this WHO columns with bug number also ,which may
not be same as your user ids

Sultan

----- Original Message ----- 
From: "Tanel Põder" <tanel.poder.003@xxxxxxx>
To: <oracle-l@xxxxxxxxxxxxx>
Sent: Tuesday, July 20, 2004 4:48 PM
Subject: Re: Re[1]:reg APPS standard WHO column ?


> and
> "select TO_NUMBER (FND_PROFILE.VALUE('LOGIN_ID')) from dual"
> returns null.

Where did you execute it from? If you did from plain sqlplus session, it
might not work, because it might use some session or package variables which
Apps Forms normally execute.

Try to initialize the apps variables first (or create a temporary after
logon trigger which gets the login_id value using fnd_profile).

Tanel.


----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to:  oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------


----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to:  oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Other related posts: