Not Able To Write Custom Calculations On Movement
(Doc ID 2424832.1)
Last updated on FEBRUARY 07, 2023
Applies to:
Oracle Financial Consolidation and Close Cloud Service - Version 18.06.55 and laterInformation in this document applies to any platform.
Goal
Problem description -
----------------------------
The requirement is to create a calculation for Movement members that will create the necessary blocks while minimizing a performance impact that is expected from creating movement dimension member formulas which is not suggested best practice..
Below is the rule which takes a very long time to run consol. It is evident that putting a large set of dense member (account) in Fix and using a sparse block member are the reasons for poor performance.
/*code starts*/
FIX( @REMOVE(@relative("FCCS_TotalInputAndAdjusted",0),"FCCS_JOURNAL INPUT"),@relative("FCCS_Intercompany Top",0) ,@RELATIVE("Total Custom2",0),@RELATIVE("Total Custom1",0) )
FIX((@REMOVE(@RELATIVE("FCCS_Balance Sheet",0), @LIST("FCCS_BALANCE", "FCCS_CTA"))) )
"Mvmts_MVT_CALC"
(
"Mvmts_MVT_CALC"="FCCS_ClosingBalance_Input"-"FCCS_TotalOpeningBalance"-"FCCS_Mvmts_Cash"-"FCCS_Mvmts_Operating"-"FCCS_Mvmts_Investing"-"FCCS_Mvmts_Financing"-"Mvmts_FXINPUT";
)
ENDFIX
ENDFIX
/*Code Ends*/
Solution
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
Goal |
Solution |