Data Migration

Does anyone know if it is possible to use the Excel Plugin to access multiple data bases?I have a customer who want to be able to update both test and Prod.Not both at the same time, but be able to switch between the two. 

Hi!Does anyone know if it’s possible to use any kind of input parameters in a Data Migration where clause? In case you want to run the same job multiple times but using different input parameters without the need of edit the where clause statements every time..\Mats

I am setting up a data migration project for a client running IFS 2004 migrating into Apps 10 UPD8. In the Apps 10 database I have created local VIEWs in a separate schema named IFS2004 using a database link to their IFS 2004 database. This makes it easy to use the FNDMIG input of using a VIEW/TABLE as the data source. Its fast and easy. Does anyone have any pre-built data migration (FNDMIG) jobs for customers, suppliers, etc. that you can export and share (PL/SQL format preferred please)? Your assistance will keep me from having to re-invent the wheel. Thank you for your help!

Hi, I am trying to export at list of customers to Excel. However, I can see that I am limited to these columns fro the customer table:Is i possible, using an advanced SQL query, to include the address columns of Address Identity ‘10’ in the export?  Br,Nielf

In a number of threads I've read that regular (older) Migration Jobs (FndMig) are not the favorite anymore. One better uses Data Migration Manager.Where does that leave Excel migration jobs? They are linked to FndMig, as far as I know.If FndMig is deprecated and may not be available anymore in coming versions, where does that leave the implementation/explanation of Excel migration jobs?Is it better for consultants not to mention that it exists?Is it better for customer not to start using them or trying to remove them from the possible functionality to use in IFS Cloud?I'm interested in your thoughts,Steve

Hey everybody, I am trying to set up an Excel Migration Job for with custom fields. Unfortunately it doesn´t work. Without the CFs I am able to upload data in the master. With the CFs it seems to work (validation and execution works without errors), but the record set doesn´t update. I am curious if someone of you faced the same issue. Name and Cepi have been updated. Validation looks good.After execution it looks also good.

HiI am migrating into Sales Price List Part (SALES_PRICE_LIST_PART)Method List is set to New and Modify.Ran the migration job and all records were imported.When I re-run the Migration Job I get an error ORA-20112: SalesPriceListPart.EXIST2: The Sales Price List Part object already exists.Does anyone know why I get this error? teh record does exist so it should be doing an update now, not an insert!Cheers,Graham 

Hello All,I’m trying to migrate users between environments and I’m missing data.Why can’t I migrate the email address?If so, what do I add to the migration job.The field seems to be part of the same table, but does not get added to the migration job. Thanks,Rob

Hi all, I received the below question from one of our APPS8 customers. They want to migrate closed PO's from their old ERP system into APPS8 (Customer recently aqcuisitioned new business).. My idea was to migrate the PO's with No Parts instead of Part lines, but I'd like to double check with the community!-------------------------------The question is if there is a way to migrate closed POs and what is the impact to postings. We will only go for a migration of No Part POs. If we are migrating POs with the status closed is there a posting connected to the status? Is this on kicking of the system functionality of posting a GRNI? If there is no posting linked to the status in the data migration, how is the matching of the invoice to the PO working? We will post an opening balance in IFS which is the closing balance of the old system. In this one we have the GRNI amount from the closed POs of the old system. So now we need to reduc

Hi All,I’m trying to import Person records and I get this error:READ ONLY GRANTS FOR IFSINFOThis was working yesterday, so I’m confused.I’m using the view PERSON_INFO_ALL.The Users have migrated for all these records and the Company User records migrated as well.Any Thoughts?Thanks, Rob

I’ve got my source migration job working, but I’m trying to log errors that just show up as unprocessed records. In this case it’s a bad Operation No/ID and you can see in the debugger it can’t find the Objid/Objversion for the routing operation I’m trying to update. Is there a way to flag these rows so the end users can go back and resolve the issue with the source data?     Thanks, Lane

Hello everyone,I have met one tough problem from time to time. I often need to upload Customers’ Purchase Order into IFS 10. Most formats of theses POs are PDF, and they contain less than 20 lines, in this case, I would upload them into IFS manually. But there are some POs in Excel format and contain more than 100 lines (we can see Sales Part Number, Quantity, Unit Price with Currency, Wanted Delivery Date, etc. In short, all the key information is provided) It may take me more than one hour to deal with it if I choose to set up it in IFS and this is what I did for a several times before. Time-consuming job!!! So, does anyone here know how to do migration job for upload one PO of Excel format containing more than 100 lines one time? Also, does anyone here know how to create a lot of sales parts (usually more than 50) one time? All the sales parts belong to the same product family. A lot thanks.Ple

