Data Migration

I have a user on my team that, when opening an EXCEL_MIGRATION job on a spreadsheet, gets the results where the “Result Column” is created but left outside the Excel Table, like this: odd results from the user In spite of that, if I do exactly the same steps this executing, I end up with a table where the “Result Column” is included: it works for meAt first I thought something was wrong with the Job configuration, but having confirmed this cannot be replicated in my computer (and it also worked fine for a 3rd user who tried it...) I am more inclined to believe this is an Excel issue on this user’s machine. Has anybody expe

Hi Everyone,We have a customer using the Test Data Management tool, and they currently have a quota of two environments.We have already approved and created a QA environment, and we now need to create two DEV environments. Before proceeding, we would like to confirm whether creating the new DEV environments could have any impact on the data in the existing QA environment.Thank you for your assistance.

Hi,In the documentation of 25R2 it is mentioned that IFS comes with pre-packaged data migration definitions. These prepackaged migrations should consist of:The definition itself which is available upon manual installation of the PROD components as migration jobs in the form Overview - Migration Jobs An excel spreadsheet that may act as an input container for the data with additional information about fields, formats constraints, etc.I can see the migration jobs are there, but I can't find the Excel spreadsheet the documentation is referring to nor can I find a job that is able to create this. Does anyone more about this Excel spreadsheet?/Michael

Getting an Error when migrating Sales Contract Header. Insert into SALES_CONTRACT_TAB failed - ORA-20110: SalesContract.CONWINPROBERR: Win Probability must be within the range 0 - 100. (Error caused by line: 26)PLANNED_START_DATE=2006-04-17-00.00.00PLANNED_FINISH_DATE=2027-04-01-00.00.00WIN_PROB=100CUSTOMER_ID=XYZAm i missing anything?

Hi,I was wondering if there is a way for me to delete IC tables created by migration jobs of type CREATE_TABLE_FROM_FILE. I don’t have access to database, to use sql operations.Thank you,Roshan

I'm trying to update an existing record for functional objects using the Smart Data Migration Manager (DMM) tool. I've mapped the Equipment Object Seq field to the legacy source, but when I deploy from the deployment container, it treats it as a new INSERT and returns an error saying the functional object already exists.I've included all the configuration details and data in the description. Could someone help me identify what I might be missing or doing incorrectly?Excel Record I’m trying to Update :Legacy Data :Mapping : Deployment Container :

There are a lot of migration jobs that are run every night, for example, a re-schedule job to update shop order need data from MRP calculated date. There are also many scheduled custom and standard database tasks running.The mig jobs run perfectly well and quickly in Apps 10 but run extremely slowly (I mean like they take hours instead of minutes) in Cloud 25R1.There's doesn't appear to be any reason for their slow running in Cloud. They eventually complete without errors or warnings, which is frustrating because if there was an error or warning that might give me a clue!Has anyone else experienced this behaviour and what steps did you take to troubleshoot and were you were able to resolve it?Grateful for any comments, advice or experiences. They are run by a service account (on a fast queue) that has access to the jobs and pretty wide ranging permissions. As I said, no errors or warnings, just e x t r e m e l y slow to complete.Thanks in advance!

Hi,We have imported several thousand Request Contracts using DMM. They are at status ‘Planned’ and we want them to be Active. Is there any way that we can automate making these Active? Presumably we need to update objstate and/or state fields on sc_service_contract but these fields don’t seem to be able in the mapping. 

I am trying to migrate Migration Job Group but i am getting this error when i import, What am i missing 

I’m looking for a reliable approach to migrate users from one environment to another. Currently, during ongoing development, we frequently refresh non-production environments by cloning production data. However, this process removes existing users from the lower environments, which creates recurring issues and requires significant effort to manually recreate user access.Is there any functionality available that supports exporting and importing users along with their associated configurations—such as roles, sites, person records, and related data? Any guidance or recommended approach to streamline this process would be greatly appreciated. We are currently on 24R2 and will be upgrading to 25R2 next month.

Hello Data Migration Wizards,I am trying to migrate several “child” serial objects. The ‘parent’ objects already exist. I am using FNDMIG migration jobs for this. This allows me to create the serial objects. However, the field “Belongs_To_Object aka (SUP_MCH_CODE)” always remains empty. As a result, I cannot create a parent-child relationship. If I enter the “Parent Object” manually, it works!  I understand that the field is only insertable, meaning it can't be updated. However, I can't insert new data or update it. I don't get an error message either. The field is simply left blank.I've tried various things, including entering the equipment sequence. Nothing has worked. So, how should I populate the field using a migration job? 

Hi All,I am using IFS Cloud 24R2. FNDMIG job using MIGRATE_SOURCE_DATA procedure.Does anyone know how to avoid the above error when migrating customer_order_line ?The DEFAULT_ADDR_FLAG has value ‘Yes’ and DEFAULT_ADDR_FLAG_DB has the value ‘Y’, but the error says it is NULL.ORA-20124: Error.NULLVALUE: Field [DEFAULT_ADDR_FLAG] is mandatory for Customer Order Line and requires a value.The source data will have  below values.Is something wrong with these values? Should we check on a value of another field in the data set for some validations?Your thoughts, experiences and suggestions to solve this issue is much appreciated.Thank you!

