+18Hi,
In Apps 9 whilst using Data Migration Jobs, users were able to delete records after loading data from spreadsheet and before migrating the records into IFS.
However, in IFS Cloud (23.1.11) there seems to be no option to delete records like the ones highlighted below:
Users need this ability to review and delete records before migrating them into IFS.
Is this a case of missing functionality in Cloud that will be added in future updates?
Best answer by Jens
Hi
additional hint/experience from my point of view.
I suppose you’re trying to migrate data using the procedures INSERT_BY_METHOD_NEW or INSERT_OR_UPDATE.
I don’t recommend to use these procedures because of limited possibilities. For very simple migrations where the provided data is always good this might be ok.
My recommendation is to use 2 migration jobs (CREATE_TABLE_FROM_FILE to load the raw data into a “temporary” Oracle table (IC_-table) and then MIGRATE_SOURCE_DATA to fetch the data from the “temporary” table and migrate the data using APIs).
When using the MIGRATE_SOURCE_DATA job then you have much more possibilities. So for example you can also filter “empty” records with a WHERE-clause.
To delete these kind of “empty” records manually several times cost a lot of time.
Kind regards,
Jens
+14Hi Srikant,
In IEE versions, there is step to save record after loading data through spreadsheets and before saving, option is there to delete desired record(s), however, in Clouds version, system automatically saves spreadsheet data with loading.
I don’t think it is a case of missing functionality since IFS has automated the data saving procedure.
Regards
Abdul Rehman
+10Hi
additional hint/experience from my point of view.
I suppose you’re trying to migrate data using the procedures INSERT_BY_METHOD_NEW or INSERT_OR_UPDATE.
I don’t recommend to use these procedures because of limited possibilities. For very simple migrations where the provided data is always good this might be ok.
My recommendation is to use 2 migration jobs (CREATE_TABLE_FROM_FILE to load the raw data into a “temporary” Oracle table (IC_-table) and then MIGRATE_SOURCE_DATA to fetch the data from the “temporary” table and migrate the data using APIs).
When using the MIGRATE_SOURCE_DATA job then you have much more possibilities. So for example you can also filter “empty” records with a WHERE-clause.
To delete these kind of “empty” records manually several times cost a lot of time.
Kind regards,
Jens
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.