Data Migration

Hello, I would like to know whether there is a functionality to “delete” data by using data migration:Let me explain:Data has been integrated in IFS using data migrationThe client wants to delete and update a new list of data. Is it possible to “delete” data by using data migration. Thanking you for your feedback.

Hi Community, I want to create a migration Job which calls the procedure Confirm_Alternates from Engineering Transfer_API view. The Parameter Structure_rec_ is a variable for the above procedure Can anyone help me on how to use this as a parameter in migration job?Best Regards,Thean

Hi, Is it possible to modify the DEF_ADDRESS in the customer_info_addess_type using data migration ? When i try, i have this message: ORA-20112: CustomerInfoAddressType.FND_RECORD_EXIST: The Customer Info Address Type already exists.

Hi,I wan t to call a custom event action using a migration job. I am loading data from a file to IFS system using migration jobs after that I want to execute a custom action using a migration job. Can anyone help me by mentioning the steps for this?Thanks,Sachini

I’m not sure what’s going on but I have the projections for my migration job granted to the permission set that I need them granted to as well as permission for FND_ADMIN, and FNDMIG_EXCEL_ADDIN and I’m still getting this error in my production environment. I have less permissions granted in my test environment and it’s loading with no issue. I even imported the permission sets from my test environment to prod and it’s still giving me the error. Any help is appreciated.    

Hello,I’ve created a Migration job for importing new service resources in Cloud. By baseline, while creating a New Service Resource, it automatically creates a Maintenance Employee record and assigns it to the Service Resource created.But while creating a Migration job, the Maintenance Employee record is not created. Also the Resource Connection with the Company and Site are not setup properly.Below is the Method List used to create Service Resources and Connections. What could be the possible reasons? Any inputs would be appreciated.Kind RegardsPriyanka Cecilia

I'd like to know how to register new customer order headers and line items in the same migration job.I have tried this and confirmed that adding CUSTOMER_ORDER and CUSTOMER_ORDER_LINE to the "Method List" tab allows me to update them all at once. However, when I try to insert both the header and line items, I get the error "DEVELOPER_ERROR_03: Most likely a usage definition is wrongly defined for LU: [CustomerOrder] in table RM_ACC_USAGE_TAB, internal exception: [Ex_Get_Id]."  

I am looking for a way to update Safety Stock, Planner, or any parameters in the inventory part screen. I would like to enter these changes in Excel and mass upload them to IFS 7.5 for now. We migrating to the cloud in January but, I would like to make this mass change in IFS 7.5 for now. Thanks in advance. 

I want to know how to get the Sales Price List by API. When registering a Customer Orders in the migration job, I want to use the API to retrieve the sales price from the sales price list. Because the migration job does not appear to be referencing the sales price list.

Hi All,I’m trying to create a data migration job for the Product Structure Header.When the structure type is ‘Manufacturing’ and if the record is already exists, I get an error ‘ORA-20112: ProdStructureHead.FND_RECORD_EXIST: The Prod Structure Head already exists.’ I have enabled modify option but it’s not letting me updating the record.I would really appreciate it if there’s any other ways we can try to make this work, please. Already tried to get the idea from the below post and unfortunately it didn’t work for me.Create Migration Jobs to Update Custom Fields(CF) | IFS Community also tried the bellow API call in objid fieldINTFACE_METHOD_LIST_API.GET_OBJID_FROM_KEY('PROD_STRUCTURE_HEAD', 'CONTRACT;PART_NO;ENG_CHG_LEVEL;BOM_TYPE_DB', CONTRACT||';'||PART_NO||';'||ENG_CHG_LEVEL||';'||BOM_TYPE_DB||';')Thank you in Advance!

What are some of the methods to export the photos in the Attachment DB in MWM as a file?

I’m new to IFS and currently exploring the Excel Plugin in V8 and the Excel Add-in in IFS Cloud.I successfully created an Excel migration job for the COUNTING_REPORT view (Count Report Transaction), exported the data, made necessary changes, validated and executed the job using the Excel Add-in. The changes were reflected in IFS as expected.However, when I followed the same process for the COUNTING_REPORT_LINE_EXTENDED view (Count Per Count Report Transaction), the changes did not reflect in IFS after execution.Could you please advise if there are any specific steps or configurations required for the physical inventory process when using the Excel Add-in with this view? Is there a limitation or approval workflow that I should be aware of?Thank you for your support.Best regards,Gowtham

Hello Everybody, we are trying to run a fairly simple Mig Job,  we are getting the following error message Start time - 24-OCT-2025 09:26:59   HFI_ENG_PART_ACTIVEError in  select   - ORA-01445: cannot select ROWID from, or sample, a join view without a key-preserved table End time - 24-OCT-2025 09:27:00   HFI_ENG_PART_ACTIVE  Here is the Query we are running:  SELECT OBJID, OBJVERSION, 'DO', ROWID FROM ENG_PART_REVISION_REFERENCE WHERE State='Preliminary' ORA-01445: cannot select ROWID from, or sample, a join view without a key-preserved tableLength of statement : 121 characters Here below you will find a few screenshots of the Job itself, im fairly new at Mig Jobs and overall IFS, i have not been able to figure this out out. any help would be appreciated.   

