FCCS_10 rule performance and double consol issue
Summary: Our FCCS 10 rule takes 4x as long to build on the fly as it does to execute
Content (required): In order for our app to consolidate properly first time round we had to add a particular line to our movement calcs - but this is impacting performance
Our calc looks at the account checks the UDA then puts the Balance Sheet movement against the correct movement type (see code snippet below). However for the consolidation to roll up correctly first time we had to add the line in yellow. We have a lot of UDA based assignments.
This means there a lot of calls to Essbase when the calc is being created to determine the parent entity and we have found that this can increase the consol time for a single entity substantially from 5 to 20 minutes+. It doesn't appear to have an appreciable effect on a full Group consolidation - although time of day has an impact. The issue appears to be (From Oracle SR) that the connection to Essbase is being dropped and the calc build has to start again. Oracle have put a workround in place to reduce the amount of