Data Migration

We are trying to bulk change the status of Product Structure/ Routings Alternate from Tentative to Buildable as part of the migrated data using the below settings but the job is not updating anything and getting the below error ,not sure what is going wrong here  

Good morning,How can I configure file imports from a specific location, e.g., a network directory, using external file transactions in the IFS CLOUD system?I assume that I have a .csv file in a specific directory and the system has a schedule for reading the file from that directory.I am considering this in the context of currency imports and wondering whether it would be reasonable to use the file reader mechanism in this case.

We are currently in IFS CLOUD 25R1. We successfully migrated all of our documents from our on prem non-IFS system to IFS CLOUD (600k files). Then we migrated the documents from database storage to our BLOB. However, we need to now migrate to the production environment. As we were only in UAT. To avoid migrating all the documents again. Could we clone the file storage from our UAT environment to our PROD environment. Then populate all of the needed tables that reference these files? If this is possible does anybody know what all tables would need populated. I know of EDM_FILE_TAB, DOC_ISSUE_TAB, but I wasn’t sure if there was another table I was missing. Any help on this would be useful. Thank you. *NOTE we cannot clone the database from UAT to production because we need our PROD environment to be a blank slate for our data migration.

Hello everyone,We recently migrated to IFS Cloud 25R2 (SU6) and noticed a change in the format of the "ActualShipDate" field in the Dispatch Advice messages (DESADV) we send.Before migration:"ActualShipDate": "2026-07-17T16:04:55" (local timestamp, no timezone indicator)Since the migration to 25R2:"ActualShipDate": "2026-07-20T10:29:20Z" (UTC timestamp, with "Z" suffix) This is causing issues on the receiving side, which expects the previous format without the UTC indicator.Has anyone else run into this on Dispatch Advice (DESADV), or on other outbound messages? Is this an intentional/documented change, and if so, is there a way to keep the previous format?For reference, we have also opened an official support case on this topic: CS0542209.Thanks in advance for any insight! Soumia

I am trying to migrate Project activities. using Insert or Update procedure in migration job. I am getting this error: INFOError ORA-01422: exact fetch returns more than requested number of rows when executing BEGIN SELECT objid, objversion INTO :objid, :objversion from ACTIVITY; End;  Is this a bug?

Do we need separate license for Smart Data Manager Migration Tool or as part of standard IFS 11 cloud license we get SDM to use for data migration.

25.1.7Using the DMM tool, if the standard unit in IFS for INCH is ‘in’, will a part migrate if it’s unit in the legacy system is ‘IN’? Does the legacy unit case affect if the part will/will not migrate?

We are implementing data purging in our Clevest Test environment and need clarificationon the recommended approach before moving to production:Current Setup:- Active Archiving feature- ETL Data Warehouse task running every 15 minutes (non-one-to-one mapping)- Web frontend purging feature availableQuestions:1. Should purging be configured via Archiving or ETL?2. What is the recommended sequence: Archive → Purge → ETL, or another order?3. How do we ensure all source data is captured in the Data Warehouse beforepurging from the source database?4. Does the system automatically archive before purging, or must we manuallycoordinate this?Thank you,

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  

HiI have connected to our PROD environment via Oracle Database in Excel but I can’t seem to find the correct views.I have searched within the folders listed but unable to see INVENTORY_PART view for example.Is is possible to query these views in Excel? 

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? 

Hi, We have just upgraded from Apps10 to CLoud.  Cloud no longer has a sticky note feature, I am trying to find the best way to convert the data held in the table to readable text.  My hope is to create a custom field on the table and then populate it with the data.  However when I try to convert I am getting the following in the field. {\rtf1\ansi\ansicpg1252\deff0\deflang1033{\fonttbl{\f0\fnil\fcharset0 Trebuchet MS;}}\viewkind4\uc1\pard\lang2057\f0\fs20 new PO has been created\par\parplease see \fs20 E200049\lang1033\par} What is the best way to get the actual text ?

Can someone point me to the location of the 24R2 Data Migration Manager Project Template file?

Hi. I have the following structure of the XML file called data.xml <?xml version="1.0" encoding="UTF-8"?>!--scriptorstartfragment--><Message>    <ErrDiscoverCode>10</ErrDiscoverCode>    <Description>data10data</Description></Message>!--scriptorendfragment--> I need to be able to import this data into IFS, and I'm doing this with Postman using this API. Post:https://*******/int/ifsapplications/entity/v1/WorkOrderDiscCodeEntity.svc/WorkOrderDiscCodeSet{  "ErrDiscoverCode": "10",  "Description": "data10data"}   I'm unable to register the following data in IFS:  What is the procedure for registering IFS data that comes from an XML file? Thanks 

