Migration not working PURCHASE_PART_SUPPLIER

Hi,

it’s a bit difficult to give an answer without seeing the migration job.

I just created a small migration job where the source name and target view name is the same → PURCHASE_PART_SUPPLIER and I selected only 1 record to update the columns LIST_PRICE and LIST_PRICE_INCL_TAX.

I deleted all unnecessary  columns in the mapping.

Result after execution only for one record:

Probably the wrong SITE selected in the client?

What kind of method you are using  “insert new records “ or insert or update , if later then you need to check the settings properly.

I recommend to create 2 migration jobs:

1. To load the new prices based on a csv-file in a "temporary" IC_- Oracle table using the procedure name "CREATE_TABLE_FROM_FILE" in the migration tool
2. To migrate/update the prices based on the "temporary" loaded IC_ - Oracle table (Source name) using the procedure name "MIGRATE_SOURCE_DATA" in the migration tool. Target view name is PURCHASE_PART_SUPPLIER.

I don't recommend to use the procedure name "INSERT_BY_METHOD_NEW" (because we want to UPDATE existing records) or "INSERT_OR_UPDATE". With the combination of 2 migration jobs using "CREATE_TABLE_FROM_FILE" and "MIGRATE_SOURCE_DATA" you have more flexibility and possibilities in the data migration area.

Please have a look into the attachment regarding a simple example how to handle this topic. You have to adapt this example to your requirement of course but the approach is the same.