ORACLE APPLICATIONS ARCHIVES

Topicwise collection of
Postings on Mail Lists
ON
MULTI ORG



Inventory Setup Problem

Date: Fri, 11 Jun 1999 18:08:20 -0700 (PDT)
From: siddhartha nandi sid_nandi@yahoo.com
Subject: Multi-org Inventory Set-up Problem

Hi,

I am setting up Inventory for Multi-org. I already defined Set-of-books, Legal Entities,Operatiing Unit,Inv. Org. Everything looks fine. But in Define Location I can't see inventory org.

Appreciate your help.
Thanks,
Sid Nandi
Sr. Principal Consultant
Millennia Vision Corporation
Snandi@mvsn.com
650-232-6330 (230)


Date: Mon, 14 Jun 1999 07:56:12 +0800
From: "Gracia Becongco" Gracia.Becongco@tip.toshiba.co.jp
Subject: Re: Multi-org Inventory Set-up Problem

have you defined the subinventories for each of the orgs???



Setup Validation Report

Date: Wed, 7 Jul 1999 09:54:13 +0200
From: =?iso-8859-1?Q?Mar=EDa_Aranzazu_Beascoa_Alzola?= mba@nekkar.es
Subject: Multi-org

Hi all,

we are setting up a multi-org environment, but when we want to run the Setup Validation report , it ends with error. Any ideas would be appreciated,

Thanks in advance
arantza beascoa
e-mail: mba@nekkar.es
Tlf directo: 91 523 97 29


Date: Wed, 7 Jul 1999 14:53:57 -0400
From: Melanie Jubinville Melanie.Jubinville@future.ca
Subject: RE: Multi-org

Did you run the Replicate Seed Data ?


Date: Thu, 8 Jul 1999 08:42:52 +0200
From: =?iso-8859-1?Q?Mar=EDa_Aranzazu_Beascoa_Alzola?= mba@nekkar.es
Subject: RE: Multi-org

Yes, we did, and it ended OK.

arantza beascoa
e-mail: mba@nekkar.es
Tlf directo: 91 523 97 29



Converging transactions from multiple instances to one instance in Multiorg structure

Date: Tue, 13 Jul 1999 20:24:19 -0700
From: "Welter, Ed" Ed.Welter@nike.com
Subject: Multi-Org: Converging history

Has anyone tackled trying to bring all transactions (historical and open) from multiple organizations in separate instances into a single instance multi-org structure? Since the open interfaces do not handle historical transactions has anyone built templates via some tool, built convergence scripts, etc? I would assume these would have to be written directly to the tables...Is there another way? We feel that it is a very high risk effort to orchestrate it in the proper order without leaving something out or changing the data somehow. Leaving the historical transactions behind is an option for us. Nor is separating them into something else a feasability at this point.

Any thoughts?
Thanks,
Ed Welter
Nike Inc.


Addition of an Org of a different country

Date: Thu, 12 Aug 1999 15:01:59 -0700 (PDT)
From: Siddharth Shah shahsd@yahoo.com
Subject: Multi-Org Experts!!!

Hi Forum,

I have a client who is already live on Oracle Apps 10.7. The multi-org feature is enabled. Now the client wishes to include another org. This org is based in another country (Ecuador). The questions that I have are:

1. Do we have to run the multi-org program again from the adadmin utility. The new org will have its own set of books, calendar and currency. The SOB will be consolidated into the US SOB.

2. The Ecuador folks want to see their forms in Spanish. Can we turn the NLS on for a single org. How should we do it?

3. The Ecuador currency fluctuates like anything. Last year alone it has depreciated by 50%. How do we handle such a situation.

I would appreciate your help in this matter. Thank you in advance.

Siddharth Shah


Date: Thu, 12 Aug 1999 20:10:49 -0400 (EDT)
From: Madhu Sudan Dada dada@csee.usf.edu
Subject: Re: Multi-Org Experts!!!

Hi,
You donot have to enable the multi org feature again. They have to just create another org and see that replicate seed data run properly.

Madhu Sudan Dada
Independent Consultant & Former Ora. Support Specialist.


