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
(19)
Subscribe to this comment's feed
...
written by mohammed , December 10, 2006
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,
Votes: +0
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,
report abuse
vote down
vote up
...
written by rajesh , January 15, 2007
written by rajesh , January 15, 2007
Hi Anil,
whether GL date and TRX date for a Invoice in Oracle receivables should be same ?
Votes: +1
whether GL date and TRX date for a Invoice in Oracle receivables should be same ?
report abuse
vote down
vote up
...
written by rajesh , January 15, 2007
written by rajesh , January 15, 2007
Hi Anil,
whether GL date and TRX date for a Invoice in Oracle receivables should be same ?
Votes: +0
whether GL date and TRX date for a Invoice in Oracle receivables should be same ?
report abuse
vote down
vote up
...
written by Bibhuti , May 03, 2007
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?
Votes: +0
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?
report abuse
vote down
vote up
...
written by Anil Passi , May 04, 2007
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
Votes: +0
http://oracle.anilpassi.com/differences-between-eit-and-sit-in-hrms.html
Thanks,
Anil
report abuse
vote down
vote up
...
written by sri , May 16, 2007
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.
Votes: +0
i have a question for u.can u please explain me about the whole life cycle for oracle financials.
thanks,
sri.
report abuse
vote down
vote up
...
written by sumitsharma , May 29, 2007
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
Votes: +0
U are really doing a great job!!!! Do you have some contents in respect of Project module too.
Best Regards,
Sumit
report abuse
vote down
vote up
...
written by Raja Ramesh , July 07, 2007
written by Raja Ramesh , July 07, 2007
HI Anil
My Congratulation on giving easy way of explanation on oracle apps.
Thanks
Raja Ramesh
Votes: +0
My Congratulation on giving easy way of explanation on oracle apps.
Thanks
Raja Ramesh
report abuse
vote down
vote up
...
written by krishnab , September 17, 2007
written by krishnab , September 17, 2007
Hi Anil,
Do you have any sample code to extract data from GL_BALANCES table?
Votes: +0
Do you have any sample code to extract data from GL_BALANCES table?
report abuse
vote down
vote up
...
written by david haimes , December 14, 2007
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
Votes: +0
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
report abuse
vote down
vote up
Upgrade to R12 from 11.5.10.2 for General Ledger
written by Aman Khan , January 02, 2008
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
Votes: +0
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
report abuse
vote down
vote up
re: Upgrade to R12 from 11.5.10.2 for General Ledger
written by David Haimes , February 09, 2008
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
Votes: +0
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
report abuse
vote down
vote up
How to remove 'Please click here to Respond' link in email notification?
written by Prasad Raju , April 21, 2008
written by Prasad Raju , April 21, 2008
Hi,
The links in the workflow email notification that goes to timecard approvers when a timecard has been submitted.
It is causing a lot of confusion to the customer, so we would like the "Please click here to Respond" and "Click here to view attachment" be removed.
The "Please click here to Respond" is causing more problems but it would be great if both could be removed?
Can any one please tell me how to remove the above links in wokflow email notification?
it's urgent. Thanks in advance.
Thanks,
Prasad Raju
Votes: +0
The links in the workflow email notification that goes to timecard approvers when a timecard has been submitted.
It is causing a lot of confusion to the customer, so we would like the "Please click here to Respond" and "Click here to view attachment" be removed.
The "Please click here to Respond" is causing more problems but it would be great if both could be removed?
Can any one please tell me how to remove the above links in wokflow email notification?
it's urgent. Thanks in advance.
Thanks,
Prasad Raju
report abuse
vote down
vote up
my question
written by praveen kumar21 , June 21, 2008
written by praveen kumar21 , June 21, 2008
hi anil
see in R12 i have done moac setups.
i have entered invoice in one operationg unit and iwant to pay with the other operating unit pls can u help me over here. how should
we pay and what r the setups for payments.
thanks
regards
praveen
Votes: +0
see in R12 i have done moac setups.
i have entered invoice in one operationg unit and iwant to pay with the other operating unit pls can u help me over here. how should
we pay and what r the setups for payments.
thanks
regards
praveen
report abuse
vote down
vote up
Do you have GL & FA setups with screen shots
written by Zachariah T Panickareth , September 01, 2008
written by Zachariah T Panickareth , September 01, 2008
Hi,
I would like to have Screen-shots on GL & FA set-up steps with case study.
Your reply would be very important to cruise ahead for the current project.
Votes: +0
I would like to have Screen-shots on GL & FA set-up steps with case study.
Your reply would be very important to cruise ahead for the current project.
report abuse
vote down
vote up
...
written by kishor nagbhire , December 09, 2008
written by kishor nagbhire , December 09, 2008
hi anil i'm a new user of ur site
can u help me on that topic
i want record in GL
'''''' undefined accounting periods in the current accounting calendar '''''''''''
help me
thanks
Votes: +0
can u help me on that topic
i want record in GL
'''''' undefined accounting periods in the current accounting calendar '''''''''''
help me
thanks
report abuse
vote down
vote up
Ledger separation
written by Manas , February 04, 2009
written by Manas , February 04, 2009
In one of my project we are separaing the Ledgers. from one SOB to two SOB s. What should be the my report and data controls?
Votes: +0
report abuse
vote down
vote up
Ledger Separation
written by Manas , February 04, 2009
written by Manas , February 04, 2009
In the Ledger separation what should be the data and report migration control?
Votes: +0
report abuse
vote down
vote up
| < Prev | Next > |
|---|
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,