Data Migration

HiI am trying to create an Excel Migration Job that will delete User’s Sites. I would like to use the method USER_ALLOWED_SITE_API.Remove_User_Allowed_Site. It requires only COMPANY and USERID and removes all Sites associated with the given COMPANY for the given USERID. I would like it in Excel so that we can load the specific Users and Companies we need to target.If I run this PL/SQL, it completes successfully…beginUSER_ALLOWED_SITE_API.Remove_User_Allowed_Site('USERID','COMPANY');end;I have tried various configs in the Excel Migration job and it either errors, says it has processed it (but hasn’t) or churns for a while and returns a blank.Any pointers?

Hi Community,Is it possible to delete/remove records using an excel migration job? I’m trying to delete/remove users for WaDaCo processes but unfortunately i cannot solve it.. I have added ‘DATA_CAPT_CONF_VALID_USER_API.Remove__’ in the Method List. An example could be to delete/remove all users for our scanner ID6: The migration job has the current setup:   I’ve also tried different setups. Example in the method lists to use ‘%’ in Column value and DUMMY in Column Name.  

Hi All, Can anyone share Data Migration Manager> Template Project file for 23R2 and if you have 24R1 as well?

How can we configure a migration job to accept user inputs?

Before IFS Cloud you define that environment you want to upload data throught IFS Excel Ad-In, how do you select environment to upload data when running IFS Cloud?

Hello,  I want to import invoices to cloud from 7.5 a “PartlyPaidPosted” invoices. Is it possible to have this status automatically  on the imported invoices ?  Best regards

Hi When updating from 23R2SU4 to 24R1SU2, all of the permissions for the projection of '~MigJobHandling', which is the permissions of the migration job, were revoked. Has anyone else experienced the same problem?・Why are permission revoked when Release Update is applied?・What is the workaround?

Good morning everyone, I post this topic cause after many hours of research I can’t find a solution about using an API.Here is my problem :  I have to build an flow for make an insertion of data in IFS DB.I did it on the application and use the debug window for see what kind of API is called. After analyse, I see this :   I understood the parameters are checked in the FndTempsLobs API which is genering a LobID and this LobID is the payload of the PickSelected API. My question is : How can I give the inforamtion PICK_LIST_NO, SOURCE_REF1, QTY_TO_PICK, etc… to the FndTempsLobs API ? The documentation show us the only payload is CreatedByModule :  My 2nd question is : The LobID generated contains the previous information ?  Thx a lot for your help and sorry if my explication are confused.  

Hello,My question concerns the finance migration to the IFS cloud version.I have a question regarding this process.We have the client's opening balance as of 31.12, and we are planning to migrate elements such as invoices, customers, suppliers, taxes, using external vouchers.However, I am wondering about the general ledger—how can we migrate the remaining elements from the general ledger? Should I request a full general ledger and import it as an external voucher to reach the balance as of 30.09?Thank you for your help. Best regards,

Quite new to the Data Migration Tool in IFS I try doing my first Excel migration job using two LU’s. The purpose of the job is to update the SUPPLIER.SUPP_GRP column. As an additional information we will need the ASSOCIATION_NO from the SUPPLIER_INFO_GENEREAL LU but only SUPP_GRP needs to be updateable. I have configured the job as follows: In the method list tab I added the two LU’s:   In the rules tab I added a FETCHCONDITION that seems to work:   supplier_info_general.supplier_id = supplier.vendor_no  And finally I configured the source mapping tab as follows:   Running the job in Excel the Load Data procedure works as expected. One row for each supplier and all field showing the correct existing value. But then edit the SUPP_GRP value on a supplier and the run the Validate procedure I got an “Object does not exists” error in the Result Column. Back to the migration job trying edit and save some information on the SUPPLIER_INFO_GENERAL row in the method list I got the following erro

Hi All, We are implementing one integration, which includes, we read csv file from URL and dump the data into custom table. By reading the custom table, we are calling the  API and updating the data into IFS. We get any error with the data from CSV file, then we need to create a projection to log those error. Can anyone please  help me to create the projection to log the errors ?   

Hi All,We're developing a excel migration job for creation of parts.We're using ENG_PART_MASTER_SEQ.NEXTVAL in this job.We would like to see in the excel migration job what the number is.So,  if we want to use the part after creating the part with the migration job, we don't have to search in IFS to find the created part_no.Any idea's how to manage this?   

