How to find out user id, responsibility id and application id in oracle apps

by

Here we will learn, how to find out user id responsibility id and application id in oracle apps . $SQL> select user_id from fnd_user where user_name=’SETUPADMIN’;

Steps to find out user id responsibility id and application id.

To know about User Id use below Query:-

$SQL> select user_id from fnd_user where user_name='SETUPADMIN'; 

To know about Responsibility id use below Query:-

$SQL> select responsibility_id,RESPONSIBILITY_NAME from fnd_responsibility_vl where responsibility_name like '%India%Local%Payables%';

To Know about Application id use below Query:-

$SQL>select APPLICATION_ID from fnd_responsibility_vl where responsibility_id=50366;

To Know about Org id from po:-

$SQL>select org_id from po_headers_all where segment1='&PO';

To know about Requisition Org id from requisition number:-

$SQL>select hr.name, prh.segment1, prh.org_id from po_requisition_headers_all prh, hr_all_organization_units hr where prh.org_id = hr.organization_id and prh.segment1 = '&Enter_Req_Number';

Relates/References:-

Leave a Comment