Data Migration

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! 

We are working on an effort to implement the India GET Functionality. To implement this new functionality we need to create a new Company/Site. We will be migrating from one site to another. As we work through all transactions, we have an issue regarding our open inter-site Purchase Orders > Customer Orders.Specifically:We have Intersite Purchase Orders (our India site 1300) to one of our internal Supplier: 10 where the connected Customer Order is on Site 10.When we migrate the Purchase Orders (from site 1300 to the new site with India Get: 1301) we are looking for a way/best practice to reconnect them to the existing Customer Orders in Site 10.Product Version: 24.2.6We have close to 4,000 open Inter-Site PO Lines that will need to be migrated to the new site. And are looking for the best way to update all of them in mass.

This I think is one of those questions that will be hard to solve, hopefully I’m wrong. I have been using the Data Migration Manager for some time now, it works well(ish) for (al)most all containers… sometimes… well… nobody’s perfect 😁One area where I have struggle particularly is the Additional Deployment Processes, more specifically, the Post Deployment actions that update statuses.I have seen one example created by IFS R&D which is the one that update statuses for CUSTOMER_ORDER entities. It is normally included in DMM templates and it does precisely what it should do.Updating Customer Order States in DMM: The “Happy” path!I needed to do something similar for PROJECTS.I thought updating STATES for other entities (such as PROJECTS) using this example as reference, should land me where I needed to be, so after finding what code behind gets executed when updating the STATE of Project I got myself into the task of creating a similar Additional Deployment Process in DMM, only to mov

Hi together,we are currently in an Upgrade Project to 22R2 and we want to migrate Notes.We found the topic Job migration of Business Opportunity - Note issue | IFS Community but when we enter the method BUSINESS_OPPORTUNITY_API.Write_Note_ in the Method List of the Mig Job we get the following error. So we checked the API in PL/SQL Developer and saw that the datatype for rowid_ is ROWID. This seems wrong.Does anybody have the same issue? Do you know how to fix that error?Thanks in Advance for any help!Best regards,Andreas

i am trying to migrate Posting Control Details but the Migration Job fails with a strange error. I have confirmed that the Posting Control Master record is available with valid dates but i still get the mentioned error. Any clues what might be causing this? Thanks Insert into POSTING_CTRL_DETAIL_TAB failed - ORA-20111: PostingCtrl.FND_RECORD_NOT_EXIST: The Posting Ctrl does not exist. 

Hello;        I’m new to IFS & I’m quite surprised at the difficulty there is in changing a unit of measure. I’m a designer, & a portion of my former company was acquired by another who uses IFS. In the process there was a lubricant that got transferred & the unit of measurement was a pail. I’m not sure what the correct unit is but that wasn’t the unit it was supposed to be. Instead of being able to correct the unit, my main division of the company is saying the only thing we can do is create a new part no. with the correct unit of measure. This lubricant is used all over the place in 103 boms & 93 drawings which would have to be changed. Is this a limitation with IFS, & if it is, why would it be. I believe with our former system using CMS, we would have just revised the unit, & been done with it. I should add, it has already been used which seems to make it more of an issue.Thanks for any input in advance. SonDrum

I’m trying to test AccountSet (GET) API IFS Cloud Demo environment as follows. Im able to retrieve the bearer token using following IAM client but once I pass the bearer token to the API it gives me following error. Appreciate if you can help with resolving this error. {    "error": {        "code": "DB_ACCESS_ERROR",        "message": "Database access error. Contact administrator.",        "details": [            {                "code": 20105,                "message": "ORA-20105: Login.FUSRNULL: The directory id XXX is not allowed to run the application."            }        ]    }}

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.    

Hi IFS Community!Upon running the Excel-Add In for Data Migrations on IFS Cloud for a specific job in Production, we get "Unexpected end of JSON file" with no further information as to why this is happening.We migrated the same data to a different environment last week (CFG) with NO errors whatsoever, so we know that the data we are migrating is not the issue.We checked permissions for the user running the migration and it all looks fine as well. Any ideas what could be causing it?

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?

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  

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?