Hi Everyone,In Cloud 25R1, we have 10 companies in one instance, and we are in a process to migrate/carve out one company (for ex: Company A) to a fresh instance and to remove that company (Company A) data from the existing instance.Is there an easy way to achieve this? your suggestions will be very helpful.And an easy way to know the list of screens/tabs which has that Company (Company A) data to be carved out.In other words:Is there a method to get a list of screens pertaining to the company that should be taken into consideration when carving off a company from our current instance and inserting it into a new instance? 

Here goes a question for all of you who have some expertise deploying containers in the Data Migration Manager (or experienced in any type of migration tool with PAYMENT_ADDRESS as the destination).I’m trying to understand why, upon deploying PAYMENT_ADDRESS, I get the following error:Method NEW failed : ORA-20124: Error.NULLVALUE: Field [MAPPING_TYPE] is mandatory for Payment Address and requires a value. I am providing a value for MAPPING_TYPE as you can see in the screenshot:Error on Data Migration Manager. Notice the field has MAPPING_TYPE has data! I tried changing the value of mapping type to other values to see if that could be the reason (I tested with values such as “CHK” or “PAYMENTADDRESS”) but I always get the same error.I tried to insert manually and it seems to work.Entering the data manually seems to workIn this post (https://community.ifs.com/data-migration-333/data-migration-payment-address-56748?tid=56748&fid=333) I see someone reported something similar and the q

Hi everyone,I need to replace a large number of skills on standard tasks, but doing it manually is not feasible. I tried using Excel Migration, but I encountered an error and it seems this method might not be supported for deletions.As an alternative, I’m considering uploading the new skills in bulk and removing the old ones. Does anyone know how to properly remove skills using Excel Migration? Any guidance or examples would be greatly appreciated.Thanks in advance!Best regards,Stefania 

Hello everyone, I want to update the supplier association number using a data migration job.I have identified the relevant package to use: Supplier_Info_General_API.Modify__.When I call this package through a PL/SQL script, it works as expected and successfully updates the value.the package is called by the crud_update method :supplier_handling_svc.crud_update(                '*',                v_supplier_id,                'ASSOCIATION_NO' || chr(31) || v_association_no || chr(30),                'DO',                supplier_info_general## => ''            );However, when I run the same operation through the data migration job, no changes occur. Any idea why please?The select statement generated by the datamigration job do return the correct value : Datamigration Job Details : The ATTR_ value used is :  'ASSOCIATION_NO'|| chr(31)|| IC_I_SUPP_ASSOC_UPDATE_TAB.association_no|| chr(30)

Hi,I am using Data Migration Manager.An error message is generating in the Deployment Container:Template: CUST_ORD_CUSTOMER_ENTError: Field [RECEIVE_PACK_SIZE_CHG] is mandatory for Customer and requires a value.RECEIVE_PACK_SIZE_CHG is not in the Target Table Definition, but RECEIVE_PACK_SIZE_CHG_DB is.RECEIVE_PACK_SIZE_CHG_DB is not mandatory.Has anyone previously come across this and found a resolution?

Hello, I'm Markus and I'm new here in this community, and this is my first post.One of my tasks is to prepare the master data from the old ERP and migrate it to the IFS cloud. Of course, a lot of mapping is necessary, as we don't have this many columns and tables in the old ERP.I learned from our consulting to use these data migration tools: Migration Job for LOAD and for MIGI have a VPN to the IFS cloud and can select the data VIEWS via ORACLE SQL Developer to reconcile the column names and fields for the migration job files or to build the mapping for this.Is there a best practice for the migration of master datafrom our old ERP to our IFS cloud?Thank you very much for your knowledgeGreetingsMarkus 

What method should I use to change the status Plannable to Tentative? Thanks in advance,

Hello ​@Jens ,I am trying to migrate some data to the Purchase Part screen using Source Migration.I also want to migrate the document text value.Do I need to have a separate job for Document Text?Can you please help me out by providing your suggestion. Thanks,Thean

Hi Community,I was trying to Migrate the Translation for Customs Statistics Number. in screen Basic Data Translation for English and PROG Data will alredy exist.I am trying to migrate the data for french Language via Excel Migration Getting error ORA-20110: BasicDataTranslation.PROGNOTEXIST: Corresponding basic data does not exist for attribute key  Any idea how to solve this error?Thank You

After upgrading from App8 to cloud, the ‘Close Shop’ operation has been changed to ‘Park’. Does anyone have any insights or information regarding this change?

Has anyone seen this error message when loading or validating data for jobs with the Excel addin?  Last week we could load data the COA to the worksheet without error.  This week we are getting the above error for any of the migration jobs.  Office365Aurena  

when using Excel add-in for data work with IFS - I can’t perform any functions in the spreadsheet as the buttons disappear.Does anyone have a solution please?When I first log in - the buttons & mig job tree is available:After the first interaction, say load data - everything disappears: