Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Re[1]:reg APPS standard WHO column ?

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

From: Tanel Põder <tanel.poder.003_at_mail.ee>
Date: Tue, 20 Jul 2004 15:48:07 +0300
Message-ID: <306b01c46e57$d0ba58e0$0a879fd9@porgand>


> 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_at_freelists.org put 'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Received on Tue Jul 20 2004 - 07:44:47 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US