Login
Register

Home

Trainings

Fusion Blog

EBS Blog

Authors

Contact Us

General Ledger
  • Register

Oracle Gold Partners, our very popular training packages, training schedule is listed here
Designed by Five Star Rated Oracle Press Authors & Oracle ACE's.

webinar new Click here to raise Support Ticket. Get reply within 48 hours.

Search Courses

User Rating: 5 / 5

Star ActiveStar ActiveStar ActiveStar ActiveStar Active
 
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.




Anil Passi

Comments   

0 #1 mohammed 2006-12-10 00:00
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 ,
Quote
0 #2 mohammed 2006-12-10 00:00
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 ,
Quote
0 #3 rajesh 2007-01-15 00:00
Hi Anil,

whethe r GL date and TRX date for a Invoice in Oracle receivables should be same ?
Quote
0 #4 rajesh 2007-01-15 00:00
Hi Anil,

whethe r GL date and TRX date for a Invoice in Oracle receivables should be same ?
Quote
0 #5 Bibhuti 2007-05-03 00:00
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?
Quote
0 #6 Anil Passi 2007-05-04 00:00
The link below should answer your question

http://www.google.com/search?q=site:apps2fusion.com+differences-between-eit-and-sit-in-hrms

Thanks,
Anil
Quote
0 #7 sri 2007-05-16 00:00
hi anil,

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

thanks,
sri.
Quote
0 #8 sumitsharma 2007-05-29 00:00
Hi Anil!!!!!

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

Best Regards,

Sum it
Quote
0 #9 Rose 2007-07-07 09:29
HI Anil

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

Thanks
R aja Ramesh
Quote
0 #10 Hardeep Singh 2007-09-17 08:03
Hi Anil,
Do you have any sample code to extract data from GL_BALANCES table?
Quote
0 #11 david haimes 2007-12-14 06:01
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 responsibilitei s 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.

-------
G ood Luck - David
davidhaim es.wordpress.co m
Quote
0 #12 Aman Khan 2008-01-02 13:00
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.

T hanks
Aman Khan
Quote
0 #13 David Haimes 2008-02-09 06:43
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
Quote
0 #14 Prasad Raju 2008-04-21 00:43
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?
i t's urgent. Thanks in advance.

Thank s,
Prasad Raju
Quote
0 #15 praveen kumar21 2008-06-21 01:30
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.

than ks

regards

praveen
Quote
0 #16 Zachariah T Panickareth 2008-09-01 03:44
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.
Quote
0 #17 kishor nagbhire 2008-12-09 06:10
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 '''''''''''

he lp me
thanks
Quote
0 #18 Manas 2009-02-04 09:42
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?
Quote
0 #19 Manas 2009-02-04 09:46
In the Ledger separation what should be the data and report migration control?
Quote

Add comment


Security code
Refresh

Search Trainings

Fully verifiable testimonials

Apps2Fusion - Event List

<<  Aug 2021  >>
 Mon  Tue  Wed  Thu  Fri  Sat  Sun 
        1
  2  3  4  5  6  7  8
  9101112131415
16171819202122
23242526272829
3031     

Enquire For Training

Related Items

Fusion Training Packages

Get Email Updates


Powered by Google FeedBurner