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:
  mo_global.set_policy_context('S', <orgID>);
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';

No comments:

Post a Comment