Set MOAC context (R12)

To set the MOAC (Multiorg Access Control) context in your database session (SQL*PLUS, TOAD, SQL Developer etc) use:

begin
  mo_global.set_policy_context('S', <orgID>);
end;

When policy context is set to M (Multi), data from all accessible Operating Units will be returned. When policy context is set to S (Single), then only data from the specified org_id will be returned.

Set language:

alter session set nls_language = 'SWEDISH';