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_20 rule taking time in Consol run

in Financial Consolidation and Close 1 comment

Hi,

Below is the customized script written for Cash Flow purpose and it is deployed in FCCS_20 rule. Because of which the Consol time has significantly increased by 18 mins - 19 mins. We have tested the Consol time without this script and it is around 7 mins, but with this script it is taking around 26 mins.

Really appreciate if anyone can help in understanding why the rule is taking long and a better way to write the script.

script:

FIX ("FCCS_Entity Input", "Entity Currency", "FCCS_Periodic", @LEVMBRS("FCCS_Intercompany Top", 0), @RELATIVE("FCCS_TotalInputAndAdjusted", 0), @LEVMBRS("Total Custom2", 0), @LEVMBRS("Total Custom4", 0), @RELATIVE("FCCS_Mvmts_SubTotal", 0), @REMOVE(@RELATIVE("Total Custom1", 0), @LIST(@RELATIVE("FA00", 0), @RELATIVE("LL00", 0), @RELATIVE("RS00", 0))))

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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