Data Migration

I have a customer who is implementing IFS Cloud 23R1.  Their question: Is there a list of all possible data objects along with their dependencies? For example:  To migrate Shop Orders into IFS, you must first have migrated Inventory Part, Routing, Product Structure, Work Guideline data objects from your source system(s) into IFS.  

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!

Hello, I have created an event action as follows, but when I RMB and print order I get the print as expected but also get the default print.  How do I stop the default one ? Thanks

 Hello good morning team, could you help me with this question pleaseSince property is added to a Binding, I need to put a new property 

Hi all,I’m running ifs-cloud-23.1.6-penyzy3-3.5.0I’m trying to import the data from CUSTOMER_INFO_ADDRESS but the CREATE_TABLE_FROM_FILE job is splitting the ADDRESS field like so:ADDRESS=4291 5th Ave ES6V 7V6 - Prince AlbertSaskatchewanCA - CANADA In Excel export it looks like this:4291 5th Ave ES6V 7V6 - Prince AlbertSaskatchewanCA - CANADA How do I keep the information in the same record?I’m assuming it’s processing a Hidden Tab from Excel .csv file Thanks,Rob

I have created a Data Archive Job for Shop Order, I follow the documents properly  by using following documentshttps://docs.ifs.com/techdocs/Foundation1/040_administration/260_data_management/020_data_archiving/210_general_data_archiving/020_how_to_setup.htm?_gl=1*a5k3p6*_ga*MTk5MzI4Mzk2LjE2Nzc0ODIwMTU.*_ga_H7YJR9R7Q1*MTcwMzIyNDczNC4xMzAuMS4xNzAzMjI2NjI4LjAuMC4w https://docs.ifs.com/techdocs/Foundation1/040_administration/260_data_management/020_data_archiving/210_general_data_archiving/120_data_archive_orders.htm     How we can rectify this issueKindly advise Regards

I am using the Data migration tool in Apps9 to update an existing custom field. This field is indexed and coming up with the error:- Execution No 0Error creating index CREATE  INDEX IC_SM_SALES_PART_PP_REF_IX1 ON IC_SM_SALES_PART_PP_REF_TAB() - ORA-00936: missing expressionDo I need to set up the DM job in a certain way?

Any idea why ifs cloud does not allow function_result@5 in the column name?Column name is a drop list with all the columns from the source mapping tab. 

​Hello everyone,I have a tricky problem for you.As part of a go live project with IFS APP10, we migrated the financial data, including the ledgers. We went through external assistant and everything went smoothly.Later, the finance team realised that for many rows the E code was the wrong one. So we modified the E code using Excel Add-in with the GEN_LED_VOUCHER_ROW_UNION_QRY view.This worked well, so the E code has been modified. In the view GL Voucher Rows Analysis, the CODE E is good. All the CODE E are ‘EXTERNE’ But when we look at the view GL Balance Analysis different results from 'EXTERNE' still exist.  When We look at the SQL Query Tool :It is therefore clear that the 'accounting balance' view has not been updated.This table is used to summarise the balance. The balance has therefore not been updated.So I tried to recreate an excel add in to update the values using the ‘ACCOUNTING_BALANCE’ view tu update the balance.But when I want to execute the excel, an error message occurs :

Good afternoonI would like to know how to insert one object inside another, that is, make it a sub item.I think changing the level would work but I don't know how to do it and I would like to ask for help.Best Regards 

Hi all,We are trying install IFS Excel Add-In in AWS VM with Windows Server 2019 OS but getting the error.We are using Microsoft 365 (Enterprise). We did reinstall the excel and update the chrome browser version, but it still doesn't work.Below is the documentation we follow.https://docs.ifs.com/techdocs/22r1/070_remote_deploy/400_installation_options/010_data_management/030_data_migration/Can you advise what will be the issue and suggest some method to resolve.Thanks 

Hi,Does anyone know how to add a picture to a IFS apps 10 standard Report, do i also need access to the build place to publish my changes on the report? thanks,