I have created a DMM project with service catalog → Urgency as scope. I have done the mapping and imported all the basic data into the basic data container and completed the steps till ‘Approved’. But I still get an error in basic data validation. Any idea what can be wrong in this scenario. Output containerBasic data containerThank you /Heshani N

Hello All,We have a lot of Migration Jobs, and we want to migrate all of them in a new IFS Cloud environment.Are there any ways to accomplish this at once? Can we make a Migration Job for this task? Thank you for your help.

Hello,My name is Tomek and we’re starting to implement IFS Cloud 25R1 at my company.Please check  whether it works for you.I have a migration task with data export to a file in the OnServer directory. The directory was created in Windows and as an Oracle directory. It also has an archive subdirectory (Windows and Oracle). In the migration task rules, I have the FILEBKP rule active, pointing to the Oracle directory (archive)After the task is completed, a file named file.txt should be created in the destination directory (and this works), and according to the rule, a backup file named file*.bkp should be created in the Archive directory. However, this file is not being created. FILEBKP is enabled in the Default Rules.This works very well in IFS8, but not in IFS Cloud.What could be the cause of this?Thank youTomek   

Hi.We’ve created a quick report to fetch some specific data and we’re hoping to schedule said report to run on a weekly basis and e-mail the file to a specific person.I have IFS_ALL permissions as the scheduling user.The report query is as follows:SELECT DISTINCT A.*, B.CF$_CC_SUPPLIERFROM PROD_STRUCTURE_CFV AINNER JOIN MULTI_LEVEL_STRUCTURE_CFV B ON A.COMPONENT_PART = B.COMPONENT_PARTWHERE A.QTY_PER_ASSEMBLY = 1 AND A.PRINT_UNIT = 'm' AND A.CONTRACT = 'ULV'AND B.CF$_CC_SUPPLIER = '5808'The report itself executes just fine within Cloud, and we can manually export the resulting data, but when we try and schedule it, the background job ends in an error. The errors listed in the Background Job details are as follows:ORA-31011: XML parsing failedORA-06512: at "IFSAPP.QUICK_REPORT_TEMPLATE_RPI", line 305ORA-19202: Error occurred in XML processing

Please advise on how to handle this error. I would like to enable inventory part movement using the Migration Job in IFS.To achieve this, I added Move_Inventory_Part_SVC.Do_Update_Inventory_Part_In_Stock_Delivery to the METHOD LIST tab.However, when I clicked the Save button, the following error occurred.Error message:[Error making attribute and references - value too large for column "IFSAPP"."INTFACE_METHOD_LIST_ATTRIB_RTB"."COLUMN_NAME" (actual: 34, maximum: 30)]   

Hi all,Here the data is extracted from company1 and migrated to company2 with new project_id and activity_seq updated in the source data file to input to the migration job  (say project_id1, activity_seq1 in company1, the new data file will have project_id2, activity_seq2 for company2) I use a FNDMIG job to migrate the purchase_order_line_part  for Loram. In the first migration, I remove the project_id and activity_seq fields from source mapping. No migration errors. The row was inserted. But the project_id1 and insert it in code_c field in purchase_order_line_part. And that was wrong and it should take project_id2.Anyone has thoughts on why this is happening and how to resolve this situation?Any clue or advice is much appreciated!.

Hi together,we are currently in an Upgrade Project to 22R2 and we want to migrate Notes.We found the topic Job migration of Business Opportunity - Note issue | IFS Community but when we enter the method BUSINESS_OPPORTUNITY_API.Write_Note_ in the Method List of the Mig Job we get the following error. So we checked the API in PL/SQL Developer and saw that the datatype for rowid_ is ROWID. This seems wrong.Does anybody have the same issue? Do you know how to fix that error?

Hi All.. Can anyone help how to download/Extract item master data from IFS…  it will be great to have selection option to extract data based on need.. i.e if use need  part /Description / Item class / Lead time / MOQ/ Lot / Part type/ Product code /Family etc etc field.. in order to avoid massive data dump which could cause an issue while downloading.

Want to set up a default lobby on the main page for each user group we have -- cannot figure out how to do this

Hi, is it possible to configure the session timeout in IFS Cloud specifically for running quick reports?Currently, I have an issue where the report execution is interrupted after 3 minutes, so it doesn’t finish and returns no data.Is there a way to extend the session duration to, say, 5 minutes, but only for ad-hoc reports?

I have a simple migration job that loaded Customer Order lines from an Excel spreadsheet. The migration job which worked wonderfully in Apps9 will not work in Cloud.The migration job has been rebuilt but am getting the following error:ORA-20124: Error.NULLVALUE: Field [TAX_DOM_AMOUNT] is mandatory for Source Tax Item Order and requires a value.That field name is not in CUSTOMER_ORDER_LINE either in the view or table. Any pointer would be welcome.

Hi All,Unfortunately, I have some junk basic data values, already used, which prevents me from cleaning and deleting.Can I hide these values in order not to appear in LoV and not to be used anymore? Many Thanks in advanceAbdeslam 

When I access the database in the PRD environment using ‘IFSDBREADONLY’, I can view standard tables and add-on tables, but I am unable to view virtual tables whose names begin with ‘IC_’.Could you therefore please explain the steps required to view these virtual tables?