Oracle Support is saying this is not supported since it's related to metadata setup between FDM and HFM.
We have a staging and testing environment and there appears to be a difference in terms of when Force Calculation or Consolidation is triggered.
Example: There are two hierachies COAL_V and N001_V base parent. Both of them are set up as the validation entity for two different locations in FDM.
IN the staging environment, when exporting data for a base entity (that belongs to COAL_V) but with N001_V as the POV in FDM , the check report will give an error. The cell staus in HFM for the base entity is CH and for N001_V is CN ND.
In the test environment, when following the same steps and load the same file, no error with in the check report. The cell status for the base entity is OK and for N001_V is OK.
Any ideas why we're getting different results in consolidations status and error in check report in FDM?