IFS 22R1We came across one issue in Data Migration Manager where we found circular reference of tables while validating Basic Data and unable to validate the Basic DataCOMPANY_FINANCE being used as reference table for few other basic Data target tables. While validating COMPANY_FINANCE data, it is referring to CURRENCY_TYPE which also requires validation.On validating CURRENCY_TYPE, it is referring to COMPANY_FINANCE and also CURRENCY_CODE.CURRENCY_CODE also referring to COMPANY_FINANCE, seems like Circular reference and unbale validate basic Data for these target tables.Any suggestion how we should be resolving this issuescreen shot attached for referenceThanks,

Hello all, Hoping someone can help with this.  I am trying to schedule a quick report so the first thing I do is create the ‘Application server task’.  However when I save and RMB I get the following :I select yes, then get the following:How can I resolve this issue please ?

Hi,I’m trying to load Functional Objects using the Equipment_Functional_API. But I’m unable to set the “Belongs to Object” or SUP MCH CODE via this API and view Equipment_Functional_UIV. Any suggestions, how do this under Data Migration Job? Thanks

Hi Team,I am trying to upgrade our IFS 7.5 SP6 oracle DB from 11.2.0.3 to 19c. But I am not sure if it is supported. Can you please suggest if I can do upgrade by using export import of DB and then configure IFS 7.5 SP6 application on 19c DB will it work? Does anyone done this. Regards,Ashish Dubey

Hi,I downloaded and installed the configuration analyzer tool on my workstation.I downloaded the file InterfaceReports.ifrWhen I launch the tool, I just have time to see the main screen and the application closes immediately.Do you have any ideas why ?Thank you

I want to create Purchase order line via  PURCHASE_ORDER_LINE_API.New__.when I pefrom  “PURCHASE_ORDER_LINE_API.New__(info_,objid_,objversion_,attr_,'CHECK');” no error message. but I change to  “PURCHASE_ORDER_LINE_API.New__(info_,objid_,objversion_,attr_,'DO');” it dispaly  “4246591008” is not a valid integer value.my script as beolowDECLARE          info_ VARCHAR2(32000);          objid_ VARCHAR2(2000);          objversion_  varchar2(300);          attr_ VARCHAR2(32000);          BEGIN        -- TBOOLENSTRING:=TRUE;         Client_SYS.Clear_Attr(attr_);      --Client_SYS.Add_To_Attr('BUYER_CODE','3HB03', attr_);-      Client_SYS.Add_To_Attr('ORDER_NO','10112', attr_);      Client_SYS.Add_To_Attr('BUY_QTY_DUE','100', attr_);      Client_SYS.Add_To_Attr('DATE_ENTERED',sysdate, attr_);      Client_SYS.Add_To_Attr('LAST_ACTIVITY_DATE',sysdate, attr_);      Client_SYS.Add_To_Attr('PLANNED_DELIVERY_DATE',sysdate, attr_);      Client_SYS.Add_To_Attr('PLANNED_ARRIVAL_DATE',sysdate, attr_); 

Hello, in IFS10, can I run a scheduled task once a file has been uploaded to a folder? ThanksRoss

Hello the community,A customer is looking for a tool to integrate Ifs with MS Dynamics 365 CRM.He found this tool “Commercient” (https://www.commercient.com/product/sync-integration-for-ifs-and-microsoft-dynamics-365-crm/#tab-id-4) Any advice/experience is welcome :-)Thanks. 

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.

Hi Experts,Search , validate and execute functions are not working in below migration job. Appreciate it if any one could help to resolve this issue.   Best regards,Theja

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

I am looking for recommendations on how best to manage the migration of documents (300gb+) from an Apps9 database to Cloud. Primary concern is the ‘what to avoid’ type scenarios and also how to monitor during the migration process that the process did not stop or error out and, if it did, what to do next.

Hi everyone,I'm trying to migrate the view "PART_SERIAL_CATALOG" which holds the history data for the inventory parts in stock.My approach was to first create a temporary table with a .csv file and then migrate the source data. the second step isn't working, I'm getting the error: "ORA-20132: PartSerialCatalog.NOTHANDLED2: Operation "" is not allowed for Part Serial Catalog objects in state "". There's no problem migrating the inventory parts in stock, but they can't be used if the Part Serial Catalog is not available.Can anyone help me with this error?I'm grateful for any help, thanks in advance!Kind regards.Joshua ps: here you can find a Screenshot of the File Mapping for the migrate source data Migration Job