Aby zobaczy\u0107 dane w niekt\u00f3rych widokach w bazie danych, nale\u017cy ustawi\u0107 odpowiedni kontekst organizacji.<\/p>\n
Jest to element funkcjonalno\u015bci Muli-org.<\/p>\n
1) If you know the security_profile_id<\/strong> for that responsibility and user, you could call:<\/p>\n Security profiles are stored in PER_SECURITY_PROFILES, and the final parameter is the application short name of the application associated with the responsibility you would be using.<\/p>\n <\/p>\n 2) To set the operating unit context to a single operating unit<\/strong>, you could simply use:<\/p>\n However, it is generally preferable to use the following wrapper functions from MO_GLOBAL<\/strong> which will call the appropriate utilities to maintain the various elements of the multi-org context:<\/p>\n Procedure: SET_POLICY_CONTEXT<\/strong>(p_access_mode varchar2, p_org_id number) Procedure: SET_ORG_ACCESS<\/strong>(p_org_id_char varchar2, p_sp_id_char varchar2, p_appl_short_name varchar2) Procedure: INIT<\/strong>(p_appl_short_name varchar2) Function: GET_CURRENT_ORG_ID<\/strong> Function: GET_ACCESS_MODE<\/strong> Aby zobaczy\u0107 dane w niekt\u00f3rych widokach w bazie danych, nale\u017cy ustawi\u0107 odpowiedni kontekst organizacji. Jest to element funkcjonalno\u015bci Muli-org. R12 1) If you know the security_profile_id for that responsibility and user, you could call: mo_global.set_org_access(null, <sp_id>, 'PA’); Security profiles are … Czytaj dalej mo_global.set_org_access(null, <sp_id>, 'PA');<\/pre>\n
mo_global.set_policy_context(\u2018S\u2019,<org_id>);<\/pre>\n
\nThis procedure will set the access mode, and when applicable the current operating unit context.<\/p>\n
\nThis procedure determines if the application specified has multi-org access control enabled, by querying FND_MO_PRODUCT_INIT for the application short name. If this is enabled, and a security profile is specified (p_sp_id_char), then all orgs the user has access to will be populated in MO_GLOB_ORG_ACCESS_TMP. If there are more than one such org, the access method will be set to „Multiple”. Otherwise if no security profile id is specified, it will use the value of p_org_id to set the current operating unit value and set the access mode to „Single”.<\/p>\n
\nThe procedure used by the applications when starting a new session. Based on the profile options „MO: Operating Unit” (ORG_ID) and „MO: Security Profile” (XLA_MO_SECURITY_PROFILE_LEVEL), this procedure calls set_org_access to establish the multi-org context for the session. To call this from withing SQL, the profile option context should have been initialized for the session.<\/p>\n
\nReturns the current operating unit setting. This should be null if the access mode is not 'S’<\/p>\n
\nReturns the current access mode value.<\/p>\n11i<\/h2>\n
-- zmiana kontekstu organizacji --\r\n\r\nbegin\r\n\r\n apps.fnd_client_info.SET_ORG_CONTEXT('107');\r\n\r\nend;\r\n\r\n--ID organizacji mo\u017cna odczyta\u0107 z:\r\nselect * from hr_operating_units\r\nselect * from org_organization_definitions\r\n\r\ndeclare\r\n auser_name varchar2(50) := 'LUSER';\r\n aresponsibility_name varchar2(150) := 'XX-Dystrybucja';\r\n l_req_id number;\r\n auser_id number;\r\n aresponsibility_id number;\r\n aapplication_id number;\r\nbegin\r\n execute immediate 'ALTER SESSION SET NLS_LANGUAGE = POLISH';\r\n select user_id into auser_id from fnd_user where user_name = auser_name;\r\n select responsibility_id, application_id\r\n into aresponsibility_id, aapplication_id\r\n from fnd_responsibility_tl\r\n where language = userenv('lang')\r\n and upper(responsibility_name) like upper(aresponsibility_name);\r\n fnd_global.apps_initialize(auser_id, aresponsibility_id, aapplication_id);\r\n begin\r\n insert into fnd_sessions values (userenv('sessionid'), trunc(sysdate));\r\n exception\r\n when others then\r\n null;\r\n end;\r\n commit;\r\nend;<\/pre>\n","protected":false},"excerpt":{"rendered":"