Re: how to get user_id for a APPS user ?

From: Hemant K Chitale <hkchital_at_singnet.com.sg>
Date: Mon, 23 Aug 2004 22:15:43 +0800
Message-Id: <6.1.2.0.0.20040823221436.024dbd40@pop.singnet.com.sg>

Are you sure that
user_id = apps.fnd_profile.value('user_id'); is succeeding ? What is 'USER_ID' being passed to APPS.FND_PROFILE.VALUE ?

@At 06:26 PM Friday, you wrote:
@Hi All,
@The environment is Oracle EBS 11.5.9/ Oracle 9.2.0.4/ AIX5.2L.
@
@Below is the procedure is use to get the USER_ID of
@oracle applications user.This procedure in turn is
@being used by DBMS_FGA as shown below .

Hemant K Chitale
Oracle 9i Database Administrator Certified Professional http://web.singnet.com.sg/~hkchital

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 Mon Aug 23 2004 - 09:13:27 CDT