Multi-Instance to Single Instance Multi-Org
Date: Thu, 8 Jul 1999 19:07:43 -0700
From: Eric Lucas Elucas@constellar.com
Subject: Multi-Instance to Single Instance Multi-Org
Hi:
Has anyone combined multiple instances of the Apps into a single instance of
the Apps using Multi-Org? Anything close?
How about multiple sets of books into a single set of books, but multi-org?
If so, what kind of issues came up? How did you do the migration - did you
do it internally or contract it out? With who?
What would you advise to a company thinking of moving into a single,
multi-org instance from a more diverse environment?
Thanks!
Eric L. Lucas
Date: Fri, 9 Jul 1999 08:43:17 -0400
From: "Kamdar, Rita R, CFCTR" rkamdar@att.com
Subject: RE: Multi-Instance to Single Instance Multi-Org
Eric,
At my last company, we combined multiple installs
of 10.7 Apps(non multi org) into a single install with
Multi-Org.
A private consultant along with local develpoment team
did the job. Oracle came out to be tooooo expensive.
Rita
Date: Fri, 09 Jul 1999 13:42:50 GMT
From: "Joe Lichtefeld" j_lichtefeld@hotmail.com
Subject: Re: Multi-Instance to Single Instance Multi-Org
Late last year we migrated from multiple installs of 10.6 into a single
install of 10.7 and implemented Multi-org with a single org. We had three
sets of books under our old systems and moved all of these to a single book
in the 10.7 environment.
We has a number of issues with duplicate AP suppliers and sites across
each set of books. We also descided to bring all fixed assets items over
whether they were fully depreciated or not. Our other big area of concern
was the level of detail to bring over to the new instance.
We did it with a combination of internal and external help.
We felt that it was important to go to the single install because it makes
maintenance easier.
Multiple Legal entities
Date: Thu, 08 Jul 1999 21:13:33 EDT
From: "Mark Thomas" appsora@hotmail.com
Subject: Multi Org?????
Hello all,
I have two questions.
1) how do you attach 2 different set of books to 2 different
responsibilities?
2) how do you obtain only those legal entities corresponding to a particular
organization in multiorg? For example there are 3 legal entities (1,2,3)
assoiciated with multiorg A. Whenever i log into multiorg A i should be able
to get the three. What are the backend tables involved in this?
Any insight is greatly appreciated.
--Mark
Date: Fri, 9 Jul 1999 08:41:48 -0700
From: Manolas Mike -G14515 G14515@email.mot.com
Subject: RE: Multi Org?????
Multi-org
Re: attach 2 different set of books to 2 different responsibilities:
1. For each responsibility, assign the set of books at the in the
profile option setup.
2. Profile Option Name: GL Set of Books Name
3. Set it at the "responsibility" level
To limit certain entities to specific responsibilities:
1. Create a security rule on your entity segment
2. Include only the desired entities in the rule
3. Assign the security rule to your desired responsibility
Mike Manolas
Motorola Flat Panel Display Division
mike.manolas@motorola.com
AR Setup in MultiOrg
Date: Sat, 10 Jul 1999 11:28:37 -0400
From: "Bob Delaney" rdelaney@prodigy.net
Subject: AR: Multi Org Setup's
Does anyone have a list of AR set-up's that must be duplicated per operating
unit? I have reviewed the AR and MO user guides to no avail. I assumed
there would be a section on this like there was in PA, but no such luck.
My client wants to convert from a 10.7 GL/AR non-multi org environment to
multi-org to support a newly purchased business. Any insights or pointers
regarding this type of conversion would be also be greatly appreciated.
Thanks,
Bob Delaney
Principal Consultant
ISS, Inc
Date: Mon, 12 Jul 1999 11:31:19 +0530
From: rohit.sharma/Polaris@polaris.co.in
Subject: Re: AR: Multi Org Setup's
Hi Bob,
I hope the following steps you have to set up with each operating unit in A/R
set in
Multiy org
Rohit
E0 Step 1: Customize Your FlexBuilder (Required
E0 Step 2: Define Your Sales Tax Location Flexfield Structure (Requ
ired with
Defaults
E0 Step3: Define Your AutoInvoice Line Ordering Rules (Optional)
E0 Step 4: Define Your AutoInvoice Grouping Rules (Optional)
E0 Step 5: Define Your System Options (Required)
E0 Step 6: Define Your AutoAccounting (Required)
E0 Step 7: Define Your Transaction Types (Required with Defaults)
E0 Step 8: Define Your Invoice Sources (Required)
E0 Step 9: Define Your Adjustment Approval Limits (Required)
E0 Step 10: Define Your Distribution Sets (Optional)
E0 Step 11: Define Your Receipt Sources (Required)
E0 Step 12: Define Your Profile Options (Required)
E0 Step 13: Define Your Tax Codes and Rates (Required)
E0 Step 14: Define Your Customers (Required)
E0 Step 15: Define Your Remit-To Addresses (Required)
E0 Step 16: Define Your Customer Relationships (Optional)
E0 Step 17: Define Your Customer Banks (Optional)
E0 Step 18: Define Your Lockboxes (Optional)
E0 Step 19: Define Your Transmission Format (Optional)
E0 Step 20: Define Your Receipt Programs (Optional)
Step 21: Define Your Standard Memo Lines (Optional)
E0 Step 22: Define Your Item Tax Rate Exceptions (Optional)
E0 Step 23: Define Your Tax Exemptions (Optional)
E0 Step 24: Define Your Document Sequences (Optional)
Inventory Orgs and AR operating units
Date: Mon, 12 Jul 1999 19:49:15 -0400
From: "Bob Delaney" rdelaney@prodigy.net
To: "Ora Apps" OraApps-L@cpa.qc.ca
Cc: "Delaney, Bob (Home)" rdelaney@prodigy.net
Subject: MO: Inventory Org for AR Items
Hi Folks,
My client has implemented GL and AR (only) in a non-multi org 10.7 SC
environment and now wants to convert to MO. The target org structure is a
single set of books with multiple operating units. The only organization
they have currently defined is a single inventory org to support the
creation of item numbers for invoicing purposes - they have not and do not
plan on implementing inventory. The only "other" information specified for
the inventory org is the set of books, since no legal entities or operating
units are currently defined. The desire is to share the item numbers
between multiple AR operating units.
My question is: Can items currently defined using the single inventory org
be shared between different AR operating units?
If not, will an inventory org need to be defined for each operating unit and
items re-created?
Thanks in advance for any insights,
Bob Delaney
Principal Consultant
ISS, Inc
Date: Tue, 13 Jul 1999 11:48:23 -0700 (PDT)
From: Ravi Krishnamurthy ravi_krishna@rocketmail.com
Subject: Re: MO: Inventory Org for AR Items
Bob,
As long as you have the same set of books, the items which you define
in the inventory org will be seen by all the AR operating units. You
don't need to create seperate inventory orgs for each AR operating unit.
HTH.
Ravi K.
Conversion from single org to Multiorg
Date: Tue, 13 Jul 1999 14:00:37 +0530
From: Chandrashekar S SSChandra@inf.com
Subject: Info on conversion from Single-org to Multi-org
Hi All,
We have just upgraded from 10.7SC to R11. The modules
upgraded are PO, AP, GL & HR.
Now we are planning to shift from Single-org to Multi-org
structure. In all possibility we will be using 1 SOB and multiple
operating units, multiple Business Groups etc.....
For this scenario, can somebody suggest, what are all the steps
that we need to carry out ? Also do we need to replicate any
setups in the new oraganizations created ? How is the data from
the earlier Single organization handled ? If we want to divide this
data among the newly created Organizations, how should we proceed ?
Any inputs on the above would be greatly appreciated.
With Best Regards,
Chandrashekar.S
Date: Tue, 13 Jul 1999 02:15:03 PDT
From: "ravi chandran" johnny_ravi@hotmail.com
Subject: Re: Info on conversion from Single-org to Multi-org
chandra,
The syadministrtor must run the seed data replication report. specify
from which organisation your data must be replicated. The majority of
the setup will be replicated. But, certain setups you have to do in the new
ou
Ravi
Date: Tue, 13 Jul 1999 15:36:39 +0530
From: Chandrashekar S SSChandra@inf.com
Subject: RE: Info on conversion from Single-org to Multi-org
Hi Ravi,
We are looking for info regarding these "certain setups".
If you have any do forward the same.
Thanks for your inputs.
With Best Regards,
Chandrashekar.S
Date: Tue, 13 Jul 1999 04:24:41 -0700 (PDT)
From: Krishnakumar Narasihman chnkrishna@yahoo.com
Subject: RE: Reply:Info on conversion from Single-org to Multi-org
Dear Chandra,
in continuation of ravis input, i suggest you to go through the
documentation on Multi org setup steps which suggests the "Certain
Setup" Steps Module wise.
i hope you are aware that in multi org, AP,AR,Pur, OE needs setup for
every operating unit other than the seed data replication. pl.be aware
that before converting in to multi org, there are basic setup to done
at GL and INV and ADADMIN program had to be run. all these are spelt
out in detail in the multi org setup. all the best
nkrishnakumar
Move from Multiple SOB to MultiOrg by Disabling SOBs
Date: Thu, 29 Jul 1999 13:43:25 -0700
From: Barbara Douglass BDouglass@FairIsaac.com
Subject: Multi SOB's to Multi-org
Hi,
We are migrating from Multi SOB's to Multi-ORG. The migration path we
have decided to use is:
1)disable SOB 2..N using a script that Oracle provides
2)merge data into the primary SOB
3) setup our Multi-Org environment
4) Re-implement SOB 2..N into the Multi-Org environment.
Has anyone used the script provided by Oracle to disable sob's 2..N? Any
experience and feedback you
can share in regards to the Oracle script would be greatly appreciated.
Thanks,
Barbara
Barbara Douglass,
Financial Systems Designer
Mail Stop A13, Fair Isaac & Company
120 North Redwood Drive, San Rafael, CA 94309
Phone 415-492-5773 Fax 415-444-5033
email bdouglass@FairIsaac.com
Date: Thu, 29 Jul 1999 23:10:36 GMT
From: "Ananth Swaminath" ananth999@hotmail.com
Subject: Reply: Multi SOB's to Multi-org
Hi Barbara
Are you on a multiple database scenario? If so, I would suggest you re-check
with Oracle Support whether their scripts will support such a scenario. To
my mind, I don't think it does - but do check this out.
The disabling scripts basically do this:
1. They allow you to shut off access to the non-primary product installation
groups. After the scripts have been run you can either
convert to Multi-Org or upgrade in a single product installation group from
that point.
2. The product installation groups still exist. The scripts do NOT delete
them. This therefore will allow you to use query tools such as Discoverer to
"view" information in the non-primary product groups. However, you will lose
application level inquiry. I think you will also lose drill down capability.
I would suggest that you back up your MSOB environment prior to running the
disabling scripts.
3. Another aspect you may want to clarify is whether you can use the
disabling scripts if you "need" the existing data in your NON-primary
product installation groups. This will help to determine whether you require
any conversion effort of historical/transaction data. If so, it adds to the
complication. Another approcah will be to preserve your MSOB architecture as
such - for inquiry purposes.
4. Also bear in mind that the application will be off-line during the
mogration. The time involved will depend upon the size and complexity of
your database.
5. Reconfirm Oracle's support to this tool. They simply have to support you
right through. Till you get back online.
6. Just a thought - have you considered re-implementing under a multi-org
environment?
Hope this helps.
Ananth
Senior Applications Consultant
Date: Fri, 30 Jul 1999 08:37:01 -0700
From: Barbara Douglass BDouglass@FairIsaac.com
Subject: RE: Reply: Multi SOB's to Multi-org
Thank you so much for your reply.
To answer your questions, the reason we have chosen this migration path is
that 1) the entire db is only 22 GB, 2) the largest number of open
transactions in SOB 2..N, for (AP, AR, & GL), is like 300 and is in only
one sob's - the other's have like 44 3) we are going to make a backup of our
current Multi-SOB env. and keep online for inquiry only.
We see our biggest task - 1) Merging the data from SOB 2..N into the primary
SOB 2) setting up Multi-Org, 3) Re-Implementing SOB 2..N into the Multi-Org
env.
These tasks are key, but are relatively straight forward (we think). We
will definitely get support from Oracle for the disabling script - but have
you by chance had experience running this script? I was just wondering what
if any would be trouble spots or "show stoppers".
Thanks for your help,
Barbara
Date: Fri, 30 Jul 1999 20:39:39 GMT
From: "Ananth Swaminath" ananth999@hotmail.com
Subject: Reply(2): Multi SOB's to Multi-org
Hi Barbara
From what you have described, there don't seem to be too many issues as
such. The primary problem with the scripts is that they don't function on
multiple databases. And if that isn't an issue, then I don't think you
should have a problem.
You seem to have thought of the correct thing to do - backing up your MSOB
environment. That is an essential step.
With regard to the vital tasks involved, a few issues you may need to
consider are:
- All operating units in the Multi-org instance must be configured correctly
BEFORE migration starts.
- Do note that this task involves a re-analysis of your business. For
besides possessing a very different technical architecture (MSOB vs MO), the
manner in which the two are configured are essentially different.
- Also analyse the functional processes that were supported on MSOB but are
not in a Multi-org environment. And then analyse their imapct on your
business.
- There is no quick fix migration approach. It depends upon your business
case.
- The conversion process actually runs the ADADMIN feature. All this process
does is to populate the multi-org enabled applications with a new column
called Org_ID. (Note that this is distinct from the Organisation_ID column).
Further it replicates seed data for operating units.
A few important areas you must note are:
- Are there any customisations in your current setup?
- Have you then documented these customisations/interfaces?
- Have you considered all aspects of data security, financial reporting,
and historical reporting?
- Analyse and document the existing database layout.
- Have you identified the primary key/foreign key relationships in your
existing setup? This will prove to be a veritable task actually. I would
suggest you speak with Support on this issue.
- By storing data in a single table from multiple tables, are you losing
something out somewhere?
Barbara - all I aiming at over here is provide you some inputs on how you
could approach the matter at hand. I am by no means an expert at this and
hence these are just a few thougts hoping that they may be of some help to
you.
Cheers
Ananth
Senior Applications Consultant