Data Migration

In Apps10 client, when entering decimal values, they are being recorded as comma-separated. For example, I enter 2.5, but it appears as 2,5 and is saved to the database that way. How can this be corrected?

Hello, I am trying to migrate some data in using the following : I am getting the following error: The issue is that the sequence field in ‘CHANGE_OBJECT_IMPACT_FIN’ needs to be the same as ‘CHANGE_OBJECT’. How is that done in a migration job please ?

Hi community, our customer uses Excel add-in for creating and updating parts in different views. We are trying to create a new job including SUPP_BLK_PART view but there it stops and we can´t run the job in excel. If we remove the view it works. We have also tried and add other vires such as ASSORTMENT_NODE and SELF_SERV_PROC_CATALOG without issues but SUPP_BLK_PART cannot be handled. Have anyone any experience in this? BR Emma

Trying to create a flat file from a view using Migration Job CREATE_OUTPUT_FILE in 21R1. No output is being generated and it is sitting at Error but no error message is displayed.

Hi, we are struggling to create an Excel Migration job, when trying to load data we get the following error message and no data is loaded at all. I´ve never seen this error before and cannot figure out what is wrong here? InsertDeleteConflict Thanks! BR Emma

We need to have same Basic Data in Development Environemnt What is the easiest method availabe to Tansfer Basic Data from "Use Place Env" to "Dev Env"

Hi,Is there an auto-scheduling engine inbuilt in IFS Cloud? Please let me know how to configure it.

we are currently importing data from our former ERP system into IFS Cloud 23R1SU6 and we notice that for instance the TEMPORARY_PART_COST_DETAIL table is just growing Does anyone know how supposed temporary table is cleaned? is there some cleanup batch to schedule? thank you in advance

Hi Community, I was trying to Migrate the Translation for Customs Statistics Number. in screen Basic Data Translation for English and PROG Data will alredy exist. I am trying to migrate the data for french Language via Excel Migration Getting error ORA-20110: BasicDataTranslation.PROGNOTEXIST: Corresponding basic data does not exist for attribute key Any idea how to solve this error? Thank You

Hi I 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 error: To m

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

Is there an “easy button” to move one site under another company within the same IFS instance? Or does that require a full blown data migration to move data from one company to another? How have other IFS customers resolved this situation?

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 Regards Emma