My Oracle Support Banner

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 later
Information in this document applies to any platform.


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) )



/*Code Ends*/


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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.