Data Migration

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 

Hi All,“Copy Part” screen seems to only allow us to copy one part at a time, is there a way to bulk copy this? They can’t use migration jobs.Does anyone have scripts handy or a tweak for this? I rather not write it from scratch as there is very limited time for this.

Hi All,I am trying to do export of IFS database from oracle source server to destination server using oracle user ‘SYSTEM’. I see the export import completed fine. But while starting the application the background_jobs is not running and looks like it is trying to run these jobs with ‘SYSTEM’ user which was used for importing the database. I am getting below error can you please suggest anyone faced this? do I need to impersonate ‘SYSTEM’ user? If yes how can I do it these are all background jobs triggered by application during configuration automatically. Below is the error I am getting. Fnd_Session_Util_API.Impersonate_Fnd_User_ Could not impersonate Foundation User .========================================== Could not impersonate Foundation User .========================================== Fnd_Session_Util_API.Reset_Fnd_User_ ========================================== Foundation User is not reset. Foundation user is .Fnd_Session_Util_API.Impersonate_Fnd_User_ ORA-20111: FndUser.NOTEX

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? 

Hello,I receive below error when trying to execute a Excel Migration,Any idea why?

Hello,I want to change the structure status from “tentative” to “buildable”. I am using a two step job and I am looking for the right method. I was trying with this one (screenshot), but I get the message that the method is not righT. could you please advise?Thank you!Aleksandra