Welcome

Welcome to HandsonERP.com

This site provides video based training of Oracle Financials.
Learn concepts and functionality in a step by step manner.

Login

HandsonERP - Oracle E-Business Suite Training
Welcome, Guest
Please Login or Register.    Lost Password?
Please post inquiries related to lessons content here. All questions and inquiries related to the website should be submitted directly using Contact form in the top menu.
Go to bottom Post Reply Favoured: 2
TOPIC: Re:Consolidation
#880
arun (User)
Expert Boarder
Posts: 144
graphgraph
User Offline Click here to see the profile of this user
Consolidation 13 Years, 9 Months ago  
Hi Hasan,

I have been going through the Consolidation process and I have two questions/observations

a) Subsidiary to Parent mapping - It should be Many to One. You are saying One to Many. One to Many from Subsidiary to Parent - would that really help?
b) What happens when you have segment let's say Cost Center and you do not have that segment in the Parent. How would you tackle that scenario?
c)Also, what happens when you have action value as "Not Assigned" while doing the mapping?

Thanks,

Arun
 
Report to moderator   Logged Logged  
  The administrator has disabled public write access.
#881
handsonerp (Admin)
Admin
Posts: 1989
graph
User Offline Click here to see the profile of this user
Re:Consolidation 13 Years, 9 Months ago  
a) I might have used one to many in some other context unless I made a mistake. Many subsidiaries will be mapped to one parent or consolidated ledger. That is obvious from my diagrams.
b) I have covered this in mapping videos. Did you get a chance to look into these?
c) This quesion should be answered within next few videos (on how to create mappings)
 
Report to moderator   Logged Logged  
  The administrator has disabled public write access.
#891
arun (User)
Expert Boarder
Posts: 144
graphgraph
User Offline Click here to see the profile of this user
Re:Consolidation 13 Years, 9 Months ago  
Hello Hasan,

Point A- I was actually refering to the account rules. My understanding is that it is either 1 to 1 or many to 1, never 1 to many. Correct me if I am wrong. I have attached the screenshot.

Point B - You have a shown a scenario where the Parent has 4 segments and the subsidiary has a 3 segment COA. What happens when the subsidiary has a 4 segment structure COA and the parent has a different 3 segment COA. How do you map in that situation? Let us assume that there are data against the segment values of all the four segments and all of them has multiple values in the segment? How does the values in the segments of the subsidiary fold up then?

Also wanted to know how the data is passed - detail or summary level - what lets you decide that?

After the transfer takes place we would have to take care of the intercompany accounts and pass elimination entries? Is it not?

Thanks,

Arun
 
Report to moderator   Logged Logged  
  The administrator has disabled public write access.
#892
handsonerp (Admin)
Admin
Posts: 1989
graph
User Offline Click here to see the profile of this user
Re:Consolidation 13 Years, 9 Months ago  
A) Screen shot is right. More than one accounts in subsidiary ledger could be mapped one account in parent ledger. Many to One.
B) I have covered this scenario in the videos. You use Single Value Segment rule if parent have more segments. Did you see this video? Let me know if you want me to give you an example again here.
C) Question about eliminations is premature. Please let all consolidation topics complete first.
 
Report to moderator   Logged Logged  
  The administrator has disabled public write access.
#893
arun (User)
Expert Boarder
Posts: 144
graphgraph
User Offline Click here to see the profile of this user
Re:Consolidation 13 Years, 9 Months ago  
Hello Hasan,

I have seen the video - I am taking about, if the subsidiary has more segments than the Parent how would it be handled while doing the segment mapping. Also, would you let us know how to do mixed rules - like segment as well as account rules.
In a situation where you have number of subsidiaries at a National level, then at the Regional Level and may be then at the Global level. How do you tackle that kind of scenario? Global consolidation system would be inadequate in such a situation. Yes, an example would always help.

In practice when you do a consolidation of a subsidiary do you do mapping for every value in the segment?

Thanks,

Arun
 
Report to moderator   Logged Logged  
  The administrator has disabled public write access.
#894
handsonerp (Admin)
Admin
Posts: 1989
graph
User Offline Click here to see the profile of this user
Re:Consolidation 13 Years, 9 Months ago  
Yes the label says One to Many. One to Many is more of a generic term. But the arrows are indicating Many to One. Now I know what was causing all this confusion.
 
Report to moderator   Logged Logged  
  The administrator has disabled public write access.
#895
handsonerp (Admin)
Admin
Posts: 1989
graph
User Offline Click here to see the profile of this user
Re:Consolidation 13 Years, 9 Months ago  
Subsidiary COA:
Company-Account-Department

Parent COA:
Company-Account

In Segment Rules mapping you will simply ignore Department in your mapping. Segment Rule mapping is based on Parent segments. All parent segments must have a mapping.

In Account Rules mapping you will map subsidiary combinations with distinct department values to a single parent account:

01-1000-10 -> 20-1000-00
01-1000-20 -> 20-1000-00
01-1000-00 -> 20-1000-00

Lets wait for next few videos till you see the demos on creating mappings. Then see if your question still remains outstanding.
 
Report to moderator   Logged Logged  
  The administrator has disabled public write access.
#898
arun (User)
Expert Boarder
Posts: 144
graphgraph
User Offline Click here to see the profile of this user
Re:Consolidation 13 Years, 9 Months ago  
Thanks Hasan. As always your videos are fantastic.

Can you answer the other two question that I had.

Thanks,

Arun
 
Report to moderator   Logged Logged  
  The administrator has disabled public write access.
#899
handsonerp (Admin)
Admin
Posts: 1989
graph
User Offline Click here to see the profile of this user
Re:Consolidation 13 Years, 9 Months ago  
Thanks.
I thought I answered them. May be I am getting all confused.
Please post outstanding questions again here so that I take it from there. Thanks.
 
Report to moderator   Logged Logged  
  The administrator has disabled public write access.
#900
arun (User)
Expert Boarder
Posts: 144
graphgraph
User Offline Click here to see the profile of this user
Re:Consolidation 13 Years, 9 Months ago  
Hi Hasan,
Not a problem. Here they are once more.

"In a situation where you have number of subsidiaries at a National level, then at the Regional Level and may be then at the Global level. How do you tackle that kind of scenario? Global consolidation system would be inadequate in such a situation. Yes, an example would always help.

In practice when you do a consolidation of a subsidiary do you do mapping for every value in the segment?"

Thanks,

Arun
 
Report to moderator   Logged Logged  
  The administrator has disabled public write access.
#911
handsonerp (Admin)
Admin
Posts: 1989
graph
User Offline Click here to see the profile of this user
Re:Consolidation 13 Years, 9 Months ago  
Lets say were have three companies:

Company A - National Level - COA: Company - Account - Department
Company B - Regional Level - COA: Company - Account - Department - Project
Company C - Global Level - COA: Company - Account - Cost Center

Or come up with any COA structure you like.

Why don't you explain why can't we handle this scenario using GCS?

Side note: You should also explore Financial Consolidation Hub (FCH).
 
Report to moderator   Logged Logged  
 
Last Edit: 2010/06/16 01:31 By handsonerp.
  The administrator has disabled public write access.
Go to top Post Reply
Powered by FireBoardget the latest posts directly to your desktop