Data Migration

Does anyone know if it is possible to use the Excel Plugin to access multiple data bases?I have a customer who want to be able to update both test and Prod.Not both at the same time, but be able to switch between the two. 

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!

Hello IFS Community! I’m assessing a strategy for a legacy ERP migration into a PRODUCTION IFS APPS 10 (UPD16). This is a multi-tenant  instance (many companies are running on this IFS instance). There is already one company operational and I am migrating company #2.My question is this: we are considering two strategiesMigrate this new company (let’s call it, company “A”) into PRODUCTION where the current company (company “B”) is operational. Do the migration and QA work directly in PROD. Once the GO-NO GO decision is made (if GO) then just start using PROD with no further delays. In this approach there is no freeze period for company “B” Migrate this new company in a staging environment that we will clone off PRODUCTION (so all of company’s “B” data is there), freeze PROD during migration (tell users of company “B” site is off-limits for now). Do the migration and QA work there (in staging). Once the GO-NO GO decision is made (if G

Hi, I am trying to export at list of customers to Excel. However, I can see that I am limited to these columns fro the customer table:Is i possible, using an advanced SQL query, to include the address columns of Address Identity ‘10’ in the export?  Br,Nielf

How could I migrate data from a GPE environment to a PPE environment? The goal is to migrate parts of the whole data set: customers, companies and some other transactional data.

I am trying to export SRV_REQUEST_CFV using the procedure FNDMIG_EXPORT and when I execute it, it returns an empty file.  I have one record that I have entered into the table, but it is not pulling it.  Any ideas? 

Hello,I am trying to migrate the work location for the emplyee file. I tried it via template EmployeeWorkLocation, but I didn’t manage. The two-step job works fine, but the field “work location” is empty.I am using the Cloud version 22R1I appreciate any help on the subject!Kind regards,Aleksandra 

Need to know if anybody load actual hours on project? I am using the voucher entry load for historical information but what can be use to impact the used/actual hours as well?

I am trying to migrate Customer_info where the Creation Date is today’s date.  The migration does not like the format:  1000001 ABAN ABRAHAM PTE LTD 11/16/2022 1000001 CUSTOMER United States of America en 1000041 SEADRILL OFFSHORE AS - EUROPE OPERATIONS

Can anyone describe the difference between using the Data Migration tool vs the Data Migration Manager Tool?

We are upgrading IFS 8 to IFS 10 in a Portuguese customer.Since portuguese localization requires that voucher entries for the current year must be in one software to extract legal reports we need to export data from 8 to 10. Can anyone help us with some documentation or samples?Regards 

Hi. I get an error when attempting to validate a row in a newly created migration job:The logged in user has permissions to the migration job and the data is OK, I’ve created a few other similar jobs today and all have worked fine.ThanksAO0001

Hello all, I am getting the error message: class intfaceFile does not exist when trying to select a file, does anyone have any ideas what the issue is please.

What setups are necessary to use the IFS Smart Data Manager?   I do not see the permission sets SDT_CLOUD_FULL and SDT_CLOUD_MIGR_FULL.  Is there something that has replaced these?  We are on 21r1.

Hi,Does anybody have knowledge how it is possible to get adjust batch size function done during migration of recipe structure lines? It looks like it is not done during setting structure buildable. Is there an own migration job/script for that or should it be part of migration of each recipe structure line?Best regards,Kirsi  

Hi everyone,  My need would be to migrate WBS Projects and automatically import the structure of the Project such as allowed by the standard API PROJECT_API.COPY_PROJECT_ATTR.This API is related to standard command “Copy Project”:There are a lot of parameters to be set up in the client when using this wizard, but I can’t manage to identify all of them properly using the SQL debug console as well as triggering the Method in a Data Migration Job.I am in IFS 21R2 Cloud Version.Here are the parameters that I managed to retrieve from the SQL debug console in IFS APPS 10 for the attribute OPTIONS_ATTR_ :'PROJ'||chr(31)||'YES'||chr(30)||'SITE'||chr(31)||''||chr(30)||'SUBPRO'||chr(31)||'YES'||chr(30)||'RUNINBACKGROUND'||chr(31)||'NO'||chr(30)||'COPYSITE'||chr(31)||'FALSE'||chr(30)||'ACTIVITY'||chr(31)||'YES'||c

Hi All, I tried creating a Migration job for custom table using the procedure INSERT_OR_UPDATE When tried to Execute Job it throws the below errorExecuteJobError  

Hello, I am trying to configure Oracle (or any compatible) ODBC connection for an IFS database.I have no setup details for the database and have had no success mirroring existing computers.  The existing computers that can refresh reports in excel have Oracle19c installed. I am open to doing anything and have full access to the sql server. I am just looking for some guidance. Thanks! 

Hi,In APPS10, we’re getting this error when trying to perform an inventory movement. Upon checking the inventory location, it appears that it’s because Bay Route Order, Row Route Order and Tier Route Order are NULL.This is odd as the location’s Bay ID, Row ID and Tier ID are populated so I would expect the route orders to have the same value.Bay ID, Row ID, Tier IDBay Route Order, Row Route Order, Tier Route OrderI’m not able to use a migration job to populate these fields as they’re not stored values. Is there a way to almost refresh/re-execute the

I am trying to create an ETM Channel to create new Event Builders at Item Level.Fields Usage Type and Event Type are Integers. I tried with value “1” for both fields but it is failing.Can anyone please help me in getting the Usage Type and Event Type values?

Whats the different between P and K field flags in a migration job?I thought P stood for Primary key?

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

We are migrating inventory balances for a about 45000 records in an IFS 10 environment.The majority of these uses  handling units. The creation of the records with handling units are extremely slow. It jeopardizes our go live. Has anybody encountered the same issue? Did you find a way around it? Any input is highly appreciated. B.RPer

I am trying to use the Data Migration Manager tool to load our HR data. I used the template as an example and I am currently trying to load the COMPANY_PERSON Target Table. COMPANY_PERSON has a reference to COMPANY_EMP. I tried loading a couple of records through COMPANY_EMP, but when I did that, COMPANY_PERSON returned the message from the Deployment Container that the Employee already exists. For the next attempt, I disabled the reference to COMPANY_EMP and tried to load the COMPANY_PERSON record directly. Now I am receiving the following error:Method NEW failed : ORA-20105: AccessAttribute.NO_ACC_TO_PERS_MOD: Insufficient access rights. You cannot modify Pers data for the person 2390.I did not make any modifications to the NAME or FREE_FIELD(s), and only added the data for the required fields like Internal Display Name. Any idea why I am now seeing this error when I can create the PERS data using PERSON_INFO and the 2 PERSON_INFO address tables?

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