mrc in GL 11i

This forum is to discuss different features/issues of Oracle Financials modules ( GL - General Ledger, AP - Accounts Payable, AR - Accounts Receivable, FA - Fixed Assets & CM - Cash Management ).
Post Reply
nrao1981
Posts: 90
Joined: Sat Jan 24, 2009 7:51 am
Location: India

mrc in GL 11i

Post by nrao1981 »

Version R12/11i? =
Instance PROD/TEST/VIS? =
Module? =
OS? =

hi everyone

this is about mrc in GL 11i


I have 2 sobs. One is in uk and another one is in us.In both sobs the chart of accounts different. Now i want to do mrc. Is it possible if the chart of ac is different or not. If Yes How?

thanks.
tgs100
Posts: 624
Joined: Tue Jun 13, 2006 3:42 am
Location: USA
Contact:

Post by tgs100 »

I have 2 sobs. One is in uk and another one is in us.In both sobs the chart of accounts different. Now i want to do mrc. Is it possible if the chart of ac is different or not. If Yes How?
I think you are looking for consolidation..not MRC...

Cheers,
Saravanan
nrao1981
Posts: 90
Joined: Sat Jan 24, 2009 7:51 am
Location: India

Post by nrao1981 »

I have 2 sobs. One is in uk and another one is in us.In both sobs the chart of accounts different. Now i want to do mrc. Is it possible if the chart of ac is different or not. If Yes How?
I think you are looking for consolidation..not MRC...

Cheers,
Saravanan

<i><div align="right">Originally posted by tgs100
tgs100
Posts: 624
Joined: Tue Jun 13, 2006 3:42 am
Location: USA
Contact:

Post by tgs100 »

By the way, what is MRC, what is translation and what is consolidation?

I found the basic concept is missing.

Cheers,
Saravanan
nrao1981
Posts: 90
Joined: Sat Jan 24, 2009 7:51 am
Location: India

Post by nrao1981 »

[quote]By the way, what is MRC, what is translation and what is consolidation?

I found the basic concept is missing.

Cheers,
Saravanan

<i><div align="right">Originally posted by tgs100
karthikeyanp1981
Posts: 463
Joined: Thu Nov 09, 2006 4:50 pm
Location: India
Contact:

Post by karthikeyanp1981 »

You have 2 SOB's.
SOB 1 is in GBP and SOB 2 is in USD

Now what are the options you have ....

Option no 1: Performing MRC and Consolidation
You will create a Reporting Set of book for either SOB 1 (to convert it to USD) or SOB 2 (To convert it to GBP)
After that you need to perform consolidation,
if you want all balances to be in GBP, then Consolidate SOB 1 with Reporting SOB of SOB 2 and vice versa for USD balances.

Option no 2: Perform Translation and Consolidation
No reporting set of books required.
Perform Translation of your primary set of books
Consolidate the translated balances to your parent set of books..


Under both the options you are required to perform the consolidation, and you can consolidation for different chart of account structures. One time setup of mapping is required.

You said you want to do MRC, which means you wanted to have Reporting Set of books... yeah you can have, what is preventing from doing so ? We will be more interested in knowing the error message you are receiving if you have tried it in the instance.

Regards,
Karthikeyan
tgs100
Posts: 624
Joined: Tue Jun 13, 2006 3:42 am
Location: USA
Contact:

Post by tgs100 »

Rao: The definitions you have given for MRC, translation and consolidations are correct.

What is the MRC currency? If MRC currency is different from GBP and USD, then you should have two MRC SOBs. Then you need to do consolidation for reporting.

Still not clear? Explain with specific issues.

Cheers,
Saravanan
nrao1981
Posts: 90
Joined: Sat Jan 24, 2009 7:51 am
Location: India

Post by nrao1981 »

[quote]Rao: The definitions you have given for MRC, translation and consolidations are correct.

What is the MRC currency? If MRC currency is different from GBP and USD, then you should have two MRC SOBs. Then you need to do consolidation for reporting.

Still not clear? Explain with specific issues.

Cheers,
Saravanan


<i><div align="right">Originally posted by tgs100
karthikeyanp1981
Posts: 463
Joined: Thu Nov 09, 2006 4:50 pm
Location: India
Contact:

Post by karthikeyanp1981 »

I Assume now this is what you have did,

Primary Set of Books is defined as below:

SOB 1( COA 1, Calendar, USD)
SOB 2 (COA 2, Calendar, GBP)

You defined Reporting Set of Books as below:

For SOB1 = RSOB 1 (COA2, Calendar, GBP)
For SOB 2 = RSOB 2 (COA 1, Calendar, USD)

Now you are trying to assign the primary set of books with the reporting set of books ...
SOB 1 with RSOB 1
SOB 2 with RSOB 2

You are facing an error (no values in LOV field) at the assignment stage ....

The reason being :
The Primary and Reporting SOBs should have the same calendar and chart of accounts.

Suggestion:
Create Reporting set of books with same Chart of Accounts and then perform consolidation.

Regards,
Karthikeyan
Post Reply

Who is online

Users browsing this forum: No registered users and 13 guests