SOS on operating Units
Date: Fri, 19 Mar 1999 10:04:28 -800
Please let me know if multiple operating unit can share an inventory org (warehouse/stocking
location).
Also let me know about possible problems with having many operating units under
one set of books (like each inventory organization can be defined as an operating
unit also).
Thanks in advance.
Sushi
INV:Multi org
Date: Fri, 19 Mar 1999 13:35:48 EDT
Hi all
1. In a multi org setup can I attach one Inventory Organization to multiple operating units. I understand that conceptually this is what multi-org is ?
But we are unable to do so in the system. Any help.
thanks
venkat
Date: Fri, 19 Mar 1999 14:56:54 EST
Why would you want to attach one inventory organizations to multiple
organiazations. This is not what multi-org is intending to accomplish.
Please explain why you are doing this.
It sounds like the two operating units are really one operating unit.
Thanks,
David
ORG_ID
From: DINESH CHANDRA [SMTP:dchandra@usa.net]
Date: Fri, 19 Mar 1999 01:18:50 -0500 Setup
Date: Fri, 26 Mar 1999 13:50:27 +0800
Date: Fri, 26 Mar 1999 11:40:14 +0530
Date: Fri, 26 Mar 1999 07:45:30 -0600
Date: Fri, 26 Mar 1999 10:58:02 -0500
Date: Fri, 26 Mar 1999 16:18:00 -0000 GL shifting to MultiOrg
From: DIPANKAR BASU [mailto:dipankar_99@yahoo.com]
Date: Sun, 28 Mar 1999 17:38:27 -0500 (EST)
--- "Logan, Ernie" Ernie_Logan@bmc.com wrote: Timestamp for Multi-Org
From: Ismert, Michael K. [SMTP:mismert@ecs-its.com]
Date: Thu, 8 Apr 1999 08:33:56 +0100 Access issues
Date: Tue, 20 Apr 1999 13:27:00 -0700 (PDT)
Date: Tue, 20 Apr 1999 13:41:51 PDT
Date: Tue, 20 Apr 1999 16:14:46 -0700 (PDT) No. of SOBs
Ahmed Abd El Sattar asattar@oratech-eg.com on 27-04-99 03:05:01 PM
Date: Tue, 27 Apr 1999 16:45:06 +0530
Date: Tue, 27 Apr 1999 16:55:26 +0530
Date: Tue, 27 Apr 1999 13:11:37 +0100
Date: Tue, 27 Apr 1999 10:18:55 PDT OE Item Master Validation
Date: Tue, 4 May 1999 17:58:16 -0400
From: Kimberly Bell [mailto:KMilios@specgrp.com]
Date: Tue, 4 May 1999 18:18:56 -0400
Date: Wed, 5 May 1999 08:11:24 +0300
Date: Fri, 7 May 1999 09:15:17 -0400 Retrieving multi org info
From: sredrova@es.com [mailto:sredrova@es.com]
Date: Mon, 14 Jun 1999 15:05:51 -0700
Date: Tue, 15 Jun 1999 10:15:13 +0100 Validate Seed Data Replication
Date: Fri, 25 Jun 1999 10:29:07 +0100
Date: Fri, 25 Jun 1999 09:44:20 -0500
Date: Fri, 25 Jun 1999 11:45:51 PDT
From: "qq"
Message-ID: <36f291ac.103.0@flashmail.com>
From: "Venkatraman Gopalakrishnan"
Message-ID: <199903191335.AA14287436@oracleassist.com>
From: Dkasper1@aol.com
Message-ID: <59fcff1a.36f2ac06@aol.com>
Sent: Wednesday, March 17, 1999 5:15 PM
Subject: Field ORG_ID
Hi Gurus,
How is field ORG_ID in all the _ALL tables is populated under Multi Org S=
etup?
Thanks
Dinesh Chandra
From: "Agiwal, Yogesh"
Subject: RE: Field ORG_ID
Through profile option "MO : Operating Unit "
Yogesh Agiwal, CPIM
Oracle Applications Consultant
yogesh_agiwal@unforgettable.com
From: "2200 Hsieh, Patrick" patrickh@ctxopto.com.tw
Subject: Multi-org set up
Many literature stated that the following profile options
should be appropriately set at the responsibility level for each
responsibility
in a Multi-org environment. Like many other sites, we have more than
80 responsibilities (and keep growing). It is a tremendous work to set
every of them.
Is there any short cut? For example, with
General Ledger responsibility just set "GL: Set of books" profile and
ignore the others.
HR: Business Group
GL: Set of Books
MO: Operating Units
OE: Set of Books
OE: Item Validation Org
INV: Intercompany Currency Conversion
AR: Receipt Batch Source
AR: Transaction Batch Source
TAX: Allow Override of Tax code
TAX: Invoice Freight as Revenue
TAX: Inventory Item for Freight
We are on 10.7SC16.1
Thanks,
Patrick
From: amareesh amareesha@sohm.soft.net
Subject: RE: Multi-org set up
Hi Patrick,
You cannot avoid this route. The MO profile option determines which
organization your responsibility is attached to & where the transactions
should go to. The MO & GL profile options are a must in your Multi-Org
set up.
Hope it helps.
Srini & Amareesh
From: JVales@darc.com
Subject: RE: Multi-org set up
Profile options can be set at higher levels than the responsibility
(Site or Application) and then ONLY when a responsibility has a requirement
to be set different than the default do you have to apply a value to the
responsibility. Choose the Site and Application profile options to be
the ones that apply to the most of your responsibilities.
Judy
From: Steve Bradley sbradley@sprynet.com
Subject: RE: Multi-org set up
Additional comments:
You only need to set the GL Set of Books profile option for the GL
responsibilities, not for AP, AR, etc. The other modules get the SOB from
the financials setup within the Org.
You do not need to set the MO: Operating Unit in the GL responsibilities
since it has no affect.
The HR: Business Group only needs to be assigned to the Inventory
responsibilities used for the Define Organization and Organization
Relationships. It is not needed for the end user responsibilities.
Respectfully,
Steve Bradley, CPA
OASIS Consulting Group, Inc.
Office 404-352-8387
Fax 404-609-9856
Pager 888-912-2569
From: "Thornton, Steve (UK01)" Steve.Thornton@UK.Honeywell.com
Subject: RE: Multi-org set up
You do need to setup the MO:Operating Unit within GL if you intend to use
the 'Zoom' functionality, to drill back into the sub-ledgers.
Regards
Sent: Friday, March 26, 1999 4:42 PM
Subject: Re: GL - Shifting to Multiorg
Hi all,
We are currently on three different production
instances, two on Oracle
Apps and the third non-Oracle. We are now planning
for a fourth
Consolidation instance in which we will consolidate
the three Sets of
Books through Oracle MultiOrg.
Each of the instance have different Chart of Accounts
and Functional
Currency.
Can anyone help? Any suggestion is welcome. Any
references to on-line
information regarding the above topic available to
the net is welcome
too.
Thanks in advance
Dipankar
From: gangadhar andru gangaa@yahoo.com
Subject: RE: GL - Shifting to Multiorg
Hi Deepankar,
There are a couple of approaches that you can consider depending upon
the requirement that the organization has. However, you need to have a
custom program that picks up the data from the gl Balances table at
source DB and inserts into the GL Interface of Destination DB.
1. You can have an identical source set of books on the Destination DB
and transfer the gl balances into it. Perform the standard consolidation
process from there.
2. Have an identical paernt set of books on the Source DB and perform
the consolidation process there. Use the custom code to transfer the gl
balances from the Source (Parent) DB to GL Interface of Destination
(Parent) DB. Import the journals into Parent Set of Books and run
reports.
There can be other approaches depending on the need.
Best wishes
Gangadhar
Dipankar:
Multi-Org has nothing to do with GL. GL is multi set
of books, not
multi-org. Neither will do anything for you if you
are truly running
multiple DB instances, or multiple installs in the
same instance. In either
of those cases, you will need to write custom code to
do your
consolidations.
Sent: 07 April 1999 18:47
Subject: Timestamp for Multi-Org
Does anyone know if R11 supports a local timestamp for multi-org setup
when
only one instance of the database is being used? i.e.: Production is
setup
in LA with a org in Belgium. Is there a way to get Belgium's
transactions
to generate a local (Belgium)timestamp instead of the PST timestamp?
Michael K. Ismert
Oracle Applications Consultant
ECS Integrated Technology Solutions
(503) 226-2558
(503) 202-5233 (Pager)
mismert@ecs-its.com
http://www.ecs-its.com
From: Graham Duggan gjduggan@mail.com
Subject: RE: Timestamp for Multi-Org
I did a fair amount of research into this on my current site which
covered France to West Coast US.
The end result was there is no supported method with Oracle applications
to do this at this time. The functionality is rumored to be either
* in release 12
* with a change to the rdbms to give the time entered a context relating
to time zone thereby allowing all times to be stored in one timezone and
translated to the users local time zone (ultimate!)
Most sites who run across multiple time zones either use multiple
instances or run in GMT worldwide.
Graham.
From: Monica Tat monica_tat@yahoo.com
Subject: Multi-org
Hi,
in the multi-org set-up, we have one set of books with 3 operating
units. Will users of one operating unit be seeing the purchase orders
and sale orders of the other operating units? If yes, is there any way
we can stop that. All operating units have more or less same items.
Your help is appreciated.
Monica.
From: "Ananth Swaminath" ananth999@hotmail.com
Subject: Reply: Multi-org
Hi Monica
Tie a responsibility to the Operating Unit. And link users to the
responsibilty when you define them. You could take this further by
restricting access to certain Inv. Orgs by responsibility too (in the
ORg. Access form).
Hope this helped. In case you do have any further queries I'll be
glad to pitch in.
Ananth
Senior Functional Consultant
Financials/Supply Chain
From: siddhartha nandi sid_nandi@yahoo.com
Subject: Re: Reply: Multi-org
Monica,
Ananth is right. Access security for OE and Purchasing is at the
Operating unit level. Regarding items, Oracle recommends to have one
item master org for all the inventory orgs. So create responsibility at
Operating unit level and that should do the job for you.
Good luck!!!
Sid.
cc: (bcc: Sudhir Kumar/Erp/DFI)
Subject: MO: Do we need Multiple set of Books
Dear All,
Do we need to define a set of books per Operating unit in Multi-org, or
can all operating units share the same SOB (with different balancing
segment per operating unit).
Appreciate your earliest feedback.
Thanks,
Ahmed.
From: skkumar@dfuture.com
Subject: Re: MO: Do we need Multiple set of Books
Yes you have to define seprate SOB in feeder modules for diffrent Operating
Units .
From: Appanaboyina_Kishore Appanaboyina_Kishore@hts.satyam.com
Subject: RE: Do we need Multiple set of Books
Hi,
Can have the same SOB for many operating units. But you may have to explore
on the business needs and accounting needs to decide on whether you need the
same SOB or a different SOB for a operating unit.
Kishore
From: Peter Wolyniec pwolyniec@edenconsulting.co.uk
Subject: RE: Do we need Multiple set of Books
Ahmed,
You do not need to define an SOB per Operating Unit as long as you have no
issues with using the same Calendar, Currency and Chart of Accounts across
your organisations. Assuming this situation, you can have one SOB (and
Legal Entity) with multiple Operating Units underneath it using one product
installation. You information is secured by Operating Unit and accessible
to only those with priveleges for that OU.
For centralised processing across Legal Companies, tax reporting by each
Legal Company can be maintained seperately for GL reports and 1099 purposes
by using Balancing Segments on your CoA.
Hope this helps,
Peter Wolyniec
Eden Consulting
From: "Ananth Swaminath" ananth999@hotmail.com
Subject: Reply: Do we need Multiple set of Books
Hi Ahmed
The primary reason for having multiple sets of books arises from your
legal financials reporting needs which usually occur since you may be
operating in different currency zones. Yes the main issue is your
need to have atleast one of the 3C's different from the others.
What occurs is this:
- The Legal Entity reports on the financial state of affairs of the
business.
- The transactions which cause these financial implications on which
the LEgal Entity reports occurs at the Operating Unit level
- What the Operating Unit transacts in (sells, purchases,
manufactures etc.,) are determined by the inventory organisation
which is attached to the Operating Unit.
It therefore becomes imperative that the Inv. Org and the Optg. Unit
speak the same language and hence they MUST share a common Set of
Books. Briefly this is the issue involved.
In case you need any clarifications on the matter, do get in touch.
Ananth
Senior Functional Consultant
Financials/Supply Chain
From: "Tom D'Amico-273" TDAMICO@amtrol.com
cc: (bcc: Funda Bekar/Darica/Tr/Cement/Lafarge)
Subject: Multi-org setup - OE Item Master Validation
When I try to setup the Profile Option 'OE Item Master Validation' for a
new
Operating Unit and Responsibility, it seems that it can only be set at the
site level. Is this a constraint of Oracle? Can I have only one 'OE Item
Master Validation' organization for the enterprise??
I expected to be able to setup a second Item Master Validation organization
for the second Operating Unit.
Tom D'Amico
Sent: Tuesday, May 04, 1999 6:08 PM
Subject: RE: Multi-org setup - OE Item Master
Validation
Tom,
There is a way via the System Admin responsibility that you
can change that
profile option to be updateable a lower level; however, I am
not sure how it
is done. I do believe there has been information on this
subject before, so
trying searching the archives of this list server. You
should have detailed
instructions there.
Hope this information is useful to you!
Kim Bell
From: "Tom D'Amico-273" TDAMICO@amtrol.com
Subject: RE: Multi-org setup - OE Item Master Validation
Thanks. I'll keep looking. I've been using the System Admin responsibility
but can't get the Profile Option to accept a value at the Responsibility
level. I'll try the archives.
Thanks again.
Tom D.
From: Funda.Bekar@Lafarge-Turkey.lafarge.com
Subject: Re: Multi-org setup - OE Item Master Validation
hi,
the application level of profile options can be changed by standard
"Application Devoloper" responsibility. on the menu of AD responsibility,
you'll navigate to "Profiles", and call for "OE: Item Validation
Organization" profile option.
hope this helps.
From: "Tom D'Amico-273" TDAMICO@amtrol.com
Subject: RE: Multi-org setup - OE Item Master Validation
Thanks. Archives helped. I used the 'Application Developer
Responsibility' to set the Profile Option to updateable at the
Responsibility level.
Tom D.
Sent: Monday, June 14, 1999 10:17 AM
Subject: FND: retrieving multi org info
Hi,
We are upgrading to R11 and turning on multi org for future use.
Some of our custom processes are build as follow:
concurent program calling a shell script
Shell script call a sqlplus session and call procedures.
we are running into some problems with wiews using the CLIENT_INFO
variable,
they run fine within the apps but not in the sqlplus session.
I was wondering what was the best way to retieve the variables of the apps
environment so that they can be set in the sqlplus session where the
procedures are called from.
I hope this is clear....
Thanks for any help you could provide me.
Stephanie Redrovan
Information Technologies
Evans & Sutherland Inc. (http://www.es.com)
sredrova@es.com =B7 801.588.1825
From: "Walker, Cary" Cary.Walker@fluke.com
Cc: "'sredrova@es.com'" sredrova@es.com
Subject: RE: retrieving multi org info
use the dbms_application_info package to set client_info in sql*plus. use
the following:
begin
dbms_application_info.set_client_info('xxx');
end;
where xxx is the org_id of the operation unit you want to see. then run your
select statement or procedure.
Regards,
Cary Walker
From: "Grist, Fergal" Fergal.Grist@ncp.co.uk
Subject: RE: retrieving multi org info
Hi Stephanie
What you need to do is pass down the current ORG_ID to the shell script,
then pass it into your SQL script and finally perform the "exec
dbms_application_info.set_client_info($ORG_ID)" command.
To pass the org_id down to the shell script, create a parameter against your
concurrent program with the following characteristics:
DEFAULT TYPE: profile
DEFAULT VALUE: ORG_ID
Let me know if you require any further help.
Regards
Fergal Grist.
From: peter.van_zaalen@nllum.mail.abb.com
Subject: Validate Seed Data Replication
We run apps rel 11.02/03 in Multi-org.
After creation of a new Operating Unit we run the Replicate Seed Data
request and it ends succesful.
1. This request should run automatically after creation of the OU but it
does not. Anybody knows why?
2. On some Operating Units not all seed data is there, we get No data found
errors in some setup screens.
Does any of you have a script that validates presence of seed data on
Operating Units?
Peter van Zaalen/ABB
From: "Hendrix, Deborah A." HendrixDA@bvsg.com
Subject: RE: Validate Seed Data Replication
To my knowledge it has never automatically run after the creation of an
operating unit, even though the documentation has stated that it does since
10.7.
Debbie Hendrix
BV Solutions Group, A Black & Veatch Company
913-458-8519
hendrixda@bvsg.com
From: dave parker watsui@hotmail.com
Subject: RE: Validate Seed Data Replication
I don't have a script that validates, but there is a Sys Admin standard
report entitled "Multi-Org Setup Validation Report"
that might be of some (maybe, limited) help.