Data Migration

I am using the Smart Data Manger concept in IFS Cloud, Navigation : Solution Manager > Data Management > Data Migration Manager > Project Basic Data  DB link is created from IFS Cloud db to fetch data from the Source (tried IFS Apps10 and from FSM Database)But in Project Basic Data - Under connected environment : Database link is listed only if the DB Link source is created from IFSMIG User (Tried both in IFS app10 and in FSM database)But IFSMIG Schema is introduced only from IFS Cloud versions, not available in Apps10 and obviously not available in FSM db, so how do we connect the legacy database of Apps10 or FSM DB?Need assistance on using Smart Data Manager for Data Migration task to fetch data from Apps10 or FSM db.Please confirm if this approach is possible using SDM  DATA Migration :IFS Cloud ← Data from IFS APPS10 or IFS Cloud ← Data from FSM DB

 Hi Team,Could you please advise on the way to add an additional book for fixed assets that have already been imported? We have tried the following way as described in the below post, but it does not work in IFS Cloud. Importing Depreciation for an Existing Object/Asset | IFS Community Please see below our migration error message:  Thank you in advance for your support. Regards,Yentl

Hi Experts. We plan to use Data Migration Manager.We would like to import data from the legacy system in JSON format.Is there any way to do this? 

We have migrated our IFS production database (Oracle 12c) to our client’s AWS cloud environment. The  was migrated to Oracle 19c.We are encountering issues similar to what occurred when our DEV environment was migrated, where the FND roles were missing supporting sub-role grants. We have fixed most of them manually, but there are a few new issues where we are getting errors like ORA-20105: "FND_WEBRUNTIME" is non existing grantee. There are others that have similar errors: BA_ADMINISTRATOR, BA_BARS_ADMIN, BI_VIEW_ACCESS, BR_FULL_IS_VIEW_ACCESS, FNDSCH_RUNTIME, and CUSTOM_OBJECTS_ADMIN.We tried to export/import the roles from our on-prem database and importing them, but still get the above error.What happened during the migration? How do we correct it?

Our company is on cloud version 24R2 and we have missing capabilities for our admins. We need access to Data Management > Migration Jobs with permissions sets FNDMIGRATION_JOB (limited access) and FNDMIGRATION_JOB_MANAGER (full access) which I do not see. Would someone please provide us a step by step solution to get this resolved?

I'm trying to import current supplier ordersI'm getting the following error: No revision found for inventory part 303406This applies to all products. What I did:1. Imported the order headers: OK2. Added the product-supplier links for the corresponding order lines: OK3. Added the order lines (PURCHASE_ORDER_LINE_PART) for which we have the product number: KOI tried putting 1 or nothing in the ENG_CHG_LEVEL (Revision No) column.With 1: ORA-20110: ChangePurchaseOrderLine.NOREVFOUND: No revision found for inventory part 303406Empty: ORA-20110: ChangePurchaseOrderLine.NOREVFOUND: No revision found for inventory part 303406If you have any ideas, you're welcome.

I know that the Entity configuration has changed from Apps9 ‘WoRoleSrvQuo’ to IFSCloud ‘JtTaskSrvQuoResource’.I would like to know 'ROW_NO' in Apps9 ‘WoRoleSrvQuo’ corresponds to which item in IFSCloud ‘JtTaskSrvQuoResource’.I would also like to know the conditions for linking Apps9 ‘WoRoleSrvQuo’ data to IFSCloud ‘JtTaskSrvQuoResource’ when migrating the data from Apps9 ‘WoRoleSrvQuo’ in a core upgrade.

I am receiving the following error when trying to create inventory parts from engineering parts : Invalid value for property 'PartNos'.Any idea what might be the issue?

Hello,I try to upload Purchase Order lines. As there is no particular notes, I let empty the Note_id field.This brings the following error : ORA-01400: cannot insert NULL into ("IFSAPP"."PURCHASE_ORDER_LINE_TAB"."NOTE_ID")Any idea about how to avoid such error ?Thanks in avance

Hi all,We want to add custom menu on Execute Job page but when I try to create new projection configuration I can’t find entity name of IntfaceHeader. Is there any specific reason why I cant find it. Does any one know how can we solve that?  

hi, İ wanna create an excel migration about Cost/Revenue Element per Code Part Value.i select view name - PROJECT_COSTREV_CODE_PART source mapping coming is empty. i want to try add but i am getting the following error. how to make an excel migration to match cost/revenue and code parts.  