Date: Fri, 13 Aug 1999 07:51:33 GMT
From: "Ananth Swaminath" ananth999@hotmail.com
Subject: Reply: Multi-Org Experts!!!

Siddharth:

1. Creation of a new operating unit requires the replication of seed data for that particualar organisation in cases of an existing multi-org installation. You can run ADADMIN manually if the process doesn't trigger itself automatically.

2. I am not too sure of the second question - whether forms can be viewed in a different language for any particular operating unit. I can check this out though. Give me a few on this one.

3. MRC is not enabled in Release 10.7. So you will not be able to view transactional detail in multiple currencies relatime. However, you can consolidate detail transactions periodically into USD and ensure management reporting.

I recommend that you explore the possibility of an upgrade to Release 11!!

Hope this helped. However, if you do have any other particular questions, do get in touch.

Ananth Senior Applications Consultant


Date: Fri, 13 Aug 1999 04:31:35 -0400
From: sbradley@sprynet.com
Subject: RE: Multi-Org Experts

You will need to run the "Replicate Seed Data" program after you set up your second Org.

It sounds like you need MRC (Multiple Reporting Currencies). One set of books for Ecuador and the other for your reporting currency. If the reporting currency is USD then FASB 52 will mandate USD as the functional currency. The only way to have 2 functional currencies is with MRC.

Oracle has the ability to inflate your assets and handle other hyperinflationary issues.

Respectfully,
Steve Bradley, CPA
OASIS Consulting Group, Inc.
Office 404-352-8387
Fax 404-609-9856
Pager 888-912-2569



MultiOrg White Paper

From: "Sumit Sen" sens_sumit@hotmail.com
Subject: Multi Org white paper
Date: Fri, 13 Aug 1999 01:55:26 GMT

Dear All

Could anyone let me know as to where I can find a good writeup on Multi-org and its features.

Thanks in advance.
Sumit


Date: Fri, 13 Aug 1999 12:08:20 PDT
From: "Lakshmi Viswanath" lviswanath@hotmail.com
Subject: Re:Multi Org white paper

Sumit, Check out http://www.orafaq.org/faqapps.htm


How to turn on NLS for Ecuador based Org using Spanish

Date: Fri, 13 Aug 1999 14:20:11 -0700 (PDT)
From: Siddharth Shah shahsd@yahoo.com
Subject: NLS Question!

Hi,

My client is up and running on 10.7 with multi-org feature on. Now they want to add another org (based in another country--Ecuador). The language that is used in Ecuador is Spanish. Can we turn on the NLS for that new org. If yes,how can we do it? Or else, what is the workaround for this?

Thank you in advance.
Siddharth
===
Sincerely,
Siddharth Shah



HRMS with MultiOrg Apps

From: "Groeneveld, Ronald" Ronald_Groeneveld@bmc.com
Date : 17th August 1999
Subject: HRMS with MultiOrg apps

Hello,

We are running Oracle Financials 11.0.2 with OHRMS installed. We have implemented AP & GL installations throughout the world and would like to see if/how we can (re-)setup our OHRMS to facilitate proper global HR functionality and Payroll with the apps.

Any suggestions on where to start?

Ciao,
Ronald
BMC Software
Manager Business Applications
+31(30)608-5500 (phone)
+31(30)600-0277 (fax)
Ronald_Groeneveld@bmc.com
Ronald.Groeneveld@usa.net


Organization - create a new

From: arindam.sarkar@in.pwcglobal.com
Reply-To: oraapps-l@cpa.qc.ca
To: Multiple recipients of list oraapps-l@cpa.qc.ca
Date: Mon, 23 Aug 1999 05:27:46 -0400 (EDT)

Hi,
We are using Oracle Release 11.0.1 on Sun OS. We have not installed multi org patch. Oracle purchasing is installed in share mode. When I am trying to query the default oracle business group ie "Setup Business Group" from the Organisation screen, query returns no data. Even when I am trying to create a new organisation, it is not allowing me to do so. Funny part is in the "HR:Business group" profile option "Setup Business Group" is defaulting at the site level.

