Monday, March 6, 2023

FCC Release 23.03 - Metadata Validation for Movement Members

In the 23.03 release of FCC there is a new metadata validation that requires that all members under FCCS_ClosingBalance have a consolidation operator of Addition. On the surface this makes sense; however, it will cause major issues with cash flow.

It is common for cash flow to require various types of manual adjustments and calculations that are not part of the closing balance calculation. But, if a movement member is not under FCCS_ClosingBalance, then the data does not consolidate.

So what I and many others have done is to put these members somewhere under FCCS_ClosingBalance with a consolidation operator of Ignore. That way the data consolidates and does not impact the closing balance.

With the 23.03 release, when a metadata validation is run, this happens:


I filed an SR for the company I'm currently working with for this issue. Unless Oracle removes the restriction that members must be under FCCS_ClosingBalance to consolidate, I expect that this validation will get pulled back.