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@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 -----------------------------------------------------------------