Monday, October 28, 2013

R12: MO_GLOBAL replacing DBMS_APPLICATION_INFO

In the 11i application we would use the PL/SQL procedure to set our org_id:

begin dbms_application_info.set_client_info(&org_id); end;

With our brave new world of R12, we need to be using this to set our org_id information:

BEGIN MO_GLOBAL.SET_POLICY_CONTEXT('S',&org_id); END;
Which isn't a horrible thing, but my tip is that as a result you need to be granting execute permissions on FND_GLOBAL and MO_GLOBAL to non-system or non-standard users and roles that need to be able to run this.  If you don't do this, then you'll receive ORA-06550 or "PLS-00201: identifier 'MO_GLOBAL.SET_POLICY_CONTEXT' must be declared."

No comments:

Post a Comment