Data for "Setup Business Group" exits in the HR_ALL_ORGANIZATION_UNITS. Can anybody tell me whether I have to setup some profile option so that I am able to create organisation??....

regards
arindam


Date: Mon, 23 Aug 1999 15:46:14 PDT
From: "Prasanna Kumar Jena" pk_jena@hotmail.com
To: oraapps-l@cpa.qc.ca
Subject: Organization

Hi,
Release 10.7 onwards is Multi-Org enabled. I think there is no need to run a Multi-Org patch.

Each responsibility is attached to an Operating Unit. Check the Operating Unit of your concerned responsibility. The Profile Option to check so is
MO: Operating Unit
Perhaps your OU is attached to some other Business Group. So you can not see the site level Business Group when you query.
The Profile Option to check is
HR:Business Group
Just check that the Operating Unit of your responsibility is attached to the Business Group you want to query.

Prasanna Jena


Date: Tue, 24 Aug 1999 09:44:58 +0530
From: arindam.sarkar@in.pwcglobal.com
To: oraapps-l@cpa.qc.ca
Subject: Re: Organization

Hi,
Unfortunately I cannot define any operating unit from the Organisation setup screen. So no value on the LOV is coming when I am trying to set the profile option MO:Operating Unit for the Oracle Payables responsibility.

ari.


Date: Mon, 23 Aug 1999 21:54:14 PDT
From: "ravi chandran" johnny_ravi@hotmail.com
To: oraapps-l@cpa.qc.ca
Subject: Re: Organization

Ari,
following are the steps you must follow for a multi-org setup:

1). Finalise with the client the organization structure( Set of books, legal entity, inventory org etc.)
2). In the organization setup define an organization.
3). In the profile MO:operating unit this organization will come as a pick.
4). Do the basic setups for other modules.
5). Run the seed data replication in the sysadmin module.
6). Define all other organizations and attach them in the respective responsibilties.

I have given u a brief only. The sequential steps are clearly given in the document.

Ravi


Date: Tue, 24 Aug 1999 10:37:16 +0530
From: arindam.sarkar@in.pwcglobal.com
To: oraapps-l@cpa.qc.ca
Subject: Re: Organization

Ravi,
Thanks for the reply. But the problem I am facing is
1in the Organisation screen itself the system is not letting me define a new organisation. so as a result I am unable to create a operating unit and inventory org.
2the default oracle predefined "Setup Business group" is not defaulting on this screen on query.
So the steps you mentioned becomes redundant. Any further help will be highly appreciated.
regards ari.


Date: Tue, 24 Aug 1999 09:11:25 EDT
From: "Senthil Anand" sa272@hotmail.com
To: oraapps-l@cpa.qc.ca
Subject: Re: Organization

hi ari,

Try these steps to create in following the orders

SOB, Hr profile,Location, Organization, Business group, Legal entity, assign business groupto site and responsibility level and Operating units.

You will succeed.

1. Set up one SOB.

2. You have to set the profile option: HR: User Type to User for your new responsibility before you do the Organization set up.

3. Create One Location especially for the Organization which you intended to create the Business Group.

4. Create an Organization with the above location and save the changes.

5. Create a new Business group, Other than the Setup Business Group and Enter a Short name for the business group. (You can Enter Directly) Thatshould be the first option in the Organization classification region

6. Now Create a legal entity, In the organization classification region.We set the organization to Legal Entity and In the legal entity accountingflexfield enter your set of book name and save the information.

7. Set the values in the profile option region to your responsibilityand site level with the new business group name. The name will be appearingin the LOV by now.(if not re-login and see).

8. After the above steps create a new location other than the one you assigned to the business group ( Do not use the same location it may give aproblem)

9. Create a new organization and attach the new location.

10. Now , create the Operation units in the organization classification zone.

11 Then create Inventory Organisation - SOB, LE, OU will default

Check the steps .. thats the catch.. Morover the steps has to be built based on ur org. hierarchy modelled.

Things should work Senthil



Adding a company segment