Hi Evevybody, We prepare de data migration job to add some project activities. Table is ACTIVITY and a key field is ACTIVITY_SEQ. is it possible to call activity_seq.nextval to init this field ?I test but without success. When I initialize with a numeric value it works but I will prefer use sequence.Regards, Christophe

Hi When I try to create an Excel Migration job, I got an error as below. What is the base view. Why the SITE_INVENT_INFO is not a base view.Thanks & RegardsPeak 

Hello,We are working on data migrations of a 21R2 customer using the smart data manager. We have first started working with CUSTOMER_INFO and CUSTOMER_INFO_OUR_ID which has a parent-child relationship, both objects are in scope and target definition tables are also created.Our next step is to add the data in to the input container in "Mapping Legacy Tables To Migration Object” window. When we click on "Mapping Detail [Options]” > “Add into Input Container” we get the below error.   We investigated and found out the issue is triggered by the primary key/s of CUSTOMER_INFO_OUR_ID. 

Good afternoon all,  I am after a little help/advise. My company are looking to add the Harmonized System (HS) codes to the inventory Part Record using the Customs Stat No field (unless anyone can advise me differently). We have identified over 100,000 inventory parts tariff codes and I wondered if anyone knows of a way to bulk upload them from an excel spreadsheet? At present the field is blank.  

Hello,I did a test to migrate an employee and it appears with “preliminary status”. How can I migrate it as “active”? It’s for the Cloud version 21R1 and I created a two step job.Thank you in advance,

Hi,I’m looking into the Data Migration Manager component and am looking for a way to migrate data from an external database into IFS Cloud. I took a look at the online documentation and it mentions that in the process of defining a Migration Project, there is a section where you can connect to an environment using a Database Link, which will be created by Cloud Operations in the application.Does anybody have a guide on how exactly we would create or define this Database Link?If I wanted to connect to an external database for data migration, is using the Database Migration Manager the correct process? If so, how does this process work? If not, what is the correct process?Any insights would be very much appreciated. Thanks!

Hello,  I have a question please about the inventory migration. I hear about “NREC” to migrate inventory. Can you explain how it works ? Is it a type of external voucher ? Best regards

Hello,I am trying to migrate the Supplier for Purchase Part in IFS Cloud.I encountered the following error:“ORA-20110: TaxHandlingUtil.INVTAXCODE2: You are not allowed to use Tax Codes of type Tax with percentage greater than 0%.”I think that the problem is that for one site the field Tax Code is blocked:As for the other site, the field is “unblocked”:Is there any specific setup on site level that needs to be done to have this field avaliable for the Supplier for Purchase Part page? Thank you in advance,

Hello,I want to change the structure status from “tentative” to “buildable”. I am using a two step job and I am looking for the right method. I was trying with this one (screenshot), but I get the message that the method is not righT. could you please advise?Thank you!Aleksandra

I am trying to migrate Customer_info where the Creation Date is today’s date.  The migration does not like the format:  1000001 ABAN ABRAHAM PTE LTD 11/16/2022 1000001 CUSTOMER United States of America en 1000041 SEADRILL OFFSHORE AS - EUROPE OPERATIONS

Is there a way to change the status of a record created using a migration job? When creating a record it is always created in ‘Preliminary’ Statusex- Create a Customer Order with status ‘Released’ or Create PM Action with status ‘Active’ using a migration job 

Hi, We use 21R2 on IFS Cloud and try to use Excel Data Miogration.I downloaded Excel DataMigr Manifest from IFS but when I try to import it in Excel  I have a certificat error.Do you an idea about this ? Regards, Christophe

I am trying to use the Data Migration Manager tool to load our HR data. I used the template as an example and I am currently trying to load the COMPANY_PERSON Target Table. COMPANY_PERSON has a reference to COMPANY_EMP. I tried loading a couple of records through COMPANY_EMP, but when I did that, COMPANY_PERSON returned the message from the Deployment Container that the Employee already exists. For the next attempt, I disabled the reference to COMPANY_EMP and tried to load the COMPANY_PERSON record directly. Now I am receiving the following error:Method NEW failed : ORA-20105: AccessAttribute.NO_ACC_TO_PERS_MOD: Insufficient access rights. You cannot modify Pers data for the person 2390.I did not make any modifications to the NAME or FREE_FIELD(s), and only added the data for the required fields like Internal Display Name. Any idea why I am now seeing this error when I can create the PERS data using PERSON_INFO and the 2 PERSON_INFO address tables?