Register today for Oracle CloudWorld. October 17th - 20th, Las Vegas

Register now

Hillel Cooperman, Senior VP of User Experience Design, has a message for you on Oracle CloudWorld

Watch now
Performance issue on a custom calc in FCCS_10 Opening Balance Carry Forward Rule — 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

Performance issue on a custom calc in FCCS_10 Opening Balance Carry Forward Rule

Received Response
22
Views
1
Comments
edited Nov 12, 2020 9:44AM in Financial Consolidation and Close 1 comment

Content

Dear Expert,

I have a performance issue with a custom rule puts into the FCCS_10 Opening Balance Carry Forward Rule.

The requirement is to calculate a percentage to be applied to a specific account. This percentage needs to be calculated only for the Actual scenario.

Another requirement is that the numerator and denominator to calculate the percentage are Revenues and Costs where I need to calculate a value for 12 months rolling in the past.

Below a semplification

  Dec-19 Jan-20 Feb-20 Mar-20 Apr-20 May-20 Jun-20 Jul-20 Aug-20 Sep-20 Oct-20 Nov-20
                         
Acc1 100 105 110 115 120 125 130 135 140 145 150 155
Acc2 50 55 60 65 70 75 80 85 90 95 100 105
                         
                         
                      rolling Acc1 1530
                      rolling Acc2 930
                         
                      percentage calculated as 930/1530 60,8%

I notice the calculation puts in insertion rule is "heavy", but my problem is that when I run a scenario where I don't need to have that calculation, the execution performance are quite the same. Specially when I need to run a consolidation for a scenario and for 12 months, like in a monthly budget.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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