Data Migration

Hello!I created a MIGRATE_SOURCE_DATA Migration Job to modify a field on a Fixed Asset. The field is Estimated Life.Field I want to modifyIn the database the field is called estimated_life_cl and is a VARCHAR2(4000)By using a trace and debugging code, I found that the API used when modifying that field is DEPR_DISTRIBUTION_API.MODIFY__. Here is the code.Code to run a modification on estimated_life_clThe problem is: My migration job is doing nothing!All I get in the “Last Info” value is thisNot very useful to understand the problem :)Here is how it is configured Header with DATABASE INFORMATION TabSOURCE MAPPING TabMETHOD LIST TabMethod List Attributes FormMy IC_FA_OBJ_HEAD_IMP table (the source of this job)Any idea what could be wrong? Any suggestions on what to try to debug and fix this problem?Feel free to request any additional information and I’ll provide gladly

Dear community,We are experiencing an issue with the Excel Add-in on a limited number of computers.The following error message appears when users attempt to connect:"IFS.Fndmig.ExcelAddIn has not been configured to run in the selected language. Please use a different language to log in."Has anyone encountered this issue and identified the root cause or a workaround?Thank you for your support.

Hi All,When I migrated Resources tab in the PM Action/Work List, the Sales Part Site field was not migrated, even when the loaded data had a value for CATALOG_CONTRACT field.And the Cost field was not populated  in the Resource tab.IFSAPP10 FNDMIG job with MIGRATE_SOURCE_DATA procedure.view Name = PM_ACTION_RESOURCE_UIVI have attached the migration job and a sample data file i tried.Can I please know if I am doing anything wrong in the migration job?Appreciate any guidance or suggestions!Thank you!Disna M.

Hello,IHAC tying to update the expire date on 4,000 records within ‘report archive’.  According to support KB0084604,” To update the expiration date, system use 'Report_Archive_SVC.Do_Change_Exp_Date' method. Users can create a new migration job with this method to bulk update the records.”How does one properly set up the migration job for this?How do we determine the required source columns, parameter mapping, and expected input values for the method.?If possible, it may be helpful to provide:A sample Migration Job configuration Required parameters for Report_Archive_SVC.Do_Change_Exp_Date Example mapping for updating expiration dates in bulk Any relevant documentation or screenshotsThanks in advance for any guidance.

We are in the process of transporting data from IFS database into an organization internal Data warehouse. We are needing a list of IFS database objects that have PII information. Please let us know if there is a some kind of have a dictionary or data guide that helps to identify where sensitive entities/fields/etc may be in the databaseProduct Version: 24.2.5Business Impact: Unable to proceed with setting up the ETL process to transport data from IFS database to the internal Datawarehouse

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  

Hi All, I have migrated data into Fixed assets Object page by creating a migration job with the view FA_OBJECT.And now I’m trying to import objects to each FA Object to add Acquisition data and Depreciation information.So I created a migration job connecting FA_OBJECT_TRANSACTION view but it seems like that’s not the correct way to migrate them because they’re not showing in balance analysis report. But I can see records in Post Imported Object Transactions page.I would really appreciate it if I could get your guidance to migrate them.Thank you in Advance! 

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?

Is it necessary to update the manifest required for the Excel add-in in conjunction with IFS Cloud updates? Also, if you are aware of the update procedure (including steps for end users of the Excel add-in), could you please let me know?

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?