понедельник, 23 июля 2012 г.

Инициализация переменных окружения

begin
dbms_application_info.set_client_info(102);
apps.fnd_client_info.set_org_context(102);
fnd_global.apps_initialize(user_id=>1670,resp_id=> 20678,resp_appl_id=>222); -- conversion,Receivable Manager
dbms_output.put_line(fnd_global.org_id);
end;
/

The USERENV('CLIENT_INFO') is a database session info. Oracle Apps
specificly uses it to know what operating unit (multiorg) you are in (when you
change responsibilities).

Every multiorg view in Oracle Apps will have where-clause to compare your
current operating unit, which is USERENV('CLIENT_INFO') , to ORG_ID in the
base table. 

1 комментарий: