Data Migration

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? 

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. 

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.

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”) bu

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 :

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?

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 

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?

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

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: 

How to execute a IAL view/ quick report and export its out put to file location?I know we have two migration tools in IFS cloud 24 R2. Data Migration and DMM. I see the options to do that using Data Migration but I don’t have access to it. Not sure if it has to do with licensing. However, I have access to DMM. How to achieve this task using DMM? I used DMM for importing CSV files and move the data from source to target tables. Any thoughts on this would be helpul.

I am trying to run a migration job to the customer credit limit table. I am using the excel add-in tool. We have to update some customer credit limits in bulk. The problem is the job keeps telling me that I am trying to update the PARTY_TYPE and that I’m not allowed to. I do not care to modify the party type, as it should remain Customer. I have tried to modify the migration job by eliminating the source code (column) for Party_Type and/or Party_TypeDB, and set up defaults as “CUSTOMER’ and ‘Customer’ and all possible combinations of such. No matter what, the system is convinced I am trying to “update” the party type, when all I want to do is update credit limits. Any advice or resources? This is for IFS Cloud 24R1. I was pointed to IFS Apps 10 - IFS Data Migration Excel Add-in Overview and De

I’m looking for some sort of materials to get trained on how to use the excel add-in tools for data migration. Would love to learn more about designing migration jobs, setting defaults, strategy, and more. I can’t seem to find anything on Community or Academy for resources. Where do you go to learn?

We are trying to migrate Open stock  which I am trying to do using migration job , the data is loaded successfully and can see it under “Inventory Parts in Stock “, what are the next steps to transfer the balance to GL please? I am trying “ Transfer Inventory Transactions “  option but I can’t see any transactions generated ,is there a step in between I am missing here to generate the inventory transactions so that they can be transferred to GL? I can’t see any data under Inventory transaction history as well so looks like I am missing a step here  

Hi,I recently got a new 25R1 repository in IFS Scope Tool and I downloaded the 25R1-Data Tracker Template File.What I found is that values are missing in Basic Data sheet - column K (Global/Company/Site). This is very valuable information for us since we are going to implement IFS to a multi Country/Company solution.Also we are also missing the entire Master Data Tracker sheet.My question is if there will be a second release of 25R1 Data Tracker Template including the missing values and the Master Data sheet?Kind Regards,Christian 

Hi.There’s an existing thread on this with a fix here, but following it I was unable to get the migration job working and I’m still receiving the same error. We’re aiming to update only the CODE_F field with a migration job, but running the MIGRATE_SOURCE_DATA job after the CREATE_TABLE_FROM_FILE results in the ORA-20111: Site.NOTEXIST2: The Site object does not exist. error for every line in the file. As  mentioned in the post above, I’ve attempted to add the CONTRACT field into the file mapping, but sadly it has not solved the issue. Any help here would be appreciated. 

Hi, I wan’t to update only certain fields (the adresses) of the customer info adress view by data migration. Is it possible ? What do I hace to do to recuperate the other fields that I don’t wan’t to update ?How can I construct the field “Adress” that seems to countains the new address ?Thank’s.Julien.  

Hi all.My client is upgrading fron IFS App 10 to IFS Cloud 24.2.In IFS Apps 10 they share the consults that are saved with others users and it is a good functionality for them. They asked me if this functionality is allowed in Cloud and I do not find anything related to that.So, is it possible to share the bookmarks? I’m not meanning to export/import functionality between profiles but share the bookmark when you set it up.

Hi All, I’m having an issue with migrating persistent custom fields using the data migration manager. Seems like the objid and version in the deployment container is not passing even if I set it to in scope and  set auto generated flags on.in the deployment container it doesn't show the generated objid and version once the master record is deployed. this is related to part catalog (master part). master record deployed correctly but not the custom fields.  am i missing anything here or do we have any issues migrating custom field data using the DMM ? IFS cloud 24R2 Kind Regards!Niyo 

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 [CATALOG_TYPE] in Sales Part may not be modified. The value of [CATALOG_TYPE] is ‘NON’. Is it possible to proceed so ? Thank’s Julien.    

Hi.We’re hoping to create an OnServer CREATE_OUTPUT_FILE type migration job that would return all active employees in our organization, including the address data for their listed company work locations. Work location data already exists in the table, but the address data for the work location doesn’t. This is a copy of an older migration job that returns other employee results, and based on that I’ve created a SELECT statement in the File Mapping tab as follows: (SELECT ADDRESS FROM IFSAPP.PERS_COMMS4 WHERE COMPANY_ID = IFSAPP.COMPANY_PERSON.COMPANY_ID AND PERSON_ID = IFSAPP.COMPANY_PERSON.PERSON_ID) With this query, the job runs but returns only partial results and the following error: ORA-01427: single-row subquery returns more than one row As I understand it the Address field is a concatenation of multiple Address fields (Address1, Address2 etc). Is there a viable workaround this issue due to the nature of the Address field?

Hi All,  We are looking to get some basic data setup (Even if it’s just dummy data) in build placeWhen the environment  expires we lose a lot of time setting the basic data up for testing. Does anyone have experience with setting it up so when we build a new environment it already has data. We believe this is possible but we are struggling to get the process set off. ThanksCameron

Is there anyone here that uses IFS and connects it to Salesforce? I have so many questions about this integration and why certain fields don’t map as expected. We are using the Address Type in IFS to map to certain fields in Salesforce based on the Default Address value, but certain records aren’t getting updated as they should. I did notice that some records in Salesforce don't have the document address populated if the Latitude and Longitude in Salesforce doesn’t match IFS but that doesn’t seem to be consistent enough to me. Thoughts on this anyone?

Dear Community, We are looking for an expert in "migration jobs." The goal is to develop a migration process—specifically an "Excel migration"—to generate a manufacturing control plan (header + lines) from an Excel file, which itself is an export of the definition plan.!--startfragment>This approach aims to eliminate manual data entry, thereby reducing the risk of typos and saving valuable time.!--endfragment>!--startfragment>So far, we’ve successfully generated the header of the control plan (seq 10 in the job). However, the task becomes more complex when it comes to generating the individual data points.!--startfragment>Several views are involved in the process, and I’m currently feeling a bit lost navigating through all of them.!--endfragment>!--startfragment>!--endfragment>Has anyone h

Hello, In view ENG_PART_MASTER_MAIN I have column description and I want to create excel data migration, but in this excel data migration i cannot see this column Description, why? I want to add some items with part_no and description. In IFS I added this column but I still cannot see Description in excel.  Thanks