Consolidation generates no records

[Former Member]

Hi all,

Our client is on BPC 10.1 Standard. It is a fresh implementation and I took a copy of the EnvironmentShell to start setting up consolidation. The issue is that on running Consolidations no elimination records generated.

I have setup the following -

1. Currency translation has been setup and on running Currency Translation and Consolidation LC records get converted and placed on the right groups.
2. For testing, I have marked 2 base level GL accounts as ICELIM in property TYPELIM, and have populated property ELIMACC with a clearing account (maintained in Account dimension).
3. I have setup an ICELIM business rule (pretty standard) Accounts with ICELIM in property TYPELIM as the source and the destination. Group account PROP(ELIMACC). Multiplier M_IC which is 100,101 - 100,101 - 1 - 1.

I am not sure what I am missing. I have spent 3 days on this now but I am not able to figure out whats wrong.

Please help!

Thanks.

Raj

[former_member225135 · Accepted solution]

Hi Rajkumar,

Have u tried to follow checkpoints listed in this note: 1941497 : Checklist for legal consolidation

Regards,

Rahul Periwal

[Former Member · Accepted solution]

Thanks Rahul, this was very helpful in checking all the config, but unfortunately everything is maintained in the system as per the note.

In the business rule, I have tried using properties to identify accounts as well as using accounts directly to be eliminated. I have tried to re-create rules, methods, multipliers, use different accounts, flows, scope, etc for elimination, but I am just not getting the desired results.

Running consolidation from Monitor or package gives me the same results. FX happens but no eliminations. Attached is the log of Consolidation DMP.

[former_member225135 · Accepted solution]

Hi,

Can you share the screenshot of elimination rules, scope dimension and source data which as per you should get eliminated ?

Regards,

Rahul

[former_member225135 · Accepted solution]

and even script logic of consolidation

[Former Member · Accepted solution]

Rahul, I have just provided the basic setup in my reply to JP.

Scope is here -

[Former Member · Accepted solution]

This is the expectation -

1. Entities 2004 and 2005 fall under group S_2004 (GC is GBP).

2. S_2004 rolls up to S_2003 (GC = USD), S_2003 to S_2001 (GC = USD) and S_2001 to S_3001 (GC = USD).

3. Cells in yellow are a direct input at S_NONE in LC for entities 2004 & 2005 is GBP.

4. On running Consolidation, LC gets converted to GC based on the Group Currency maintained in the Scope dimension, resulting in cells in green.

5. However, elimination does not happen. Expected results are shown in grey color.

Ownership for S_2004 (sub-group) is below, I expect to see elimination happening at S_2004 too (along with other higher groups).

Added Ownership structure.

[Former Member]

Hi Rajkumar,

Some screenshots would really help to understand your issue...I hope ownership is maintained for all the entities under respective group.

Regards,

JP

[Former Member]

Hi JP,

I have added one screenshot of the Consolidation DMP log in my reply to Rahul above.

Yes Ownership is maintained too. However, I would like to get clarification on one point -

If the holding percentages of all entities in the group is 100% (i.e., a subsidiary is held 100% by it's parent) am I still required to use the "Calculate" option in the Ownership Manager? I have tried calculating and it refers to the percentages maintained in methods and changes all entities with Full (100% holding) to Equity (<20%). Then a colleague of mine suggested that I can just manually maintain the holding percentages and do not need to use the Calculate option. There is no cross-holding.

I am attaching a document with the basic setup (could not upload a .doc so took a screenshot of the whole doc). Let me know if you require additional details.

Thanks!

[Former Member]

In my initial question I had set the TYPELIM property value as ICELIM for the accounts to be eliminated. During my course of testing I changed it to ARAP. That is what is shown in the screenshot above.

[former_member225135]

Hi Rajkumar,

Entire setup is perfect. It should work.

Try to include one item in method based multiplier and check (Just a check)

Regards,

Rahul

[Former Member]

Hi Rajkumar,

In your multiplier rule under Intco instaed of using 101,100 can you use 99 and check whether its working?

Regards,

JP

[Former Member]

Tried. No change.

[Former Member]

Tried. Made no difference.

[former_member225135]

Hi,

Is PROP(ELIMACC) is account number or group of account?

If it is group of accounts, try using a single member

Regards,

Rahul

[Former Member]

I had tried that in my initial tests... did not make any difference.

Anyway, the issue is now resolved. On SAP's suggestion removed the model parameter -

ENABLE_PARALLEL_CONS = 'X'