Tuesday, August 23, 2011

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';

1 comment:

  1. Excellent article. Very interesting to read. I really love to read such a nice article. Thanks! keep rocking.
    Oracle SOA Online Training

    ReplyDelete

javascript:void(0)