Data Migration

Hi All,I created a FNDMIG job using the method Eng_Part_Structure_API.Remove__ to remove subparts from Engineering Part Navigator and it does delete any records.  It does not give any errors but display this in the Last Info.I have attached my migration job herewith.If I use the Method Eng_Part_Structure_API.Part_SubPart_Conn_Removeit will remove the subpart.Which method should I use to remove Subpart from an Engineering Part Navigator?Why the first method(Remove__) does not work in the migration job?Can someone please help me to clarify what is the correct method to use and why the first method fails? Thank you!Disna M 

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? ​@Marcel.Ausan Thanks in advance.

Good Day,I am in the process of implementing IFS Cloud 25R2. I am currently running the SAP application, and I need to migrate 7-year-old data to IFS Cloud. Tell me if that is possible and what are the risks come with that migration load. The reason is that our legal requirement requires us to carry 7-year-old data to the new system.RegardsRukiya

When clicked on the migration job in excel migration database error occurs. what could be the reason

I want to use a migration job (Procedure Name: EXCEL_MIGRATION) for a specific view to create multiple data records where all fields—except for "Contract"—have the same values, while the "Contract" field has a different value for each record.Previously, I had to write a separate row for each "Contract" and click the "Execute" button to register them.Now, I would like to be able to enter just a single row of data and have multiple records (one for each "Contract") registered upon clicking the "Execute" button.

Smart mapping - no use? I always have to do manually selecting every object in DMM. why can’t it do the job even though my legacy file and target table definitions object names are same? I did the Re-synch and set legacy file to target before I did that smart mapping option. Any ideas? 

As I’m learning Data Migration Manager I have created a few projects. For a couple of them, while Mapping Legacy Tables to Migration Object there has not been any Target Tables available in the Smart Mapping assistant and I have had a hard time figuring out why. Am I missing any setup? What are the requirements for Target Tables to be available for Smart Mapping? 

In cloud version, cannot create data migration job for custom view. Returning “custom lu views are not supported” error. Any idea?

I am trying to update authoriser field for supplier invoice using a migration job as below , job is executing without any errors but the value is not updating in the invoice tab Can add the authoriser manually so the configuration part looks ok  

