Data Migration

We are running Apps10 UPD14I know we can see the history of migration jobs (which jobs were run when and by who) for the non-Excel jobs in view INTFACE_JOB_HSIT_HEAD.  I’m looking for the equivalent information for Excel Migration jobs.  Does that migration job history exist?

I am trying to create a migration job for customer agreement using excel migration , i followed the steps and added two methods of both header and detail. CUSTOMER_AGREEMENT and AGREEMENT_SALES_PART_DEAL but while validating , am getting error message like "RmAccUsage.Developer Error: CustomerAgreementDEVELOPER_ERROR_03: Most likely a usage definition is wrongly defined for LU: [CustomerAgreement] in table RM_ACC_USAGE_TAB, internal exception: [Ex_Get_Id]"steps are as follows       

I am working with the Smart Data Manager and I receive the following error when I try and add the COMPANY_INVOICE_INFO Target Table to the Project’s Basic Data Migration object:  If the Image doesn’t come through it says Target COMPANY_INVOICE_INFO cannot be added to the Basic Data Container.  I haven’t had any issues with other tables so far, so I am trying to see if anyone has come across this before.  I do have a ticket open with support, but I thought the nice people here might have some ideas too!  :) Thanks!Jay

I tried to create a migration job to update the values in the supplier view.I added this API method “IDENTITY_INVOICE_INFO_API.Modify__” and ran the job.I don't see any changes.Is there any recommendation on how to proceed?

Hi everyoneI’m trying to migrate manual customer invoices using a MIGRATE_SOURCE_DATA migration job and I’m using Man_Cust_Invoice_Item for the lines.  I’m getting an error that the DIV_FACTOR is mandatory and requires a value even though it has actually been set.  I’ve tried setting it using the default value and via a source column but I get the same error in both cases.  I’m using Cloud 21R2.  Does anyone have any items on how to resolve this?Thanks!

Does IFS Data Migration Manger have built in Number series functions which can be used in the Input Container as Transformation Rules.For example assume a Customer in the legacy system has multiple addresses.If they do not have Address IDs in the legacy system , how do we generate Address IDs in IFS (Say Address IDs 01,02,03,04,05)

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 All,When we do Data Migration using old Data Migration tool, we create legacy data file structure based on the Migration job we write.For example assume we need to migrate Customers.In the csv file we define headers as CUSTOMER_ID, NAME,CUSTOMER_CATEGORY,DEFAULT_LANGUAGE etc. based on the DM job column order  and then fill data in csv file  accordingly.Based on new tool ‘Data Migration Manager’ documentation, it looks like we do not need to do this anymore. Instead we can export legacy data into csv files as it is in the legacy system  and then import them into IFS Data Migration manager. After the import it looks like we can map legacy data into target tables as we require.We can also use dblink in order to map legacy data tables into target tables as well. Could someone explain and confirm if my understanding is correct?   

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 Evevybody, We prepare de data migration job to add some project activities. Table is ACTIVITY and a key field is ACTIVITY_SEQ. is it possible to call activity_seq.nextval to init this field ?I test but without success. When I initialize with a numeric value it works but I will prefer use sequence.Regards, Christophe

Hi All,Is there a way to get access to Data Migration Server folder in Build Place DEV Environment?I know this is a short lived environment but there should be a way to access Data Migration database server folder in DEV(Build Place) so that customer can do data migration tests in several iterations and delete data whenever they require. 

When I tried to create a migration job from what’s available on DEV and save, I get the above error message. Can someone advise?  

I am using FSM with a SQL database and wish to produce a new Test DB from my existing PROD DB. I have tried restoring a backup of the Prod DB to the test DB and this doesn't work as it says DB not available. I have tried doing and export from the Prod DB to the Test DB but I get an error about writing to a read only table. Does anyone have any advice? 

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. 

Is there a way to change the status of a record created using a migration job? When creating a record it is always created in ‘Preliminary’ Statusex- Create a Customer Order with status ‘Released’ or Create PM Action with status ‘Active’ using a migration job 

Are there any UK based IFS partners that deliver Technical training on lobbies, Data Migration, Events etc, but not specifically PL/SQL   

Hello, I want to consult the values of an enumerate in order to export it and add a new values. how can I make it ?. Thanks

i want to create a migration job  using a method  ,that method name define two times in a package.ex, Create_Purchase_Order  method define in Purchase_Order_Api , one has 6 parameter and other one has more than 6 parameters .I'm using the method with 6 parameters, but when i try to execute the migration job getting following errors, any idea how to use these type of method in migration jobs?attached images.

Hello everyone,When I want to create Target Table Definition in Smart Data Manager, I have this error when I select the option: "From Template Project":On the other hand, no problem with the "Master Environment" option.Did I forget something in my project settings? For your information, I made all the elements I was interested in "In Scope" in the "Migration object scope" tab.Thanks in advance!

After the initial installation it appears that there are migration jobs (at least the interface headers) available. I'm not able to delete them as there is no detail available so they only confuse the customer.List is shown as follows:I gave myself update access to the job.When searching via the page Migration Job (so not Jobs), I don't see it. If I try to add it, IFS returns the error message that the interface already exists.Any idea how to get rid of these jobs?

What’s the best way to migrate basic data between environments in IFSCloud? 

HiMy customer has installed IFS Cloud on-premise and is using Excel version - Windows Excel : 16.0.5317.1000. The customer has successfully installed the Excel Add In and the Excel IFS icon appears on the excel. But when the customer launches it nothing happens.Just to test in the same laptop we tried installing Office 365 excel and the IFS Excel plugin successfully launched. But is not working with the excel version the customer is using. The customer has no plans to update the excel version and is asking how to make the excel plugin work with the current version.Has anyone of you experienced this issue ? Is there any possibility the customer can launch the excel plugin with the version of excel the customer has.Thank you in advance. RegardsSumit ROY

Hi All,I have granted access to the Execute Job for one of permission set in the application. Now the users who has assigned to the particular role can see the window. But uses try to populate the records, it says "No Record Found"I refreshed the security cache and checked. But the issue still remains.Any help for this? Regards,Malin

Community, I have a problem when doing migration job of updating part description. when saving the excel file to text (tab delimited), i can see the double quote is added by the system. please see the attached. after I ran the migration job, i can see the part description is also updated with double quote text. see attached.I am wondering how to fix this issue when updating the part description. Thank you.

Hi,for external (QlickView) security reasons we need the following format in the DIM_Employee/DIM_Person in the datawarehouse.FirstCharacterSurName+LastName. Like MKAISER (michael.kaiser@company.de)While I’m in the IFS maskSolution Manager > Security > Users > Create UserI will see IDENTITY and Database ID: with the formatting above.The System Info stays empty and the debug console don’t show anything.So any hints, in which View/Table I can find an PERSON_ID and DATABASE_ID in one row? Thanks a lot!All the best. Michael