Friday, January 8, 2010

Setting Organization Context in Oracle R12 and 11i

Release 12

BEGIN
apps.mo_global.set_policy_context ('S', org_id_value);
END;

11i Releases

BEGIN
DBMS_APPLICATION_INFO.set_client_info (client_info => 'org_id_value');
END;
--------------- or----------
BEGIN
fnd_global.initialize (NAME => 'ORG_ID', VALUE => 'org_id_value');
END;

Meaning of table's suffix


1 comment:

  1. Regards
    Sridevi Koduru (Senior Oracle Apps Trainer Oracleappstechnical.com)
    LinkedIn profile - https://in.linkedin.com/in/sridevi-koduru-9b876a8b
    Please Contact for One to One Online Training on Oracle Apps Technical, Financials, SCM, SQL, PL/SQL, D2K at training@oracleappstechnical.com | +91 - 9581017828.

    ReplyDelete