Question Re: Legal Consolidations package runs, but 0 records submitted in Financial Management Q&A

Legal Consolidations package runs, but 0 records submitted

Former Member — Fri, 05 Feb 2016 20:41:54 GMT

Hi Everyone,

I'm working on a BPC Consolidations Demo, and for some reason I'm having an issue running my Consolidations package. The package runs successfully, but 0 records are submitted. Please advise!

Re: Legal Consolidations package runs, but 0 records submitted

former_member186338 — Sat, 06 Feb 2016 08:18:34 GMT

Sorry, but without detailed information this question is equivalent to "BPC is not working, please help!"

Vadim

Re: Legal Consolidations package runs, but 0 records submitted

Former Member — Tue, 09 Feb 2016 15:41:09 GMT

Hi Vadim,

Thank you for your response. Which others details would you like me to provide that may be helpful to you? I went over my Master Data, business rules, and logic script to make sure it's all configured properly. I cleared out my rates model, and re-loaded the data.

This is the logic script I currently have for my consolidations and currency conversion:

*RUN_PROGRAM CURR_CONVERSION

CATEGORY = %CATEGORY_SET%

GROUP = %SCOPE_SET%

TID_RA = %TIME_SET%

//OTHER = [ENTITY=%ENTITY_SET%]

RATEENTITY = GLOBAL

*ENDRUN_PROGRAM

*RUN_PROGRAM CONSOLIDATION

CATEGORY = %CATEGORY_SET%

GROUP = %SCOPE_SET%

TID_RA = %TIME_SET%

*ENDRUN_PROGRAM

My controls, currency translation, and equity pick up run without a problem. My consolidations run, however 0 records are submitted. Please let me know if I can provide you with any other details.

Thank you!

Re: Legal Consolidations package runs, but 0 records submitted

former_member186338 — Tue, 09 Feb 2016 16:19:40 GMT

I can recommend you to start with IFRS Kit and read all IFRS Kit documentation. Then you will be able to understand your issues.

Vadim

Re: Legal Consolidations package runs, but 0 records submitted

Former Member — Wed, 10 Feb 2016 08:31:30 GMT

Did you also check your ownership data?

Re: Legal Consolidations package runs, but 0 records submitted

damovand — Wed, 10 Feb 2016 19:32:56 GMT

Hello,

As a general rule for trouble shooting business rules, you should simplify your scope. By that I mean you need to identify the specific rule that is not working. The following is a list of steps I take to trouble shoot this type of problems:

Find the specific rule that is not returning data. In your case is CT or Consolidation causing the problem and if you have multiple rules for CT or consolidation which one is causing the problem?
Once you identify the rule, you can find the specific data region based on the rule configuration, and what you are passing to the script logic.
After step two you need to do two things,
1. Check the master data configuration for the members tat fall within the scope of the rule to ensure they correctly configured
2. Query the transaction data that fall within the scope of the rule for both source and target
Check presence of data in ownership cube for the data region within the scope of the rule.

In my experience most of the times going through the above details reveals the problem.
There is only one caveat to this, to simplify the rules you will need to work on a copy of your BPC environment where you can remove the rules as you are testing.

Best Regards,

Leila

Re: Legal Consolidations package runs, but 0 records submitted

Former Member — Mon, 22 Feb 2016 15:39:16 GMT

Hi Arnold,

Yes, I checked the ownership data, and everything seems to be fine.

Re: Legal Consolidations package runs, but 0 records submitted

Former Member — Mon, 22 Feb 2016 15:46:17 GMT

Hi Leila,

I will go ahead and try the steps you have mentioned. Thank you for your response.