Thursday 22 March 2012

How to set ORG ID in PL/SQL

11i
BEGIN
DBMS_APPLICATION_INFO.SET_CLIENT_INFO('ORG_ID');
END;

R12
BEGIN
MO_GLOBAL.SET_POLICY_CONTEXT('S',ORG_ID);
END;

for reference links use this ones

http://bansibaba.blogspot.in/2011/07/how-to-set-org-id-in-plsql.html
http://oracledollarschennai.blogspot.in/2008/07/flex-and-profiles.html

 http://souravpupu.blogspot.in/2011/08/how-to-enable-oracle-apps.html
 http://oracleinme.blogspot.in/2009/08/how-to-enable-personalization-link-for.html
http://oracle.anilpassi.com/personalization-link-does-not-appear-despite-setting-profile.html

 /OA_MEDIA/FNDSSCORP.gif
path to keep the image for report
for xml reports refer the below links
http://oracleapps88.blogspot.in/search/label/XMLP

IMP LINK FOR OAF AND ALL ORACLE OBJECTS
http://oracleapps88.blogspot.in/2011/09/oracle-apps-xml-reports-in-excel.html