Hi All,
I'm on a data migration activity and I'm trying to import some entities involving financial dimensions.
recently we changed the separator to | so to avoid conflict with items that have - in their codes, since then I'm facing this issue:
as I try to import an entity with fin dim entirely all rows go in error returning: "Results. The number of dimension values specified in 15.101|||C04304|21OC019779|| is different from the number set up in the active format for data entities." ,as the separator is not recognized (this happens on every entity such as Purch orders, Sales Orders, Prod orders).
the weird thing is that if I select some of the rows in error in the staging and I reimport them (without changing anything) then the import is finalized correctly for those rows (I tried to select all the rows with a sql update but re-import returned the error).
did anyone face the same situation and knows how to fix it ? we have thousand of transactions with dimensions so it's not possible to manually select all rows and import them as workaround.
thanks in advance, Best regards
