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