Facing issue with BICC PVO extraction

Summary:

We have Configured Fivetran to pull data from Fusion to Fabric.
However, when we try to sync after enabling the PVO ItemEFFBPackaging__InformationPublicVO and the column packagingsize , we encounter the below error

DeduplicationException: Coerce error for table: fusion_na_dev_EgpBiccExtract_EgpBiccItemEFFExtract.ItemEFFBPackaging__InformationPublicVO, column: packagingSize, finalType: Long, valueType: String

Upon analysis, we found that in BICC, the data type for the column packagingsize is set to numeric, but the PVO contains float values for this column. Because of column datatype numeric fivetran creates same column and same datatype and it tries process data in numeric format only but because pvo provides data in float.