I have a user on my team that, when opening an EXCEL_MIGRATION job on a spreadsheet, gets the results where the “Result Column” is created but left outside the Excel Table, like this: odd results from the user In spite of that, if I do exactly the same steps this executing, I end up with a table where the “Result Column” is included: it works for meAt first I thought something was wrong with the Job configuration, but having confirmed this cannot be replicated in my computer (and it also worked fine for a 3rd user who tried it...) I am more inclined to believe this is an Excel issue on this user’s machine. Has anybody experienced this behavior, and if so, can you tell me what can be causing this? Thanks!

Hi Everyone,We have a customer using the Test Data Management tool, and they currently have a quota of two environments.We have already approved and created a QA environment, and we now need to create two DEV environments. Before proceeding, we would like to confirm whether creating the new DEV environments could have any impact on the data in the existing QA environment.Thank you for your assistance.

Hi,In the documentation of 25R2 it is mentioned that IFS comes with pre-packaged data migration definitions. These prepackaged migrations should consist of:The definition itself which is available upon manual installation of the PROD components as migration jobs in the form Overview - Migration Jobs An excel spreadsheet that may act as an input container for the data with additional information about fields, formats constraints, etc.I can see the migration jobs are there, but I can't find the Excel spreadsheet the documentation is referring to nor can I find a job that is able to create this. Does anyone more about this Excel spreadsheet?/Michael

Getting an Error when migrating Sales Contract Header. Insert into SALES_CONTRACT_TAB failed - ORA-20110: SalesContract.CONWINPROBERR: Win Probability must be within the range 0 - 100. (Error caused by line: 26)PLANNED_START_DATE=2006-04-17-00.00.00PLANNED_FINISH_DATE=2027-04-01-00.00.00WIN_PROB=100CUSTOMER_ID=XYZAm i missing anything?

Hi,I was wondering if there is a way for me to delete IC tables created by migration jobs of type CREATE_TABLE_FROM_FILE. I don’t have access to database, to use sql operations.Thank you,Roshan

I'm trying to update an existing record for functional objects using the Smart Data Migration Manager (DMM) tool. I've mapped the Equipment Object Seq field to the legacy source, but when I deploy from the deployment container, it treats it as a new INSERT and returns an error saying the functional object already exists.I've included all the configuration details and data in the description. Could someone help me identify what I might be missing or doing incorrectly?Excel Record I’m trying to Update :Legacy Data :Mapping : Deployment Container :Error;  

There are a lot of migration jobs that are run every night, for example, a re-schedule job to update shop order need data from MRP calculated date. There are also many scheduled custom and standard database tasks running.The mig jobs run perfectly well and quickly in Apps 10 but run extremely slowly (I mean like they take hours instead of minutes) in Cloud 25R1.There's doesn't appear to be any reason for their slow running in Cloud. They eventually complete without errors or warnings, which is frustrating because if there was an error or warning that might give me a clue!Has anyone else experienced this behaviour and what steps did you take to troubleshoot and were you were able to resolve it?Grateful for any comments, advice or experiences. They are run by a service account (on a fast queue) that has access to the jobs and pretty wide ranging permissions. As I said, no errors or warnings, just e x t r e m e l y slow to complete.Thanks in advance!

Hi,We have imported several thousand Request Contracts using DMM. They are at status ‘Planned’ and we want them to be Active. Is there any way that we can automate making these Active? Presumably we need to update objstate and/or state fields on sc_service_contract but these fields don’t seem to be able in the mapping. 

I am trying to migrate Migration Job Group but i am getting this error when i import, What am i missing 

I’m looking for a reliable approach to migrate users from one environment to another. Currently, during ongoing development, we frequently refresh non-production environments by cloning production data. However, this process removes existing users from the lower environments, which creates recurring issues and requires significant effort to manually recreate user access.Is there any functionality available that supports exporting and importing users along with their associated configurations—such as roles, sites, person records, and related data? Any guidance or recommended approach to streamline this process would be greatly appreciated. We are currently on 24R2 and will be upgrading to 25R2 next month.

Hi All,I am using IFS Cloud 24R2. FNDMIG job using MIGRATE_SOURCE_DATA procedure.Does anyone know how to avoid the above error when migrating customer_order_line ?The DEFAULT_ADDR_FLAG has value ‘Yes’ and DEFAULT_ADDR_FLAG_DB has the value ‘Y’, but the error says it is NULL.ORA-20124: Error.NULLVALUE: Field [DEFAULT_ADDR_FLAG] is mandatory for Customer Order Line and requires a value.The source data will have  below values.Is something wrong with these values? Should we check on a value of another field in the data set for some validations?Your thoughts, experiences and suggestions to solve this issue is much appreciated.Thank you!