How to Set Organization

How to Set Organization? SET MO.

/*
select * from fnd_user where user_id=4080
select * from fnd_responsibility where responsibility_id=20707
select * from fnd_application where application_id=201
*/

begin
  fnd_profile.put('USER_ID', 0);--SYSADMIN
  fnd_profile.put('RESP_ID', 20432);--PA
  fnd_profile.put('RESP_APPL_ID', 275);--PA
  apps.fnd_client_info.set_org_context(to_char(183));
end;
/

begin
dbms_application_info.set_client_info('Org_id');
end;



To Retriew the records from Org dependent Views on Sql Developer/Toad/Sql * Plus

begin
fnd_client_info.set_org_context(Org_id);
end;



No comments:

Manage Inactive session in Oracle 23AI Database.

# CONNECT WITH PDB DATABASE(ORACLE 23AI) [oracle@prd-23ai ~]$ sqlplus / as sysdba  SQL*Plus: Release 23.0.0.0.0 - for Oracle Cloud and Engin...