Data Migration

Hi,In Apps 9 whilst using Data Migration Jobs, users were able to delete records after loading data from spreadsheet and before migrating the records into IFS.However, in IFS Cloud (23.1.11) there seems to be no option to delete records like the ones highlighted below:Users need this ability to review and delete records before migrating them into IFS.Is this a case of missing functionality in Cloud that will be added in future updates?

 I am creating an Excel Migration job that will set hundreds of Requisition Authorisation Rules to ‘Planned’.This is very much like the topic I raised and got a very good answer that worked well: Excel Migration - Delete User Sites | IFS Community. On this occasion the same principles are not working for me.Here is the job...For the Action on Seq 10 I have toggled InLoop and NoExecution.For Seq 20, I set these attributes…My source mapping looks like this - I allowed the default Source Columns and assume I don’t need to do anything with the firs

Trying to use an External File to migrate a Trial Balance (GL Transactions) from the legacy system to the new Cloud IFS solution.  File conforms to the STDVOU template with semi-colon separated values all matching the individual fields.  We have several different IFS Cloud environments at the moment (since we are in Implementation Phase), but none of them accepts an STDVOU type file and fails with the following Oracle error message:ORA-20115: ExtLoadIdStorage.The "Ext Load Id Storage" has already been removed by another user.Anyone got any ideas?…  we have already been successful in loading External Files using different Templates (ExtFAObjectImport for example), so doesn’t seem to be a generic issue with the environment as such...

Hello, I created a new page (Work Order Journal) in MWO but it shows an error message. From the designer page of my creation page, the page works correctly but as soon as I leave the designer page the page returns to errorThe goal is for technicians to be able to directly access the “Work Order Journal” page from the MWO application, can you tell me how to do this?     Thank’s

Hi All,  Is there a place which I can get the Data Tracker for 24R1? Your assistance is highly appreciated.  Best Regards, Thushila 

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

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! BREmma

We need to have same Basic Data in Development EnvironemntWhat 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 growingDoes anyone know how supposed temporary table is cleaned? is there some cleanup batch to schedule?thank you in advance 

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 me

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

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 so

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?