Date: Tue, 31 Aug 1999 13:11:09 -0700 (PDT)
From: Siddharth Shah shahsd@yahoo.com
To: oraapps-l@cpa.qc.ca
Subject: Multi-Org question!

Hi All,

I have a client which has a Legal Entity with one Balancing Segment value, for ex 01. Now they want to add another segement value (company) i.e 02 with its own set of account values. The question is, do the folks who are assigned to 02 have to see all the vendor and vendor sites or do they just see the vendor and can setup new vendor sites specific to their company.

Please help if you can.

Thank you.
Siddharth


Vendor info across orgs

Date: Tue, 31 Aug 1999 19:26:03 -0700 (PDT)
From: Siddharth Shah shahsd@yahoo.com
To: oraapps-l@cpa.qc.ca
Subject: MultiOrg Query!

Forum,

I am at a client site which is up on Oracle Apps 10.7 They want to add another operating unit. They already have a legal entity and an operating unit tied to it. This new operating unit was also be tied to this legal entity. The question is:

1. Vendor Information -- Is this info shared across operating units at header level only or both at header and site level .

Kindly help.
Thank you.
Siddharth Shah


Date: Tue, 31 Aug 1999 21:27:21 PDT
From: "ravi chandran" johnny_ravi@hotmail.com
To: oraapps-l@cpa.qc.ca
Subject: Re: MultiOrg Query!

Hi,

vendor information is shared across organization at header level only. You have to create the site in each org & activate it.


Date: Wed, 1 Sep 1999 08:37:46 +0200
From: Gorre Richard GorreR@fnherstal.com
To: "'oraapps-l@cpa.qc.ca'" oraapps-l@cpa.qc.ca
Subject: RE: Multi-Org question!

Siddharth

If you need separate account values, you must define a new SOB a new LE, OU,etc..

The vendors an suppliers header information are shared, but site and adresses are OU dependent.

Richard


Date: Wed, 1 Sep 1999 08:43:29 +0200
From: Gorre Richard GorreR@fnherstal.com
To: "'oraapps-l@cpa.qc.ca'" oraapps-l@cpa.qc.ca
Subject: RE: MultiOrg Query!

Just header level
richard


Date: Wed, 1 Sep 1999 08:03:32 -0400
From: "Mitesh Patel" miteshp@mastech.com
To: oraapps-l@cpa.qc.ca
Subject: Re: MultiOrg Query!

Siddharth,

Vendor information is shared at header level only. Same things is true for Customers in AR module.

Mitesh Patel.


Date: Thu, 2 Sep 1999 11:55:57 -0400
From: Melanie Jubinville Melanie.Jubinville@future.ca
To: "'oraapps-l@cpa.qc.ca'" oraapps-l@cpa.qc.ca
Subject: RE: Another Multi-Org Question!

You will be able to see the Vendor Header across all operating units regardless of the SOB. But you will not be able to see the Vendor Sites because these are not shared, they are specific to the operating unit where they were created.

Melanie Jubinville
Financial System Analyst
Future Electronics Montreal
514-694-7710 ext.2059


Date: Thu, 02 Sep 1999 15:43:06 -0700
From: GALAIAH NEELAKANTI ramadevi@prodigy.net
To: oraapps-l@cpa.qc.ca
Subject: Re: Another Multi-Org Question!

Vendors & Customers are global in multi-org implementation. Vendor sites & Customer addresses are specific to each operating unit. So when you define a vendor or customer, those vendors and customers are visible across all operating units. Only header information is global not specific site or address. So it's a normal feature and it will not harm you. Any way in each OU, You'll have to pick a Vendor site or Customer address to do transactions. Even though the Vendor or Customer information is visible globally, you will have to define Vendor sites and Customer addresses at operating unit level. Even if the sites and addresses are same for two operating units, you will have to define them twice for that two operating units. I hope your problem is addressed.

Galaiah Neelakanti


Date: Fri, 3 Sep 1999 08:06:17 +0200
From: Gorre Richard GorreR@fnherstal.com
To: "'oraapps-l@cpa.qc.ca'" oraapps-l@cpa.qc.ca
Subject: RE: Another Multi-Org Question!

