Excel-to-CI for Assets - INTFC_FINPHY_SS_A
I have a client that has the following issue when they load their assets using the delivered INTFC_FINPHY_SS_A, when they have a value in the INTFC_FIN.TRANS_CODE field.
#1 The value LTD2 is too long for the field INTFC_FIN.TRANS_CODE (91,68)
#3 Error saving Component Interface. {INTFC_FINPHY_SS_A}.
It loads okay when TRANS_CODE has no values. I have checked the CI and the size of this field is 5 char and client is using 4 char. I have also checked the actual data they have entered in the Excel to ensure there were no hidden <space> characters on this field.