Data Migration

Hello Community,I'm facing an issue with the Data Migration Manager. Whenever I deploy records that include dates, the time is being interpreted as 12:00 PM instead of 12:00 AM, which leads to a "resource not found" error.For example: 1/1/2000 12:00 PM is being used, but it should be 1/1/2000 12:00 AM.I've tried modifying the date format in the legacy file, but that hasn't resolved the issue.Thank you for your support.

I have set the file type for 2 views (Header & Line) Material requisition ( MATERIAL_REQUISITION  & MATERIAL_REQUIS_LINE ) but row status unpacked.any suggestion from anyone. how to solve this issue. Please see the steps of data setting after transaction screenshot.   

Hello everyone, I hope you're all well!I'm starting to learn how to do a data migration in IFSCLOUD and I'd like to know if anyone has a step-by-step manual for importing data using an Excel spreadsheet.Thank You

Hi,I would like to know how I can send an excel business report from IFSAPP 10 to SharePoint. I am using Power Automate for this. I want to know how to send an excel file to Power Automate when sending POST JSON request using Power Automate API. I have the Power Automate API. Just want to know how to add an excel file to JSON payload. is it possible to convert BLOB to   Base64 ? Thanks,Sachini

Hello community,For opening balances migration, what is the better approach for Down payments into supplier? Is there a template for that or it’s possible to migrate those advances invoices through the template  Thanks and Regards.

Is it possible to get more granular information about what is contributing to our Database growth rate?   On IFS Cloud (IFS Hosted) for past 15 months?  This PowerBI report was generated via the Service Insight Studio on Build Place.    We started with essentially no transaction history so this growth rate seems quite high...   

Dear Sir/Madam,When I press the login button in EXCEL Add-in, the login screen does not appear.Can someone tell me how to solve this?

Hi,Has anyone managed to configure the migration job/jobs so that you can migrate instant invoice header and lines (multiple headers and multiple lines). The problem is that when creating the header, invoice_id and inovice_no are generated and you have to enter it in lines.I'm talking about the window Financials\Supplier Invoice\Manual Supplier Invoice

Hi All, We are implementing one integration, which includes, we read csv file from URL and dump the data into custom table. By reading the custom table, we are calling the  API and updating the data into IFS. We get any error with the data from CSV file, then we need to create a projection to log those error. Can anyone please  help me to create the projection to log the errors ?   

The standard customer invoice templates facilitate to load advance customer invoices. Can they be connected with the customer order number when loading? The reference fields can be used but it will not connect the customer invoice with the customer order.

Hi, We’re currently about to go live and we have a number of open orders that have been configured from on legacy system which needs to be migrated over to IFS. We have created migration jobs for customer order header & customer order lines.We’re yet to create a migration job for the configuration as we’re not sure if it’s possible to migrate configuration ID’s with configuration spec values into IFS or if this has to be manually.Has anyone come across this before and how did they get around it?  

Need to know if anybody load actual hours on project? I am using the voucher entry load for historical information but what can be use to impact the used/actual hours as well?

 Hello, How should I approach this kind of data migration / Custom object usage? The need is to show inventory part’s newest revision from on inventory part main page. I have created Custom object like this to General page of “Inventory Part“ The problem is that in our environment this Revision information is saved only on different site (So called Master site) and 90% of users do not have access this site. Would it be possible to use somekind of migration job to get Revision data from master site part revision tab and save it to this custom field? Revision information on Inventory Part Revisions Tab Custom field “Revision”. Data is from Master Site and without user’s access right to Mast site, this does not work.   

Hello, Trying to implement a user available excel migration file and have to solve two problems to make it useable.  problem 1) Want to make one of the columns a drop down with 5 to 6 options for ease of input and formatting. Other values could be manually input but the drop down would contain the most frequently used values. Would prefer to do this using Client Values and not DB values. In this example it would be the Work Task Template ID  - Description - Rev. Problem 2) This specific migration container is to a custom page and the primary values are Contract and Line No. The issue is that the migration file is asking for line DB value and the user will not have access to that information since its not viewable in the client. There is an API call to the OBJKEY on that table which is the DB value for the Line Number. Trying to determine how to have the file fetch the DB value after the user specifies the client value.  I’ve scoured documentation and watched numerous videos with no luc

Hi everyone,  My need would be to migrate WBS Projects and automatically import the structure of the Project such as allowed by the standard API PROJECT_API.COPY_PROJECT_ATTR.This API is related to standard command “Copy Project”:There are a lot of parameters to be set up in the client when using this wizard, but I can’t manage to identify all of them properly using the SQL debug console as well as triggering the Method in a Data Migration Job.I am in IFS 21R2 Cloud Version.Here are the parameters that I managed to retrieve from the SQL debug console in IFS APPS 10 for the attribute OPTIONS_ATTR_ :'PROJ'||chr(31)||'YES'||chr(30)||'SITE'||chr(31)||''||chr(30)||'SUBPRO'||chr(31)||'YES'||chr(30)||'RUNINBACKGROUND'||chr(31)||'NO'||chr(30)||'COPYSITE'||chr(31)||'FALSE'||chr(30)||'ACTIVITY'||chr(31)||'YES'||chr(30)||'TASK'||chr(31)||'NO'||chr(30)||'PROGRESS_TEMPLATE'||chr(31)||'NO'||chr(30)||'DOCPACK'||chr(31)||'NO'||chr(30)||'DOCOVERVIEW'||chr(31)||'NO'||chr(30)||'P3CONSTRAINTS'||chr(31)||'

 Hello,How to include multiple views on replication job? We have already replication job that replicates item data from one site to another sites. There’s only INVENTORY.PART view included in this replication job and it’s working, but now there’s also need to include PART_REVISION data to this same replication but I cannot figure out how this can be achieved. Here’s the original replication job with only one view. This works ok.  Here’s how I have tried to create new replication job with two views. INVENTORY_PART and PART_REVISION. Firstrly I’m not sure how should I use the “Source Name” field. I guess I should use join clause here but not sure how should I format it. I have tried with these guides but with no success..Internal Replication (ifs.com)Db-Links, JOINS (ifs.com)Replication tab of the new replication job Source Mapping tab:And Method list 

My Basic Data Container in Data Migration Manager is saying that these 5 records for countries are in a “Not Deployed” Deploy Status state…  Yet, if I go to the Deployment Container for the same Target Table (ISO_COUNTRY) my 5 rows are in either Deployed With Commit or Deployed state. Why is the discrepancy between the Basic Data Container and Deployment Container Statuses? is this a bug in the User Interface?

Dear All,I would like to know if it is possible to use Data Migration Manager(DMM) tool to migrate 'Resource Deatails' and 'Resource Connections' in IFS. Has anyone done that already?If possible, how do we do that? How do we handle sequence numbers in DMM? Any examples?Can we use 'resource_connection_seq.nextval'?Any reference documentation/materials will also be helpful.Thank you!

We’re implementing our first FIFO site in IFS and trying to migrate the actual Received Dates for their raw material inventory.  Seems IFS wants to always set these to the import date and not the actual date value.  Anyone faced this or have a workaround?

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 here already implemented a migration job for creating manufacturing control plans (applicable version : 8) ?!--endfragment>!--startfragment>Thanks in advance

Hi Admin team, Since the beginning of this year, all the contents of the posts on the community have been blocked for me. They are covered by block of plain colour patch like purple. Not sure whether just me get this issue or same to some of the members. Is this issue related to expiry of my membership or not? 

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 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

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.

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