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.
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.
Этот комментарий был удален автором.
ОтветитьУдалить