Siddharth

Many of us explained that Customer & Supplier Header are share in Multi org. Only site and adresses are OU dependant.

But in one specific responsability, link to a OU ans to a LE and to a SOB, when you record transaction, of course you can select the "wrong" customer, but at the step further, you will se that nothing is defined for your legal entity and the system will refuse to go further. The security is there,but only at second step.

Richard



Access of Orgs - Query 2

Date: Wed, 1 Sep 1999 08:24:54 -0400
From: "Solomon, Jim" Jim.Solomon@axiohm.com
To: "'OraApps-L@cpa.qc.ca'" OraApps-L@cpa.qc.ca
Subject: Multi - Org Question

I have a question regarding multi-org (10.7 SC Character), and I would really appreciate any assistance.

We have just gone multi-org. We now have a Master Org, an "I" org, and a "C" org. The "C" org is the new one, and they reside at a different site. Now that we are multi-org, when users get in to Oracle Manufacturing, all orgs. pop up in the quickpick window. Already, users have "accidently" selected the wrong org.

We have gone to the Organization Access form and tried to limit org's by responsibility. We can't get it to work both ways.

We don't want users in "C" org to be able to get into "I" org, and vice versa.

Can anyone help us? Management is getting very concerned, so we need to do something quickly.

Thanks.


Date: Wed, 1 Sep 1999 07:06:03 -0700
From: CFowler@littonapd.com
To: oraapps-l@cpa.qc.ca
Subject: RE: Multi - Org Question

Hi,

You can create different responsibilities for each organization and give each responsibility only access to either "C" or "I" organization, but not both. That will prevent them from accidentally transacting in the wrong organization.

HTH
Candace


Date: Wed, 01 Sep 1999 16:26:09 +0200
From: "Daniel Mehaignerie" daniel.mehaignerie@esfrance.com
To: oraapps-l@cpa.qc.ca
Subject: Re: Multi - Org Question

Jim,

You seem to be confusing Inventory Organisations and Operating Units. You assign an operating unit to a user by setting the MO: Operating Unit profile option (this should be done at site and responsability level). There is no possibility of changing organisations without changing responsability. To go "multiorg" usually refers to operating units.

You can avoid users getting confused on the inventory orgs by choosing an adequate name for your orgs.

hope this helps

Daniel Mehaignerie
Oracle Applications Consultant


Date: Wed, 01 Sep 1999 07:36:20 PDT
From: "ravi chandran" johnny_ravi@hotmail.com
To: oraapps-l@cpa.qc.ca
Subject: Re: Multi - Org Question

jim,

the hierarchial structure of an organization is Set of books, legal entity, operating unit and inventory org. The responsibilities are controlled at MO:Operating unit level. Under an OU there can be many inv org and they will come as a pick. Plan your structure if you want only one org under one OU

Ravi



AR Customers how link to Multiple Orgs

Date: Tue, 7 Sep 1999 09:02:18 -0500
From: Cheryl_Moore@huntsman.com
To: Multiple recipients of list oraapps-l@cpa.qc.ca
Subject: AR - Multi Org

We are currently on 10.7 character and will have 3 or more orgs. How are customer sites connected to Orgs? How will the user know the customer they are selecting is within the correct org? Is it merely a matter of which org they logged into?

Thanks!
Cheryl Moore
Ph: 713-235-6193
pgr: 800-391-6124
e-mail cheryl_moore@huntsman.com


Date: Tue, 7 Sep 1999 09:08:20 -0500
From: Tom Wyatt tom.wyatt@sitel.com
To: "'oraapps-l@cpa.qc.ca'" oraapps-l@cpa.qc.ca
Subject: RE: AR - Multi Org

Through system profiles, you will connect each responsibility to their respective organizations. However, when you speak of customer sites, they will change depending upon the Operating Unit (org_id) that your responsibility is connected too.


