Well, it depends. Generally speaking, Oracle provides capabilities to integrate approvals within your business process. However, depending on the module and transaction these capabilities can vary. As an Order to Cash expert, I want to bring some clarity to what the out-of-the-box approval capabilities are within the Quoting and Order Management modules, then go into some of the enhancements I’ve implemented in the past to improve the functionality in some of these areas.
Continue Reading February 19th, 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:
dbms_application_info.set_client_info(ORG_ID);
However, in R12, the new way of setting the organization context is as follows:
mo_global.init(’AR’);
mo_global.set_policy_context(’S',ORG_ID);
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:
mo_global.set_org_access(NULL,SECURITY_PROFILE_ID,’ASO’);
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.
February 3rd, 2009
