Let's Reconnect, thank you for making 2022 our best year yet.

Look Back
FCCS_10 rule performance and double consol issue — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

FCCS_10 rule performance and double consol issue

Received Response
37
Views
9
Comments

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

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!