Hello Community,I am attempting to migrate code parts in the Authorizer Assigning Rule (view name: AUTH_ASSIGN_RULE_CODEPART1) using the Data Migration Manager.However, I'm encountering the following error:Method NEW failed: ORA-01400: cannot insert NULL into ("IFSAPP"."CODESTRING_COMB_TAB"."ACCOUNT")This is despite the account being present in the legacy file, mapped, and transferred to Deployment.Note: I successfully migrated the same file using the INSERT_OR_UPDATE Migration Job, but encountered the same error mentioned above when using CREATE_TABLE_FROM_FILE and MIGRATE_SOURCE_DATA.Has anyone experienced this issue before and can offer assistance?Thank you 

Hello,Anyone knows how to capture the actual receipt date of inventory when the opening balance migration is doing for Apps 10? 

Our customer uses excel-addin for creating and updating parts. We are trying to figure out what flags creates new records and what flags updates existing record from the excel. Is there a simple explanation? For example I get that is you create a new Part no there is a new record and of you add a new site to an existing Part no it will create a new record. So basically, are all P and K flags creating new records or is it all M flags as well?  Hope you understand my question :) Best RegardsEmma

Hello, I need help please. I created a mapping to mass import serial objects with an Excel file, I managed to get all the desired fields working except for a "Belongs to Object ID" and I don't understand why this field doesn't start working. update when I insert a new serial object. I modified the "Flags" several times but it didn't change anything. *I specify that this field contains a list of objects already existing in the database Thank’s  

I want to change the Responsible field and export it to IFS, but it doesn’t work. Has anyone made this change before?orCan we add different columns in MS Project add-in?

HelloCan we create a shortcut keys for windowsI mean if we press Alt + C then a customer order window will open, and so on Or press F10 then  a customer order window will open.Thanks. 

Hi,We have a requirement to create Functional Objects via Migration Job.  The job should also insert Belongs to Object and Contract.In Cloud, while creating Migration Job (tried with Excel and Migrate Source Data) on EQUIPMENT_FUNCTIONAL, the columns SUP_MCH_CODE (Belongs to Object) and SUP_CONTRACT (Belongs to Site) not at all visible in Column mapping.We tried using modify Method to update these columns, but still it is not updating and Migration Job ending with an error as belowAPI Methods used: EQUIPMENT_OBJECT_PARTY_API.Modify__ Also used this method, EQUIPMENT_FUNCTIONAL_API.MODIFY__ , but in both cases it ended with same errorError:ORA-06550: line 1, column 43:PLS-00225: subprogram or cursor 'MODIFY__' reference is out of scopeAny thoughts or idea really helpful on thisThanks,Nishith

I want to map IFS FSM Stock table with IFS Cloud, Which IFS View\Table would be appropriate. Please suggest.

How to migrate customer order and customer order lines using MIGRATE_SOURCE_DATA procedure?I tried to separately make a task to migrate an order and another to migrate a line and I keep getting an error.  

I tried to upload an external file to IFS, but encountered an error. When I enter the figures in the amount field, the upload is successful. However, if I enter the figures in the currency amount field, I receive the following error: ORA-20110: ExtCheck.VOU_NOT_BAL: Voucher 28-AUG-24 is not balanced in accounting currency.How can I resolve this issue?

Hi all, this is on IFS EE Apps 10 Upd 20 for the Report in Work Order screen. I’m updating an existing Excel migration job to include the new fields Cust Warranty Claim, Output Type, (Note ID?), and Notes.. which has involved adding in 3 more views. WORK_ORDER_RETURNS_UIVWORK_ORDER_RETURNS_UIV_CFVJT_TASK_UIVDOCUMENT_TEXTI’m able to take the existing ‘Work Task’ lines and create the ‘Returns’ lines via the job and the Cust Warranty Claim field populates fine. However, the Document Text (Output Type and Notes) is not populating. When I remove the “On New Master” checkbox under Method List, I get an error that the NOTE_ID field is mandatory. However, I can’t figure out how to have this field autogenerate the value like it would in the GUI.. I’m at a loss and am hoping for some help for this rookie… I’ve included screenshots of everything I’ve got. Let me know if additional info from me is needed, I really appreciate any input. Method ListSeq 10Seq 20Seq 30Seq 40Source Mapping​​​Existing W

Hi, I am currently looking to understand how IFS loads data into the system incrementally during data migration. You have to think about IFS as a whole system not just a strict set of components. For the TEST-A-REST data sampling, the data can be pushed into a QA cloud environment which has inspired this question. Is is possible to determine a load order from the IFS oracle tables which must adhere to table constraints and foreign key understanding. I understand that generally; CustomerSuppliersParts  Have to be loaded into the system before orders can be migrated in to avoid cascade errors. Is it possible to understand a loading order for IFS oracle table names based on the above information?? I need a full list of IFS oracle tables in the correct order which will allow data to be loaded without any cascading errors occuring.

Is there a screen I can go to in cloud 23r1 where I can get a list of all configured views we have in our environment ?I am looking for a list of views themselves.