Hi Everyone,We need to know latest tools that we have for Data migration within the IFS except the DMM , Ex: SAP to IFS Cloud Ex: noted this Article as well but not sure , what are the latest approaches (https://www.ifs.com/en/insights/news/ifs-launches-accelerator-to-help-sap-customers)Best Regards,Hashan

Hi All, I have migrated data into Fixed assets Object page by creating a migration job with the view FA_OBJECT.And now I’m trying to import objects to each FA Object to add Acquisition data and Depreciation information.So I created a migration job connecting FA_OBJECT_TRANSACTION view but it seems like that’s not the correct way to migrate them because they’re not showing in balance analysis report. But I can see records in Post Imported Object Transactions page.I would really appreciate it if I could get your guidance to migrate them.Thank you in Advance! 

We are working on an effort to implement the India GET Functionality. To implement this new functionality we need to create a new Company/Site. We will be migrating from one site to another. As we work through all transactions, we have an issue regarding our open inter-site Purchase Orders > Customer Orders.Specifically:We have Intersite Purchase Orders (our India site 1300) to one of our internal Supplier: 10 where the connected Customer Order is on Site 10.When we migrate the Purchase Orders (from site 1300 to the new site with India Get: 1301) we are looking for a way/best practice to reconnect them to the existing Customer Orders in Site 10.Product Version: 24.2.6We have close to 4,000 open Inter-Site PO Lines that will need to be migrated to the new site. And are looking for the best way to update all of them in mass.

This I think is one of those questions that will be hard to solve, hopefully I’m wrong. I have been using the Data Migration Manager for some time now, it works well(ish) for (al)most all containers… sometimes… well… nobody’s perfect 😁One area where I have struggle particularly is the Additional Deployment Processes, more specifically, the Post Deployment actions that update statuses.I have seen one example created by IFS R&D which is the one that update statuses for CUSTOMER_ORDER entities. It is normally included in DMM templates and it does precisely what it should do.Updating Customer Order States in DMM: The “Happy” path!I needed to do something similar for PROJECTS.I thought updating STATES for other entities (such as PROJECTS) using this example as reference, should land me where I needed to be, so after finding what code behind gets executed when updating the STATE of Project I got myself into the task of creating a similar Additional Deployment Process in DMM, only to mov

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?Thanks in Advance for any help!Best regards,Andreas

i am trying to migrate Posting Control Details but the Migration Job fails with a strange error. I have confirmed that the Posting Control Master record is available with valid dates but i still get the mentioned error. Any clues what might be causing this? Thanks Insert into POSTING_CTRL_DETAIL_TAB failed - ORA-20111: PostingCtrl.FND_RECORD_NOT_EXIST: The Posting Ctrl does not exist. 

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

I’m trying to test AccountSet (GET) API IFS Cloud Demo environment as follows. Im able to retrieve the bearer token using following IAM client but once I pass the bearer token to the API it gives me following error. Appreciate if you can help with resolving this error. {    "error": {        "code": "DB_ACCESS_ERROR",        "message": "Database access error. Contact administrator.",        "details": [            {                "code": 20105,                "message": "ORA-20105: Login.FUSRNULL: The directory id XXX is not allowed to run the application."            }        ]    }}

I’m not sure what’s going on but I have the projections for my migration job granted to the permission set that I need them granted to as well as permission for FND_ADMIN, and FNDMIG_EXCEL_ADDIN and I’m still getting this error in my production environment. I have less permissions granted in my test environment and it’s loading with no issue. I even imported the permission sets from my test environment to prod and it’s still giving me the error. Any help is appreciated.    

Hi IFS Community!Upon running the Excel-Add In for Data Migrations on IFS Cloud for a specific job in Production, we get "Unexpected end of JSON file" with no further information as to why this is happening.We migrated the same data to a different environment last week (CFG) with NO errors whatsoever, so we know that the data we are migrating is not the issue.We checked permissions for the user running the migration and it all looks fine as well. Any ideas what could be causing it?

Is it necessary to update the manifest required for the Excel add-in in conjunction with IFS Cloud updates? Also, if you are aware of the update procedure (including steps for end users of the Excel add-in), could you please let me know?

Hello!I created a MIGRATE_SOURCE_DATA Migration Job to modify a field on a Fixed Asset. The field is Estimated Life.Field I want to modifyIn the database the field is called estimated_life_cl and is a VARCHAR2(4000)By using a trace and debugging code, I found that the API used when modifying that field is DEPR_DISTRIBUTION_API.MODIFY__. Here is the code.Code to run a modification on estimated_life_clThe problem is: My migration job is doing nothing!All I get in the “Last Info” value is thisNot very useful to understand the problem :)Here is how it is configured Header with DATABASE INFORMATION TabSOURCE MAPPING TabMETHOD LIST TabMethod List Attributes FormMy IC_FA_OBJ_HEAD_IMP table (the source of this job)Any idea what could be wrong? Any suggestions on what to try to debug and fix this problem?Feel free to request any additional information and I’ll provide gladly

Dear community,We are experiencing an issue with the Excel Add-in on a limited number of computers.The following error message appears when users attempt to connect:"IFS.Fndmig.ExcelAddIn has not been configured to run in the selected language. Please use a different language to log in."Has anyone encountered this issue and identified the root cause or a workaround?Thank you for your support.

Hi All,When I migrated Resources tab in the PM Action/Work List, the Sales Part Site field was not migrated, even when the loaded data had a value for CATALOG_CONTRACT field.And the Cost field was not populated  in the Resource tab.IFSAPP10 FNDMIG job with MIGRATE_SOURCE_DATA procedure.view Name = PM_ACTION_RESOURCE_UIVI have attached the migration job and a sample data file i tried.Can I please know if I am doing anything wrong in the migration job?Appreciate any guidance or suggestions!Thank you!Disna M.

Hello,IHAC tying to update the expire date on 4,000 records within ‘report archive’.  According to support KB0084604,” To update the expiration date, system use 'Report_Archive_SVC.Do_Change_Exp_Date' method. Users can create a new migration job with this method to bulk update the records.”How does one properly set up the migration job for this?How do we determine the required source columns, parameter mapping, and expected input values for the method.?If possible, it may be helpful to provide:A sample Migration Job configuration Required parameters for Report_Archive_SVC.Do_Change_Exp_Date Example mapping for updating expiration dates in bulk Any relevant documentation or screenshotsThanks in advance for any guidance.

We are in the process of transporting data from IFS database into an organization internal Data warehouse. We are needing a list of IFS database objects that have PII information. Please let us know if there is a some kind of have a dictionary or data guide that helps to identify where sensitive entities/fields/etc may be in the databaseProduct Version: 24.2.5Business Impact: Unable to proceed with setting up the ETL process to transport data from IFS database to the internal Datawarehouse