<-----Google Analytics Code Start----> <-----Google Analytics Code Close---->
Skip to content

Green

color

Default screen resolution  Wide screen resolution  Increase font size  Decrease font size  Default font size  Skip to content Default color Pink color Green color Green color

Related Items

Home arrow Technical Articles arrow Financials arrow Splitting the instance into different Set Of Books
This website has now moved to http://apps2fusion.com





Splitting the instance into different Set Of Books | Print |  E-mail
Written by Anil Passi   
Tuesday, 07 November 2006
In response to a question on Orkut..Seperating Set of Books/Companies ???


Someone raised a very interesting question on orkut.

His question:-
Well, we are working on 11.5.4 with Oracle Financials.
My question is...

We have two companies with two SEPERATE set of books in our setup.
Now we want to seperate both the companies on two seperate Setups (Apps + DB) ....

Is this possible if YES, How ?



A very interesting question this is, but the solution is unbelievably simple....
They wish to split their ERP install base into two different independent instances of database.

Clone your current instance(A) to another evironment say "Instance B".


In instance A, you will close all periods for SOB 2. And disable all the responsibilities that have their profile options pointing to SOB2.

In instance B, do vice versa, i.e. close all periods for SOB 1. And disable all the responsibilities that have their profile options pointing to SOB1.

By doing the above, Instance A will be used for SOB 1, whereas Instance B will be used for SOB 2.



Comments (13)add
...
written by mohammed , December 10, 2006
Dear Anil,

First of all i want to congratulate you for triggering such a service to the troubled community out there. when did your start it?

Our consultants told us that big efforts are involved in doing this. You have reflected here the GL side story only. what happens to other AP/AR/GL/FA/CM/HRMS-PAY/OM/INV/PO etc...

ahmed,
...
written by mohammed , December 10, 2006
Dear Anil,

First of all i want to congratulate you for triggering such a service to the troubled community out there. when did your start it?

Our consultants told us that big efforts are involved in doing this. You have reflected here the GL side story only. what happens to other AP/AR/GL/FA/CM/HRMS-PAY/OM/INV/PO etc...

ahmed,
...
written by rajesh , January 15, 2007
Hi Anil,

whether GL date and TRX date for a Invoice in Oracle receivables should be same ?
...
written by rajesh , January 15, 2007
Hi Anil,

whether GL date and TRX date for a Invoice in Oracle receivables should be same ?
...
written by Bibhuti , May 03, 2007
Hi Anil,
Thnax for ur all sugessions which u give to others and i love to read it constantly.
My question is For Adding a new EIT, what is the Procedure/ Can i Create a New SIT if Yes then how?
...
written by Anil Passi , May 04, 2007
The link below should answer your question

http://oracle.anilpassi.com/differences-between-eit-and-sit-in-hrms.html

Thanks,
Anil
...
written by sri , May 16, 2007
hi anil,

i have a question for u.can u please explain me about the whole life cycle for oracle financials.

thanks,
sri.
...
written by sumitsharma , May 29, 2007
Hi Anil!!!!!

U are really doing a great job!!!! Do you have some contents in respect of Project module too.

Best Regards,

Sumit
...
written by Raja Ramesh , July 07, 2007
HI Anil

My Congratulation on giving easy way of explanation on oracle apps.

Thanks
Raja Ramesh
...
written by krishnab , September 17, 2007
Hi Anil,
Do you have any sample code to extract data from GL_BALANCES table?
...
written by david haimes , December 14, 2007
If you need to worry about all the sub ledgers (AP, AR, PO, INV, OM etc) it is still not too difficult a task. All those modules use Operating Unit(OU) and one OU can only be assinged to a single set of books, so you just need to disable all the OU (or responsibiliteis using te OU) that have the set of books you want to remove associated to them.

Cloning the instances may be a good ploy, but you may have to do more than disable accesss you may need to delete the data, use the sob_id columns and the org_id columns to identify the data form each org.

-------
Good Luck - David
davidhaimes.wordpress.com
Upgrade to R12 from 11.5.10.2 for General Ledger
written by Aman Khan , January 02, 2008
Anil,

First of all Wishing Anil and everybody else on this blog A VERY HAPPY NEW YEAR 2008. Hope this year we will make this blog more useful and famous...

Had a question related to upgradation of 11i to R12.

As SOB doesn't exist anymore in R12, Will it be a complete new setup that should be made in R12. Or Oracle is providing any patch to load setup data from 11i to R12.

How much difference is there between 11i and R12. What is the basic process that should be followed in upgrading from 11i to R12.

Help Appreciated.

Thanks
Aman Khan
re: Upgrade to R12 from 11.5.10.2 for General Ledger
written by David Haimes , February 09, 2008
Aman

You are right that R12 does not have a set of books it uses ledger, but this is mostly a change in terms ledgers operate in the same way as 11i set of books. They have of course plenty of new features.

As for upgrade of course Oracle provides a seemless upgrade, check out some of the resources listed here for detailed information

http://davidhaimes.wordpress.com/2008/01/05/useful-oracle-financials-resources/

David
Blog: http://davidhaimes.worpress.com
You must be logged in to a comment. Please register if you do not have an account yet.

busy