Skip to main content

A customer is considering using the Excel Add-in for creating supplier for purchase part records. We created an Excel migration job for this and during testing we received the following error for the field Supplier Part No:
The value "SOOW 16/6 16 Gauge" has incorrect format for [VENDOR_PART_NO] in Purchase Part Supplier. Should be in uppercase.

How can the value in the column easily be converted to uppercase without needing any adjustment by the user in Excel? We would like to handle this via setup in the migration job. If the job was of type MIGRATE_SOURCE_DATA we could simply use the Oracle function UPPER when mapping, but we cannot figure out how to handle this for migration type EXCEL_MIGRATION.
 

Hi Eva,

 

Assuming a field like the supplier for purchase part note text is not needed for something else this can be used as a work around. (Or any other string field with no use)

 

In the migration job you find the PURCHASE_PART_SUPPLIER.VENDOR_PART_NO under column name and set its default value to UPPER(NOTE_TEXT). (Source Column should be blank)

 

Next find PURCHASE_PART_SUPPLIER.NOTE_TEXT and put NOTE_TEXT in the Source Column. The description for this line your can rename to Supplier Part No. That way it will show as if it is the Supplier Part no in the excel. 

 

 

Perhaps not the most elegant solution, but it seems to work. 

I would just try to have in the source column: UPPER(VENDOR_PART_NO)

Reply


Terms & ConditionsCookie settings