Data Migration

Data Migration Tool Kit (Have been majorly used in US side)IFS Smart Data Tool (New Migration Tool Launched around 2 months ago)

Settings: IFS9. Excel in Windows10 environment User has gone to Add-ons menu and selected the following two: To create and update data in IFS Applications using Microsoft Excel you need to install the IFS Data Migration Excel Add-in. As a prerequisite you need to install Visual Studio 2010 Tools for Office Runtime. Next Excel is opened. The new tab IFS Applications is visible. User uses the icon to connect to IFS: Nothing happens. No log in screen is presented. Anyone an idea what could be the issue for this?

Hi -  I can create 2 data migration jobs to create a Purchase Order. - One to create the header and one to create the lines. I am looking to create a single Migrate Source Data DM Job to create header  and lines based on an imported table of data. So the stage 1 imported Data would be simplified as something like.. Supplier Part No Qty  Stage 2 to Create a PO for the distinct list of Suppliers and then create the attached lines Anyone think this is possible without custom code? Thanks for looking..  

When trying to create migration job for method  Invent_Part_Quantity_Util_API.Move_Part and it’s not possible to save the job but you get error :Error making attribute and references - IntfaceMethodList.ILLARGTYPE:Arguement VALIDATE_HU_STRUCT_POSITION_ has illegal type. Only datatype DATE VARCHAR2 NUMBER allowed Same with Inventory_part_in_stock_API.Issue_Part_with_PostingReason seems to be that there are boolean arguments and this is not supported in data migration. Is there a way around this issue?

We have created a manifest (xml) from our test environment (IFS Cloud 21R2). Manifest is added to Excel successfully and the user can log on and load the FNDMIG job itself. But when trying to load the data this error occurs: Insufficient privileges, "SE_UNAUTHORIZED".The user has full grants in the instance.  

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? 

Has anyone seen this error message when loading or validating data for jobs with the Excel addin?  Last week we could load data the COA to the worksheet without error.  This week we are getting the above error for any of the migration jobs.  Office365Aurena  

I need to update update a custom field in Inventory_part_cfv at the same time as creating the Inventory part. Under method list, I specified Inventory_part_cfp.CF_New__ and it's of type Migrate Source data that fetches information from an IC table.I am assuming that's not enough because it doesn't update it and throws an error stating ROWKEY cannot be null.What other steps are needed? 

Hi,Can some one provide the steps for Cutover strategy in IFS and what are key points to be noted prior to data migration in Finance. Thanks & Regards,Srichand 

Hi all, We recently implemented IFS Apps 10 beginning of december for our first business unit. I was - together with a collegae - responsible for data migration. As a data warehouse builder I am wondering how we can access the data for other purposes, like reporting. On premise we have a SQL server BI stack. Is it possible for me to access data from the Information Sources? Or is this only possible from the Enterprise Explorer and/or the EOI? Kind regards, Jeroen  

Hello, I'm Markus and I'm new here in this community, and this is my first post.One of my tasks is to prepare the master data from the old ERP and migrate it to the IFS cloud. Of course, a lot of mapping is necessary, as we don't have this many columns and tables in the old ERP.I learned from our consulting to use these data migration tools: Migration Job for LOAD and for MIGI have a VPN to the IFS cloud and can select the data VIEWS via ORACLE SQL Developer to reconcile the column names and fields for the migration job files or to build the mapping for this.Is there a best practice for the migration of master datafrom our old ERP to our IFS cloud?Thank you very much for your knowledgeGreetingsMarkus 

Hi All, From where can I find IFS Cloud 22R1 Template Project file for Data Migration Manager?  I am new to Data Migration Manager and my idea is to create a Project Template and load a pre-built Template file copied into DM server location , drill down into details of the project and understand how it is set up instead of creating a Data Migration Project from scratch.

Is it possible to delete records from WORK_SCHED_ASSIGN using Data Migration and WORK_SCHED_ASSIGN_API.Remove__   Can anyone please advise how this is done.      

