February 3rd, 2009
For those of you who are trying to set the organization context within your SQL sessions or custom programs, there’s a new API you must call in R12.
The previous way of setting organization context in 11i was to execute the following statement:
However, in R12, the new way of setting the organization context is as follows:
The â€˜S’ parameter indicates a single organization context. Replace ORG_ID with the ID of the operating unit you wish to use. You can also set a context for multiple operating units by setting the security profile. This is done by executing the following statement:
Replace SECURITY_PROFILE_ID with the ID of the appropriate security profile. ‘ASO’ represents the application short name associated with the responsibility you’ll be using.