Can anybody suggest me how can the multi org. be set up?

Showing Answers 1 - 9 of 9 Answers

padmaja

  • Dec 23rd, 2005
 

We can do the  multi org set up with this command like

begin

fnd_client_info.set_org_context(204);

end;

Run this package then u will get the output.

Anand

  • Jan 2nd, 2006
 

begin
  fnd_global.apps_initialize(user_id,resp_id,resp_appl_id);
end;

  Was this answer useful?  Yes

Vinodh Boyapati

  • Jan 19th, 2006
 

begin

dbms_application_info.set_client_info('ORG_ID');

end;

  Was this answer useful?  Yes

Ramesh S

  • Apr 11th, 2006
 

Hi ,

Even the following command can also be used :)

Begin Fnd_client_info.set_org_context(<Org_id>); End;

Thnx

Ram

  Was this answer useful?  Yes

Suan

  • Jul 3rd, 2006
 

BEGIN

FND_GLOBAL.APPS_INITIALIZE(user_id,resp_id,resp_appl_id);

END;

  Was this answer useful?  Yes

Ejaz

  • Aug 3rd, 2006
 

Hi,

above answers are about initializing the multi-org and not setup.

Multi-Org can be setup/installed by adadmin utility provided by the Oracle. adadmin will create the _ALL table and appropriate views (single org views) which can then be used to view the data for specific operating unit to which your user/responsibility has access to!

thanks

ramesh

  • Apr 19th, 2012
 

Code
  1. SELECT COUNT(*) FROM PO_HEADERS_ALL  --OUTPUT =10835

  2. SELECT COUNT(*) FROM PO_HEADERS  --OUTPUT = 0


Code
  1. DECLARE

  2. V_ORG_ID NUMBER :=FND_PROFILE.VALUE(ORG_ID);

  3. BEGIN

  4. APPS.FND_CLIENT_INFO.SET_ORG_CONTEXT(V_ORG_ID);

  5. END;

  6.  


Code
  1. SELECT COUNT(*) FROM PO_HEADERS  --OUTPUT = 2643  

  Was this answer useful?  Yes

bala koti reddy

  • Feb 21st, 2013
 

In R12

begin
mo_global.set_policy_context(s,orgid);
end;

  Was this answer useful?  Yes

I am Sridevi Koduru, Oracle Apps Techno Functional Faculty with 5+ Years Training Experience on Oracle Apps Technical, Oracle Apps Functional, SQL, PL/SQL and D2K including 3+ Years of Real Time Experience. I have Provided Training for 500+ Professionals Most of them are Working in Real Time now.

Contact Me for Offline and Online Training on Oracle Apps Technical, Oracle Apps Functional, SQL, PL/SQL and D2K at sridevioracleapps@gmail.com | +91-9581017828 | http://www.oracleappstechnical.com

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions