Data Migration

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

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, 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?  

To extract data from IFS, Is the use of ETL like Boomi prevent the use of other mode of Extraction( flat files extraction ) ? that is to say, if i use Boomi to extract data from IFS i cannot do so using flat file in the same time ?

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

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.

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 

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?  

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

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

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 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.

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 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. 

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)

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?   

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

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

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!