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

From: Naveen, Nahata (IE10) <Naveen.Nahata_at_honeywell.com>
Date: Tue, 20 Jul 2004 05:46:53 -0700
Message-ID: <77ED2BF75D59D1439F90412CC5B109740F13CEB1@ie10-sahara.hiso.honeywell.com>

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

I think the problem is that you are trying to get the value of LOGIN_ID using SQL*PLUS as against Oracle Apps login.

A normal SQL*PLUS login is different from Oracle Apps Login.

When you login through SQL*PLUS, you don't get any values from FND_PROFILE since the profile needs to be setup by the application.

This is the very same reason, that you don't see any values in lots of views like 'AP_INVOICES_V', since the profile doesn't get setup by a normal login.

>so what does 42365 in FND_USER.LAST_UPDATE_LOGIN mean ?
>i'm confused !!! can this be related to any v$ view ?

Try running the following query:

SELECT * FROM FND_USER where user_id = 42365;

Regards
Naveen

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:43:52 CDT