Hi Community,I am facing an issue when i am trying to transfer legacy data to input container with the date field. other date field mapping like valid_until and acquisition date are working just fine. The error i am getting is for the VALID_UNTIL column which has a value as 30.12.2049. the value for other column are also in the same format. The error is am getting is “Unable to start IC_ADD_AND_META_VALID - ORA20110: DatInputContainerUtil.EXEERR: Error while selecting data from legacy file(s). ORA01861: literal does not match format string”. Can anyone please explain me why this is happening.I even checked the training video but there is not much information on handling date column when transferring data to input container.I would Appreciate your input on solving this. Tank you

We have some information stored in technical attributes for equipment object that would like to migrate to Service Notes, but that was not as easy as I though since Notes are a CLOB field.We are currently on 24R1 SU4 and I found this workaroundExcel Migration - Technical Documentation For IFS CloudBuisness_Lead_API have a procedure Write_Note_Excel__, but Request_Contact_Note_Api does not have a similar procedure in our version. Could some see if the Api been improved with such a procedure in 24R2 or 25R1?      

Hello,I noticed that Engineering part transfer actions do not check wether the engineering revision already exist on destination site until a first transfer is made.I’m having an issue with a customer where inventory parts & engineering part revisions have been created via data migration. However, now each time a une an existing part revision in a new engineering structure, when I transfer the top code it creates revisions for all the components … This means the setup of Product structures (issue to location, conumption type, alternatives,  ...) needs to be made every single time a component is transferred for the first time, for all the parts already in destination site. I tried to tag the transfer actions as ‘transferred’ but couldn’t reach my goal. => Has everyone encountered such an issue ? How could this be fixed ?Thank you,//Pierre 

The PROJECT INVOICE should  have direct access to the Customer details with hyperlink. This is already in place and active with the CUSTOMER INVOICE.  

Hi, We have a business requirement to import attachments (all doc formats and JPEG, PNG, JPG, etc) into IFS Cloud work task template, functional object from an external non IFS system application. We came across FsMig Tool (File Sharing Migration Tool) which is used only to import attachments from IFS Applications to IFS Cloud. is there some tool or any better way to import attachments from other systems to IFS cloud, open to suggestions.

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.

Hi Team, We are doing migration using the Ventechi script. We have a question about this: What is the processing time for this? It's been a day, and it is still running. Can we get the max time it took to process so far and the least time? Is there any workaround to speed up this process? Thanks, in advance.Thanks, 

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

Is it possible to import data into Excel using Excell addin by the Search function - only rows with empty ( NULL) field ? In IFS (cloud version) we can show rows with empty fields only using filter “!<>”  Is it a similar solution for import rows into Excel ?  

Hi All,I was following the below URL to use Excel migration job to insert/update Note field in BUSINESS_LEAD page in IFS. (IFS Cloud 24R1)https://docs.ifs.com/techdocs/Foundation1/040_administration/260_data_management/050_data_migration/002_migration_types/030_excel_migration/default.htm?_gl=1*1kzdxq4*_ga*MTI0OTMxMDg4OC4xNzA0ODM1MDgw*_ga_H7YJR9R7Q1*MTcwODUzMzQ2Mi45MC4xLjE3MDg1MzM0OTAuMC4wLjAAnd I got below error when trying to insert or update the Note field.I have attached the migration job I used.What could be the reason or any idea of resolving this error will be much appreciated.Thank you!

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.

We are looking to find a way to zero out and add back our inventory quantities, as that is a requirement to move from FIFO to Standard Costing and Allow Negative OnHand. Long story short, IFS deprecated deferred backflushes from Apps10 on.We are in IFS APPS8 but upgrading to Cloud. We want to do this change before said upgrade.Does anyone have any ideas how to do this is a script or batch manner?We have engaged IFS to provide with a script but they’re not really coming thru, and our implementation partner doesn’t want the liability -if they provide the script and somehow that fails and messes our data.We would need one method/script/batch to zero out our Inv Part in Stock quantities, and another to add the quantities back, in-between us make the inventory part changes and rolling costs.Our partner suggested that maybe a script using Issue Inventory Part and Receive Inventory Part, but the problem there is that the receive method changes the receipt date. It would probably have to be Co

Hi, I would like to copy an external file template from an environment to another one. Can somebody heklp me. Regards Christophe

Hello All, Can anyone help, how to use Api Before Unpack and Api After Unpack in package option in external file template input file in ifs aurena.