Disable an Org with balance and re-enable
Date: Thu, 09 Sep 1999 12:11:13 -0700
From: "Annie Tang"annie_tang@halw.com
To: oraapps-l@cpa.qc.ca
Subject: Disable an Org with balances
Can we disable an Org which still have balance sheet and P&L balances
and re-enable it at a later date?
Annie
Date: Fri, 10 Sep 1999 14:33:51 +1000
From: "Renzella, Vivien" RenzellaV@DNB.com
To: "'oraapps-l@cpa.qc.ca'" oraapps-l@cpa.qc.ca
Subject: RE: Disable an Org with balances
Annie,
Part of our flexfield combination contains an org unit, or what we call a
cost centre. I assume this is what you are referring to. I went into our
development system and inactivated an org unit for which there was a balance
outstanding. There did not seem to be any problem doing this - it saved the
record without a problem and created a concurrent request. Then I tried to
enter a journal against this org unit and I got an error message telling me
the org unit had been disabled and I was therefore unable to enter journals
against this org.
Hope this helps.
Vivien Renzella
Ph: 61 3 9828 3280
Fax: 61 3 9828 3505
Renzellv@dnb.com mailto:Renzellv@dnb.com
Date: Fri, 10 Sep 1999 14:48:27 -0700
From: "Annie Tang"annie_tang@halw.com
To: oraapps-l@cpa.qc.ca
Subject: Re[2]: Disable an Org with balances
Vivien
Thanks for the information. However, When I say Org, I meant,
Company, not cost center. Will that make a difference? Can I enable
the Company again at a later time?
Thanks
Annie
Date: Tue, 14 Sep 1999 16:20:03 +1000
From: "Renzella, Vivien" RenzellaV@DNB.com
To: "'oraapps-l@cpa.qc.ca'" oraapps-l@cpa.qc.ca
Subject: RE: Re[2]: Disable an Org with balances
Hi Annie,
In our general ledger our flexfield is made up of several components, one of
which is a company code. I went into Setup under Oracle General Ledger and
accessed the values within the COMPANY flexfield. I then disabled one of
those values. When I exited from this screen a concurrent request was
submitted. I then tried to enter a journal and I got an error message
telling me the code had been disabled. I then went back into setup and
re-enabled the company code value by clicking on the enabled button. Again,
a concurrent request was submitted when I exited this screen. . I then tried
to enter a journal and I got the same error message telling me the code had
been disabled which I found was very odd. I exited the Oracle application,
then signed on again and was able to successfully enter and post a journal
to the company I had previously disabled.
If you have a test environment I would strongly recommend you do what I did
- it does seem to allow you to disable and re-enable various segments within
the flexfield combination.
Good luck!
Vivien Renzella
Ph: 61 3 9828 3280
Fax: 61 3 9828 3505
Renzellv@dnb.com mailto:Renzellv@dnb.com
Transfers between Operating Units
Date: Fri, 01 Oct 1999 18:55:38 EDT
From: "Dave MacQueen" djmacqueen@hotmail.com
To: oraapps-l@cpa.qc.ca
Subject: Transfers between Operating units
Hi, we currently have 2 sobs and 2 operating units and need to transfer
product between them. Is this possible? I can not put the 2 Operating
unit's inventory org on an internal requistion.
Can anyone help with this?
Thanks in advance,
Dave MacQueen
Date: Fri, 15 Oct 1999 09:24:40 +0530
From: "bharat bhaaradwaj" bharatbh@wipsys.soft.net
To: oraapps-l@cpa.qc.ca
Subject: Re: Transfers between Operating units
Hi Dave,
You have mentioned that you cannot put the 2 Operating unit's inventory
Organisation on an Internal Requisition, so you need to treat both
separately meaning one as a selling unit and the other as a receiving unit.
When you need to do a transfer make it as though it is a sale for the OU
which is transferring the Product and make it as a purchase for the
transferee OU. One big question that you need to answer will be the
Transfer Price.
Hope this helps
Regards
Bharat
Date: Sat, 16 Oct 1999 10:43:28 -0400
From: kewishls@mindspring.com
To: oraapps-l@cpa.qc.ca
Cc: Multiple recipients of list oraapps-l@cpa.qc.ca
Subject: Re: Re: Transfers between Operating units
To add to this, are you on 10.7? The internal req/internal sales order
function only works within an operating unit if you are!!!
The intercompany functionality of shipping goods to a customer from an
inventory in another operating unit does all the background intercompany
financil transactions but doesn't actually move the inventory to the other
organization, in this 10.7 release.
R11 has drop ship functionality where by you can purchase direct from a
vendor and ship to the customer, I'm not sure if it has a cross-docking
function where the goods can be moved to the other inventory organization in
the other operating unit for consolidation of a shipment before final
shipment to the customer, though!
Hope this helps
Louise Kewish
Senior Principal - Manufacturing and Distribution Apps
TSC
Dallas, TX
MultiOrg in AP and Inventory
Date: Fri, 15 Oct 1999 17:45:36 +0500
From: fariha afreen fafreen@ora-tech.com
Subject: Multi-Organisation in AP & Inv
Hi all,
We are on release 11,implementing GL, PO,AP ,Inv & FA.
There are 4 set of books in GL each of which will have separate
subledgers except Fixed assets. Now i have defined 4 operating units to
attach them to 4 separate Payables responsibilities.For inventory,since
average costing will be used & there are around 40-50 locations each
having a separate inventory control account, we have decided to create
various inventory organisations for each of the inventory control
account.All 4 set of books are attached to different inventory
organisations.
To avoid confusion, we have not classified the operating units as
inventory organisations.They are only classified as GRE/Legal Entity &
operating Unit & attched to the different payables resposibilities..
All inventory organisations are classified as GRE/Legal Entity,Operating
Unit & inventory organisation.
The multi-org architecture was enabled before defining all of these
organisations.(this is a demo data base which already has this feature
enabled )
My questions are:
1. Are we on the right track in defining organisations for AP & Inv???
2. Should we run the ADADMIN utility again ????
Date: Sat, 16 Oct 1999 10:35:30 -0400
From: kewishls@mindspring.com
To: oraapps-l@cpa.qc.ca
Cc: Multiple recipients of list oraapps-l@cpa.qc.ca
Subject: Re: Multi-Organisation in AP & Inv
I'm not sure that you should have defined your inventory orgs as Legal
Entities and Operating units.
This would give a structure of many operating units, and it sounds as though
you want your inventory orgs attached to one of the 4 payables operating
units. By making the inventory orgs as separate operating units, you'd have
to define a purchasing/payables for each of them.
You can define your inventory orgs as that only and then attach as amany as
you want to the defined operating units, without them being defined as their
own operating unit.
Louise Kewish
Senior Principal - Manufacturing and Distribution Apps
TSC
Dallas, TX
Purchasing and Multiorg - mixed queries
Date: Thu, 21 Oct 1999 16:17:17 -0700
From: James Downey jdowney@pwccanada.com
Subject: Question
We have a government client (multi ministry) on release 11 that is going
to re-implement their application from multiple sets of books to either
single set of books / single organization or single set of books /
multiple organizations.
Can you help with the following? They would like to use multi-org, but
are unsure of the answers to the following:
1. Blanket Purchase Agreement:
The purchasing group would establish a Blanket Purchase Agreement with a
supplier. Can a Blanket Agreement be set up for access/draw down by
each organization?
Is it easy to get a cross-organization status of the Blanket Agreement?
2. Web Requisitions:
Can central catalogues be shared and drawn down upon by all
Organizations?
Can purchasing be combined across organizations?
Can approvals/workflows be routed across multi-orgs (e.g. from one org.
to another org)?
3. Web Supplier Inquiries
How would suppliers get cross-organization information through web
services for their invoices/payments under multi-org (without the need
for
multiple user IDs
4. Purchasing Analysis
How would we get cross-organization purchasing data for analysis, e.g.
leveraging purchases, volume discounts, supplier performance, etc.?
5. Business Process Improvements/Best Practices:
How to implement/facilitate best practices for purchases under multi-org
Help on any of the following would be greatly appreciated.
Sincerely Yours
James Downey
PricewaterhouseCoopers
Date: Fri, 22 Oct 1999 06:51:27 -0700 (PDT)
From: Belkis Karakas belkisk@yahoo.com
To: oraapps-l@cpa.qc.ca
Subject: Re: Question
Hi James,
Purchasing is restricted at the Operating Unit (OU)
level. If the organizatoins that you are talking about
are Inventory organizations, yes you can share
purchasing across multiple inventory orgs within one
OU. If you have multiple OUs, then only the inv orgs
that are defined within each OU can share the PUR
information.
Therefore, within one OU, you can create POs (blanket,
standard, etc) and setup approval hierarchies, and
workflows that will be shared across the OU and in all
the inv orgs assigned to that OU. But all these will
be restricted within that specific OU and will not be
shared by other OUs. So the ability to share your
purchasing info depends totally on the structure of
the org.
I suggest you take a look at the Multi-Org white
papers at oracle's metalinks and the Multi-org manual.
I may tell you more about this if you send the
multi-org structure.
Hope this helps,
Belkis Karakas
ADADMIN exited with error
Date: Wed, 27 Oct 1999 15:42:49 -0400
From: "du Feu, Richard" RDufeu@exocom.com
To: "'Multiple recipients of list'" oraapps-l@cpa.qc.ca
Subject: MO: Multi-Org Problem
Hi All,
I am trying to run the multi-Org utility (ADADMIN). It has failed at some
point in its running of job:
plus80 -s APPS/APPS @H:\APPLR11\ad\11.0.28\admin\sql\adorgcnv.pls 'CONVERT'
'JE_ES_MESSAGES_ALL' '1000'
Error:
Program exited with status 3
Cause: The program terminated, returning status code 3.
Action: Check your installation manual for the meaning of this code on this
operating system.declare
*
ERROR at line 1:
ORA-20000: ORA-00942: table or view does not exist
Cursor SQL statement:
SELECT ROWID FROM JE_ES_MESSAGES_ALL WHERE ORG_ID IS NULL
--
SQL statement:
UPDATE JE_ES_MESSAGES_ALL SET ORG_ID = 21 WHERE ROWID = :cursor_row
ORA-06512: at line 289.
Where does it create the list of jobs from? I found a text files that was
generated with all the jobs that have to be done. I want to bypass this
table as it does not exist. Can I do this, to all the multi-Org worker to
continue?
I would appreciate any help that you can provide
Richard
Date: Wed, 27 Oct 1999 15:37:33 -0700
From: Sanjay Saini kingjai@yahoo.com
To: oraapps-l@cpa.qc.ca
Subject: [Fwd: Re: MO: Multi-Org Problem]
Richard,
IF AND ONLY IF you are not using 'JE' then you can edit this file and go
ahead.
$AD_TOP/admin/sql/admorgb.pls You should find a line like
add_list('JE_ES_MESSAGES_ALL' , 'JE_ES_MESSAGES', 'SQLAP' ,'N');
You can comment this line out. I will say check if the table exists and
if there
are any records in it.
To me it looks like this table doesn't exist in the database.
Of course this is NOT supported by Oracle :)
Let me know if you any more details.
- Sanjay
Item Master Inventory Orgs - multiple
From: rams balasub [mailto:rames_b_99@yahoo.com]
Sent: Saturday, October 30, 1999 3:16 AM
To: Multiple recipients of list
Subject: Multi Org setup
Dear all,
Can we have multiple Item Master Inventory
organisation for multiple operating units/inventory
organisation. Oracle recommends that to create only
one item master organisation, but did not say we
cannot have multiple item masters.
On contrary Oracle demo application - Vision
Corporation has 2 Item master Organisation for a
single inventory setup(Responsibilities) Viz.. Vision
Operations, Vision Project Manufacturing. If they
strongly recommend one Item master inventory
organisation why they have 2 in their demo, can
someone kindly explain ?
Is it compulsory to have single item master
organisation for a single set of books?
Can we have each inventory organisation be a master of
its own ?
thanks
B.Ramesh
Date: Sat, 30 Oct 1999 10:09:31 -0400
From: Scott Neville ScottNeville@namfg.com
To: "'oraapps-l@cpa.qc.ca'" oraapps-l@cpa.qc.ca
Subject: RE: Multi Org setup
Each inventory organization *can* be it's own Item Master that is completely
independent of any other organization. You can have 1 Item Master that is
used by 3 inventory orgs and another that is used by 2 different inventory
orgs. You can have a single Item Master for all inventory orgs. Oracle is
very flexible. You have to weigh the advantages and disadvantages against
what you want to accomplish. Item Masters provide visibility of Items across
organizations. They also make it easier to maintain Items that are common to
seperate inventory orgs.
Scott
Change in Organization Structure
Date: Wed, 3 Nov 1999 10:15:13 -0500 (EST)
From: liza@instructor.net
To: OraApps-l@cpa.qc.ca
Subject: Change in Org. Structure
We are in 11.02, one SOB with multiple entities. We are live on all financial applications and
Project Accounting (PA).
We are soon implementing a change in our Organizational structure - has anyone ever done any
change in Organization structure after going live for some time?
The change involves adding legal entity, getting rid of an old entity, moving a business unit
into another legal entity that therefore affects where projects reside.
If you can point me to the right direction as to what we need to do (at least in PA), what to
watch out for, what the issues that you were faced with. Also is there any documentation that
can guide us when doing this change in structure.
Thank you for the help.
Date: Wed, 3 Nov 1999 21:12:59 -0800 (PST)
From: Krishnakumar Narasihman chnkrishna@yahoo.com
To: oraapps-l@cpa.qc.ca
Subject: Re: Reply Change in Org. Structure
hi,
Though we have not done anything of that sort, but i
would suggest you to close the organizations and move
the value to new organization that points to either
the same or new operating units. however, i really
want you to exercise caution bec in one of my
implementations, i had accpted changes in inventory
organization structure(though there was no change in
operating units) and it really played havoc and esp
some of the modules gave illogical errors and to
overcome we had to struggle a lot. when we tested the
same structure in a new instance, things worked fine.
Therefore plan it very well and do it only on a backup
test instance. all the best.
nkk