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.0 I’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 E S6V 7V6 - Prince Albert Saskatchewan CA - 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 documents https://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 issue Kindly 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 0 Error creating index CREATE INDEX IC_SM_SALES_PART_PP_REF_IX1 ON IC_SM_SALES_PART_PP_REF_TAB() - ORA-00936: missing expression Do 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

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 22R1 We 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 Data COMPANY_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 issue screen shot attached for reference Thanks,

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 beolow DECLARE 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_); Client_SYS.Add_To_Attr('PROMISED_DELIVERY_DATE',sysdate, attr_); Client_SYS.Add_To_Attr('WANTED_D

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

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

Apps 10 update 12: I am trying to load some new Inventory Locations. The migration job is pretty straight forward, see below. When I try and execute, the first row is successful but second and subsequent rows fail. The error is: Insert into WAREHOUSE_BAY_BIN_TAB failed - ORA-20112: WarehouseBayBin.FND_RECORD_EXIST: The Warehouse Bay Bin already exists. (Error caused by line: 3) It appears that there is a LOCATION_SEQUENCE which retrieves from a sequence (if the field is empty in the attribute string). Looking at the output of the failures, it is trying to use the same LOCATION_SEQUENCE value for each record. Anybody have any ideas or have been successful in data migrating inventory locations? Thanks in advance, Dom

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.