Hi, We have followed the instruction to install the IFS Data Migration Excel Add-in (https://docs.ifs.com/techdocs/21r2/020_installation/400_installation_options/010_data_management/030_data_migration/) but I do not seem to be able to deploy the manifest in Excel in a “Normal” Excel client. Does this only work in the web client? /Tor

How can the data be migrated into IFS cloud? Like we want to migrate some companies/sites/their users/service requests from legacy system to IFS cloud.

Hello All,I have a simple question.Is it possible to copy bookmarks for one IFS Cloud user and paste them across all the user profiles for a client? Is it possible to use the Cloud Data Migration screen to achieve this?  A client wants to avoid setting up the bookmarks manually for each of their users.Thanks in advance!Best Regards,Sayeef

Hi Community,Is it possible to delete/remove records using an excel migration job? I’m trying to delete/remove users for WaDaCo processes but unfortunately i cannot solve it.. I have added ‘DATA_CAPT_CONF_VALID_USER_API.Remove__’ in the Method List. An example could be to delete/remove all users for our scanner ID6: The migration job has the current setup:   I’ve also tried different setups. Example in the method lists to use ‘%’ in Column value and DUMMY in Column Name.  

Hi, I keep getting the error: ORA-06511: PL/SQL: cursor already openwhen executing below, can someone please tell me why:- DECLARE    info_ VARCHAR2(2000);    attr_ VARCHAR2(2000);        newrec_     identity_invoice_info%ROWTYPE;        automatic_pay_auth_flag_db  VARCHAR2(1):= '1';        CURSOR get_supp IS    SELECT * FROM IDENTITY_INVOICE_INFO;       BEGIN  FOR rec_ IN get_supp LOOP     OPEN get_supp;   FETCH get_supp INTO rec_;   EXIT WHEN get_supp%NOTFOUND;   CLOSE get_supp;                Client_SYS.Clear_Attr(attr_);                   Client_SYS.Add_To_Attr('AUTOMATIC_PAY_AUTH_FLAG_DB',automatic_pay_auth_flag_db,attr_);                        IDENTITY_INVOICE_INFO_API.Modify__(info_,rec_.objid,rec_.objversion,attr_,'DO');        END LOOP;    COMMIT;END;

Hello, We are using Apps 10, UPD13. We have sales parts in SITE1 (approx. 500K) and are trying to create the same sales parts in SIT99 using the script below but are getting an error message that the part already exists. They already exist as inventory parts in both SITE1 and SIT99.  Is anyone able to help us with resolving the error and creating the sales parts in SIT99 that already exist in SITE1? Thank you,Joann DECLARE  p0 VARCHAR2(32) := NULL;  p1 VARCHAR2(32) := NULL;  p2 VARCHAR2(32) := NULL;  attr_ VARCHAR2(32000);  action_ VARCHAR2(30) := 'DO'; CURSOR get_part_info_ IS    SELECT i.CONTRACT, i.PART_NO, p.CF$_SALES_GROUP    FROM  inventory_part i     left outer join sales_part s     on i.part_no = s.part_no     and i.contract = s.contract     left outer join    PRODUCT_CODE_X_REF_CLV p    on i.second_commodity = p.cf$_comm_group_2    and i.part_product_code = p.cf$_product_code    where     i.contract = 'SIT99'     and i.part_no like '%2'     and length(i.part_no) = 11     and s

Why is this error popping up?Would love help on this.Thank you!

Hi Guys Wondering if someone can help me with a data migration query.Scenario:As a part of Customer data migration, i am also looking to migrate Address types (Pay, Delivery and Document which is coming from view- CUSTOMER_INFO_ADDRESS_TYPE)  Created a migration job to insert new Customers,  Addresses and Address types (third highlighted view as below)  Migration job works fine and creates first default value i.e. Pay   But to pass other two default values (Delivery and Document) I am replacing Pay with other two one- by-one and running the same job few times. Is there any easier way to pass all three value once so that i don’t have to run the same job thrice? Thanks in advance/D

 To migrate data specifically for custom fields, follow the steps outlined below. After experimenting with multiple approaches, I have identified the most effective method for transferring data into custom fields. I hope this guide helps some of you resolve your challenges. As usual, you need to create two migration jobs:File Migration (CREATE_TABLE_FROM_FILE)Create the migration job in the standard manner. There are no special steps to follow for this process. Reference for creating a file migration job: Create File Migration Job.Here is the File Migration job created for this scenario, which you can use as a sample reference: Source Migration (MIGRATE_SOURCE_DATA)In this scenario, we are trying to migrate data into two custom fields created for the Part Window. The key identifier for this migration is the Part Number (PART_NO).In the CSV (Excel) file, three columns are defined as follows: Create the Migration Job:In the Database Information section, include both the migrated file tab

Hello Ifs communityI have created migration job to load data in Part Based tab for sales price list page.Lines are inserted but when i want to deleted or updated it i get this errorAnd when i try to modify one column of this line insert through migration job i had this error message :but I have no problem deleting or modifying manually created lines. I only have this problem for lines loaded via data mig job.This is my migration job source mapping : thank you in advance for your help.  Regards.  

Hi,  Currently I’m having the need of updating data daily to inventory_part_planning view. And I was recommended to use INSERT_OR_UPDATE procedure for this. How can I selectively update just for some fields, e.g safety stock, order point? Much appreciated if someone has a user guideline for this type of procedure.   

I am using IFS Apps 9 and would like to know if there is a way to mass import media items (images) in a folder and then associate them with inventory parts.  The images are named by the inventory part number.Could this be a data migration job…?Anyone done this type of import before, or similar?Any help would be appreciated.