Monday, April 17, 2017

How to find user id,responsibility id, application id for FND_GLOBAL.APPS_INITIALIZE

How to find USER_ID:


select user_id from fnd_user where user_name='test';


How to find  RESPONSIBILITY_ID:

select responsibility_id from fnd_responsibility_vl where responsibility_name like 'AP Accountant';


How to get APPLICATION_ID:
select * from fnd_responsibility_vl  where responsibility_id=223;

No comments:

Post a Comment