Hi,
I would like to update the list price in the view SALES_PART with the data migration.
When i try, i have the same message on everyline when i launch the MIGRATE_SOURCE_DATA:
ORA-20122: SalesPart.UPDATE: Field eCATALOG_TYPE] in Sales Part may not be modified.
The value of eCATALOG_TYPE] is ‘NON’.
Is it possible to proceed so ?
Thank’s
Julien.
Hi, this is a common issue with DB and non-DB columns (client).
In that case, go to Method List → Method List Attribute and set the “On Modify” for column CATALOG_TYPE_DB to False / No.
Screenshot from IFS Cloud but it’s basically the same for older IFS versions.
Hi
The field CATALOG_TYPE is only insertable but not updatable.
To avoid the error message please do the following:
In your migration job go to tab “Method List” and perform right mouse button “Method List Attribute”
Here search for the field CATALOG_TYPE and CATALOG_TYPE_DB and make sure that the checkbox for On Modify is not ticked
Best regards
Martina
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.