Data Migration

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_

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

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

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 :

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: 

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

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.

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.    

Apps 10 update 12:I am trying to load some new Inventory Locations.  The migration job is pretty straight forward, see below.When I try and execute, the first row is successful but second and subsequent rows fail.  The error is:Insert into WAREHOUSE_BAY_BIN_TAB failed - ORA-20112: WarehouseBayBin.FND_RECORD_EXIST: The Warehouse Bay Bin already exists. (Error caused by line: 3)It appears that there is a LOCATION_SEQUENCE which retrieves from a sequence (if the field is empty in the attribute string).  Looking at the output of the failures, it is trying to use the same LOCATION_SEQUENCE value for each record.  Anybody have any ideas or have been successful in data migrating inventory locations?Thanks in advance,Dom

We are on IFS Cloud 25.1.2.  Microsoft just forced updated Office to 2507 (19029.20136) which broke our IFS Excel add-ins.  Users that stayed on 2506 are still OK.Issue is, when you click login, the add-in panel briefly flashes and does not bring up the login window for IFS cloud.Anyone else have this issue? 

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  

I am using Excel add-in for data migration most of the time no issues.in a few examples i need to do some data retrieval/lookup and have used an expression in the ‘default value’ column in the migration job.However, as yet i am struggling to do the same with a simple SQL select. Is it not possible or is my syntax incorrect. I have no guidance so I am making it up as a I go, I could be doing it incorrectly.I did write a select first in quick reports to prove it was correct, although it is so simple I did not really need to.When I click validate or execute - I don’t get any feedback, (the debug feature does not work) - but if I remove the select my other data updates - so something about my approach is failing. Thank you for any suggestions!  

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?