Date: Tue, 7 Sep 1999 16:19:07 +0200
From: Gorre Richard GorreR@fnherstal.com
To: "'oraapps-l@cpa.qc.ca'" oraapps-l@cpa.qc.ca
Subject: RE: AR - Multi Org

Customer sites are defined in your AR or OE modules. These module are set up at Operating unit level.

If yours 3 org are belonging to the same OU you do not have any problem.

At OE recording, you can select a customer # without site for your OU, but when you have to define the ship to, the system will block you.

In your Order you have to define the ship from organization (Attention, you can define a org which belong to a other OU; in this case the Intercompany sales is available see multiorg documentation; it works).

Richard Gorr
Tel 32 4 240 88 37


Date: Wed, 8 Sep 1999 21:05:58 +0300
From: Nasir Valiya Valiya@NGHA.MED.SA
To: oraapps-l@cpa.qc.ca
Subject: RE: AR - Multi Org

When you define any new Org in your AR you have to define the customer sites in those new Organization. Only Sites defined in the organization is available for transaction in that organization.

You can add new sites to your existing Customers or if new customer, add customer and sites.

Customer sites are not shared across organizations.
While selecting a sight they can select the sites in the organization attached to there responsibly only.


Date: Wed, 8 Sep 1999 09:29:54 +0300
From: Mohammad Fouwaaz Mfouwaaz@savola.com
To: oraapps-l@cpa.qc.ca
Subject: RE: AR - Multi Org

Hi

Customers are at the global level -- hence they are visible across all operating units. However, the customers' addresses and their sites (BILL_TO, SHIP_TO, etc.) are defined at the operating-unit level (as you rightly stated, it is determined by the log-in responsibility). If an address/site is not defined for a particular organization, then a user would not be able to see the address/site although he may select such a customer. Hope this answers your question.

Regards


Date: Wed, 8 Sep 1999 09:13:31 -0700 (PDT)
From: Ajay Alur ajayall@yahoo.com
To: oraapps-l@cpa.qc.ca
Subject: Re: AR - Multi Org

Cheryl,
Customers are global entities. A customer can have addresses across the globe. Hence Sites are multi org based. When a user has logged on, based on the MO:Operating unit - profile option, only sites created within this particular org will showup wherever reqd. Most of the forms have the org name displayed in the form title. I am not sure how it works on character based apps.
Hope this helps
Ajay


Date: Wed, 8 Sep 1999 19:11:38 +0200
From: Gorre Richard GorreR@fnherstal.com
To: "'oraapps-l@cpa.qc.ca'" oraapps-l@cpa.qc.ca
Subject: RE: AR - Multi Org

Nasir

When you add a new inventory org, this inv org is linked to a OU and your customrers sites too

Is it clear ?

Richard Gorr
Tel 32 4 240 88 37


Match Revenue and CoS at Org Level

Date: Thu, 9 Sep 1999 23:54:27 EDT
From: Bhanupd@aol.com
To: oraapps-l@cpa.qc.ca
Subject: (no subject)

Hello Financial experts,

IHAC, that has the following problem. I appreciate if any one can shed some light on this.

PROBLEM:
1. Client has an organizational design with a single Operating Unit that has multiple orgs which ship to and serve different markets.

2. He wishes to match and track Revenues and Cost of Sales at the Org level.

3. It is easy to drive Cost of Sales to their Org-level ledger accounts but

4. It has proved very daunting to get revenues to their corresponding Org level ledger accounts.

I appreciate any help in this matter. Please send your responses directly to me.

Thanks a bunch,
Bhanu


Date: Fri, 10 Sep 1999 08:15:52 -0500
From: "Severtson, Anne" amsevertson@sbec.com
To: "'oraapps-l@cpa.qc.ca'" oraapps-l@cpa.qc.ca
Subject: RE: (no subject)

Bhanu,
We used separate order types in OE and transaction types in AR. By linking these two, we got the AR AutoAccounting to reference a different org.

We also had a few "exceptions" as always. We added a script which ran after the orders were sent to the RA Interface table, which looked at order types, and a few other items and changed the accounting in the interface tables. This way it was not "custom" but a separate script.

Anne