Data Migration

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.

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.

How can the data be migrated into IFS cloud? Like we want to migrate some companies/sites/their users/service requests from legacy system to IFS cloud.

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 expertsWhen i try to login into the Migration excel add inI always get into this login mask    can i somehow access the system with the migration tool as an admin with the following loginscreen? I allready tried to enter the Admin URL but i always get an error message​​​​

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’m new to IFS & I’m quite surprised at the difficulty there is in changing a unit of measure. I’m a designer, & a portion of my former company was acquired by another who uses IFS. In the process there was a lubricant that got transferred & the unit of measurement was a pail. I’m not sure what the correct unit is but that wasn’t the unit it was supposed to be. Instead of being able to correct the unit, my main division of the company is saying the only thing we can do is create a new part no. with the correct unit of measure. This lubricant is used all over the place in 103 boms & 93 drawings which would have to be changed. Is this a limitation with IFS, & if it is, why would it be. I believe with our former system using CMS, we would have just revised the unit, & been done with it. I should add, it has already been used which seems to make it more of an issue.Thanks for any input in advance. SonDrum

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! 

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?

Has anyone seen this error message when loading or validating data for jobs with the Excel addin?  Last week we could load data the COA to the worksheet without error.  This week we are getting the above error for any of the migration jobs.  Office365Aurena  

Hi!I have a migration job that fails with the error message “Error when closing job ORA-12899: value is to big for column “ifsapp.intface_header_tab”.”last_info” (actual: 4002, maximum: 4000)After checking in PLSQL it seems that the migration job is generating this “Last info”. (The print screen is in swedish):I can also verify in PLSQL that the VARCHAR is set to 4000:Does anyone know how to solve this issue?Thanks!

Hi Community, I have tried to add the Excel migration Add-in (IFS Excel Add-in - 21.2.0.2) using both Excel windows client and office 365 web client for IFS Cloud. When I click the IFS Excel Add-in icon in the Excel, I am getting the ADD-IN ERROR.For the window client, I have opened the Excel as ‘Run as  Administrator’. so this is not a privilege issue.  Any idea on how to resolve this issue? Best Regards,Kapilan

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?

Hi, We’re currently about to go live and we have a number of open orders that have been configured from on legacy system which needs to be migrated over to IFS. We have created migration jobs for customer order header & customer order lines.We’re yet to create a migration job for the configuration as we’re not sure if it’s possible to migrate configuration ID’s with configuration spec values into IFS or if this has to be manually.Has anyone come across this before and how did they get around it?  

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

Hello,in the IFS 10 version we used the excel file (input excel). Was such a file created for the CLOUD 22R1 version?if so - can I ask for this file?

Hi Experts, One of our customers is getting an issue where the FSM installer creates a temporary sql server on Azure unsupervised without the option to select existing one for migration of metadata. Is there a manual procedure to update of the database in such scenarios?Environment :Azure environment managed by customer  Thank you,Leshika

Hi, I have forgotten the api/function call to get logged in users id, so I can pass it to a migration job. Please help

We have a business requirement to change many of our top level project ids. It looks like this is a primary key on the project_tab table, so it sounds like it might be messy. Can anyone help provide guidance on approaches to changing project ids, if there is a third party tool, or if it would be possible using any of the built-in migration tools. We are on apps10 if it matters. TIA

Is it possible to load time data into a Date field?Using a Migration Job, I’m trying to load a time value into Day Type Details (FTIME field) but can’t get the date value (06:00:00.0000000) to parse properly:Error formatting date value 06:00:00.0000000 for FTIME I’ve also tried 06:00 and set the Date Format to hh:mm without success.

I will create and assign 19 end users an excel migration job that allows them to import purchase requisition lines into IFS from Excel.We have only 1 license for data migration excel add-on in our IFS 10 UPD 12. If I understand correctly, the end users who assigned to run a excel migration job don't need a license. We just need to grant them the permission set "FNDMIG_EXCEL_ADDIN" to run the add-in after they install the Add-on. Please advise if I am missing something.

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